What Is the Abandoned Checkout Report?
The Shopify Abandoned Checkout Report lists checkout records for shoppers who started checkout but did not complete a purchase at the time the checkout was captured. It brings together cart timing, checkout identifiers, product and variant details, customer contact information, quantities, and checkout value.
A checkout can later be recovered. Use Completed Date to distinguish a checkout that was subsequently completed from one with no recorded completion date. This helps you prioritize relevant follow-ups without treating every recorded abandonment as permanently lost revenue.
Report Overview
- Report period
- Choose the cart-date range you need to review.
- Data included
- 14 fields covering checkout, product, variant, customer, quantity and value.
- Best for
- Identifying open recovery opportunities and products commonly left at checkout.
- Export formats
- Excel, CSV, TXT and PDF.
- Automation
- Schedule recurring delivery by email; other destinations depend on configured export options.
What Can You Learn from Abandoned Checkouts?
1. Find checkouts that still need attention
A blank Completed Date can help isolate checkouts with no recorded completion. Review the cart date before contacting anyone.
Example: A checkout captured yesterday has no Completed Date.
What you can do: Review eligibility and timing before sending an appropriate recovery message.
2. See which variants are repeatedly left behind
Product Title, Variant Title and SKU help reveal whether the same sizes, colors or items appear frequently in checkout records.
Example: A particular shoe size appears repeatedly in incomplete checkouts.
What you can do: Check that product page, size guidance and availability are clear.
3. Prioritize higher-value opportunities
Sort by Total Price to review larger checkout values first. The figure is potential checkout value, not confirmed lost sales.
Example: One incomplete checkout shows a total of $280.
What you can do: Review higher-value checkouts for personalized, consent-appropriate follow-up.
4. Separate recovered checkouts from unresolved ones
Compare Cart Date and Completed Date to see which recorded checkouts were ultimately completed.
Example: A checkout started Monday and shows a Tuesday completion date.
What you can do: Exclude completed records from lists intended for current recovery outreach.
What Should You Check First in This Report?
Start with the fields that turn a long export into a useful recovery list.
- Completed Date: Separate later-completed checkouts from those without a recorded completion.
- Cart Date: Focus on recent activity, then look for recurring patterns across longer periods.
- Total Price: Sort to review potentially valuable checkouts, while avoiding double-counting at line-item level.
- Product Title, Variant Title and SKU: Find product-specific patterns rather than relying on checkout totals alone.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing an abandoned-checkout follow-up list | Filter for records without a Completed Date and use available email and cart date details. |
| Investigating recurring product drop-offs | Compare Product Title, Variant Title and SKU across incomplete checkouts. |
| Reviewing higher-value incomplete checkouts | Sort Total Price to identify records to inspect first. |
| Checking whether older checkouts recovered | Use Completed Date alongside Cart Date to distinguish later completion. |
| Sharing a recurring checkout review | Schedule an export for a team to review patterns and next steps. |
How to Create This Report in Data Export
Start from the premade Abandoned Checkout Report rather than building the field list from scratch.
- Open Data Export: Custom Reports and find the premade Abandoned Checkout Report.
- Open the report and review its 14 default fields, especially Cart Date and Completed Date.
- Set the date range; apply supported product, vendor or blank Completed Date filters if needed.
- Save the configured report and export it in the format you need.
- Optionally schedule daily, weekly or monthly email delivery to the appropriate team.
Make the Most of This Report
Use these four checks before acting on a checkout export.
01 / RECOVERY STATUS
Check completion first: A later Completed Date means the checkout should not be treated as unresolved.
02 / RECORD DETAIL
Check record granularity: One checkout may contain multiple products; avoid summing repeated checkout totals as distinct lost sales.
03 / FOLLOW-UP TIMING
Use recent cart dates: Prioritize timely reviews and respect customer messaging permissions.
04 / SHARING
Limit customer details: Share email addresses and checkout information only with people who need them.
Frequently Asked Questions
Does this report include recovered abandoned checkouts?
Yes. Records can include both abandoned and later-recovered checkouts. Check Completed Date to distinguish them.
How do I find checkouts that have not been completed?
Filter for a blank Completed Date when that filter is available, then review Cart Date and checkout details.
Can I see what products shoppers left behind?
Yes. Product Title, Variant Title, SKU, Quantity and Vendor identify items associated with each checkout.
Can I export the report to Excel?
Yes. You can export it as Excel, CSV, TXT or PDF.
Can I have the report sent automatically?
Yes. You can schedule recurring email delivery on a daily, weekly or monthly basis.