#Lightspeed onsite cusomize statments software

This field describes what type of matrix it is. Can be Color/Size, Size, Color, 3 Attributes, or blank. Inventory > Matrix > Setup > Matrix TypeĬolor/Size, Size, Color, 3 Attributes, or blank. No returns, line breaks or foreign characters. Text up to 255 characters long or blank if not in a matrix. If you have 3 items in stock, the reorder point is 5, and the reorder level is 10, the Reorder List report will show that you need to order 7 to get your inventory back to 10. The level your store wants to be at when you reorder. Whole number and reorder point has to be specified. Item view > Details Tab > Automatic Re-Ordering > Level When you view a Reorder List report in admin, the item will show as needing to be reordered if your stock is at or below the number specified as the reorder point. Whole number and reorder level has to be specified. Item view > Details Tab > Automatic Re-Ordering > Point The quantity of the item you have on hand. Item view > Details Tab > Stock > In Stock If vendor field is blank, vendor ID will not be imported. Item view > Details Tab > Vendor drop down list Sub-category you want the item to be put in, such as Clothes > Shorts > Men. Sub-category you want the item to be put in, such as Tires > Mountain or Clothes > Shorts. Item view > Details Tab > Sub Category field No returns, line breaks or foreign characters.Ĭategory you want the item to be put in, such as Tires or Clothes. This field can be searched by items tagged with or tagged without your search criteria. Keywords or terms used to search for your product. Multiple tags separated by a comma, such as 'shirts, womens'. Price you charge to the customer for the item. If this item is marked as Yes, the item will be charged the default tax rate when added to the register.Ĭurrency format, such as $1.99. Item view > Details Tab > Taxable check box Item view > Details Tab > Default Cost field This field only displays on labels if selected in admin. This is not what the customer is charged for the item. The color and size of the item will be added to the description if they are specified in the color and size column (Matrix items).Ĭurrency format. Recommendations: Make each of your item descriptions unique so you can tell items apart by looking at their description. Item view > Details Tab > Description field Manufacturer's SKU identification number for the item. Item view > Details Tab > Manufacturer SKU field Some shops use this field for their old POS barcodes or item numbers. Item view > Details Tab > Custom SKU field A 12-digit barcode number is a UPC number. 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. 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:

#Lightspeed onsite cusomize statments software

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.