Adding Stock to Warehouse via Excel
- Sandra Petrovic
You can add stock to a warehouse via an excel spreadsheet. This is a good idea for large quantities.
Please ensure your Excel spreadsheet is saved as a .csv file.
Step-by-step guide
Formatting your Excel File correctly.
Barcodes will also need to be formatted once the file has been formatted to a .csv to ensure they are imported correctly. Excel often formats and saves barcodes incorrectly when formatting the file to a .csv.
Left click the barcode column and select Format Cells.
2. Select the category Number and decrease the Decimal Places to zero (0). Press Save.
3. The barcodes should now display as their full number when you select them.
Adding Stock to the Warehouse via the Reports tab.
Click on arrow and select Warehouse
Click the burger menu at the upper right > select reports
3. Select the Import Inventory tab.
4. Select the relevant Warehouse location that you want the stock to be imported to.
5. Select File to: Format 1 (GS1 and Qty)
Format 2 (GS1 Only) - Input the GS1 repeatedly based on the quantity you want to appear in the warehouse. ie 987654118544 this is equal to 3 QTY’s
. Click the browse file button to upload the file
importing options
Option 1 - This option will remove all existing inventory from the selected warehouse and replace it with new stock based on the imported file.
Important: if you have virtual warehouse linked to the main warehouse it will be a different importing logic. Contact indigo8 for more info
Click the Load file
Select Print Variance Report.
Your Variance Report will show the total imported quantity. Compare this with the sum of your Inventory Import Excel sheet to ensure the correct amount will be imported correctly.
10. Once you have confirmed the correct number will be imported, select Import - Commit New Stock Levels.
If you REFRESH the relevant Warehouse on the Arrive Purchase Orders tab after importing, you will see the Total Pieces number increase by the Imported Quantity amount (ie. 43).
Importing options
We have seen how import option 1 works on the above. below are the options for importing inventory
Option 2 - Update the stock by adding the specified quantity base on the imported File
Option 3 - Delete and replace only the styles included in the import file, while keeping all other styles in inventory unchanged.
Option 4 - Update and apply imported quantities only for GS1s included in the import file, modifying stock based solely on GS1
