Skip to content

Export products to CSV

The CSV export produces files that are designed to be re-importable. Empty referential type attribute values - including empty referential type elements in multi-valued attributes - are exported as empty cells rather than the NULL keyword. This ensures that re-importing the exported file preserves empty values correctly without creating index gaps. For details on how NULL and empty values are handled during import, see the CSV specification.

Calculated attributes

A calculated attribute is exported as its calculated result, in a column named after the attribute and its RESULT field, for example MARGIN/RESULT. The formula is not exported.

When the result varies by market, channel, device, or language, the export has one result column per segmentation, with the same segment suffixes as other segmented values, for example MARGIN/RESULT:MDENMARK. With Include default values, the export also has a MARGIN/RESULT:Default column with the result calculated without a segmentation.

A product whose formula cannot be calculated gets an empty cell.

The product CSV import ignores the result columns, so the exported file can still be imported again. See Calculated attribute values.

Bizzkit recommends

Opening a CSV export file in Excel

Microsoft Excel is a popular editor that can be used to open CSV files exported from Bizzkit PIM. However, there are known issues with encoding and formatting where Excel may not always interpret the exported data correctly.

To ensure proper handling of CSV files in Excel, follow these steps:

  1. Open a new blank workbook in Excel - do not double-click the CSV file, as this will open the file in a wrong way
  2. Go to the Data tab on the ribbon
  3. Click From Text/CSV
  4. Select your CSV file and click Import
  5. In the preview window, make sure the following options are selected:
    1. File Origin: 65001: Unicode (UTF-8)
    2. Delimiter: Semicolon
    3. Data Type Detection: Based on first 200 rows
  6. Click Transform Data
  7. Click the Use First Row as Headers button on the ribbon
  8. Click the Close & Load button on the ribbon

Alternatively, other tools besides Excel can be used for editing CSV files.