• Documentation
  InstallationUsing the Kentico interfaceDeveloping websitesConfiguring KenticoManaging usersSecuring websitesDeploying websitesManaging website contentMultilingual websitesMacro expressionsExternal utilitiesIntegrating 3rd party systemsCustom developmentE-commerce featuresOn-line marketing featuresIntranet featuresCommunity featuresRunning Kentico on Windows AzureReferences
• Tutorial
  Using the Kentico interfaceManaging content - The basicsSite development overviewCreating pages using the portal engineWalkthrough - Creating a new site using the Portal engineCreating pages using ASPX templatesWalkthrough - Creating a new site using ASPX templates

1. Start a new import session.

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

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

3. Select the object type that the system will use to store the imported data.

   • Select data type to import - Documents.

   • Import as - select the product type 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 documents and overwrite the existing ones.

4. Specify the source of the imported data.

   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.

6. Preview the source of data.

7. Check and configure the field mappings.

   • Import the documents under following parent path or parent node ID - specifies the path (for example, /Products/Electronics/Cellphones) or node identifier of the parent document 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 documents as specified in your source of data.
   • WHERE condition to find existing documents 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 documents (in the Import options section while selecting the object type).
   • 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.
   You are importing products, i.e. creating product objects, together with associated product documents.

   That's why the DocumentName, DocumentSKUName and SKUName target fields must map to the same source field.

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.

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.

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.

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

3. Repeat the steps that you went through while importing the products (Kentico Import Toolkit wizard).

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

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