Upload an Excel file to update product stock, threshold values, and calculate post-order stock automatically.
Your Excel file must contain the following columns:
| SKU | Current Stock | Threshold |
|---|---|---|
| KOHKOGC09-BO | 800 | 200 |
| KOHKOB01-BO | 150 | 150 |
| KOHPOP19-BO | 70 | 150 |
Formula (System Auto):
After Order Stock = Current Stock – Order Qty (system already knows order qty)