# A Weekly Sales Brief From Your Shopify Reports

> Researched. Small business · Beginner · Operations. Updated 2026-11-08.

Canonical page: https://www.aisetupsthatwork.com/setups/weekly-shopify-sales-brief/

## What it does
A one-screen weekly brief on how the store did, written from the Shopify report you exported.

## Who it's for
Shopify store owners who check the dashboard but never sit down with the numbers.

## Tools
- Shopify admin, Analytics, Reports (Export)
- ChatGPT or Claude

## Steps
1. In Shopify, open Analytics, then Reports, and pick a sales report for last week.
2. Export it as a CSV.
3. Paste it, or the totals and top rows, into the prompt below.
4. Check one number against Shopify before you act on the brief.

## Copy-paste prompt
Adapt bracketed fields to your situation.
```text
Here is last week's sales report from Shopify. Write a one-screen brief. Do not change anything.

[paste the report or its totals and top rows]

Include: net sales and orders compared with the week before if both are here, top 5 products, returns and discounts, and one thing worth trying next week. Use only these numbers. If something is missing, write "not in the report".
```

## Guardrails
- What it touches: Chat input you provide (Shopify admin, Analytics, Reports (Export); ChatGPT or Claude).
- Needs your OK: Send, pay, publish, and account changes stay with you. Treat agent output as drafts first.
- Safety level: Drafts for you
- Column names can change: Shopify has been changing how returns show in reports. If a column looks different from last time, tell the AI what it means.
- Two weeks pasted in one file. Say which rows are which week.
- It reads gross as net. Name the columns.

## Tips
- Same day each week, same prompt.
- Keep the briefs in one note to see trends.

## Estimates (labeled, not measured)
- Time saved: not measured yet
- Money saved: Not stated in sources.
- Tool cost: Shopify reports are part of your Shopify plan. ChatGPT and Claude have free plans with usage limits.

## Sources
Summaries use the public sources below, not independent verification.
- Shopify Help Center: https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/custom-reports/export-reports (Checked through search results Nov 8, 2026 (the build machine was blocked from opening it): reports export from Analytics, Reports, in CSV and other formats.)
- Shopify Help Center: https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/sales-report (Checked through search results Nov 8, 2026: net sales are gross sales minus discounts minus sales reversals; older return metrics were being removed.)

## Get the free starter pack
Five beginner copy-paste AI setups, free by email: https://www.aisetupsthatwork.com/starter-pack/?utm_source=ai-agent&utm_medium=markdown&utm_campaign=setup-weekly-shopify-sales-brief

Related:
- [Track true profit per order](https://www.aisetupsthatwork.com/setups/track-true-profit-per-order/index.md)
- [Reply to Shopify Return Requests Using Your Own Policy](https://www.aisetupsthatwork.com/setups/reply-to-shopify-return-requests/index.md)
