How to Perform Stock Adjustment with Excel (Batch Edit)
1. Go to All Inventory Items from the Inventory menu.
2. Then, click on the Batch Edit button.
3. Generate the existing ‘Inventory‘ for Stock Adjustment.
4. Download the generated excel file (zipped).
5. Update the ‘quantity_changed‘ or ‘new_stock_on_hand‘ for inventory stock adjustment.
Note: Column with * is Not Editable.
Update either one, for quantity_changed or new_stock_on_hand field. Else, the system will update based on the quantity_changed.
| Column | Description |
|---|---|
| *name | The Inventory Item name. |
| *isku | The iSKU of the Inventory Item. |
| *warehouse | The allocated warehouse of the Item. |
| *rack | If there is a rack set for your Item, you may insert the rack name. |
| *in_hand_stock | The current stock you have in the warehouse. |
| quantity_changed | The stock level that you wish to adjust (+/-). |
| new_stock_on_hand | Adjust the total new Stock On Hand quantity of the item. |
6. Next, upload your excel file and click ‘Next‘ to continue.
7. Click on the ‘Proceed‘ button if there is no error.
8. System will notify for the successfully imported data, then click on ‘Done‘.
