How to update product balances
You can use Excel to update the product balances of several products at once.
See a short video how to update product amounts with excel.
- First, find out the warehouse name and warehouse slot where the product is stored
- Then go to the Products tab of the Products page, import the table view of the products into Excel by pressing "Export view for excel import"
- Open excel
- Fill in the warehouse, storage slot and number of products (total) in the Excel columns AC, AD and AE. Save excel to your computer.
NOTE that the warehouse and storage location must be written EXACTLY THE SAME WAY in Spotilla and Excel. - Go back to Spotilla, on the Products tab, press "Import from excel"
- Press "Select excel file" and download the updated excel from the computer. Check from the preview that you are bringing the right things. If it looks right, press "Save"