Weekly Best & Worst Sellers Report
Every Monday, WebRun opens Shopify Analytics, pulls the full product sales breakdown for the past 7 days, logs the rankings to your performance sheet, and emails you a formatted weekly report showing your top 10 and bottom 10 SKUs by revenue.
Shopify
pull last week's product sales breakdown
How can I automatically get a weekly best and worst sellers report from Shopify?
Every Monday WebRun opens Shopify Analytics, pulls the full product sales breakdown for the past 7 days, logs the rankings to your performance sheet, and emails you a formatted weekly report showing your top 10 and bottom 10 SKUs by revenue - so you can act on the data before the next week starts.
- Top and bottom 10 SKUs by revenue surfaced every Monday
- Sales data logged to a sheet for trend tracking across weeks
- Weekly performance review delivered without logging into Shopify
Built for Shopify merchants · ecommerce buyers and merchandisers · retail brand managers · DTC founders
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
admin.shopify.comin a real browser with your saved login - no setup, no API keys. -
1
Shopify - pull last week's product sales breakdown
WebRun opens Shopify to pull last week's product sales breakdown. - Open Shopify Admin > Analytics > Products
- Set the date range to the previous 7 days
- Export the product performance table: SKU, product name, units sold, and revenue for each
- Sort by revenue to identify the top 10 and bottom 10 sellers
Done when Last week's product sales are captured and ranked.
-
2
Google Sheets - log and rank SKUs in the performance tracker
google.com
WebRun opens Google Sheets to log and rank SKUs in the performance tracker. - Open the Weekly Performance Tracker sheet
- Append this week's full SKU ranking with revenue and units sold
- Update the week-over-week change column by comparing to last week's data
Done when This week's rankings are logged and week-over-week changes are calculated.
-
3
Gmail - email you the weekly report
gmail.com
WebRun opens Gmail to email you the weekly report. - Draft a weekly report email addressed to you (not to customers)
- Include the top 10 and bottom 10 SKUs, their revenue, and the week-over-week change
- Add a brief note flagging any product that moved dramatically (e.g. a top seller that dropped 50%)
- Save as a draft - you review and send to yourself or your team
Done when A formatted weekly report draft is ready in Gmail for your review.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Shopify
Sign in once
Every action is checked against this policy before it runs.
Questions, answered
Does it send the email automatically?
No - it saves the report as a Gmail draft addressed to you. You review it and send it to yourself or your team when you're happy with it.
Can I change the 'top 10 / bottom 10' cutoff?
Yes - you can set any number in the plan, or ask it to surface products that moved more than a specific percentage week over week instead.
What if a product had zero sales last week?
Zero-sales products are included in the bottom of the ranking and flagged separately as 'No sales this week' so you can spot dead stock quickly.
Related templates
Shopify›Shopify›Shopify›Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.