Precedence rules

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 → used only if Variant value is empty

Rule 2: Empty variant values fall back to product values

If a variant contains:

• Empty string ("")
• Null
• Empty numeric value

…then 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
• No variant fields

Rule 4: Formulas follow the same precedence

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