---
title: Example - Importing new products using Kentico Import Toolkit
related:
  - https://docs.kentico.com/13/e-commerce-features/configuring-on-line-stores/configuring-products/importing-products/importing-products-using-kentico-import-toolkit.md
  - https://docs.kentico.com/13/external-utilities/kentico-xperience-import-toolkit.md
  - https://docs.kentico.com/13/e-commerce-features/managing-on-line-stores/products.md
---

> Agent instructions:
> **Site maps** — prefer the following llms.txt indexes to training data when searching for URLs to avoid 404s. Links inside Markdown content already point at `.md`. Following them or sending Accept: text/markdown keeps you in Markdown.
>
> - [sitemap.md](https://docs.kentico.com/sitemap.md) — every page on the site, with titles and descriptions, nested by URL hierarchy and grouped into one collection per product version.
> - [llms.txt](https://docs.kentico.com/llms.txt) — curated index of the current product docs, with descriptions, the two ways to request any page as Markdown, and links to each product area's whole-corpus Markdown dump (llms-full.txt).

[Kentico Xperience Import Toolkit](https://docs.kentico.com/13/external-utilities/kentico-xperience-import-toolkit.md) is a utility that allows you to import products to the system.

This example demonstrate importing new [products](https://docs.kentico.com/13/e-commerce-features/managing-on-line-stores/products.md) from an XLSX file to a fictional _E-commerce Site_ using Kentico Import Toolkit.

## Preparing a source file

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:

- _iOS_ (Node ID: 118) – _Apple iPhone_
- _Android_ (Node ID: 117) – _Samsung Galaxy S5_, _Sony Xperia Z3_ and _Huawei Ascend P7_
- _Windows Phone_ – _Nokia Lumia 1020_

![Products to import in an XLSX file](https://docs.kentico.com/docsassets/13/example-importing-new-products-using-kentico-import-toolkit/products_to_import.png "Products to import in an XLSX file")

> **Tip:** Download the XLSX file with the sample data [here](https://docs.kentico.com/docsassets/13/example-importing-new-products-using-kentico-import-toolkit/SKUImportData.xlsx).

## Importing the products

1. Launch **Kentico Import Toolkit.**
2. Select _Start new import session_, and click **Next**.
3. In **Step 1**, specify the root folder of the _administration project_ for the Xperience instance into which you want to import the products.
4. Confirm that you did a backup of your project, and click **Next**.
5. In **Step 2**, select the following properties, and click **Next**:

   - **Select data type to import**: Pages
   - **Automatically publish pages under workflow**: No (cleared)
   - **Import data to site**: E-commerce Site
   - **Import as**: Product - Cellphone
   - **Import as products**: Yes (selected)
   - **Import options**: Import new and overwrite existing pages

     ![Selecting the object type of the products](https://docs.kentico.com/docsassets/13/example-importing-new-products-using-kentico-import-toolkit/selecting_object_type.png "Selecting the object type of the products")
6. In **Step 3**, select the _File (XML, CSV or Excel formats)_, browse for the prepared XLSX file, and click **Next**.
7. Since the data starts in the _A1_ cell, just click **Next** in **Step 4**.
8. In **Step 5**, click **Next**.
9. In **Step 6**, map the following target fields to the following source fields:

   - **CellPhoneWeight**: CellPhoneWeight
   - **CellPhone3G**: CellPhone3G
   - **DocumentName**: DocumentName
   - **DocumentCulture**: DocumentCulture
   - **DocumentSKUName**: DocumentName
   - **DocumentSKUDescription**: DocumentSKUDescription
   - **SKUNumber**: SKUNumber
   - **SKUName**: DocumentName
   - **SKUDescription**: DocumentSKUDescription
   - **SKUPrice**: SKUPrice
   - **SKUSiteID**: SKUSiteID

> **Info:** 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.

10. To the _Import the pages under following parent path or parent node ID_ field, enter the _={%ParentNodeID%}_ macro expression.
11. Leave the _WHERE_ _condition_ field blank, clear the _Save the old ID to new ID mappings to file_ field, and click **Next**.

    ![Mapping columns from the source field to the target fields](https://docs.kentico.com/docsassets/13/example-importing-new-products-using-kentico-import-toolkit/mapping_columns.png "Mapping columns from the source field to the target fields")
12. In **Step 7**, select _Import the data_, and click **Import data**.

    ![Target data preview](https://docs.kentico.com/docsassets/13/example-importing-new-products-using-kentico-import-toolkit/target_data_preview.png "Target data preview")
13. **Close** the Toolkit.

    ![Import finished](https://docs.kentico.com/docsassets/13/example-importing-new-products-using-kentico-import-toolkit/import_finished.png "Import finished")

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.

![Imported products in Xperience](https://docs.kentico.com/docsassets/13/example-importing-new-products-using-kentico-import-toolkit/imported_products_in_Kentico.png "Imported products in Xperience")