How merged records are generated

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
  • Variant-level fields

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