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.
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
Every morning, ClickRuntime pulls yesterday's order figures from Amazon Seller Central.
It reads the number of orders, units sold and total sales.
You get a short email with yesterday's numbers.
Before it runs live
- Connect Amazon Seller Central
What you get
Build your own
Need it to work differently?
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
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?
What counts as yesterday?
Do I need a special Amazon account to use the API?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Flag FBA SKUs that are running low
A daily email lists the SKUs with fewer than 20 fulfillable units so you can send stock in time.
See how it worksSee unshipped Amazon orders by ship-by date
Each morning you get merchant-fulfilled orders still waiting to ship, with those due today flagged at the top.
See how it worksPost new Amazon orders to Slack
New orders appear in Slack with the order ID, items and amount, checked every 15 minutes.
See how it worksKeep exploring
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.