How to get there
- From the control menu, select Import
- Click on Inventory
- Select Stock adjustment by SKU (with products)
A modal will open. By clicking on Download Import template, you will be able to download an empty file that you will need to fill in with the number of units you want to update.
On the template
- Columns A, B (SKU), C (Name), and D (Current Stock) must not be edited as those contain system information that will help the update to work correctly
- Column E: Warehouse ID
Use it to add the name or ID of the warehouse - Column F: Add units
It is where you have to add the units of your stock. In the case that you want to subtract, you will have to write the number in negative - Column G: Inventory Date
Add the date on which you want the stock movement to be registered - Column H: Move description
You can write a description that will appear in the inventory history
Once the template is filled in
- Select Import from the control menu
- Click on Inventory
- Select Stock adjustment by SKU with products
- Drag (or select) the file in the import window
To learn more about inventory management templates, go to this article