I need a way to track inventory and customer fulfillment.
My idea is to generate a barcode/QR for the customer's order. As the items trickle into the warehouse, we scan those items into inventory, which allocates them to the customers order. We then print a customer order label for each item that we stick on and put the item into a bin location for order pulling once the entire order is received.
I have an inventory tracker, and an order tracker,both excel sheets. How do I make this work?
Hi Motar,
A Marriage is not simple, you might need an excel priest for this.
An inventory system must respect a few rules, like FIFO or LIFO, there are also complications like building an order from multiple batches, each with different prices for the same item.
To marry those sheets and manage them properly, it might be cheaper to purchase specialized software, rather than building one from scratch.
