Question
What does the checkout table contain in the Shopify connector?
Environment
Connector: Shopify
Answer
The table is used to capture the abandoned checkouts. This table has a column called completed_at which is supposed to be null for these orders. However, this column sometimes contains not null values. These not null values represent the abandoned checkouts which were completed later at some point. Fivetran captures abandoned carts and we update them when they are no longer abandoned.
Cause
Inadequate information on the data of the checkout table