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.

237 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
  • 813
  • 1
  • 11
  • 26
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…
ebcrypto
  • 610
  • 1
  • 14
  • 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
  • 451
  • 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
  • 607
  • 5
  • 9
5
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,…
laketuna
  • 3,832
  • 14
  • 59
  • 104
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

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 as…
les
  • 564
  • 7
  • 19
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
  • 188,729
  • 360
  • 878
  • 1,366
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
  • 12,157
  • 10
  • 53
  • 91
3
votes
2 answers

Ansible dynamic Inventory with bash script

We have recently built an API that allows us to query a list of VM's rather than using an inventory file. I am trying to incorporate this with our ansible set-up. I am very new to using a dynamic inventory and have tried a few different variations…
Code_Zone
  • 31
  • 1
  • 3
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
  • 6
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

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
  • 7
  • 24
2
votes
2 answers

Inventory discrete event simulation with simpy object oriented

I m trying to formulate an inventory simulation with Simpy (a Python library for discrete event simulation) using an Object Oriented approach. The simulation follow these steps: Initialization : A warehouse with unlimoted capacity and initial…
Nizar
  • 23
  • 3
1
2 3
…
15 16