This section explains how the CSV Export connector organizes and exports data, and how the available parameters influence the final CSV output.

1. Multi-language export

The CSV Export connector can export multiple languages simultaneously.

When several languages are selected in the Parameters tab:

• The connector generates one column per field and per language, for example Name_en, Name_es, or Name_fr
• Any translatable field appears duplicated for each selected language
• All selected languages are exported in the same CSV

This makes the connector useful for internal data sharing, localization workflows, translation QA, and complete multilingual catalog exports.

2. Independent CSV output per table

By default, the connector exports one CSV file per table. This creates a clear set of files that reflects the PIM structure.

Typical output files include:

• categories.csv
• products.csv
• variants.csv
• points_of_sale.csv, if enabled
• custom_entities.csv, when additional tables are added

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

This is useful when you need clean data separation, when different tables will be imported into different systems, or when different teams require different datasets.

3. Merging tables

The connector allows optional merging through two parameters:

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

These options are independent. You can activate one, the other, both, or neither, depending on the output you need.

Merging Categories with Products

If Merge categories with products is enabled, the connector adds category fields directly into the Products CSV.

Each product row can include fields such as Category Name, Category Reference, Parent Category, or Category Images.

Merging Products with Variants

If Merge product information with variants information is enabled, the connector combines product and variant fields into a single table.

This generates one row per variant and leaves category information in a separate CSV unless category merging is also enabled.

Merging all three tables

When both merge parameters are enabled, the connector creates a single CSV file that contains category fields, product fields, and variant fields.

Important notes about merging

• The 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 includes empty variant fields

This merged output is useful when you need a simplified table with all catalog information in one file.