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.
Example
SKU - sold 10
STOCK - on hand 8
NEED - 2 more. (negative 2 units)
Jon Ladd Terminus Tees
shared this idea
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?
4 comments
-
mvifquain
commented
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
Example:
SKU: 1234
* Has active orders for 10 units that are ready for fulfillment
* On Hand/In Stock Inventory: 8 unitsThis leaves 2 units Oversold.
Current system shows:
On Hand: 8
Allocated: 8
Available: 0But 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 dayThe total stock number should now say 5 instead of 10.
-
FulfillmentHouse
commented
This would be incredibly helpful. Being able to see this is a huge deal for a lot of companies that are eccomerce based.