Questions this template answers
- How are total sales, gross sales, and net sales trending?
- Which month values contribute most to total sales?
- Where should the team investigate or optimize Shopify performance?
Claude.ai & MCP supported — another step towards a more powerful AdzviserRead Me
Templates / Google Sheets / Shopify Orders & Sales Report
+
Free Shopify Orders & Sales Report Template for Google Sheets
A Shopify orders and sales report for Google Sheets — track total sales, gross and net sales, orders, shipping, returns, and discounts at a glance, with sales and orders/AOV trend charts, a new vs. returning customer breakdown, and a weekly orders comparison table.
Get the template →
What You Can Learn from This Shopify Template
Use the report to answer practical performance questions with the fields and breakdowns already included in this template.
Best for
- E-commerce managers
- Growth marketers
- Online store operators
Template setup
- 8 preselected metrics
- 6 reporting dimensions
- Google Sheets editable spreadsheet
- Live Shopify data through Adzviser
Metrics & Dimensions
The Shopify metrics and dimensions this template is pre-built with — no manual setup needed.
Metrics
Total Sales
Gross Sales
Net Sales
Orders
AOV (Average Order Value)
Shipping
Returns
Discounts
Dimensions
Order Created Datetime
Month
Week
Order Name
Order Confirmed
Is Returning Customer
Setup guide
How to Get Started
Set up your Shopify Google Sheets template in three simple steps.
1
Sign up for Adzviser
Create your account and start your 14-day trial for just $0.99. Cancel anytime. Start your trial →
2
Connect Shopify
Link your account through secure authentication and select the data you want to report on. Explore the Shopify connector →
3
Copy the template
Open the template in Google Sheets, connect Adzviser, and customize it to your needs. Learn about Google Sheets →
Related Templates
Explore more templates for Shopify or Google Sheets.
Shopify Orders & Sales Report FAQs
This template is prebuilt with 8 metrics and 6 dimensions, along with the charts, tables, formulas, or controls shown in the preview. The Metrics & Dimensions section above lists the exact fields included in this version.
Make a copy of the spreadsheet, connect Shopify to an Adzviser workspace, enter the exact workspace name in the adzviserQuery worksheet, and run Refresh all queries from the Adzviser add-on. Open the Shopify connector guide →
Yes. Connect the accounts to your Adzviser workspace, then select or query the accounts needed for the report. For agency workflows, you can also keep a separate copy per client so access, filters, and branding stay independent.
Use Refresh all queries for an on-demand update, or add an automatic refresh trigger from the Adzviser add-on's Schedule tab. Google Sheets triggers can run daily, weekly, or monthly. See refresh instructions →
Yes. You can change formulas, charts, pivot tables, formatting, queries, and tabs. Keep imported column names and ranges stable—or update anything that references them—so later refreshes continue feeding the report correctly.
Confirm that you copied the file, installed the Adzviser add-on, connected Shopify, and entered the exact workspace name expected by adzviserQuery. Run Refresh all queries and review any error shown in the add-on sidebar.
Yes. The template itself is free to copy and customize in your own account. You need an Adzviser account when you want to replace its sample data with a live Shopify connection and keep that data refreshed. See Adzviser pricing →
