Daily

Get a daily list of abandoned checkouts

Each evening you get today's abandoned checkouts with the customer email, cart value and recovery link, so you can follow up.

Runs: Daily
Apps: Shopify
AI: Not needed
Access: read_orders

Send this to your assistant

Create a ClickRuntime automation: every evening at 7pm, email me today's abandoned Shopify checkouts with the customer email, cart value and recovery link, largest cart first.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

Shopify stores lose most of their potential sales at checkout: a shopper adds a $90 jacket, enters an email address and never pays. Those people have shown real interest, and a short, friendly follow-up often brings a share of them back. But the abandoned checkouts sit in the Shopify admin, and nobody has the time to open the list daily, copy the contacts and decide who to contact. The ones that would have been recovered are forgotten within a day, when the shopper has bought elsewhere.

Each day the automation queries Shopify for checkouts abandoned since its last run and emails you a list with the customer's email, the items left behind and the cart value. You then decide whom to contact, or hand the list to your email tool. It is for small store owners who handle recovery personally rather than through a paid app.

What you get out of it

Recoverable sales are not forgotten
A daily list makes sure each abandoned cart is seen while the shopper still remembers it. Even recovering one in ten adds revenue you would otherwise lose. A shopper who left a $90 jacket yesterday still remembers it today, but not next week.
High-value carts get personal attention
The list shows the cart value, so you can prioritize a $400 order over a $12 one. A personal note to a big-spending shopper often outperforms any automated message. A $400 cart gets a personal note from you, while a $12 one can safely be ignored.
Reasons for abandonment become visible
Looking at what people leave behind shows patterns, such as a certain product with high shipping cost. That feedback improves pricing and shipping decisions, as well as recovery. If many carts hold the same item, shipping cost or sizing is probably the real reason.
Works without an extra app subscription
Many cart-recovery tools charge monthly fees. A simple daily list gives small stores a way to follow up with no additional subscription to manage. Recovery apps often charge monthly fees, while a simple daily list needs nothing extra to maintain.
Follow-up timing stays consistent
Contacting people the next morning is far more effective than after a week. A list that arrives at the same time each day makes a good routine easy to keep.

How it works

What happens, step by step

Every evening, the automation finds the Shopify checkouts abandoned since the last run.
It lists each one with the customer email, cart value and recovery link.
You get the list by email, so you can follow up with each customer.

Before it runs live

Connect Shopify

What you get

RunsDaily

Get a daily list of abandoned checkoutstoday, 9:00Succeeded

Email · 6 abandoned checkouts todayjo@acme.example 312.00 USD https://your-store.myshopify.com/…/recover

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other Shopify steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

abandoned_checkout_follow_up_list.pyexample

from datetime import date
from clickruntime import on_trigger, credentials, http, notify

STORE = "your-store.myshopify.com"

def gql(query, variables=None):
    resp = http.post(f"https://{STORE}/admin/api/2025-07/graphql.json",
                     headers={"X-Shopify-Access-Token": credentials.connection("shopify", "store")},
                     json={"query": query, "variables": variables or {}})
    resp.raise_for_status()
    return resp.json()["data"]

QUERY = """query($q: String!) { abandonedCheckouts(first: 100, query: $q) { nodes {
  abandonedCheckoutUrl customer { email } totalPriceSet { shopMoney { amount currencyCode } } } } }"""

@on_trigger
def run(event):
    carts = gql(QUERY, {"q": f"created_at:>={date.today()}"})["abandonedCheckouts"]["nodes"]
    carts = [c for c in carts if c.get("customer") and c["customer"].get("email")]
    if not carts:
        return {"carts": 0}
    carts.sort(key=lambda c: -float(c["totalPriceSet"]["shopMoney"]["amount"]))
    lines = [f"{c['customer']['email']}  {float(c['totalPriceSet']['shopMoney']['amount']):,.2f} "
             f"{c['totalPriceSet']['shopMoney']['currencyCode']}\n  {c['abandonedCheckoutUrl']}" for c in carts]
    notify.email_me(f"{len(carts)} abandoned checkouts today", "\n".join(lines))
    return {"carts": len(carts)}

FAQ

Common questions

Which checkouts are included in the list?

Checkouts where the shopper entered contact details but did not pay. Visitors who never gave an email address cannot appear because Shopify has nobody to name. Recent checkouts may still be in progress, so the list is built from carts left untouched for a while rather than from live sessions.

Does it email the shoppers directly?

No. It sends the list to you. Contacting shoppers needs their consent under rules like GDPR and CAN-SPAM, so you decide whom to contact and how. Marketing consent flags can be included in the list to help.

Does the Shopify plan matter?

Abandoned checkout data is available on Shopify plans through the Admin API, using a custom app token with read access, which ClickRuntime keeps as a secret. Plan differences affect other Shopify features more than this one, so check that your app token includes the checkouts read scope.

What permissions does it need?

read_orders. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run each time it runs (daily). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Weekly