Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Import Export

...

Tool

The PIM includes an import export tool for new product creation, customizable exports and round trip bulk editing via CSV files. Due to the nature of mass editing, restrictions are imposed throughout the process to ensure the integrity of your data.

Info

Please note that this is an advanced feature of the PIM and requires familiarity with several PIM features and operations. You are advised to read through the prerequisite articles below prior to attempting to use the import export tool.

Prerequisites

Create a Profile

  1. Navigate to the Import/Export Tool found on the left side navigation menu and select profiles

  2. Click Create an Import Export Profile

  3. Name Your Profile

  4. Designate a Channel for imported products to be enabled on by default - Optional

  5. If prices are going to be part of an import, define the pricing criteria (most fields are optional and best left default)

  6. Configure the fields (see below)

  7. Save The Profile

The Price Configuration

  • Author - The pricing authority for this import - Default is SYSTEM

  • Book Type - Master, Vendor, Etc - Default is MASTER

  • Price Book Code - Regular, Update, Promotion - Default is REGULAR

  • Base - This must match the Price Base designated for the channel on which, you wish to enable publishing. - Default is US

  • Currency - The currency abbreviation for the price - Default is USD.

...

Configure The Fields

For each field in the PIM you wish to export/import, you need to provide a label for the CSV column header. These are Case Sensitive.

...

...

Attributes

All product attributes with slugs will be available (will display name, slug). Slugs are a unique identifier tied to that attribute.

...