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
14
votes
1 answer

Need to expand an inventory journal (log) pandas dataframe to include all dates per product id

I have an inventory journal that contains products and their relative inventory qty (resulting_qty) as well as the loss/gain every time inventory is added or subtracted (delta_qty). The issue is that inventory records do not get updated daily,…
Negative Correlation
  • 725
  • 6
  • 19
7
votes
3 answers

programmatically access car dealers inventory

Not sure whether this question makes sense on SO, but I'm working on a website that would provide a list of new cars of interest to the user, a bit like autotrader.com. Do you guys know how this type of websites operate? On autotrader.com I was…
bmanu
  • 610
  • 13
  • 28
7
votes
1 answer

Basics of Shopping Store and its schema

I am planning on making a generic shopping store website like a smaller version of alibaba.com which could be used by different businesses to list their product in their own version of the shopping store. Before starting the project I want to be…
zeppelin
  • 431
  • 1
  • 4
  • 24
6
votes
3 answers

Inventory Management: How do I handle sold inventory units in the database?

i sell liquor. so i have an inventory of bottles. so far i have an "InventoryUnit" model which references product and line_item. should every single bottle be stored as an individual InventoryUnit object in my database? what's the best practice to…
Philip Paetz
  • 587
  • 4
  • 9
5
votes
1 answer

Correlate GROUP BY and LEFT JOIN on multiple criteria to show latest record?

In a simple stock management database, quantity of new stock is added and shipped until quantity reaches zero. Each stock movement is assigned a reference, only the latest reference is used. In the example provided, the latest references are never…
Sunbird
  • 53
  • 3
4
votes
1 answer

How to manage inventory of entry tickets in BlueSnap API

I'm selling event tickets for a company, and I use the BlueSnap Extended API to sell the tickets. I create a new catalog SKU each event with the corresponding price for a seat, following the BlueSnap documentation here:…
Mark Averill
  • 111
  • 5
4
votes
1 answer

Keeping inventory data in separate table from product data

TL;DR: what are some reasons to keep "stock" data table separate from products tables? I've built an application a while back that stores a catalog of retail products. It includes standard attributes such as size, color, image link, description,…
musicliftsme
  • 3,261
  • 9
  • 51
  • 95
3
votes
8 answers

Capturing spreadsheet usage throughout a company

We have a lot of customized spreadsheet solutions that are being used and we want some programmatic way of keeping track of them. Obviously since they are spreadsheets, people can save them locally, rename them, etc so we need a solution that can…
leora
  • 163,579
  • 332
  • 834
  • 1,328
3
votes
5 answers

Integrating REST services with an inventory database and SQL using Android

I'm getting started on a contracting project bid, and I was hoping for some advice on the best way to go about it. I am being asked to develop an Android application for inventory management for a small company (no more than a few thousand SKUs at…
Codeman
  • 11,457
  • 8
  • 48
  • 89
3
votes
0 answers

Complex Count: count opportunities for aggregation

I am struggling how to get the output I need to provide for a report. I am trying to show what products(LPN) I can combine, to free up space in a warehouse and how many of these opportunities there are. The below code pulls all the data I need but…
Jonathan
  • 55
  • 5
3
votes
0 answers

Woocommerce - Inventory tracking based on total weight

Can I have the variable stocks deduct more than "1" unit from the parent stock? For example. I have 10kg Total of nuts. Variable options include 1kg, 5kg, 10kg. Each weight would correspond to the correct deduction of KG's from the parent stock…
Tony Y
  • 31
  • 1
3
votes
1 answer

vCard or MeCard? Specific to creating detailed inventory forms

I am in search of the most appropriate route to take, vCard or MeCard, and the correct syntax to use in order to create unique forms for various uses. An example being an inventory form. Creating a new contact card by scanning a QR Code is as far…
les
  • 554
  • 7
  • 19
2
votes
1 answer

Getting the Total Item Quanity from previous Transactions by Date of Transaction and Getting Current Item Quantity Total

I have 3 Tables Namely: Inventory: |ID|ItemID|TransactionDate |Item |Unit|Quantity| ---------------------------------------------------------------- |1 |1 |2019-07-10 12:23:51 |Plastic Cup 22oz |Pc |200 …
Matt Pedrosa
  • 57
  • 7
2
votes
2 answers

inventory system: transaction-based or store quantity, update with trigger?

How would you design the data model for an inventory management system in RDBMS? Would you: store each purchase & usage, and uses SUM() and GROUP BY to calculate the warehouse quantity on-the-fly? same as 1, but consolidate the quantity daily, and…
Henry
  • 31,972
  • 19
  • 112
  • 214
2
votes
1 answer

Inventory Counts with Event Sourcing

I am trying to rewrite a CRUD based inventory system using event sourcing/CQRS. The problem I am having is with how to deal with inventory counts. The idea is a store will occasionally want to count their inventory and determine if there is any…
user12928
  • 35
  • 3
1
2 3
…
13 14