---
title: Importing products using Kentico Import Toolkit
related:
  - https://docs.kentico.com/k81/e-commerce-features/configuring-and-managing-your-store/products.md
  - https://docs.kentico.com/k81/e-commerce-features/customizing-and-developing-your-store/e-commerce-customization-examples/importing-products-using-api.md
  - https://docs.kentico.com/k81/external-utilities/kentico-import-toolkit.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 Import Toolkit is a utility that allows you to import data from external sources into the system. As a source of data, you can use:

- XML file
- MS Excel files, such as CSV or XLSX files
- MS SQL database

The following examples demonstrate how you can:

- **Import products from an external source of data into a Kentico website.**
- **Change product properties using an external source of data.**

In these examples, you will be importing [products](https://docs.kentico.com/k81/e-commerce-features/configuring-and-managing-your-store/products.md), i.e. creating product objects, together with associated product pages, using an XLSX file.

**You can use this procedure to import products into any Kentico website from any of the listed sources of data.**

## Importing products from an external source of data

### Taking preparatory steps

1. Prepare your external source of data, for example an XLSX file. Make sure that all product properties required for import into the Kentico database are included.

   - **SKUNumber** - contains product designation (product number) used in your external warehouse. The property allows you to bind product data in your on-line store with product data outside Kentico; an optional field.
   - **SKUSiteID** - specifies a unique identifier of the website where you want to import the products. You can get this value from the _**CMS\_Site**_ database table.
   - **NodeID** - specifies a unique identifier of the node, i.e. an item in the website structure under which you want to place the imported products. You can get this value (_Node ID_) from **Pages -> Edit -> Properties -> General** after selecting the node from the content tree.

![External source of data - objects definition](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/external_source_update.png "External source of data - objects definition")

2. Launch the Kentico Import Toolkit in **Start -> All programs -> Kentico  -> Utilities** (Windows).

   This opens the initial screen of the Kentico Import Toolkit wizard.

### Using the Kentico Import Toolkit wizard

> **Info:** In each (except for the initial) wizard step, you can click **Save profile** and save the configuration done until that point. The system saves the configuration as an ._iprofile_file in a destination of your choice.

1. Start a new import session.

   - Alternatively, load an import profile that you created during a previous product import.

![Starting a new import session](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/starting_import_session.png "Starting a new import session")

2. Specify the root folder of the project into which you want to import the products.

   ![Selecting the target project](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/selecting_target_project.png "Selecting the target project")
3.  Select the object type that the system will use to store the imported data.

   - **Select data type to import** - _Pages_.
   - **Import as** - select the [product type](https://docs.kentico.com/k81/e-commerce-features/configuring-and-managing-your-store/products/managing-product-types-and-product-section-types.md) that the system will use to store the imported products.
   - **Import as products** - confirm that the data is imported as products.
   - **Import options** - select that you want to import new pages and overwrite the existing ones.

![Selecting the object type to import](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/selecting_object_type.png "Selecting the object type to import")

4. Specify the source of the imported data.

   > **Note:** If you specify a source of data different from an XLSX or CSV file, the Kentico Import Toolkit wizard displays the following step accordingly.

5. Specify the row and column of the source file that the system will take as the beginning of the heading row of the imported data.

   ![Selecting the data](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/selecting_data.png "Selecting the data")

6. Preview the source of data.

7.  Check and configure the field mappings.

   - **Import the pages under following parent path or parent node ID** - specifies the path (for example, _/Products/Electronics/Cellphones_) or node identifier of the parent page under which you want to place the imported products. In this example, the value corresponds to the value of the _ParentNode_ field in your source XLSX file.\
     If you insert the _={%ParentNodeID%}_ macro expression, the system automatically places the imported products under different parent pages as specified in your source of data.
   - **WHERE condition to find existing pages based on source data** - determines which of the existing products the system skips or overwrites. Hidden if you configured the Kentico Import Toolkit to always insert the imported products as new pages (in the **Import options** section while [selecting the object type](#importingproductsusingkenticoimporttoolkit-anchor1)).
   - **Save the old ID to new ID mappings to file** - saves mappings of source identification fields to target identification fields into an _.fkmap_ file. You can use this file when configuring field mappings during your later import sessions.

   > **Info:** You are importing products, i.e. creating product objects, together with associated product pages.
   >
   > That's why the _**DocumentName**_, _**DocumentSKUName**_ and _**SKUName**_ target fields must map to the same source field.

   ![Configuring the fields mapping](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/configuring_fields_mapping.png "Configuring the fields mapping")

8. Preview the target data.

9. Perform the import of product data from the source to your on-line store.

   The Kentico Import Toolkit informs you about the result of the import.

   ![Viewing import results](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/import_results.png "Viewing import results")

10. Close the wizard.
    - Alternatively, continue with one of the available scenarios (the **Continue with** section).

If you open the **Products** application, you can see that the imported products are listed under **Electronics -> Cellphones**.

![Imported products](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/imported_products.png "Imported products")

## Changing product properties using an external source of data

1. Update your external source of data.

   For example, change the price of the products. This means that you need to update the values in the respective field of your source file.

   ![External source of data - objects update](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/external_source_update.png "External source of data - objects update")
2. Launch the Kentico Import Toolkit in **Start -> All programs -> Kentico  -> Utilities** (Windows).
3. Repeat the steps that you went through while [importing the products](#using-the-kentico-import-toolkit-wizard) (Kentico Import Toolkit wizard).

   > **Note:** In **Step 2 - Select object type to import -> Import options**, make sure the **Import new and overwrite existing pages** option is selected.

If you now open the **Products** application and go to **Electronics -> Cellphones**, you can see the updated price.

![Updated products](https://docs.kentico.com/docsassets/k81/importing-products-using-kentico-import-toolkit/updated_products.png "Updated products")