Skip to content

Daily

Get yesterday's Amazon sales every morning

A morning email gives the previous day's order count, units sold and sales total.

Runs
Daily
Apps
Amazon Seller Central
AI
Not needed
Access
Pricing/Sales role (read)

Send this to your assistant

Create a ClickRuntime automation: every day at 8am, email me yesterday's Amazon order count, units sold and total sales for my US marketplace.

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

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

Why use it

Why teams use this automation

Amazon sellers who run their business from the Seller Central dashboard check sales several times a day, usually on a phone, and still get a partial picture. A listing suppressed overnight, an ad that burned through the budget or a price change that killed conversion shows up only when someone notices that units are down. Because reports in Seller Central are scattered across menus and dates, comparing yesterday with the day before takes several clicks that busy owners skip.

Each morning, the automation calls the order metrics for yesterday through the Selling Partner API, formats units, orders and sales into a short message and emails it to you. The numbers are consistent every day, so a change is obvious.

Private-label sellers and small brands will like it, as will agencies that manage Amazon accounts for several clients.

What you get out of it

  • Problems show up the next morning

    A sharp drop in units on a Tuesday is noticed on Wednesday at the latest. You can check for a suppressed listing, a lost Buy Box or an out-of-stock before another day of sales goes.

  • Ad and price changes can be judged quickly

    When you adjust a price or a campaign, the next day's numbers show the effect. A quick signal lets you keep what works and reverse what does not. Fast feedback makes experiments cheaper.

  • One consistent format

    The same layout every day makes patterns easy to see, from the weekday rhythm to the lift after a promotion, without opening several Seller Central reports. Comparing two mornings takes a second.

  • Agencies and partners stay informed

    Send the email to a business partner, an investor or a client and they can follow sales without needing access to your Seller Central account. They see the numbers that matter without a password.

  • A running record outside Amazon

    Your inbox ends up with a daily history of units and sales, handy for tax prep, for a loan application or when Seller Central reports are slow to load. It also helps when reports are slow to load.

How it works

What happens, step by step

  1. Every morning, ClickRuntime pulls yesterday's order figures from Amazon Seller Central.

  2. It reads the number of orders, units sold and total sales.

  3. You get a short email with yesterday's numbers.

Before it runs live

  • Connect Amazon Seller Central

What you get

RunsDaily
Get yesterday's Amazon sales every morningtoday, 9:00Succeeded
Email · Amazon yesterdayAmazon 2026-10-18: 87 orders, USD 3,914.20 Units sold: 112

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 Amazon Seller Central 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.
daily_sales_summary_amazon_seller_central.pyexample
from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

US = "ATVPDKIKX0DER"

@on_trigger
def run(event):
    day = date.today() - timedelta(days=1)
    resp = http.get("https://sellingpartnerapi-na.amazon.com/sales/v1/orderMetrics",
                    headers={"x-amz-access-token": credentials.connection("amazon-seller-central", "us")},
                    params={"marketplaceIds": US, "granularity": "Day", "granularityTimeZone": "US/Pacific",
                            "interval": f"{day}T00:00:00-07:00--{date.today()}T00:00:00-07:00"})
    resp.raise_for_status()
    m = resp.json()["payload"][0]
    total = m["totalSales"]
    notify.email_me(f"Amazon {day}: {m['orderCount']} orders, {total['currencyCode']} {float(total['amount']):,.2f}",
                    f"Orders: {m['orderCount']}\nUnits sold: {m['unitCount']}\n"
                    f"Total sales: {total['currencyCode']} {float(total['amount']):,.2f}")
    return {"orders": m["orderCount"], "units": m["unitCount"]}

FAQ

Common questions

Which numbers are included?
Typically ordered units, number of orders and ordered product sales for the day, from the Selling Partner API's order metrics. If your account exposes more, such as average order value, those can be added. Average order value can be derived from them if you want it.
What counts as yesterday?
The previous calendar day in the time zone of your marketplace. For sellers on several marketplaces, each can be reported separately so that the dates match the local day. That avoids confusion when marketplaces are in different time zones.
Do I need a special Amazon account to use the API?
You need a Seller Central account with a developer profile and an authorized app, which Amazon calls a self-authorized SP-API application. The credentials are stored as secrets in ClickRuntime. Amazon provides the registration steps in Seller Central.
What permissions does it need?
Pricing/Sales role (read). 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.

Set up “Get yesterday's Amazon sales every morning” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.