How to Build Weekly Sales Reports from Shopify Exports
How to Build Weekly Sales Reports from Shopify Exports
Most Shopify operators already export their sales data regularly. The problem is not the export itself — it is everything that happens after. Opening the file, filtering out cancelled orders, rebuilding the same pivot, recreating charts, and copying numbers into a shareable deck takes time that adds up every single week.
This guide walks through how to build a useful weekly sales report from Shopify exports: what data you need, what the report should include, where the manual workflow breaks down, and how to reduce the repetition.
Why Weekly Sales Reporting Matters
Weekly reporting is not about tracking vanity metrics. It is about making operating decisions fast enough to matter.
A monthly report tells you what happened. A weekly report gives you time to respond. If a product is running out of stock, a discount campaign is underperforming, or return rates are climbing on a specific SKU, you want to catch that within seven days, not thirty.
The goal of a weekly Shopify report is to answer a small set of questions clearly:
Did revenue go up or down compared to last week?
Which products drove most of the change?
Are we acquiring new customers or selling to returning ones?
Is the refund or return signal getting worse?
Where is the discount budget going?
Everything else in the report should support one of these questions.
What Data You Need from Shopify
Shopify's Orders export gives you most of what you need. The fields that matter for a weekly report are:
Field | Purpose |
|---|---|
Created at | Date-based aggregation and week-over-week comparison |
Order ID | Deduplication and order count |
Financial status | Filter paid vs refunded vs voided orders |
Fulfillment status | Separate fulfilled, unfulfilled, cancelled |
Customer email | New vs returning customer classification |
Product title / variant | Product-level revenue breakdown |
Quantity | Units sold |
Gross sales | Revenue before discounts |
Discounts | Discount amount per order |
Refunds | Refund amount |
Net sales | Revenue after discounts and refunds |
Sales channel | Compare online store, POS, and other channels |
Before you start building the report, filter the dataset to confirmed, paid orders. If you include voided or pending orders in revenue totals, the numbers will not match what actually arrived in your account.
What Your Weekly Report Should Include
A practical weekly Shopify report has five sections.
1. Revenue Summary
Total net sales for the week (gross sales minus discounts and refunds)
Order count
Average order value (AOV)
Week-over-week change for each of the above
This section should fit on one screen or one slide. If someone looks at nothing else, they should still understand whether the week was up or down and by how much.
2. Top Products and Categories
Rank products by net sales for the week. Look at:
The top 10 products by revenue
Which products moved up or down compared to last week
Whether a new or recently promoted product entered the list
A product that suddenly ranks higher is worth investigating. So is one that dropped sharply. The reasons are usually one of: a promotion you ran, inventory constraints, or a quality or shipping issue surfacing in returns.
3. New vs Returning Customers
Using customer email, separate first-time buyers from those who have purchased before. Track:
New customer count and their share of total orders
Returning customer count and their contribution to revenue
AOV difference between new and returning customers
When the new customer rate spikes, it often reflects an ad or promotion that is pulling in acquisition. When returning customers drive the week, it usually signals stronger retention. Both matter and tell different stories.
4. Discount and Coupon Usage
Track the total discount amount applied, the number of orders with a discount, and the average discount rate. Then ask:
Did AOV go up or down during the discount period?
Did order volume increase enough to offset the margin impact?
Which discount codes or promotions drove the most usage?
High discount spend with flat order volume is a signal to revisit the promotion. High discount spend with proportionally higher order volume may be working as intended.
5. Refund and Return Signal
Track refund amounts, refund count, and refund rate as a share of total orders. A week-over-week spike in refunds often points to a specific product, a fulfillment problem, or a customer expectation mismatch.
If refund rate climbs on a particular SKU, cross-reference it with recent customer support tickets before the issue compounds.
Where the Manual Workflow Breaks Down
If you are building this report manually each week from Shopify exports, here is where the time goes:
Rebuilding the pivot table. Every new export file means reopening the workbook, redefining the data range, and repositioning the pivot fields. If Shopify changes a column name or adds a new field, the pivot breaks.
Recalculating week-over-week comparisons. To compare this week to last week, you need to open both files. The comparison formulas live in a third sheet or document and reference ranges across two files, which breaks if either file is moved or renamed.
Filtering order statuses. Separating paid orders from refunded and voided requires a filter step that has to be reapplied every week. If you forget to filter and build the pivot first, the revenue totals include orders that were never collected.
Formatting and sharing. After analysis comes the presentation step: copying numbers into a PowerPoint template, reformatting tables, updating charts, and saving a version for sharing. This step can take as long as the analysis itself.
The analysis is not the bottleneck. The setup before and the formatting after are.
A Better Workflow: Shopify Export to Dashboard with Kiolix Xel
Kiolix Xel is a local-first desktop app for Mac and Windows that turns Excel and CSV exports into dashboards, KPI views, and exportable reports without uploading your workbooks to a cloud pipeline.
Here is how a weekly Shopify reporting workflow looks inside Kiolix Xel:
Step 1. Import the export file. Bring in your Shopify Orders export directly. If you have multiple weeks of data in separate files, you can import them together (up to 100 files at a time). Kiolix Xel's local analysis engine, built on DuckDB, profiles the column structure, data types, date ranges, and missing values automatically.
Step 2. Review the data structure. Check which columns are present, confirm that financial status and fulfillment status columns are mapped correctly, and apply any filters you need, such as excluding voided or pending orders. Data preparation changes are applied before the dashboard is built so the numbers start clean.
Step 3. Open the sales dashboard. The sales domain dashboard assembles revenue, order count, AOV, top products, new vs returning customer breakdown, and refund signals automatically. If you imported multiple weeks, week-over-week comparisons are available without manual calculation.
Step 4. Ask follow-up questions. When the dashboard raises a question — why did AOV drop this week, which returning customers have the highest lifetime value, which discount code had the best conversion — you can ask the AI Agent using natural language. The agent works from the report context and your data summary. For transformations, it shows a preview before applying anything. For important numbers, always verify against your original export.
Step 5. Export the report. When the report is ready, export it as a PowerPoint, XLSX, PDF, or PNG for sharing with your team. The format stays consistent week to week, so distribution becomes part of the routine rather than a separate effort.
Workbook processing runs on your device. Kiolix Xel does not upload your full Shopify export to Daolix servers during normal analysis. If you use a cloud LLM such as OpenAI, Claude, or Gemini for AI follow-up, the prompt and analysis context you provide will be sent to that provider following their data policy. If your export contains customer email addresses or other personal data and you want to avoid any external transmission, the Ollama local model option runs entirely on your machine, though it requires a separate installation.
Weekly Shopify Reporting Checklist
Use this each week before sharing the report:
Exported this week's orders from Shopify using the correct date range
Filtered to paid orders only (excluded voided, pending, and test orders)
Calculated net sales after discounts and refunds
Compared this week's revenue, order count, and AOV to last week
Identified the top 10 products by net sales and noted any changes from last week
Separated new vs returning customers using customer email
Reviewed discount amount and checked whether it produced a proportional lift in orders or AOV
Checked refund rate and flagged any SKUs with a spike
Identified at least one operational action coming out of the report
Exported the report in the format used for team or stakeholder sharing
Kiolix Xel Download
If your Shopify reporting still starts with downloaded spreadsheets and ends with manual slides, Kiolix Xel can help you reduce the steps between the export file and the shareable report.
Product page and sample files: xel.kiolix.com
Mac App Store: apps.apple.com/app/id6761149232
Microsoft Store: apps.microsoft.com/detail/9NJVT5BFWCMH
Comments
Post a Comment