The Import/Export function in Kontainer’s PIM (Product Information Management) system allows you to efficiently bulk update product data. This feature is especially useful when you need to make larger edits—such as updating product descriptions, attributes, or other metadata—directly in Excel.

Step 1: Choose Variant View

Before starting, make sure you are in Variant View, which displays all individual variants of your products.
This ensures that any updates or changes are applied to the correct variant level.

Step 2: Export Product Data

You can export data in two ways:

• Export selected products:
  Mark the specific products you want to edit, then click Import/Export → Export.
• Export all products:
  If no products are selected, simply choose Import/Export → Export to export your entire product list.
  
  

An Excel file will be downloaded containing the selected product data.

Step 3: Edit the Excel File

Open the downloaded Excel file to make your edits. For example, you might update product descriptions, change attribute values, or adjust pricing details.

Important:

• Do not edit or delete the first three columns — these are internal Kontainer reference fields required for a successful import.
• You may delete any other columns that you are not changing.
  This helps keep your file clear and can speed up the import process.

Editing Tips

When editing your Excel file, please note the following rules:

• Empty cells: No changes will be made to those fields.
• Type “NULL”: Deletes any existing value in that field.
• Multi-value fields: Separate multiple values with a semicolon (e.g. Red;Blue;Green).
• Select fields: You can only use existing predefined values.
  If a value cannot be found in Kontainer, the system will highlight this during validation before import.

Once your edits are complete, save the file locally.

Step 4: Import Updated Data

Return to Kontainer (without having any products selected) and click Import/Export → Import.

1. Select your updated Excel file.
2. Click Preview import changes to start the validation process.

Step 5: Validate & Confirm Changes

Kontainer automatically checks your file before any data is updated.

• If errors are found:
  The system will display validation errors (for example, misspelled or non-existent values).
  You can correct these directly in Excel and re-upload the file.
• If no errors are found:
  You’ll see a summary of all proposed changes.
  Review these, and when you’re ready, click Import changes to confirm and apply your updates.

---

Summary

Using the Import/Export function is the most efficient way to:

• Quickly update multiple products at once
• Maintain data accuracy
• Save time when managing large product catalogs

By following the above steps, you can keep your product data clean, consistent, and fully optimized within Kontainer PIM.