In this table you will find all product information that you can export. This is useful when creating your worksheet for Importing new products and Editing products via import.
Column order (approx.) | Group | Export column title | Proposed assignment |
01 | Identification code | Product - Product-ID | |
02 | Identification code | Variant - Variant-ID | |
03 | Stock | Product - Visibility | |
04 | Organization | Product - Brand | |
05 | Organization | Product - Supplier | |
06 | Content | Product - Title - X Language | |
07 | Content | Product - Full Title - X Language | |
08 | Content | Product - Description - X Language | |
09 | Content | Product - Content - X Language | |
10 | SEO | Product - URL - X Language | |
11 | Content | Variant - Title - X Language | |
13 | Prices | Variant - Price | |
14 | Prices | Variant - Old price | |
15 | Prices | Variant - Price cost | |
16 | Prices | Variant - Unit price | |
17 | Prices | Variant - Unit | |
18 | Prices | Variant - Tax | |
19 | Stock | Variant - Inventory tracking enabled | |
20 | Stock | Variant - Stock makes repeat orders impossible | |
21 | Stock | Variant - Stock Level | |
22 | Stock | Variant - Minimum stock | |
23 | Stock | Variant - Stock Alert Level | |
24 | Identification code | Variant - Article code | |
25 | Identification code | Variant - HS-code | |
26 | Identification code | Variant - Barcode (EAN) | |
27 | Identification code | Variant - Stock keeping unit (SKU) | |
28 | Shipment | Variant - Weight (g) | |
29 | Shipment | Variant - Weight value | |
30 | Shipment | Variant - Weight unit | |
31 | Shipment | Variant - Volume value | |
32 | Shipment |
| |
33 | Shipment | Variant - Volume (ml) | |
34 | Shipment | Variant - Colli | |
35 | Shipment | Variant - Width (size X, cm) | |
36 | Shipment | Variant - Height (size Y, cm) | |
37 | Shipment | Variant - Depth (size Z, cm) | |
38 | Shipment | Variant - Width value (size X value) | |
39 | Shipment | Variant - Height value (size Y value) | |
40 | Shipment | Variant - Depth value (Z value size) | |
41 | Shipment | Variant - Size unit | |
42 | Shipment | Variant - Matrix | |
43 | Data | Product - Data 01 | |
44 | Data | Product - Data 02 | |
45 | Data | Product - Data 03 | |
46 | Stock | Variant - Minimum amount | |
47 | Stock | Variant - Maximum quantity | |
48 | Organization | Product - Category 1 - X Language | |
49 | Organization | Product - Category 2 - X Language | |
50 | Organization | Product - Category 3 - X Language | |
51 | SEO | Product - Meta Title - X Language | |
52 | SEO | Product - Meta Description - X Language | |
53 | SEO | Product - Meta keywords - X language | |
54 | Images | Product - Pictures | |
55 | Organization | Product - Tags | |
56 | SEO | Product - Google Category - X Language |
eCom and your offline physical location
Some eCom users have connected their eCom store to a physical point of sale, either Lightspeed Retail or Lightspeed OnSite, in a configuration known as an Omnichannel solution. If you're using an Omnichannel solution:
click here
Column title descriptions
These column title descriptions are grouped by similarity so that they are easy to understand. If you plan to import one of the column titles into a group, consider importing the rest of the group as well, as the information is related.
Content - What your customers read about the product, including its title, full title, description, content, and variant title
Images - The images of the product. This is done by importing the web address of the images.
Shipping - The information that shipping integrations need to know, including the Weights, Depths, Heights, Widths, Volumes, Shipping Matrix, Packages (Paazl only)
SEO - The information used by search engines to rank and display your product in their search results, including the meta title, meta keywords, meta description, product URL, and Google category
Price - How much your product costs, including the price, old price, cost price.
Stock - The stock level, visibility and how it behaves on your website, including visibility, stock level, stock minimum, stock warning level, allow/disallow back orders, maximum & minimum quantity
Organization - How your products are displayed on your website, including the 3 levels of categories, brand, supplier and tags
Identifier Codes - How to identify your products, including internal and variant ID, item code, SKU, barcodes (EAN) and HS code
Additional template data - Data 01, 02 and 03 are used in some themes, apps or customizations
Content
Content includes columns that help customers identify the product they want to buy. You can add column headings for the title, full title, description, content, and variant title.
Example 1
To import the long description, also known as content from each of your products, follow the instructions in Edit products by importing. As you follow the instructions, use these column titles in your worksheet.
Internal_ID | Internal_Variant_ID | XX_Title_Short | XX_Description_Long |
Example 2
To import translations for your content, make sure the languages you are importing have been added to the eCom Back Office first. You can add languages in the eCom Back Office > Settings > Shop Country.
Then follow the instructions in Edit products via import. As you follow the instructions, use these column titles in your worksheet.
Internal_ID | Internal_Variant_ID | XX_Title_Short | XX_Title_Long | XX_Description_Short | XX_Description_Long | XX_URL | XX_Variant_Title | XX_Category_1 | XX_Category_2 | XX_Category_3 | XX_Meta_Title | XX_Meta_Keywords | XX_Meta_Description |
For more information about manually adding product content, click here.
Title XX_Title_Short- The title of the product displayed in your eCom store. For some themes, this title is used when there is less space to display a full title, such as when your product is included in a collection of other products.
Required when importing new products, with no error occurring.
The maximum system limit is 255 characters, but the theme you have installed limits the length of the product titles.
The title also determines the initial web address of the product.
For example: You add a product titled Red Sweatshirt. The web address of the product will be: https://www.yourdomain.com/red-sweatshirt.html
Further changes to the title of your product will not alter the web address to maintain a search engine ranking. To change the URL of the product you need to change the URL of the product. You can do this manually as explained in Managing the product's SEO data.
To import changes to the URL, see Product URL.
Full Title XX_Title_Long - Your product's title that will appear on your website on the product's page. When shown here, themes generally have more room to display the full title.
Although the system does not require this for a successful import, it is strongly recommended that you include the full titles of your products in your database. This is because future edits to the product in the back office require you to enter a full title before you can save the product.
Up to 255 characters.
Could be the same as the title.
Description XX_Description_Short - A short description of your product, to be used as a quick summary of the product in most themes.
Limited to 160 characters.
Does not support HTML content.
Not available in some themes.
Content XX_Description_Long- Where you can fully explain everything about the product. You can optionally add HTML formatting for visual flair.
Limited to 65,000 characters.
Supports most HTML tags, with the exception of <div> elements.
Variant XX_Variant_Title - The title of the variant which usually describes its size, color, or other attributes. Displayed in a menu on the product page.
Up to 255 characters.
Separate multiple attributes with commas: Color: Red, Size: Large,
Importing variants only creates one drop-down menu on the product page of your website. To create more than one drop-down menu for your customers to select products, create your variants manually using Product Sets. For more information about manually creating your variants, click here. If your eCom version is connected to a Retail Point of Sale (POS), the products must be created in the Retail POS. Click here if you are not sure which version of eCom you are using.
Pictures
If images have already been uploaded to the internet and you have the web address of each image, it is possible to use the Import tool to upload images. For example, if you exported products from another Lightspeed eCom store, you can use the data file to upload images to your new eCom store.
If you do not yet have the web addresses of your photos, it is recommended to upload them manually instead of using the Import tool. For more information click here.
Images Images - Images that appear on your website to visualize each product.
Images cannot be uploaded directly from the data file, instead the web address of each image must be entered in this column.
The web addresses must always start with http:// or https:// and each web address must be separated by a comma.
The web addresses must end with the file extension. For example .jpg, .png, .jpg, etc.
The photos must be publicly accessible. Local file paths cannot be used.
Shipment
In your data file you can add columns for weight, dimensions such as depth, width, height and volume, as well as matrix and Colli (Paazl shipping integration) columns.
The shipping columns may look like double size columns, but they are used for two different purposes. When adding the weight, depth, height, width and volume columns to your data file, you can choose to add a column in which the system assumes a unit of measure or you can choose to add two columns; one to specify the unit of measure and another to specify the value of the weight.
For example, by adding a weight column with values for each product in your database, the system imports the values, using grams as the unit of measurement. By adding a weight value and a weight unit column to your data file, you can specify the weight values in pounds.
To import weight values to your existing products, follow the instructions in Edit products via import. As you follow the instructions, use these column titles in your worksheet.
Internal_ID | Internal_Variant_ID | XX_Title_Short | Weight_Value | Weight_Unit |
Weight Weight - Add this column to your data file if you want to import weight in grams (g).
Enter a numeric value without units.
Only in grams (g). To import other units, use weight value and size unit columns.
Only integers, no decimals.
Ignored if the weight value column contains data in the worksheet.
Weight Value Weight_Value - Add this column to your data file if you want to import weight in pounds, ounces, kilograms or grams.
Enter a numeric value
Accepts decimal values
Make sure to also add the column Weight unit to specify the unit of measure.
Overwrites all existing values in the Weight column
Weight Unit Weight_Unit - Add this column to your data file if you want to import weight in pounds, ounces, kilograms or grams.
Be sure to also add the "Weight Value" column to indicate how much the product weighs.
Enter the following for each product:
lb to set the units to pounds.
oz to set the units to us.
kg to set the units to kilograms.
g to set the units to grams.
Depth Size_Z- Add this column to your data file if you want to import the depth in centimeters (cm).
Enter a numeric value without units.
Only in centimeters (cm). To import other units, use the depth value and size unit columns.
Only integers, no decimals.
Ignored if the depth column contains data in the worksheet.
Only visible to customers when comparing products, but also relevant for some shipping integrations.
Depth Value Size_Z_Value- Enter this column in your data file if you want to import the depth in centimeters or inches.
Enter a numeric value without units.
Accepts decimals.
Make sure to also add the Depth Unit column to specify the unit of measure.
Overwrites all existing values in the Depth . column
Only visible to customers when comparing products, but also relevant for some shipping integrations.
Height Size_Y- Add this column to your data file if you want to import height in centimeters (cm).
Enter a numeric value without units.
Only in centimeters (cm). To import other units, use the depth value and size unit columns.
Only integers, no decimals.
Ignored if the height value column contains data in the worksheet.
Only visible to customers when comparing products, but also relevant for some shipping integrations.
Height Value Size_Y_Value - Enter this column in your data file if you want to import height in centimeters or inches.
Enter a numeric value without units.
Accepts decimals.
Make sure to also add the column Height Unit to specify the unit of measure.
Overwrites all existing values in the Height . column
Only visible to customers when comparing products, but also relevant for some shipping integrations.
Width Size_X - Add this column to your data file if you want to import the width in centimeters (cm)
Enter a numeric value without units.
Only in centimeters (cm). To import other units use width value and size unit columns.
Only integers, no decimals.
Ignored if the width value column contains data in the worksheet.
Only visible to customers when comparing products, but also relevant for some shipping integrations.
Width Value Size_X_Value - Enter this column in your data file if you want to import the width in centimeters or inches.
Enter a numeric value without units.
Accepts decimals.
Make sure to also add the Width Unit column to specify the unit of measure.
Overwrites all existing values in the Width . column
Only visible to customers when comparing products, but also relevant for some shipping integrations.
Size Unit Size_Unit - Add this column to your data file if you want to import the width in centimeters (cm) or inches.
Be sure to also add the Depth, Height, and Width Value columns to specify the product dimensions.
Enter the following for each product:
cm to set the units in centimeters.
in to set the units in inches.
Volume Volume - Add this column to your data file if you want to import the volume in ml.
(ml)
Only in milliliters (ml). To import other units use volume value and volume unit columns.
Only integers, no decimals.
Ignored if the volume column contains data in the worksheet.
Only visible to customers when comparing products, but also relevant for some shipping integrations.
Volume_Value Volume_Value - Add this column to your data file if you want to import the volume in centimeters (cm) or inches.
Enter a numeric value without units.
Accepts decimals.
Be sure to also add the Volume Unit column to specify the unit of measure.
Overwrites all existing values in the Volume . column
Volume Unit Volume_Unit - Add this column to your data file if you want to import the volume in centimeters (cm) or inches.
Be sure to also add the "Volume Value" column to indicate how much the product weighs.
Enter the following for each product:
ml to set the units to milliliters.
fl_oz to set the units to liquid onsen.
Matrix Matrix - These are visible in your online store when customers compare products. Only use the Matrix option if you use Paazl for shipments. Each matrix can have its own price group. If a product is very lightweight, but needs a large package because of its size, you can use a different matrix than with regular packaging.
Enter a letter from A - Z.
Colli - Colli (plural form colli), is the individual packing unit for a shipment. Configure this if you need multiple units to ship a particular product. Colli is only used in combination with Paazl.
SEO
Include product SEO information when you create a data file so that the SEO information is set immediately as the products are imported. This includes the product meta title, meta keywords, meta description, URL, and Google category.
For more information about product SEO click here.
Meta Title XX_Meta_Title- The title as displayed in the search engine results.
Limited to 70 characters.
Meta Keywords XX_Meta_Keywords- The keywords some search engines use to index your product pages in search engine lists.
Limited to 160 characters.
Separated by a space. For example, key1 key2 key3.
Meta keywords are no longer used by Google.
Meta Description XX_Meta_Description- The description that appears below your product title in some search engine results.
Up to 255 characters.
Use a natural flow of text and avoid only words separated by commas.
Product URL XX_URL - The URL that will be displayed when the customer visits the product on your web page.
Limited to 50 characters
When you import new products to eCom, the product URL is determined by the product name if this column is left blank.
Google Category *No system column name, map manually - A specific number or category required to integrate your products into Google Shopping.
Price
Columns for the price, old price, cost price, unit price, unit measurement and taxes can be added to your database. When you enter a value with currency, the currency will depend on your default currency in your eCom Back Office > Settings > Store Country> CURRENCIES.
For example, to import discounts, follow the instructions in Edit products via import. As you follow the instructions, you will use these column headings in your worksheet.
Internal_ID | Internal_Variant_ID | XX_Title_Short | Price_Old |
Price Price - The sales value of the product.
Add a numerical value, if empty, the product will be displayed at 0 euros, dollars or pounds etc. depending on the currency.
Do not include the currency symbol.
Old Price Price_Old - When the product is discounted online, add the previous price of the product. Most themes will visually improve sales by showing a line through the old price and showing the new discounted price.
Add a numeric value
Do not include the currency symbol.
Cost Price Price_Cost - The amount you paid to the seller or supplier.
Add a numeric value
Do not include the currency symbol.
Unit Price Price_Unit- The price of the product per unit.
Add a numeric value
Do not include the currency symbol.
Unit of Measure Unit - Add Unit of Measure column to specify the units of measure for the product.
If you add a unit of measure for your products sold by the unit, use one of these options:
Acre
Are
Capsule
Carat
centimeter
Cubic centilitre
Cubic centimeters
Cubic decameter
Cubic decimeters
Cubic feet
Cubic inches
Cubic meters
Cubic millimeters
Cubic yard
decilitre
Decimeter
Foot
Gallon
gram
hectares
Hectometre
inch
Kilogram
Kilometers
Liter
meters
micrometer
Mile
milligrams
milliliters
Millimeter
U.S
Couple
Piece
Lb
Square centimeter
Square foot
Square inches
Square kilometers
Square meter
Square Mile
Square millimeter
Square yard
Stone
Tablet
Ton
Ton
Yard
Tax Tax - If you use manual taxes, you can add a tax column and enter the tax percentage for each product. If you are using automatic taxes (North America), this column is not used.
Enter the numerical percentage value, for example, if the tax rate is 23%, enter: 23.
Do not enter the percent sign.
Stock
When you create your data file, you can add columns for product visibility, stock level, stock level and visual alert alert level, backorder settings, and minimum/maximum order quantity.
Visibility Visible- Whether the product is visible on your eCom store's website. Enter the following for each product:
Y to set the product as Always visible.
N to set the product as Hidden.
S to set the product as Visible when in stock.
Stock Level Stock_Level - The stock level of this product or variant.
Enter a numeric value
Inventory Tracking Enabled Stock_Track- Add this column to configure eCom to track the inventory of a variant of a product. Enable this to prevent out-of-stock purchases. Only disable it if the stock level for this variant is not important or does not exist. For more information click here. Enter the following for each product:
Y to avoid an out-of-stock purchase.
N to allow a purchase that is no longer in stock.
Minimum stock Stock_Min - The amount of stock that is reserved. For more information click here.
Enter a numeric value
Inventory Alert Level Stock_Alert - Alerts back office users when a product's inventory is low. If the value is below the stock level, the stock level is colored yellow.
Enter a numeric value
Inventory does not allow backorders Stock_Disable_Sold_Out - Add this column to enable or disable backorders for your products. Disable it to prevent the purchase of out-of-stock products. Only enable it to allow purchases of products that may be temporarily out of stock. For more information click here. Enter the following for each product:
N to allow backorders for your products.
Y to disable backorders for your products.
Maximum Order Quantity Buy_Max - Add this column to set a limit on the number of products a customer can purchase in one order. E.g. maximum 5 per order.
Enter a numeric value
Minimum Order Quantity Buy_Min - Add this column to set a limit on the minimum number of products a customer must purchase per order. For example, you need to buy at least 3 of these products.
Organization
Categories, brands, suppliers and tags can be added to your database to organize your products once they are imported. If the category, brand, supplier or tag exists in eCom with a name that matches your data file, it will be added to the product. If it doesn't exist, it will be created automatically.
For example, to import categories to your existing products, follow the instructions in Edit products via import. As you follow the instructions, you will use these column headings in your worksheet.
For more information about:
Categories, click here.
For brands, click here.
Suppliers, click here.
Tags, click here.
Internal_ID | Internal_Variant_ID | XX_Title_Short | XX_Category_1 | XX_Category_2 | XX_Category_3 |
Category 1, Category 2, and Category 3 XX_Category_1XX_Category_2XX_Category_3- The name of the main category, subcategory, and subsubcategory. Customers will use categories as navigation on your website.
Categories are nested when imported. For example, category 1 is the main category, category 2 is imported within category 1. Category 3 is introduced within Category 2.
Each variant of a product must have the same category structure.
Limited to 255 characters each.
The category name cannot be edited or overwritten during import. Category name edits must be done manually.
Brand Brand- You can organize your products by brand. Some themes can automatically create a page for customers to find products by brand.
Up to 255 characters.
Supplier Supplier- This is not visible to your customers and is a way for you and your staff to organize your products in the back office.
Up to 255 characters.
Tags Tags- Customers can sort products by tags. They also contribute to SEO.
Tags must be separated with a comma. For example: tag1, tag2, tag3.
Identification Codes
Products have a variety of identifiers that can be classified into 2 groups based on behavior:
Internal - Internal IDs and internal variant IDs are used by the system as unique identifiers for each product.
Industry - Industry IDs are used in industry, including SKUs, item codes, barcode/EANs and HS codes.
Internal
Internal ID Internal_ID- The behavior of the internal ID changes depending on whether you are importing new products or editing products via import.
When you create a data file to import new products, use the Internal_ID column to indicate that a product has multiple variants, such as size or color/etc. by entering the same number in the Internal_ID column. The system will interpret this as one product with multiple variants. After the import, a unique internal ID is permanently set when creating a product. For more information about creating variants manually, click here.
When editing products via import, the Import tool uses the Internal_ID and the Internal_Variant_ID to identify the content. Therefore it is necessary to have the internal IDs and the internal variant IDs in your worksheet. Do not change the internal ID or the system will not be able to find that product.
Internal Variant ID Internal_Variant_ID - When you import products for the first time, you don't need an internal Variant ID column in your spreadsheet as the system automatically assigns a unique value to eCom once the product is imported. This column is only needed when editing products via import.
NOTE: Unlike industry IDs, the internal ID cannot be used to locate products in your eCom Back Office.
Industry
When creating your data file to import new products, you can add industry identifiers such as article codes, SKUs, barcodes (EAN) and HS codes.
You can also use item codes, SKUs, barcodes or EAN codes to create variants in the same way you can use internal IDs above, as long as a unique item code/SKU/barcode(EAN) is used for each row of variants of a product in your database.
For more information on product identifiers click here.
Article Code Article_Code- A custom inventory unit (SKU) that you assign to products so you can identify them in your online store. The item code is optionally visible on invoices and packing slips and can be used to search your online store and the back office.
Alphanumeric
Up to 255 characters.
SKU SKU- Inventory Unit (SKU), the number of the warehouse where products are stored. It is printed on the packing slip.
Alphanumeric
Up to 255 characters.
Barcode/EAN EAN- European Article Number (EAN), also used as barcode. Handy if you use a barcode scanner.
Alphanumeric
Up to 255 characters.
HS Code HS_Code- Harmonized System Code. Most shipping companies require HS codes for international shipments. To enable the HS codes in your eCom Back Office, click Settings> Advanced > Scroll to the STORE and enable the switch at HS Code.
Numeric, specified by the Harmonized Commodity Description and Coding System.
Up to 255 characters.
Additional template data
Additional template data is used to specify certain elements of your online store at the product level. What you enter here depends on the connection terms you enter in the Theme Editor. To enable the extra template data, click on Settings in the left menu of the back office. Workflow > In the section BACK OFFICE turn on the switch next to Extra template data.
Data 01 Data_01
No format, depending on theme or app requirements.
Data 02 Data_02
No format, depending on theme or app requirements.
Data 03 Data_03
No format, depending on theme or app requirements.
