Shopify

Sample Queries

1. How to get all abandoned checkouts from checkout table?

   If you want to know if a checkout was completed, you would look at the completed_at field. This will be a timestamp of when the checkout became an order. All the abandoned checkouts have completed_at field as null.

   SELECT * FROM shopify.checkout WHERE completed_at is NULL;