This article will help you import new products, whether you're starting from scratch or switching to Lightspeed eCom from another platform.

Article navigation

This article is divided into two parts:

  • Instructions - Contain step-by-step instructions.

  • Reference - Contains reference material.

Instructions

A successful import depends on the quality of your data. That's why most of the steps you need to follow when importing to eCom revolve around your worksheet. For more information about the importance of a worksheet, click here.

Use the following instructions to get started:

  1. Creating your worksheet

  2. Import your worksheet

  3. Verification of your worksheet

1. Creating your worksheet

To import new products, these steps instruct you to create an empty table that will become your worksheet.

  1. Click here to sign in to your Google account and open Google Sheets. Google Sheets is the recommended spreadsheet software. For more information about this software and its format, click here.

  2. Create a new blank worksheet by clicking +. This is used as a worksheet.

  3. In column A, add a column for the product title. Read Formatting Columns in Your Worksheet to learn more about the requirements of this column and how to name it.

  4. In the following columns, add the column titles for the data you need to import.

    1. For the most important columns needed to start from scratch and why, see Common Required Columns for Worksheet .

    2. Use the article Product column titles to know the available columns to be added, as well as their specific requirements.

  5. Enter your product data for each column.

  6. When you're done, save your worksheet to your computer. This can be done by clicking File > Download as > Comma separated values โ€‹โ€‹(.CSV). Note: the file can contain a maximum of 1000 lines. Do you want to import more rules? Then split the file.

2. Import your worksheet

Once you've created your new product import worksheet, you can import it into eCom.

  1. In the eCom store's back office, click Tools.

  2. Click on New Import.

  3. Click Browse computer.

  4. Find your worksheet and click Open.

  5. Click on Choose what to import and click on Products.

  6. The page will continue automatically. In the section ADDITIONAL SETTINGS:

    1. For Behaviour, click Choose: and select Add new products only.

    2. For Group by, click on Product ID and select the column that your worksheet uses to group variants. For example, you use the Product ID to group variants. For more information, see Internal ID.

  7. The columns in the SELECT FIELDS section are automatically mapped to the correct fields as long as the column headings have not been changed in your worksheet. Find out which columns should be mapped to the correct fields using the table in the Product column titles article.

  8. Click Continue in the top right corner of the screen.

  9. Click Start the import. The Import tool will start processing the import. You don't have to stay on the page and can come back to it later.

3. Verifying your changes

It is necessary to check whether your new products have been successfully imported after starting an import. After checking the Import tool for errors, it is important to randomly test some products from your worksheet and confirm whether your edits have taken place.

3a. Confirm that no errors occurred during the import:

  1. Log in to your eCom store's back office and click Tools.

  2. Find your import by date or file name and click on View report next to the status.

  3. If errors are visible, correct your worksheet and re-import your edits. To see frequently asked questions and ask your own questions about errors, visit the Lightspeed Community article here.

3b. Confirm that the new products have been added correctly

  1. In Google Sheets, open the sheet you uploaded on Lightspeed eCom.

  2. Select any row and copy the internal ID of the product.

  3. Log in to your eCom store's back office and select Products.

  4. Select a product.

  5. In the web address bar, replace the number na /admin/products/ with the copied internal ID and press Enter on your keyboard.

  6. Compare the product with your worksheet to make sure the changes you made are reflected correctly.

  7. Repeat steps 1-6 for a few products until you are sure all your new products have been imported correctly.

Reference

When you prepare your worksheet, you need to check specific things to make sure your import is successful. To find out the requirements for each column go to: Product column titles. In this reference section you can learn more about:

  1. Commonly required columns for worksheets

  2. Tips for column names in your worksheets

Commonly required columns for worksheets

Preparing a worksheet can seem overwhelming. To simplify this process, here are the most important columns you should add to your spreadsheet file and the reasons why they are important. For more information about each column name, click here. If you are familiar with a basic worksheet, you can add other columns to your worksheet using the information in this article.

You can copy the following columns, see below for an explanation of why they are important.

XX_ is used here as a reserved place for the language. This depends on your shop language or languages. For example, US_ for English (US) or EN_ for English (UK). Click here for more information.

When you have prepared your worksheet, learn how to import your file by clicking here.

Column name

System name

Importance

01

Product-ID

Internal_ID

Allows you to add variants.

02

Title

XX_Title_Short

Required upon entry.

03

Full title

XX_Title_Long

04

Description

XX_Short_Description

Used in most themes as a short summary of the product.

05

Content

XX_Long_Description

Most themes display the content on the product page. If left blank, the product page may look incomplete.

06

Variant title

XX_Variant_Title

When adding variants, you can set the title of the variant.

07

Category 1
Category 2
Category 3

XX_Category_1
XX_Category_2
XX_Category_3

Used for the navigation and product organization of your website. Cannot import changes to existing categories. For more information click here.

08

Brand

Brand

Used by most store navigation themes, usually an overview page showing all brands.

09

price

Price

Required when selling products online.

10

Visibility

Visible

Controls whether your products are immediately visible in your eCom store. For more information about product visibility, click here.

11

Stock Level

Stock_Level

Setting the stock level can prevent customers from buying more products than you have in stock.

12

Weight unit

Weight_Value
Weight_Unit

Setting the weight value and the unit is important for the shipping methods because the shipment is based on the weight. If you don't know the exact weight of each product, it's better to estimate instead of setting the weight of the product to 0.

Tips for column names in your worksheet

  1. When creating your worksheet, you should always include a product title for the column. This is the only required field when importing new products.

  2. You need to make sure that the column names of your worksheet match the column names in an export. In this way, the system will automatically map them to the corresponding fields when you import the worksheet. Otherwise, you'll need to map your columns manually. For more information go to Product column titles.

  3. You must name your columns according to the title of the column name in an export so that Lightspeed eCom automatically maps each column to a field when you import your spreadsheet. On the other hand, you can manually choose your own column titles on the input screen when you import your worksheet.

  4. When using your own column titles, make sure your columns are mapped to the correct fields in eCom. Visit the Suggested Mapping When Importing the Product Table Column Here.

  5. For more information about other languages โ€‹โ€‹visit our language table here.

Did this answer your question?