If your product requires lot or serial number tracking, three columns are required in the Excel file.
Column 1: Product ID
Column 2: Lot ID
Column 3: Qty
If you keep stock at multiple location and your product requires lot or serial number tracking, an additional column is required in the Excel file. A sublocation column is to tag where the products are stored. An example format is shown below
Since there are multiple combinations of sublocations and lot IDs, product IDs may be listed in multiple rows in the Excel file. Although it is not used the actual import, using an optional description column is helpful to allow you to make an easier association with the product.
Please watch this video how to import products.