Amazon Tutorials

Shopify Sales Report in Google Sheets: Build the Number Your Team Trusts

Last updated -

May 28, 2026

Article Summary

✅ The real problem is not getting Shopify data into Google Sheets. The problem is deciding which sales number the team is allowed to trust.

‍
✅ A good Shopify sales report starts with line-item sales data, then keeps discounts, refunds, and SKU logic clean enough for repeated decisions.

‍
✅ Shopify’s sales report is useful, but the moment someone exports it into a CSV, the file starts aging.

Shopify Sales Report is Messy and Tedios

Shopify is usually telling the truth.

The problem starts after someone exports the report, pastes it into a sheet, and the team starts treating it like it's the latest data.

It's not.

It is a snapshot of the store at the moment it was downloaded. Then more orders come in. A refund gets processed. A discount code gets used. A fulfillment status changes. Shopify keeps moving, but the sheet does not move unless someone carries the next file over.

That is how teams end up arguing over sales numbers.

One person is looking at Shopify. Another person is looking at the CSV. Another person is looking at a cleaned-up workbook from the previous export. Everyone thinks they are looking at sales.

The First Decision Is Which Sales Number Counts

Before I build a Shopify sales report in Google Sheets, I want one thing settled first: what number are we using in the team review?

Gross sales sounds exciting. Net sales is usually more useful. SKU-level sales is where product decisions start.

| Sales number | What it tells you | Where I would use it | |---|---|---| | Gross sales | What customers bought before discounts and refunds | Demand and product interest | | Discounts | How much revenue promotions removed | Promo review | | Refunds | What changed after the order | Product and customer issue review | | Net sales | What the store kept after reductions | Main sales review number | | SKU-level sales | What each product contributed | Reorder, margin, and product decisions |

Shopify includes sales reports inside its default report categories, which is useful when you are reading performance inside Shopify. See Shopify default reports documentation.

A team workbook has a different job. It has to make sure everyone is working from the same definition.

A Dashboard Helps You Look. A Sheet Helps You Work.

A Shopify dashboard is great when I want to check something quickly.

How did the store do? Which product is moving? Did the promotion bring in orders?

That is dashboard territory.

But once the number has to be reused, compared, filtered, joined to COGS, or handed to someone else, I want it in a workbook.

That's why every business still uses Excel or Google Sheets. Even in billion dollar companies like Microsoft, Salesforce, Shopify themselves, they use spreadsheets.

For sellers like us, you can build a repeatable sales view. You can compare SKU sales over time. You can join sales to product cost. You can compare Shopify to Amazon. You can give the same file to a VA, manager, or accountant without asking them to log into Shopify.

The dashboard shows the number.

The sheet lets your team work with the number.

I Would Start With Line Items, Not Totals

A Shopify sales report gets weak fast if it only works at the order-total level.

One order can include three products. One product may be discounted. One item may be refunded later. One SKU may be the real winner while the order total hides what happened.

That is why I would start with line-item data.

Shopify’s Order object includes line items, refunds, timestamps, fulfillment status, discounts, transactions, and updated timestamps. Shopify also notes that apps get the last 60 days of orders by default unless all-order access is granted. See Shopify Order API documentation.

For a working sales report, I care about rows that can answer this:

| Question | Data the row needs | |---|---| | What sold during the selected period? | Order date, SKU, quantity, product title | | Which variant drove revenue? | SKU, variant title, quantity, sales amount | | How much did promos reduce sales? | Discount code or discount amount | | Which sales changed later? | Refund amount, refund date, updated timestamp | | Which orders should be filtered out? | Fulfillment status, cancellation status, test order flag if available |

Keep the Raw Sales Tab Boring

A good raw sales tab should be boring.

That is the point.

No merged cells. No manual notes in the middle of imported rows. No formulas pasted beside raw data. No pivot table sitting next to live order data.

I have made messy sheets before. They feel fast in the beginning. Then one person filters the wrong range, a formula skips new rows, and nobody wants to touch the file.

For Shopify sales reporting, I would rather keep the workbook simple:

| Tab | Job | |---|---| | shopify_sales_raw | Imported order and line-item rows | | sku_map | Internal SKU, Shopify SKU, product family, active status | | cogs | Product cost by internal SKU | | repeat_sales_view | Sales by date, SKU, and product | | sales_review | The view used in team review |

The raw tab is not supposed to be pretty.

It is supposed to stay stable.

Refunds Change the Story After the Sale

Refunds can change the sales report after the original order was already counted.

That timing is where many Shopify sheets get sloppy.

The team pulls sales, then the store keeps changing. Refunds post later. Discounts adjust the final number. Fulfillment status changes. The original export still looks clean, but it no longer represents the current store.

Shopify’s Refund object tracks refunded amounts, transactions, refund line items, shipping refunds, and related order context. Shopify also notes that a refund object does not always mean the money has fully returned to the customer because transaction status matters. See Shopify Refund API documentation.

For this article, I only need refunds to answer three things:

Which order changed?
Which SKU was affected?
Did the team’s working sales number change?

The deeper refund workflow belongs in Shopify returns.

Discounts Deserve Their Own Line

A product can look like a winner until you see how much discounting helped it sell.

That is why I want discounts visible in the sales report.

If a SKU did $20,000 in gross sales but needed $6,000 in discounts to get there, that is a different product decision than a SKU that sold at full price.

At minimum, the sales report should let the team see:

Gross sales
Discount amount
Refund amount
Net sales
Units sold
SKU
Date

This does not need to be fancy.

It needs to be clear enough that nobody celebrates the wrong number.

The CSV Process Fails Quietly

Manual Shopify exports usually do not fail in a dramatic way.

They fail in boring ways.

A file gets downloaded late. A date range is wrong. Refunds are missing. A pivot table points to the previous export rows. Two people use two different files. The review number looks official because it is in a spreadsheet.

That is the dangerous part.

A clean-looking sheet can still be stale.

| Manual export problem | What it causes | |---|---| | Wrong date range | Sales number is off | | Order totals without line items | SKU review is weak | | Refunds handled separately | Net sales does not match reality | | Manual paste into old tabs | Formulas point to the wrong range | | Multiple file versions | Team argues over which number is current |

How to Use Gorilla ROI for Shopify

You can now connect your Shopify Store to Gorilla ROI to automatically load your Shopify Data into Google Sheets.

Connect Shopify.
Pull Shopify sales data into Google Sheets.
Keep order and line-item rows in a source tab.
Build repeatable sales views on top of that tab.
Refresh the data without repeating the CSV routine.

The standard workflow is point-and-click. You do not need formulas just to pull Shopify data. The formula layer is there for advanced users who want more control, but that is optional.

For the broader setup, start with Shopify to Google Sheets.

Do Not Make the Sales Report Carry Everything

A Shopify sales report should answer what sold, when it sold, and how sales changed after discounts and refunds.

If one tab tries to answer every question, it is too much information and becomes extremely messy.

Use the next report for the next problem:

Product cost and margin: Shopify COGS tracking
Inventory planning: Shopify inventory management
Campaign source and UTMs: Shopify marketing attribution
Daily monitoring: Shopify sales tracker
Amazon comparison: Shopify Amazon integration

Sales gets its own lane.

Let the other reports do their jobs.

Shopify Sales Report Checklist

Quick checklist on building a Shopify Sales Report checklist.

Pick the number the team will trust: gross sales, net sales, refund-adjusted sales, or SKU-level sales.
Pull line-item data if SKU reporting matters.
Keep raw sales rows in a source tab.
Separate gross sales, discounts, refunds, and net sales.
Keep fulfillment status available as a filter.
Use order ID to prevent duplicate counting.
Use SKU as the product join key.
Build one repeatable sales view before building a dashboard.
Test one refresh before using the sheet in a team review.

The best sales report is the one the team can use without asking who updated it.

Shopify Sales Report FAQ

What is a Shopify sales report?

A Shopify sales report helps merchants review sales over a selected period. Shopify includes sales reports inside its default report categories in Shopify Admin.

Can I export Shopify sales reports to Google Sheets?

Yes. You can export Shopify sales data and open it in Google Sheets. That works for one-time analysis. If the same report is used repeatedly, a connected Google Sheets workflow is usually cleaner than repeating CSV exports.

What sales data should I pull into Google Sheets first?

Start with order ID, order date, line items, SKU, product title, quantity, discounts, total sales, refunds, fulfillment status, and updated timestamp. Shopify’s Order object includes order lifecycle and line-item fields that support sales reporting.

Is Shopify’s native sales report enough?

Shopify’s native sales report is enough when you only need to check sales inside Shopify. Google Sheets becomes more useful when the team needs reusable rows, SKU logic, team review tabs, or sales data joined to COGS, refunds, or other channels.

What is the difference between a Shopify sales report and a Shopify sales tracker?

A Shopify sales report explains what sold over a selected period. A Shopify sales tracker is a monitoring view for daily changes, trends, and recurring checks.

Should sales, inventory, and COGS live in the same tab?

No. Keep sales, inventory, and COGS in separate tabs, then join them by SKU when needed. The sales tab should stay focused on order and line-item sales data.

Can Gorilla ROI pull Shopify sales data into Google Sheets?

Yes. Gorilla ROI connects Shopify data to Google Sheets so your team can build sales reports without manually exporting and pasting the same CSV repeatedly.