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