The Fivetran connection states that it has the following limitation: "If an update to a child object does not trigger an update in its parent object, we do not capture the update until the parent object is updated." (https://fivetran.com/docs/connectors/applications/shopify#synclimitations)

This limitation causes issues for our business in the following scenario:

• An order is created for a customer in Shopify that is NOT associated with a B2B company.
• Fivetran ingests the order and company_id and company_location_id are null.
• Later on, a user in Shopify migrates the original customer to a B2B customer by associating them with a company. As part of that migration, they also migrate the customer's historic orders and associated them with the B2B company. (https://help.shopify.com/en/manual/b2b/getting-started/migrating-customers)
• Because this is an update to an association and not an update to the order object itself, the Fivetran connector does not sync in the new information.
• company_id and company_location_id remain null, even though the order is now associated with a company.

This causes problems downstream for us because we are syncing data into our CRM based on company associations. I would love to see this limitation of the connector removed so that these associations stay current without the need for manual re-syncs.