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