When both the Product and Variant tables send data to the same output column, the connector applies strict priority rules to avoid ambiguity.

Rule 1: Variant fields override Product fields

If a column is mapped at both levels:

• Variant value takes precedence.
• Product value is used only if the Variant value is empty.

Rule 2: Empty variant values fall back to product values

If a variant contains an empty string, null, or an empty numeric value, the connector uses the product-level value.

Rule 3: Parent rows use only Product fields

When Add parents to variants is enabled, the extra Parent row has all product fields and no variant fields.

Rule 4: Formulas follow the same precedence

If a formula is used at variant level, it overrides product-level formulas.