This section explains in detail how the connector builds the merged output when Products and Variants are combined. The Parent-Child logic is essential for marketplaces that work with product variations such as size, color, material, or style.

How merged records are generated

When both Products and Variants tables are active, the connector:

• Reads the Products table.
• Finds all Variants linked to each product.
• Creates one output row per variant.
• Combines category-level fields, if categories are merged, product-level fields, and variant-level fields.

This produces a flat CSV where each row fully describes a specific variant but also contains all necessary product information.