What is Out-of-Stocks Statistics?
When new orders with insufficient inventory enter Out of Stock list, the quantities of shortage products can be quickly calculated through the Out-of-Stocks Statistics function, so that the targeted and rapid replenishment can be achieved.
Step1: Go to Orders >New Orders > Out of Stock > Click on Out-of-Stock Statistics.
Step 2: Select the out-of stock SKUs (the selected SKUs must be from the same shipping warehouse ) > Click refresh to calculate the out of stock quantity > Click Manual stock-in / transfer button to replenish the stock quantity
Step 3: Add Stock-in List and Submit
Step 4: Refresh the Inventory
Calculation Formula: Out-of-Stock orders required inventory qty - Out-of-Stock orders allocated inventory qty - available inventory qty
For example: There are three orders, corresponding to Merchant SKU [A], SKU [B] and a combination SKU [A+B] (The combination SKU contains SKU [A]*1 and SKU [B]*1).
Step1: Go to Orders >New Orders > Out of Stock > Click on Out-of-Stock Statistics.
Step 2: Select the out-of stock SKUs (the selected SKUs must be from the same shipping warehouse ) > Click refresh to calculate the out of stock quantity > Click Manual stock-in / transfer button to replenish the stock quantity
Step 3: Add Stock-in List and Submit
Step 4: Refresh the Inventory
Calculation Formula: Out-of-Stock orders required inventory qty - Out-of-Stock orders allocated inventory qty - available inventory qty
For example: There are three orders, corresponding to Merchant SKU [A], SKU [B] and a combination SKU [A+B] (The combination SKU contains SKU [A]*1 and SKU [B]*1).
| Inventory List | On Hand | Allocated | Available |
| SKU [A] | 20 | 15 | 5 |
| SKU [B] | 0 | 0 | 0 |
Order 1: Purchased [A]*5, allocated [A]*5 -- In Stock
Order 2: Purchased [A+B]*10 -- Out-of-Stock
Order 3: Purchased [A]*10 and [B]*10, allocated [A]*10 and [B]*0 -- Out-of-Stock
Now the calculation is:
[A] Out-of-stocks qty= Out-of-Stock orders required inventory qty(20) - Out-of-Stock orders allocated inventory qty(10) - available inventory qty(5) = 5
[B] Out-of-stocks qty= Out-of-Stock orders required inventory qty(20) - Out-of-Stock orders allocated inventory qty(0) - available inventory qty(0) = 20
💡 Note: Each file can export up to 5000 data, and if there are more than 5000, multiple files will be exported.
How to add the product inventory
html_help_user_feedback_content_helpful
html_blog_comm_feedback_tips1
html_blog_comm_feedback_tips7