Exporting Abandoned Checkouts
Export your abandoned checkouts — carts a customer started but never completed — to a CSV or Excel file, across one store or all your connected stores at once. It's the fastest way to pull a recovery list into a spreadsheet or another tool: who abandoned, their email, what was in the cart, and how much it was worth.
For the wizard itself — picking columns, formats, destinations, and schedules — see the exporting overview.
What you can export
In Simple mode you pick from a curated list of the fields merchants export most. The default set covers the essentials; these are the most useful ones:
| Field | What it is |
|---|---|
Name | The checkout's name. |
Checkout URL | The storefront URL the customer can return to. |
Customer Name | Full name of the customer (falls back to email, then phone). |
Customer Email | The customer's email — the address you'd send a recovery message to. |
Customer Phone | The customer's phone number. |
Line Items Quantity | Total quantity of all items in the cart. |
Subtotal | Cart price before shipping and taxes. |
Total Price | Full checkout total, including shipping and taxes. |
Discount Codes | Any discount codes applied to the checkout. |
Shipping / Billing | Full address blocks — name, street, city, province, country code, zip, phone. |
Created At | When the checkout was started. |
Completed At | When it was completed, if it later was. |
The export can also carry the matching line items (title, SKU, variant, quantity, unit and discounted prices), checkout-level taxes (total tax plus up to five named tax lines), and, when a correlated order was resolved, linked-order fields such as financial and fulfillment status. Switch to Template (Advanced) mode to open the full column tree and rename headers.
One row per line item
By default each abandoned checkout is a single row. As soon as you include any line-item column, the export expands to one row per line item — the checkout-level fields (name, customer, totals) repeat on each row, and a Top Row marker flags the first row of each checkout. A Row # column numbers the rows. This is the same shape the Orders export uses, so it re-imports cleanly.
Filtering what you export
You can narrow an abandoned checkouts export to a common slice:
- Store — one store, several, or all of them.
- Recovery status — recovered or not recovered.
- Status — open, archived, or cancelled.
- Payment status — paid, pending, voided, or unpaid.
- Fulfillment status — fulfilled, partially fulfilled, or unfulfilled.
The filter you set on an export in the wizard is part of that export and is independent of whatever filter you last used on the dashboard.
Exporting from the dashboard vs the wizard
From the Abandoned Checkouts dashboard, the Export button (the Export Builder) is the quick path — it exports exactly what you're looking at, scoped to Current page, Filtered, Selected, or All abandoned checkouts across your stores. Use the Export Wizard (Exports → New export) when you want to combine abandoned checkouts with other entities in one run, or save the export on a schedule.
Scheduling
Any abandoned checkouts export can run on a recurring daily, weekly, or monthly schedule instead of once — handy for a standing recovery list. See scheduled exports.
Tutorial: build a weekly abandoned-cart recovery list
- Go to Exports → New export (
/exports/new). - In Step 1, tick Abandoned Checkouts and click Next.
- In Step 2, keep Simple columns (Name, Customer Name, Customer Email, Total Price are in the default set). Add the Recovery status filter and choose Not recovered.
- In Step 3, choose Excel and set the destination to Email.
- In Step 4, name it "Weekly abandoned carts", choose Save as scheduled bundle, set the frequency to Weekly, and save.
- Open Exports → Schedules and use Run now to test it immediately.
Permissions
- View Exports (
viewExports) — build and run abandoned checkout exports. - Download Exports (
downloadExports) — download the finished file.
Account owners have both. Grant them to team members from their permissions.
FAQ
Can I export abandoned checkouts to Excel? Yes — choose CSV or Excel
(.xlsx) in Step 3. A combined multi-entity workbook is always Excel.
Does the export include the customer's email? Yes — Customer Email is a Simple column, along with the customer's name and phone, so you can build a recovery list directly.
Can I export only carts that were never recovered? Yes — add the Recovery status filter and choose Not recovered.
Why does one checkout span several rows? Only when you include line-item columns — then the export expands to one row per line item, repeating the checkout fields on each row. Without line-item columns it's one row per checkout.
Can I export abandoned checkouts from all my stores at once? Yes — an export spans every connected store by default; add a store filter to narrow it.
Can I schedule the export? Yes — save it as a daily, weekly, or monthly schedule and each run rebuilds from live data.