Product Import

In this section, we will learn how to efficiently create or update product content via import. The process is divided into two sections: creating new products and updating existing product content.

Product Creation

For product creation, a sample import sheet is provided on the same page under the "Download Sample" section. This sheet serves as a template for Product Creation in PIM. When importing products, PIM requires the following mandatory headers in the import sheet:

Required headers

These headers are mandatory in the import spreadsheet.

  1. sku: Product SKU, which must be unique. If the product SKU already exists in PIM, the system will update the product content instead of creating a new product.

  2. family: Product Family Code. (Reference Link)

  3. channel_code: Channel Code to assign the product to a specific channel.

  4. category_code: Category Code to assign the product to a specific category.

  5. channel_product_status: Determines whether the product is active or inactive for a specific channel.

  6. product_completeness: Indicates the Product Completeness Status, determining whether the product is Published, in Draft, or in Ready status.

Required values

These product content must contain a values section.

  • sku

  • family

Custom Attribute

For user-defined attributes, the header in the import sheet should contain the Attribute Code and Locale Code. For example, when updating the Name for a product, the header should be in the format of name-en_US, where "name" is the attribute code for the name attribute, and "en_US" is the locale code.

Similarly, for updating the Image and Description for product content, the attribute headers should be in the format of image-en_US and description-en_US, respectively. This format ensures that the import process accurately maps the custom attribute values to the corresponding product attributes in the specified locale.

  • If there are multiple languages, each should have a separate header for columns with <language code>, like “name-en_US”

In PIM product imports, all header values should be case-sensitive. Ensure the accuracy of header values to avoid import errors.

Product Update

Updating products is simpler than creating new ones. With the Product Update sheet, users can update one or more specific attributes for existing products.

Required Headers:

Only the "sku" header is mandatory for product updates. It is essential to ensure that the product SKU already exists in PIM. Otherwise, PIM will not import the product content, and an error message will be logged.

For user-defined attributes, the header in the import sheet should contain the Attribute Code and Locale Code. For example, the header should be in the format of <attribute_code>-en_US. This format ensures that the import process accurately updates the specified attributes for the product in the specified locale.

Required Values

  • sku

Important Notes

  1. sku: The SKU must be unique and is a mandatory value for both Product Create and Update Imports. If the SKU is not present, PIM will return error message logs.

  2. family: The family code is mandatory during the product creation process. You can validate valid family codes from the Family List Page. If you want to change the attribute family from one to another, you can specify the new attribute code in the Product Update Import sheet.

  3. channel_code & category_code: Channel code should exist in PIM. You can validate channel codes in the Channel and Category List Page.

  4. channel_product_status: For Product Channel Status, 0 means Inactive and 1 means Active. If no value is mentioned, it defaults to inactive.

  5. Radio Attribute Type: Values should be either Yes or No.

  6. Price Attribute: Values should contain the currency code. For example, if the price attribute value for Product ABC is $7.47, the sheet should contain 7.47 USD.

  7. Select and Multi-Selection Option: These options are created automatically during product import.

  8. Metric Attribute: For Metric attributes, users can set the Metric Unit by mentioning it next to the metric value. For example, if Product ABC has a weight attribute with a value of 750 grams, in the import sheet, users can change the type of the metric to 0.750 kilograms.

  9. Image and File Attribute Type: Users can mention the file path in the import sheet for Image and File Attribute types.

Data Overwrite

Data Overwrite is an option available during the Product Import process. This option is presented in the dropdown box when selecting the import method. The Data Overwrite feature is designed to manage existing data during import operations, specifically for product images and multi-select attributes.

When the Data Overwrite option is enabled, it performs the following actions:

  1. For Product Images:

    • If an image value is already present for a product, enabling Data Overwrite will remove the existing image and replace it with the image specified in the import sheet.

    • If the uploaded sheet contains an image value that is already associated with the product, Not enabling Data Overwrite will duplicate the image against the product.

  2. For Multi-Select Attributes:

    • If a multi-select attribute value is already assigned to a product, enabling Data Overwrite will remove the existing value and update it with the value provided in the import sheet.

    • If the uploaded sheet contains a value that is already assigned to the product, Not enabling Data Overwrite will update the attribute with the new value.

It's important to exercise caution when using the Data Overwrite option, as it directly affects existing data within the system. Careful consideration should be given to ensure that the desired outcome is achieved without unintended consequences.

When importing categories for products, it is essential to include the Channel Code and Channel Product Status. This is crucial as PIM supports a many-to-many relationship between product categories and channels.

Last updated