Mastering the Sales by Discount Report in Shopify

Table of Contents

1. Introduction
2. What Is the Sales by Discount Report in Shopify?
3. The "Bundle With Intention" Decision Path
4. Understanding the Key Metrics in Your Report
5. How Bundling Mechanics Affect Your Reports
6. What Bundling Tools Can and Cannot Do
7. Advanced Data Analysis: Going Beyond the Basics
8. Managing Performance and Operations
9. Putting It Into Practice: A Real-World Decision Path
10. Summary of Key Takeaways
11. Conclusion
12. FAQ

Introduction

Every Shopify merchant knows the rush of a successful promotion. The notification pings on your phone are frequent, the "Live View" map is glowing, and your revenue chart is climbing. But as the dust settles, a nagging question often remains: Was that promotion actually profitable? Or did those heavy discounts simply move product while eroding the margins you need to keep the lights on?

Understanding the true impact of your promotional strategy is the difference between a store that simply generates "noise" and one that generates sustainable profit. For growing Direct-to-Consumer (DTC) brands, high-SKU catalogs, and gift-heavy stores, the sales by discount report shopify provides is the compass you need to navigate these waters.

In this guide, we will walk through how to locate, read, and—most importantly—act upon your Shopify discount data. Whether you are a new founder looking to understand your first Black Friday results or an experienced operator refining a sophisticated bundling strategy, we’ll help you bridge the gap between "running a sale" and "building a brand."

At MBC Bundles, we believe in a phased approach to growth: start with a solid foundation, clarify your specific goals, check your margins, bundle with clear intention, and then reassess based on data. This article is designed to help you with that final, critical step: the data-driven reassessments that turn a one-time sale into a long-term strategy.

What Is the Sales by Discount Report in Shopify?

In plain English, the sales by discount report is a breakdown of how your promotional codes (and sometimes automatic discounts) are impacting your bottom line. It isn't just a list of codes; it’s a financial summary that links specific marketing efforts to actual sales dollars.

When you open this report, you aren't just seeing a "Total Sales" figure. Instead, Shopify aggregates your data to show you the "Gross Sales" (the price of the items before any discounts) and then subtracts the "Discounts" and "Returns" to give you the "Net Sales." This distinction is vital. Net sales represent the actual money that stays in your business to cover your inventory costs, shipping, and marketing spend.

How to Access the Report

Depending on your Shopify plan, you may have access to different levels of detail.

1. Log into your Shopify Admin.
2. Click on Analytics in the left-hand sidebar.
3. Select Reports.
4. Search for or scroll down to the Sales section and look for Sales by discount.

Pro Tip: If you are on the "Basic" Shopify plan, your reporting options are more limited than the "Shopify," "Advanced," or "Plus" plans. If you don't see the specific "Sales by discount" report, you can often find discount totals in your "Finance" reports, though they may offer less granular detail about specific codes.

The "Bundle With Intention" Decision Path

Before we dive deeper into the technical columns of the report, we must address the strategy behind the data. At MBC Bundles, we advocate for "Bundling with Intention." This means you shouldn't just look at the report to see what happened; you should use it to decide what to do next.

Step 1: Foundations First

Before you worry about which discount code performed best, ensure your store's foundations are rock solid. Is your mobile UX fast? Are your shipping and return policies transparent? A high "Sales by Discount" number might look good, but if your "Returns" column in that same report is also high, the problem might be your product descriptions or shipping speeds, not your discount strategy.

Step 2: Clarify the Goal

What was the purpose of the discount?

• To raise Average Order Value (AOV): You want to see that the discount encouraged people to buy more than they usually do.
• To move old inventory: You are looking for high "Net Quantity" sold, even if the "Net Sales" are lower.
• To acquire new customers: You should filter your report by "Customer Type" to see if the code attracted new shoppers or just gave a deal to existing fans.

Step 3: Margin and Operations Check

This is where the sales by discount report becomes a shield for your business. You must confirm profitability. If you offer a 20% discount but your product margin is only 30%, and then you factor in shipping and credit card fees, you might actually be losing money on every sale.

Step 4: Bundle with Intention

Once you see which discounts are working, you can move from "simple codes" to strategic bundles. If the report shows that a $10 off coupon is popular, perhaps a "Mix & Match" bundle or a "Buy X Get Y" (BOGO) offer would be even more effective at increasing your AOV without the "cheapening" feel of a site-wide coupon.

Step 5: Reassess and Refine

The report is your feedback loop. If a "FREESHIPPING" code results in higher net sales than a "10PERCENTOFF" code, you know where to focus your future marketing spend.

Understanding the Key Metrics in Your Report

The sales by discount report shopify generates can be intimidating at first glance. Let's break down the most important columns into plain English.

Gross Sales vs. Net Sales

• Gross Sales: This is the total "sticker price" of the products sold. Think of this as the "potential" revenue before any deals happened.
• Discounts: This is the total amount of money "given away" through the use of codes or automatic promotions.
• Returns: This shows the value of items sent back. If one specific discount code has a much higher return rate than others, it may indicate that the "deal" attracted low-quality traffic or "serial returners."
• Net Sales: The holy grail metric. [Gross Sales] - [Discounts] - [Returns]. This is the actual revenue your business generated from those discounted orders.

Net Quantity

This tells you how many physical items left your warehouse. This is a key metric for inventory planning. If you run a "Quantity Break" (where customers save more when they buy more), your net quantity should be significantly higher than your order count.

Orders and Average Order Value (AOV)

AOV is calculated by taking your total revenue and dividing it by the number of orders.

• Scenario: If you notice that orders using a "BUY2SAVE10" code have an AOV of $80, while your store average is $50, that discount is doing its job—it's encouraging larger carts.

Takeaway: Always prioritize Net Sales over Gross Sales. Gross sales tell you how much you moved; Net sales tell you how much you earned.

What to Do Next:

• Identify your top 3 discount codes by Net Sales.
• Compare the return rate of discounted orders vs. non-discounted orders.
• Calculate the AOV for each specific discount code to see which one drives the largest carts.

How Bundling Mechanics Affect Your Reports

Bundling is essentially a more sophisticated form of discounting. Instead of a generic "10% off everything," you are offering a discount in exchange for a specific customer behavior—like buying a set or reaching a spending threshold.

Discount Types and How They Show Up

In Shopify, bundles can be powered in a few different ways, and this affects your reporting:

1. Fixed Amount: "$10 off the bundle." This shows up as a flat discount amount in your report.
2. Percentage Off: "Save 15% when you buy the set." This is often easier for customers to understand at a glance.
3. Buy X Get Y (BOGO): "Buy a cleanser, get a travel-size moisturizer free." In your reports, the "Y" item often shows up as a line item with a 100% discount.
4. Quantity Breaks / Volume Discounts: "Buy 3 for $50." This is excellent for consumable products.

The Challenge of Discount Stacking

"Discount stacking" is when a customer tries to use more than one offer at once (e.g., using a 10% welcome code on top of a "Buy 3 and Save" bundle).

• The Risk: If you aren't careful with your Shopify settings, you could accidentally "stack" discounts until your profit disappears.
• The Solution: Within Shopify’s discount settings, you can specify whether a discount code can be combined with product discounts or shipping discounts. Always test your checkout end-to-end before launching a major promotion.

Mobile UX and Bundles

More than 70% of Shopify traffic typically comes from mobile. If your bundle offer or discount code is hard to find or apply on a small screen, your conversion rate will suffer.

• Best Practice: Ensure your bundle offers live directly on the Product Detail Page (PDP) so customers don't have to "hunt" for the deal.
• Performance Check: Large, unoptimized bundle apps can slow down your site. Use "Built for Shopify" apps that prioritize clean code and fast load times.

What Bundling Tools Can and Cannot Do

It is important to have realistic expectations for your discount and bundling strategy.

What They Can Do:

• Improve Perceived Value: A well-packaged bundle feels like a "curated experience" rather than just a price cut.
• Reduce Friction: By grouping related products (like a "Skincare Starter Kit"), you help the customer make a decision faster.
• Increase AOV: They provide a clear incentive to add "one more thing" to the cart.
• Move Inventory: Bundles are a great way to pair a "slow-mover" with a "best-seller."

What They Cannot Do:

• Fix Poor Traffic Quality: If you are sending the wrong people to your store, a discount won't make them buy.
• Replace Product-Market Fit: No amount of bundling will save a product that people don't actually want.
• Fix Unclear Policies: If your shipping is too expensive or your return policy is scary, customers will abandon their cart regardless of the discount.
• Guarantee Revenue: Results will always vary based on your margins, your industry, and how well you execute the offer.

Advanced Data Analysis: Going Beyond the Basics

Once you are comfortable with the standard sales by discount report shopify provides, you can start looking for deeper "storytelling" in your data.

Segmenting by Customer Type

Are your discounts being used primarily by new customers or returning ones?

• If new customers are the main users: Your discounts are an acquisition tool. This is great for growth, but check your "Customer Acquisition Cost" (CAC) to ensure you aren't overpaying for those leads.
• If returning customers are the main users: Your discounts are a loyalty or retention tool. Be careful not to "train" your best customers to only shop when there is a sale.

Analyzing Refunds by Discount Code

This is a frequently overlooked part of the report.

"If a 50% off 'Flash Sale' code has a 30% refund rate, but your 10% 'Welcome' code only has a 2% refund rate, the 50% off sale might actually be a net negative for your operations team and your bottom line."

Measuring "Attach Rate"

While not a standard column in the basic report, you can calculate "Attach Rate" by looking at how often a specific bundle item is purchased alongside your main product. A high attach rate indicates a successful "intentional" bundle.

One Change at a Time

When testing new discount strategies, try not to change everything at once. If you launch a new "Mix & Match" bundle, a new free shipping threshold, and a new popup discount code all in the same week, you won't know which one actually moved the needle.

Managing Performance and Operations

Success in eCommerce isn't just about making the sale; it's about fulfilling it efficiently.

Inventory and Variants

As you add bundles and quantity breaks, inventory management becomes more complex.

• If you sell a "bundle" that consists of three separate products, your system must be able to "deduct" one from each of those three products' inventory levels.
• Shopify’s native "Bundles" app and advanced third-party tools (like MBC Bundles) help manage this logic so you don't accidentally oversell a product that is part of a kit.

Shipping and Fulfillment

Discounted orders often have different shipping dynamics.

• If a bundle makes a package heavier or larger, your shipping costs might spike, eating into the profit you calculated.
• Ensure your shipping rules are set up to handle the increased weight of bundled orders.

The "Red Flag" Guide: When to Bring in Help

While Shopify is user-friendly, some areas require professional eyes:

• Custom Code: If you are editing your theme's liquid files to display bundles and notice your site is slowing down or "glitching" on mobile, stop and consult a Shopify developer.
• Legal/Compliance: Pricing transparency is regulated differently in various regions (e.g., the "Omnibus Directive" in the EU). If you are unsure if your "Compare at" pricing or discount labels are legal, consult a compliance specialist.
• Payments & Fraud: If you see a sudden spike in high-value orders using a specific discount code from a single IP address, it could be a fraud attempt. Contact the MBC Bundles Help Center and review your fraud filters immediately.

Putting It Into Practice: A Real-World Decision Path

Let's look at how a merchant might use the sales by discount report shopify offers to make a real change in their store, then compare that approach with our Sony World case study.

The Scenario: A merchant selling premium coffee beans notices their "10% Welcome Code" is their most used discount, but their AOV is stuck at $35 (one bag of coffee). They want to increase AOV to $60.

The Phased Approach:

1. Foundations: They ensure the "Add to Cart" button is easy to find on mobile.
2. Goal: Increase AOV by encouraging multi-bag purchases.
3. Margin Check: They calculate that they can afford a 15% discount if a customer buys 3 bags because the shipping cost for 3 bags is only slightly higher than for 1 bag.
4. Bundle with Intention: Instead of just a code, they implement a "Mix & Match" bundle on the product page: "Pick any 3 blends and save 15%."
5. Reassess: After 30 days, they check the sales by discount report.
   • They see a new entry for the automatic "Mix & Match" discount.
   • The AOV for orders using that discount is $62.
   • The "Net Sales" are higher than when they were just using the 10% Welcome Code.

The Result: The merchant successfully used data to move from a "reactive" discount (giving money away to get a single sale) to an "intentional" bundle (offering value in exchange for a larger order).

Summary of Key Takeaways

Managing your store's discounts is a journey of continuous improvement. Here is how to keep your strategy on track:

• Trust the Data: Always look at Net Sales and Refund Rates in your Shopify reports to see the true health of a promotion.
• Phased Strategy: Never skip the "Margin Check." A sale that loses money is just a hobby, not a business.
• Keep it Simple: Start with one or two clear bundle types (like Mix & Match or Quantity Breaks) before moving to complex, stacked offers.
• Mobile First: Ensure your bundles look great and load fast on phones.
• Test and Iterate: Use your reports to identify what’s working, then double down on those tactics while cutting the ones that underperform.

"The most successful Shopify stores don't just 'have a sale'; they use discounts as a strategic tool to guide customer behavior, protect their margins, and build a sustainable brand."

Conclusion

The sales by discount report shopify provides is more than just a list of numbers; it’s a window into your customers' motivations and your business's financial health. By moving through the phased journey—from establishing foundations to bundling with clear intention—you turn raw data into a competitive advantage.

Remember to stay focused on sustainable growth. Don’t be afraid to turn off a discount code if the data shows it’s driving high returns or low margins. Conversely, when you find a bundle that resonates with your audience and lifts your AOV, lean into it.

At the MBC Bundles homepage, our mission is to help you implement these strategies with ease, ensuring that your bundling efforts are helpful to your shoppers and profitable for your brand. Start simple, measure the impact, and grow with intention.

FAQ

Why don't my automatic discounts show up in the Sales by Discount Code report?

Shopify often separates "Discount Codes" (which the customer types in) from "Automatic Discounts" (which apply based on cart rules). To see the impact of automatic discounts, you may need to look at your "Sales by Product" report or your "Finance" reports, where discounts are often aggregated as a total line item. Some advanced reporting apps can help combine these views into a single dashboard.

How can I tell which specific products are being discounted the most?

While the Sales by Discount report shows you the code used, the "Sales by Product" report (filtered or grouped by discount) is often better for seeing which items are being moved by your promotions. If you notice one product is only ever sold when it's discounted, it may be time to reassess its base price or its marketing strategy.

Can I see which customers used a specific discount code?

Yes, but you usually need to "drill down" into the data. You can click on the specific discount code within the report (on higher Shopify plans) to see the associated orders, or you can use the "Customers" report and apply a filter for "Discount Code used." This is helpful for identifying your most "deal-sensitive" customers for future email segmentation.

How long should I wait before analyzing the results of a new bundle or discount?

ECommerce data can be "noisy" in the short term. For most stores, we recommend waiting at least 14 to 30 days to collect enough data to see a real trend. This allows you to account for weekly shopping patterns (like weekends vs. weekdays) and gives you time to see if any of those discounted orders result in early returns.