Import product data (censhare Client)

Import product data from an external source or supplier via a Microsoft Excel file into censhare. The import creates Product assets and Product item assets in with the respective product properties in the censhare PIM application.

Prerequisites

You should be familiar with the product data structure of your censhare PIM.

Introduction

To exchange product data between censhare PIM and third-party systems or customers, you need to import the data to you censhare system. Microsoft Excel is a widely used, human-readable and machine-readable format. For example, if technical specifications or prices of your products change, customers, retailers or partners send you the updated data in a Microsoft Excel file which you import to your censhare system.

censhare PIM uses Pentaho PDI to import data from Excel. Pentaho PDI is an Extract, Transform, Load (ETL) processor from Hitachi Vantara. Based on a predefined schema for product and product item data, Pentaho transforms and splits the data into individual data records and passes them to censhare.

The import creates new Product assets and Product item assets with the respective properties in censhare. If censhare identifies existing assets that match the imported data records, it updates these. For more information see Update existing assets.

Importing product data requires an import schema. For a successful import, the source file must conform with the import schema. The import schema also defines how the data structure of the import file is transformed and split in order to match the censhare data model. You can use multiple import transformations with one configuration. This article describes the default import from Microsoft Excel. Other import formats can be available in your system.

Starting an import extracts the data from the uploaded Exel file and transforms it and splits the data into individual records. These records create new assets or update existing ones.

Import product data

1. Open the Server actions menu and select Schema based import. This is the default name of the action. The name can be different in your censhare system:

   Icon	Action
   	Opens the server actions menu.

2. In the file browser dialog window, select the Excel file that contains the data that you want to import and confirm your selection.

3. In the Schema based import dialog, select an import option. The selected option must correspond to the data structure of the source file. The following options are available in the censhare standard configuration:

   • Pentaho import products and product items from one Excel sheet

   • Pentaho import products and product items from separate Excel sheets

4. To start the import, click OK.

5. censhare opens the newly created assets in a new tab. If an error occurs during the import, censhare aborts the import. Data that have been imported yet are not deleted. An error report is shown in the dialog field. For more information, see Troubleshooting. 

Update existing assets

During an import, censhare checks for existing assets and updates these instead of creating new assets. In the standard configuration, censhare uses the following properties as unique identifiers. They can be customized in your system:

censhare checks in the defined order if one of these properties is found in the imported data sets. First, it checks the ID, next the UUID, and so on. It then compares these values to the existing asset data in the censhare data base (cdb). If any two values match, censhare updates the existing assets. The imported data overwrite the stored data. If none of the properties are found in the imported data, or if no matches are found with existing assets, censhare creates a new asset.

The following table shows the match schema that results in an update of an existing asset asset:

Notes

(1) If two properties match, the following ones are not checked. For example: The IDs of an imported data record and an existing asset match. The data record does not contain a UUID and an External ID. The GTIN and EAN do not match. The asset is updated, censhare overwrites GTIN and EAN with the values from the import data.

(2) The matching algorithm provides a common schema that can be used for different import formats. The six standard keys cover most use cases from external PIM providers. Customize the schema only if your specific use case is not applicable.

Result

The selected product data is available in censhare. New Product assets and Product item assets are created. Existing Product assets and Product item assets are updated.

Troubleshooting