This is an old revision of the document!
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 |
|---|
| *name |
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‘.