Error : All matrix children doesn’t contain same product_id.

The error “All matrix children doesn’t contain same product_id” in Celigo typically occurs when syncing a matrix item from NetSuite to Shopify. This happens because Shopify expects all variants (matrix children in NetSuite) of a matrix item to share the same product_id, whereas in NetSuite, each matrix child might be treated as a separate product.

Troubleshooting and Potential Solutions:

1. Check Matrix Item Configuration in NetSuite:

• Ensure that all matrix child items are correctly linked to the same parent matrix item in NetSuite.
• Verify that each matrix child item is using the same set of attributes (such as size, color, etc.), as Shopify will treat them as variants of the same product.

2.Review Celigo Mapping:

• In your Celigo integration, confirm that the product IDs are mapped correctly for matrix children and the parent matrix item.
• You may need to adjust the mapping so that all matrix children reference the same product_id in Shopify.

3.Consolidate Product IDs:

• In Shopify, all matrix children should correspond to the same product_id to ensure consistency. You may need to manually update or remap product variants in Shopify to have the same product_id.

4.Update Shopify Data:

• If the matrix items already exist in Shopify but with different product_ids, you might need to delete the product in Shopify and resync it from NetSuite to ensure all matrix children are properly grouped under the same product_id.