Stack Overflow
Stack Overflow

Questions tagged [inventory-management]

Inventory management is the process of efficiently overseeing the constant flow of units into and out of an existing inventory.

204 questions
2
votes
2 answers

Magento2 Out of Stock Assosiated Products not showing in the dropdown options for Configurable Products

I am facing an issue with Magento2 and I am not sure whether it's a bug or not. I want to show Out of Stock Assosiated Products in the Configurable Product Dropdown. In the admin settings, Stores -> Configuration -> Catalog -> Inventory -> Display…
Hardik
  • 51
  • 1
  • 6
2
votes
0 answers

Sql sum value subtract by user input in asp.net

I am trying to develop Inventory System. I created 3 tables Product,Supplier and Purchase. Product productId(PK) productName Supplier SupplierId(Pk) CompanyName Purchase PurchaseId(PK) ProductId(FK) SupplierId(FK) To show my available stock…
Kaushik
  • 87
  • 1
  • 1
  • 9
2
votes
1 answer

Best way to use compound Index to query with multiple combination of query parameters?

I am building a functionality to estimate Inventory for my Ads serve platform.The fields on which I am trying to estimate with their cardinality is as below: FIELD: CARDINALITY location: 10000 (bengaluru, chennai etc..) n/w speed : 6 (w, 4G, 3G, 2G,…
arpit bhawar
  • 21
  • 1
  • 7
2
votes
1 answer

How to handle change in Inventory Quantity on a backdate

My database has 2 tables 1. INVENTORY with attributes of ID, Name, QOH (ie Quantity on Hand) INVENTORY_ADJUSTMENT with attributes of Date, AdjQty, QOH, Notes Each time a inventory item is sold or purchased, I make an entry in the…
user1763470
  • 177
  • 1
  • 1
  • 10
2
votes
1 answer

How to structure database for multilevel packing items

I want to make an inventory system where items have multilevel packings e.g A carton has medium boxes , medium boxes has small boxes and small boxes has 2 items. Please tell how to handle it by using sql server 2005 so that it can easily handle sale…
Ghulam Haider
  • 21
  • 1
2
votes
1 answer

inventory database with stock level tracking - how to implement stock check before checkout

I am designing a database for an inventory management application that will handle stock level tracking of items and checkout order submission and processing. so far, i got: an Item table item id desc initial stock level other relevant info an…
kfc
  • 291
  • 6
  • 19
2
votes
2 answers

Designing an Inventory Management System for Point of Sale (POS)

I want to design a custom Inventory Management System. I have no previous experience designing anything similar. Since the subject can dig deep into many fields of Accounting and Economics, as a programmer I cannot come up with a perfect mental…
Paul-Sebastian Manole
  • 1,733
  • 22
  • 29
2
votes
1 answer

How to design database for product sets/packs

I am designing a database for inventory system. My client sells products in two different ways: As a whole set (like set of 8 parts in a bath fittings pack) Any of these parts can be sold separately If one or any number of parts has been sold,…
user1115284
  • 71
  • 3
  • 14
1
vote
1 answer

php mysql inventory

I'm creating an app for a trading card game called Magic: the Gathering and I have made a query that checks all user-submitted decks and gives you the percentage of cards you have in your inventory over the cards in the deck. But my problem is, it…
voldomazta
  • 1,238
  • 1
  • 10
  • 18
1
vote
2 answers

Avoiding interaction between if statements

I have an algorithm in a game that simplified looks like this: if click: if a and not b and not c: b = True c = True follow_mouse_pos() if b and c: b = False c = False stay_on_slot() This is…
Ciro García
  • 194
  • 11
1
vote
1 answer

C# inventory updating stock

I am building an app with a SQL Server database. I have a main table of products (tblProducts) with a column that holds the quantity in hand (quantity). Another table holds the orders (tblOrders) that come from the supplier. When an order comes in,…
Nick Massias
  • 25
  • 3
1
vote
1 answer

Is it possible to populate R dataframe with two interdependent columns

I am try to use R to calculate sales as a function of inventory as a function of sales. See below data snapshot. Is there anyway to calculate this? Group, Day and Sell_Thru are independent variables Inv = lag(Inv,1) – lag(Sales,1) Sales = (Inv *…
Matt Gossett
  • 99
  • 1
  • 8
1
vote
1 answer

Inventory Management JAVA ( check if item already exist)

i am making an inventory application using netbeans wherein in the add button, it adds data to the table and checks if the data is already exists in the table. In my code, it lets me add data in the first row but when i try to add again, it doesn't…
pi3_14
  • 13
  • 6
1
vote
1 answer

SQL query to get free vehicles on basis of their booking date

Here is my Inventory Table, And this one is my Engaged Inventory Log Table, and there is also a Main Booking Table with different fields with detailed information of a particular booking. Once a row created in Main Booking Table , trigger for…
Hamza Khan
  • 66
  • 6
1
vote
1 answer

How to use "DoParallel" for this LOOP which took me 12h+ to run

I am currently working on this code. Everything is fine, except...the code needs 12 hours to finish. I really do want to change this code to use Doparallel, but I just failed over and over again. I have to use Foreach but it seems it cannot improve…
Zhan Peng
  • 11
  • 1
1
2
3
…
13 14