How the Connector works

This section describes how the Connector organises and exports data, and how the available parameters influence the final CSV output.

1. Multi-language export

The CSV Export Connector has the ability to export multiple languages simultaneously.

When you select several languages in the Parameters tab:

• The Connector generates one column per field per language (e.g., Name_en, Name_es, Name_fr).
• Any translatable field (name, description, label, etc.) will appear duplicated for each selected language.
• All languages are exported in the same CSV, which makes this Connector ideal for:
  • internal data sharing
  • localisation workflows
  • translation QA
  • exporting complete multilingual catalogues

2. Independent CSV output per table

By default, the Connector exports one CSV file per table, generating a clear and structured set of files that reflect your PIM architecture.

Typical output files include:

• categories.csv
• products.csv
• variants.csv
• points_of_sale.csv (if enabled)
• custom_entities.csv (for added tables)

Each file contains only the fields mapped for that specific table.

This makes the Connector particularly useful when:

• You need clean data separation
• You will import the tables into different systems
• You want to analyse or transform each dataset independently
• Different departments require different subsets of data

Because each table is exported independently, there is no product–variant merging logic unless you explicitly enable it.

3. Merging tables (Categories + Products + Variants)

The CSV Export Connector allows an optional merging of tables through two parameters:

• Merge categories with products
• Merge product information with variants information

These options are fully independent; you may activate one, the other, or both, depending on the type of consolidated output you need

.

Merging Categories with Products (only)

If you enable Merge categories with products, the Connector will:

• Add category fields (e.g., Category Name, Category Reference, Parent Category, Category Images)
• Directly into the Products CSV 

This results in a unified output where each product row includes its category information, while variants remain in a separate CSV unless variant merging is also enabled.

Merging Products with Variants (only)

If you enable Merge product information with variants information, the Connector will:

• Combine product and variant fields into a single table
• Generate one row per variant
• Leave category information in a separate CSV

This results in a consolidated file containing product and variant data, without involving the categories table.

Merging all three tables (Categories + Products + Variants)

When both parameters are activated, the Connector creates a single CSV file combining multiple tables.

This generates rows that include:

• Category fields
• Product fields
• Variant fields

Important notes about merging:

• This merging is flat and non-hierarchical.
• No Parent-Child model is applied.
• No Parent rows are created.
• If a product has no variants, the row will simply include empty variant fields.

This merged output is useful when:

• You want a single table with all catalog information
• You need a simplified export for external tools
• You want to share a consolidated dataset internally

This merging flexibility allows you to configure the CSV Export Connector exactly as needed, whether you want a single fully consolidated file, or a partially merged structure, or to keep all tables separate.

However, this merge is not suitable for marketplaces because:

• No Parent-Child structure is generated
• No grouping logic is applied
• No marketplace rules or formatting are enforced

For marketplace exports, use the CSV Connector for Marketplaces.