...
Please ensure your Excel spreadsheet is saved as a .csv file.
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.
Enter the Warehouse Module.
Select the Reports tab on the top right hand corner.
...
9. 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.
...