Demand vs. Stock on Hand
For anyone doing Just in Time fulfillment, preorders, or presales... It is Very important to be able to see How many skus sold, vs. how many in stock. The balance would let you know how much is OVERSOLD or PRE ORDERED. Our company can produce products on demand, thus giving us a production list so we can get the orders out.
Currently , it is a massive headache to see negatives.
This would also be beneficial to companies that have accidently oversold or have reconciled inventory and are missing the stock they need to satisfy the orders.
SKU - sold 10
STOCK - on hand 8
NEED - 2 more. (negative 2 units)
We’re interested in getting more information about what inventory source(s) you are using and how you’d like to view the on-hand vs in-stock counts.
Could you provide some more details on how you store inventory and how you’d like to view this in ShipStation?
Yes. Currently we are unable to use the "Allocated" functionality because we are not allowed to over-allocate any particular SKU. I would like to be able to see a Negative # for the amount of units that are oversold per SKU
* Has active orders for 10 units that are ready for fulfillment
* On Hand/In Stock Inventory: 8 units
This leaves 2 units Oversold.
Current system shows:
On Hand: 8
But what happens to the Oversold Units? There is no mention of them in any single report.
To get the actual Available/Oversold # I do the following:
1. Unallocate all SKU's
2. Run "Current Inventory Status" Report, export to excel
3. Run "Item Demand Summary" Report, export to excel
* Select "Awaiting Shipment"
4. Take SKU unit counts from Awaiting Shipment and enter into Allocated Column on Item Demand Summary
5. Change formula for available to be (On Hand - Allocated)
This gives me the negative # I am looking for to show an Actual inventory Status.
Shannon Tardie commented
Yes please! I need to be able to project and plan for once the item becomes available again and I ship out the backorders, how low am I going to be? There must be a way to show negative stock for planning purposes.
Danny Loevy GoodState Inc. commented
Agree with everything already said. In my case, if I'm out of stock of a SKU but know that I will be refilling later that day, I want the orders to come through instead of blocking them. However, when I add the stock produced later in the day, I would like my total stock number to reflect the orders I had printed out earlier in the day.
1. Units of SKU = 0
2. Print off 5 orders
3. Add 10 Units later in the day
The total stock number should now say 5 instead of 10.
This would be incredibly helpful. Being able to see this is a huge deal for a lot of companies that are eccomerce based.