Shopify Sales by Discount Report What Does It Include

Introduction
The Core Components of the Sales by Discount Report
Detailed Metrics: What Each Column Represents
Platform Constraints and Reporting Limits
Practical Scenarios: Analyzing Discount Performance
Enhancing Your Strategy with the Nextools Suite
Advanced Data Considerations for Plus Merchants
Compliance and Data Integrity
Optimizing Discounting for Italian Merchants
The Future of Reporting: AI and Shopify Functions
Nextools Shopify App Suite (Quick Links)
Conclusion
FAQ

Introduction

Managing a high-volume Shopify Plus store requires more than just high traffic; it requires a granular understanding of how every dollar of promotional spend impacts the bottom line. For merchants, agencies, and developers moving away from the legacy world of Shopify Scripts toward the modern era of Shopify Functions and Checkout Extensibility, data transparency is the primary hurdle. When you launch a site-wide sale or a targeted influencer campaign, the immediate question is never just “did we sell?” but rather “how much did those discounts actually cost us in net revenue?”

At Nextools, we specialize in helping merchants navigate these complex technical shifts. Whether you are migrating logic from Scripts to Functions or building advanced checkout validations, the “Sales by Discount” report is your primary audit tool. This post is designed for Shopify Plus merchants and the developers who support them. We will break down exactly what the Shopify sales by discount report includes, how the data is calculated, and how you can use this information to optimize your discounting strategy using the Nextools suite of tools.

Our approach follows the Nextools Playbook: we first clarify the constraints of Shopify’s reporting engine, confirm the limits of the platform’s native analytics, choose the simplest durable approach for implementation (often leveraging the Nextools Shopify App Suite), implement safely in staging environments, and finally, measure the impact on your AOV and conversion rates.

The Core Components of the Sales by Discount Report

The Shopify Sales by Discount report is a specialized view within the Analytics suite that categorizes your revenue based on the specific discount codes or automatic discounts applied at checkout. Unlike a general sales report, this view prioritizes the performance of your promotional triggers.

Understanding Gross Sales vs. Net Sales

The most critical distinction in this report is the difference between Gross Sales and Net Sales. In the context of a discount report, these numbers tell the story of your promotion’s efficiency.

Gross Sales: This represents the product price multiplied by the quantity before any taxes, shipping, or discounts are applied. If a customer buys a $100 item using a 20% discount code, the Gross Sales figure remains $100.
Discounts: This column tracks the total dollar value reduction. In our example, this would be $20. It includes both line-item discounts and order-level discount shares.
Net Sales: This is the “real” product revenue. It is calculated as Gross Sales - Discounts - Sales Reversals. Using our example, if there are no returns, the Net Sales would be $80.

At Nextools, we often see merchants focus too heavily on Gross Sales during high-velocity events like BFCM. However, the Nextools Shopify App Suite helps you focus on Net Sales by providing the logic to prevent “discount stacking” that can erode margins faster than native Shopify settings allow.

The Inclusion of Sales Reversals (Formerly Returns)

Shopify recently updated its terminology to be more precise for accounting purposes. What was once labeled as “Returns” is now often categorized under “Sales Reversals” and “Reversed Quantity.”

The Sales by Discount report includes these reversals to ensure your marketing ROI isn’t inflated by orders that were later refunded. A reversal includes:

Full refunds where products were returned.
Refunds without physical returns (goodwill adjustments).
Partial refunds.
Order edits that removed items after the discount was applied.

If a customer used a “WELCOME10” code and then returned half their order, the report proportionally adjusts the discount value and the net sales to reflect the actual retained revenue.

Detailed Metrics: What Each Column Represents

To truly master the Shopify sales by discount report, you must understand the data schema behind each column. This is especially important for developers building custom reporting connectors or using apps like SupaEasy to create complex discounting logic.

1. Total Sales Calculation

The “Total Sales” figure in this report is often higher than the Net Sales. This is because Total Sales includes:

Net Sales (Gross – Discounts – Returns)
Shipping charges
Taxes
Duties
Additional fees (like processing or eco-fees)

It is a common pain point for merchants to see a discrepancy between their bank payouts and the Total Sales column. Total Sales represent what the customer paid, not what the merchant keeps.

2. Discounts (Line Item vs. Order Level)

Shopify handles discounts in two ways. Line-item discounts are applied to a specific product. Order-level discounts (like “10% off your entire order”) are distributed proportionally across all line items in the order. The report aggregates these into a single “Discounts” column for each specific code.

3. Shipping and Tax Attribution

The report tracks how much tax and shipping was associated with orders using a specific discount. This is vital for international merchants using Shopify Markets. If you offer “Free Shipping” via a discount code, your “Shipping Discounts” will be captured here, allowing you to see the true cost of that incentive.

4. Units per Transaction (UPT) and AOV

The report provides the Average Order Value (AOV) for customers using specific codes. This allows you to compare, for example, whether a “Buy One Get One” (BOGO) offer driven by Multiscount results in a higher UPT than a flat 20% off code.

Platform Constraints and Reporting Limits

Before relying solely on native reports, Shopify Plus merchants must understand the platform’s architectural constraints.

Timing and Data Freshness

Data in the Sales by Discount report is typically updated every 1 to 5 minutes. However, during extreme peak events (like a flash sale), there can be slight delays in how reversals are reflected.

Product Detail Changes

A significant “gotcha” in Shopify reporting occurs when you rename a product or change its type. Shopify captures the state of the product at the time of the sale. If you sell a “Blue T-Shirt” under a discount code on Monday, then rename it to “Azure Tee” on Tuesday and sell more, the report will display two separate lines for what is essentially the same product. This can make aggregating discount performance by product category difficult without external cleanup.

Checkout Extensibility and Functions

As Shopify moves toward Checkout Extensibility, the way discounts are applied is changing. Legacy Scripts ran on the server-side during the checkout process but were often opaque to the reporting engine until the order was finalized. Shopify Functions, which SupaEasy utilizes, provide a more structured way to apply discounts that integrates more cleanly with Shopify’s native analytics.

Nextools Insight: If you are migrating from Scripts to Functions, ensure your new logic uses the same naming conventions for discount codes. If your Function generates a unique “ID” for a discount rather than a human-readable “Code,” your Sales by Discount report will become unreadable for your marketing team.

Practical Scenarios: Analyzing Discount Performance

Let’s look at how a Shopify Plus team uses this report in real-world operations.

Scenario A: Influencer Attribution Audit

A merchant uses 50 different influencer codes (e.g., KIM10, CHRIS10). By filtering the Sales by Discount report, the marketing manager can see not just who drove the most gross sales, but who had the lowest return rate.

If KIM10 drove $100k in sales but had a 30% return rate (Sales Reversals), while CHRIS10 drove $50k with a 2% return rate, the report reveals that Chris is the more profitable partner. To manage these hundreds of codes efficiently, many merchants use SupaEasy to automate the creation and validation of these codes.

Scenario B: Testing Tiered Discounts

An agency wants to test if “Spend $100, Save $20” performs better than “20% Off Everything.” By using Multiscount, they can run these promotions simultaneously for different customer segments.

The Sales by Discount report will then allow them to compare the “Average Order Value” column for both groups. If the tiered discount results in a significantly higher AOV without increasing the “Discounts” column proportionally, the tiered strategy wins.

Scenario C: Preventing Fraud and Discount Abuse

Sometimes, a discount code “leaks” to coupon-aggregator sites. A merchant might notice a sudden spike in a “WELCOME10” code intended for new subscribers. By looking at the “Customer Type” filter (available in advanced views) within the discount reports, they can see if existing customers are abusing the code.

To stop this in real-time, the merchant can use Cart Block to validate the checkout and block the order if a specific discount code is used by a customer tag that shouldn’t have access to it.

Enhancing Your Strategy with the Nextools Suite

Shopify’s native reports tell you what happened. The Nextools Shopify App Suite helps you control how it happens, ensuring the data in those reports reflects a healthy, profitable business.

Choosing the Right Tool for the Job

Goal	Recommended Nextools App	Why?
Migrate Shopify Scripts	SupaEasy	Transition to Functions safely while maintaining reporting parity.
Stackable/Tiered Discounts	Multiscount	Create complex rules that native Shopify “Combinations” can’t handle.
Block Discount Abuse	Cart Block	Prevent specific codes from being used with certain payment methods or by certain customers.
Add GWP (Gift with Purchase)	AutoCart	Auto-add items when a discount code is applied, which is tracked as a $0 line item in reports.
Customize Checkout UI	SupaElements	Display “You’ve saved $X” messages in the checkout to increase conversion.

The Engineering Workflow for Discounting

At Nextools, we advise merchants to follow a strict implementation flow for any new discounting strategy:

Clarify: Define the exact goal. Is it to clear inventory or acquire new customers? Determine if you are on a Shopify Plus plan, as this unlocks advanced Functions capabilities.
Confirm Limits: Check if Shopify’s native “Discount Combinations” can handle your logic. If not, look toward Shopify Functions.
Choose the Tool: Use SupaEasy for custom logic or Multiscount for pre-built tiered templates.
Safe Implementation: Test the discount in a Sandbox/Development store. Check the “Sales by Discount” report in the dev store after a test transaction to ensure the data maps correctly.
Measure: After 7 days, audit the report for Net Sales and Sales Reversals. Adjust the logic if the discount is being abused or if margins are too thin.

Advanced Data Considerations for Plus Merchants

For larger organizations, the native Sales by Discount report is often just the starting point.

Currency and Markets

If you sell in multiple currencies, the report converts everything to your store’s functional currency. However, currency fluctuations can create “ghost” losses or gains in your Net Sales. Using CartLingo can help ensure your checkout is localized, which reduces the friction that often leads to abandoned carts—even when a discount is present.

POS vs. Online Store

The Sales by Discount report can be filtered by “Sales Channel.” This is vital for brands with physical locations. You might find that a discount code that converts well online has a high return rate when used for “Buy Online, Pick Up In-Store” (BOPIS) due to sizing issues. Analyzing this helps you refine your product descriptions.

Integration with External ERPs

Most Shopify Plus merchants sync their sales data to an ERP like NetSuite or SAP. The “Discount Code” field is a primary key in these integrations. If you are using Hook2Flow, you can trigger custom webhooks every time an order with a specific discount is placed, sending that data to Shopify Flow for advanced tagging or loyalty point allocation.

Compliance and Data Integrity

When analyzing your reports, data integrity is paramount.

GDPR Awareness

While the Sales by Discount report focuses on financial data, remember that filtering by “Customer Name” or “Email” (if you’ve customized the report) brings you into the realm of GDPR. Always ensure that your reporting practices minimize the use of PII (Personally Identifiable Information) unless strictly necessary for fulfillment or tax compliance.

Avoiding Guarantee Fallacies

It is important to remember that a “Sales by Discount” report shows historical correlation, not necessarily causation. A code might have high sales because it was placed in a prominent header, not because the discount percentage was the perfect “magic” number. Use the Nextools Shopify App Suite to run controlled experiments to find what truly drives value.

Optimizing Discounting for Italian Merchants

For our Italian Shopify community, reporting often needs to tie back to local invoicing requirements. If you are using Fatturify, ensure that your discount logic correctly reflects the VAT breakdown.

The Sales by Discount report will show the discounted Net Sales, and Fatturify will ensure that the electronic invoice (Fattura Elettronica) sent to the SDI (Sistema di Interscambio) matches those figures perfectly. This prevents reconciliation nightmares during tax season. Similarly, tracking shipments with PosteTrack can help you see if specific discounts lead to higher shipping costs with national carriers.

The Future of Reporting: AI and Shopify Functions

The next evolution of Shopify analytics involves predictive modeling. By looking at the “Sales by Discount” report over several years, AI tools (including those integrated into SupaEasy) can begin to suggest the optimal discount depth for your specific audience.

We are moving away from the “guess and check” method. By leveraging the advanced logic of Shopify Functions, you can create “Dynamic Discounts” that change based on cart attributes, customer tags, or even real-time inventory levels. For example, using AttributePro, you can capture specific customer preferences at checkout and then use SupaEasy to apply a discount that only triggers if those attributes meet certain criteria.

This level of precision is then reflected in your reports, giving you a much more sophisticated view of your business than a simple “10% off” ever could.

Nextools Shopify App Suite (Quick Links)

To implement the strategies discussed in this article, explore the full Nextools suite on the Shopify App Store:

Conclusion

The “Sales by Discount” report is a powerful window into the financial health of your promotions, but it is only as useful as the strategy behind the discounts themselves. To get the most out of this data, Shopify Plus merchants should move beyond simple codes and embrace the precision of Shopify Functions.

Key Actionable Checklist:

Audit your Net Sales: Don’t be fooled by high Gross Sales; check the Net Sales column to see what you actually kept after discounts and reversals.
Monitor “Sales Reversals”: If a specific discount code has a disproportionately high return rate, investigate if the marketing messaging for that campaign is misleading.
Standardize Naming: Ensure your developers or apps like SupaEasy use clear, human-readable discount titles so the reports remain useful for the marketing team.
Implement Safe Stacking: Use Multiscount to control exactly how discounts combine, preventing “margin bleed” that shows up too late in the reports.
Validate at Checkout: Use Cart Block to ensure that only the right customers are using the right discounts, keeping your data clean and your profits protected.

At Nextools, we believe in a methodical engineering approach: clarify your constraints, confirm platform limits, choose the simplest durable tool, implement safely, and measure relentlessly. By following this playbook and leveraging the Nextools Shopify App Suite, you can transform your discounting from a cost center into a data-driven engine for growth.

FAQ

Does the Sales by Discount report include shipping and taxes?

The report includes columns for Taxes and Shipping associated with the discounted orders, but these are added to the Net Sales to reach the Total Sales figure. Net Sales themselves are calculated before shipping and taxes are added.

Can I see which specific customers used a discount code in this report?

By default, the report aggregates data by discount code. However, on Shopify Plus, you can customize the report to add “Customer Name” or “Customer Email” as a dimension to see exactly who used each code.

Why do some discounts show up as “None” or a dash in the report?

This usually happens if an order was placed without a discount code, or if a discount was applied via a legacy method that the reporting engine can’t attribute to a specific code (such as some manual price overrides in the draft order flow).

How do I migrate my custom discount scripts to ensure they show up in this report?

You should migrate your Shopify Scripts to Shopify Functions using a tool like SupaEasy. Functions are natively integrated into Shopify’s analytics, ensuring that every discount applied is correctly named and tracked in your Sales by Discount report.

Table of Contents