![]() No return/line breaks or foreign characters.ĮAN (International Article Number) is a 13-digit barcode number. Must be a unique 13 digit number or blank. A 13-digit barcode number is an EAN number. UPC (Universal Product Code) is a 12-digit barcode number. No returns, line breaks or foreign characters. Must be a unique 11 or 12 digit or blank. If any columns do not contain data other than the heading, delete the entire column. Also, you can re-order the columns as you wish. Sub-categories beyond the third level are not imported. Note: Lightspeed Retail limits the import of item Categories to four levels: Category, Sub Category 1, Sub Category 2, Sub Category 3. You can use this example of a properly formatted Excel inventory report as a guide. For example, if you have an inventory Item Name column, rename the column to Description. Use these inventory field names to rename the inventory data headings in your spreadsheet. To avoid having to manually correct the data in your system, format your spreadsheet so that we can easily import it. Review your spreadsheet data and fix any formatting or data errors as detailed in Data verification.See Data fields for the inventory fields used in Lightspeed Retail. ![]() In your spreadsheet file, rename the column headings so that they match the Lightspeed Retail system fields.The backup file is a precaution against any errors, and can also be used to verify your data. Create a backup of your original export file.Lightspeed supports these file formats for importing: If you are transitioning from a POS software to Lightspeed Retail, export your current inventory data from your previous POS software to a spreadsheet software file such as Microsoft Excel.If your file is not formatted correctly, it will delay your import. If we have to edit your data in any way, we will send the file back to you for your approval. Note: Data import can take 15 business days to complete. ![]()
0 Comments
Leave a Reply. |