will abandoned checkouts appear in orders

[guoguang]

As stated on the page, 

A checkout is considered abandoned after the customer has added contact information, but before the customer has completed their purchase.

The cancellation reason for an order can be customer, declined, fraud, inventory, and other based on GraphQL page

I downloaded abandoned checkouts that don't have any information about an order, like the order id.

So, both data from abandoned checkout and order RESTful endpoints can not be correlated, right?

I want to do some analysis on abandoned checkout like the abandoned rate given a time period. Or, there are other ways around for my purposes

[Liam · Accepted solution]

Hi Guoguang,

Abandoned checkouts and orders are considered separate entities in the Shopify data model, and as you've found you cannot directly correlate an abandoned checkout with an order.

Once a checkout is abandoned, it remains in the abandoned state even if a customer later comes back and completes the purchase. When the purchase is completed, it creates a new order record. The abandoned checkout and the order will have different IDs, and there's no direct link between them in Shopify's system.

That said, the abandoned checkouts endpoint provides a lot of detail, including the customer's contact information, line items, and more. You can calculate the abandoned checkout rate by dividing the number of abandoned checkouts by the total number of checkouts (completed and abandoned) for a given time period.

Hope this helps!

[guoguang]

Appreciate the ins and outs about how abandoned checkouts and orders works 👍