Is this really the version you are looking for? Kentico Xperience 10 Documentation is no longer updated. Use the switcher in the header to choose your product version.
Kentico Import Toolkit is a utility that allows you to import products to the system.
This example demonstrate importing new products from an XLSX file to the sample E-commerce Site using Kentico Import Toolkit.
Before starting to import new products, prepare your XLSX file with products. The top row should contain the column names from the database table. We add five cellphones to sections according to their operating system:
Since the sample E-commerce Site does not have a section for Windows Phone, the parent node of Nokia Lumia 1020 will be Cellphones (Node ID: 68).
Download the XLSX file with the example data: SKUImportData.xlsx.
Launch Kentico Import Toolkit.
Select Start new import session, and click Next.
In Step 1, specify the root folder of the project into which you want to import the products.
Confirm that you did a backup of your project, and click Next.
In Step 2, select the following properties, and click Next:
In Step 3, select the File (XML, CSV or Excel formats), browse for the prepared XLSX file, and click Next.
Since the data starts in the A1 cell, just click Next in Step 4.
In Step 5, click Next.
In Step 6, map the following target fields to the following source fields:
Some of the fields are mapped automatically (from the list above and also not from the list above). Check whether these fields are mapped correctly.
To the Import the pages under following parent path or parent node ID field, enter the ={%ParentNodeID%} macro expression.
Leave the WHERE condition field blank, clear the Save the old ID to new ID mappings to file field, and click Next.
In Step 7, select Import the data, and click Import data.
Close the Toolkit.
The system now contains the five products you just added. Open the Products application in the administration interface to see the products assigned to the specified sections.