Shopify Analytics: Report Products Sold at Discount Compare at Price

Q: How Shopify Defines Gross Sales?

In a standard Shopify Sales report, the metric Gross Sales is defined as Product Price x Quantity. Crucially, "Product Price" in this context refers to the price the customer actually paid at the moment of checkout (the price field in the admin). If a product has an MSRP of $100 (Compare-at price) but is being sold for $75 (Price), Shopify records the Gross Sale as $75.

Introduction
The Core Conflict: Compare-at Price vs. Real Discounts
Platform Constraints and Reporting Limits
The Nextools Playbook: A Structured Implementation
Technical Solutions: Using Shopify Functions for Better Reporting
Choosing the Right Tool for Your Discount Strategy
The Impact on ROI and Financial Planning
Best Practices for Migration and Implementation
Leveraging the Nextools App Suite for Data Integrity
Nextools Shopify App Suite (Quick Links)
Conclusion
FAQ

Introduction

One of the most persistent technical frustrations for Shopify Plus merchants and growing brands is the gap between storefront presentation and backend data accuracy. When a merchant uses the native “Compare-at Price” field to represent a sale, the storefront looks perfect—customers see a strikethrough price and a sense of urgency. However, the backend analytics often tell a different, more complicated story. In Shopify’s default sales reports, “Gross Sales” are calculated based on the “Price” field, not the “Compare-at Price.” This means that when you sell a product using a compare-at price, your reports show $0 in “Discounts,” and your “Gross Sales” appear lower than they truly are.

At Nextools, we specialize in bridging these technical gaps through Shopify Functions and advanced checkout logic. For high-volume merchants, agencies, and developers, this reporting discrepancy isn’t just a minor annoyance; it’s a barrier to calculating true Return on Ad Spend (ROAS) and understanding the impact of promotional strategies. If your finance team or investors are looking for a clear breakdown of gross revenue versus promotional discounts, relying solely on compare-at prices can make your business look smaller and less efficient than it actually is.

This post is designed for Shopify Plus merchants, technical leads, and e-commerce managers who need to reconcile their financial data. We will walk through the platform limits, the technical architecture of Shopify’s reporting engine, and how to implement a durable, engineering-minded solution using the Nextools Playbook: clarify your goals, confirm platform limits, choose a Functions-first approach, implement safely in a staging environment, and measure the impact on your data integrity.

The Core Conflict: Compare-at Price vs. Real Discounts

To understand why your Shopify analytics report for products sold at discount using compare-at prices feels “wrong,” we must first look at how Shopify categorizes a “Sale” versus a “Discount.”

How Shopify Defines Gross Sales

In a standard Shopify Sales report, the metric Gross Sales is defined as Product Price x Quantity. Crucially, “Product Price” in this context refers to the price the customer actually paid at the moment of checkout (the price field in the admin). If a product has an MSRP of $100 (Compare-at price) but is being sold for $75 (Price), Shopify records the Gross Sale as $75.

The Missing Discount Line Item

In that same report, the Discounts column tracks the total dollar value reduction applied via discount codes, automatic discounts, or Shopify Scripts. Because compare-at pricing is a property of the product variant and not an applied discount logic, Shopify records $0 in the discount column for these transactions.

This creates a structural reporting issue:

Scenario A (Real Discount): Product is $100. A 25% automatic discount is applied. Report shows: Gross Sales $100, Discount $25, Net Sales $75.
Scenario B (Compare-at Price): Product Price is $75, Compare-at Price is $100. Report shows: Gross Sales $75, Discount $0, Net Sales $75.

While the Net Sales (the money in your bank) is identical, Scenario B hides the fact that a promotion occurred. For a store doing $10M in annual revenue with heavy seasonal compare-at pricing, this can result in millions of dollars of “hidden” promotions that never appear in your discount reports.

Platform Constraints and Reporting Limits

Before attempting to “fix” this reporting, it is vital to understand the constraints of the Shopify platform. Not all solutions are available to every merchant, and the right approach depends on your plan and your checkout type.

Shopify Plus vs. Standard Plans

Shopify Plus merchants have access to Shopify Functions and Checkout Extensibility, which allow for deeper manipulation of how prices are handled at the cart and checkout levels. If you are on a Basic or Shopify plan, you are largely restricted to the native reporting behavior unless you use a third-party app to mirror the strike-through effect using actual discount codes.

Where Logic Can and Cannot Run

Shopify’s analytics engine is largely “post-hoc”—it records what happened at the moment the order was finalized. To change how a sale is reported, you generally have to change how the price is passed to the checkout. You cannot retroactively tell Shopify’s “Sales by Product” report that a $75 sale was actually a $100 sale with a $25 discount unless the checkout itself recognized that $25 as a discount object.

The Role of Shopify Markets

When dealing with multiple currencies and international pricing, the complexity increases. Compare-at prices are often handled via price lists or manual conversions. If your reporting logic doesn’t account for presentment_currency versus shop_currency, your “Gross Sales” data will be further skewed by exchange rate fluctuations.

The Nextools Playbook: A Structured Implementation

At Nextools, we advocate for a structured, engineering-led workflow to solve these types of data discrepancies. When a merchant asks us how to report products sold at discount using compare-at prices, we follow this five-step process.

1. Clarify the Goal and Constraints

First, we define exactly what the merchant needs. Is this for internal marketing ROI tracking, or is it for legal accounting compliance? We also audit the existing “discount stack.” Are there other automatic discounts that might conflict with a new reporting solution?

2. Confirm Platform Capabilities

We verify if the store is using Checkout Extensibility. If the store is still on checkout.liquid, the migration to Shopify Functions becomes a priority. For Plus merchants, we leverage SupaEasy to explore how Functions can transform the cart.

3. Choose the Simplest Durable Approach

The most durable way to fix this reporting is to stop using the compare-at price field for the “sale” and instead use a real Shopify Discount that simulates the look of a compare-at price. This ensures the data is captured correctly at the source.

4. Implement Safely

We never deploy pricing changes directly to a live store. We use a development store or a sandbox to test how the new discount logic interacts with shipping rates, tax calculations, and third-party apps like ERPs or accounting software.

5. Measure and Iterate

After implementation, we verify the “Sales by Product” and “Sales by Discount” reports. We check if the Gross Sales now reflect the original price and if the Discount column accurately captures the promotional value.

Technical Solutions: Using Shopify Functions for Better Reporting

For merchants who want the best of both worlds—the storefront look of compare-at prices and the backend accuracy of real discounts—the solution lies in Cart Transforms and Discount Functions.

The “Better Compare At” Logic

On Shopify Plus, you can use a combination of a Metafield, a Cart Transform, and a Discount Function to rewire how Shopify sees the price. Here is how that technical workflow functions:

Store the Sale Price in a Metafield: Keep your product’s “Price” field set to the original MSRP (e.g., $100). Store your intended sale price (e.g., $75) in a custom Metafield.
Use a Cart Transform: When a product is added to the cart, a Cart Transform function (available via tools like SupaEasy) keeps the price at $100 but prepares the line item for a discount.
Apply a Discount Function: A Shopify Function calculates the difference between the MSRP and the Metafield price ($25) and applies it as a real, order-level or line-item discount.

The Result in Analytics: Shopify now sees a product sold at $100 with a $25 discount. Your “Sales by Discount Code” report will now show this promotion, and your “Gross Sales” will reflect the $100 MSRP. This provides the high-fidelity data needed for scaling.

Why This is Superior to Theme Hacks

In the past, developers used theme-level Liquid hacks or JavaScript to “show” a lower price while keeping the backend price high. These are notoriously brittle. They often break when a customer uses a different currency, or they fail to sync with “Buy Now” buttons and Shop Pay. By using a Functions-first approach with the Nextools App Suite, you are building on Shopify’s native infrastructure, which is faster, more secure, and works across all sales channels.

Choosing the Right Tool for Your Discount Strategy

Implementation depth varies depending on your team’s technical capacity. Here is a mini-decision tree to help you choose the right Nextools solution for managing and reporting your discounts.

You need SupaEasy if…

You want to migrate from legacy Shopify Scripts to Shopify Functions.
You want to create custom “Cart Transform” logic that changes how prices are reported in analytics.
You need AI-assisted function creation to handle complex “Compare-at” scenarios across different Shopify Markets.
Pricing: As listed on the Shopify App Store at time of writing, plans range from a Free Dev Store tier to an Ultimate plan at $399/month for enterprise-level consulting and custom function development.

You need Multiscount if…

Your main goal is stacking discounts that Shopify’s native system might struggle with.
You want tiered “Volume Discounts” (Buy more, save more) that are recorded as actual discounts in your sales reports.
You need a storefront widget that clearly displays the savings to the customer without breaking the analytics.
Pricing: As listed on the Shopify App Store at time of writing, the Premium plan is $8.99/month, while the Advanced plan is $15.99/month.

You need Cart Block if…

You are worried that your new discount reporting logic might be exploited by bots or fraudulent orders.
You need to block specific discount codes from being used in conjunction with “Compare-at” prices in specific markets.
Pricing: As listed on the Shopify App Store at time of writing, plans start at $3.99/month for Premium.

The Impact on ROI and Financial Planning

When your Shopify analytics report for products sold at discount (compare-at price) is accurate, your entire business intelligence stack improves.

Measuring Promotional Efficiency

Without accurate discount reporting, you cannot calculate the “Efficiency Ratio” of your promotions. For example, if you run a “Compare-at Price” sale and your net revenue increases by 20%, you might think it was a success. However, if your report showed that you actually gave away 35% in hidden discounts to achieve that 20% gain, you might realize the promotion was actually margin-negative.

Improving Financial Reports for Stakeholders

Accountants and tax professionals generally prefer to see Gross Revenue and Discounts as separate line items. This is particularly important for calculating sales tax in certain jurisdictions where tax is calculated on the pre-discount price or where promotional “gifts” are treated differently for tax purposes. By using real discounts instead of compare-at price hacks, you provide your accounting team with clean, standard-compliant data.

Inventory and Product Performance

When all products are tracked using a consistent “Gross Sale + Discount” model, you can compare performance across categories more effectively. If some products use compare-at prices and others use discount codes, your “Top Products by Gross Sales” report will be fundamentally skewed. Standardizing your approach through Shopify Functions ensures a level playing field for all product data.

Best Practices for Migration and Implementation

Moving away from a “Compare-at Price” only strategy to a “Real Discount” strategy requires careful planning. At Nextools, we recommend the following best practices for a smooth transition.

Audit Your Metafields: Ensure every product variant has the “MSRP” or “Compare-at” value stored in a consistent Metafield. This becomes the “source of truth” for your Shopify Functions.
Update Your Theme: If you switch to using real automatic discounts, ensure your theme’s product pages still show the strikethrough price. You can use an app like SupaElements to add dynamic UI elements to the checkout that reinforce the savings.
Sync with External Systems: If you use an ERP (like NetSuite or SAP) or an accounting tool (like QuickBooks), verify how it imports Shopify discounts. Most modern integrations handle standard Shopify discounts much better than they handle “Price vs. Compare-at Price” logic.
Monitor “Sales Reversals”: Keep an eye on your returns. Shopify recently updated its terminology from “Returns” to “Sales Reversals.” Accurate discount reporting ensures that when a discounted item is returned, the reversal amount matches the actual net price paid, preventing accounting “leakage.”

Leveraging the Nextools App Suite for Data Integrity

Managing a high-growth Shopify store requires more than just a theme and some products; it requires a suite of tools that work in harmony with Shopify’s evolving architecture. Whether you are dealing with Italian invoicing through Fatturify or complex shipping logic through HideShip, the goal is always the same: reliable, scalable data.

When it comes to the specific problem of reporting products sold at a discount via compare-at prices, our suite provides the modularity you need. You don’t have to build a custom app from scratch. You can use SupaEasy to handle the heavy lifting of Shopify Functions, and AttributePro to pass specific cart attributes that help your warehouse or ERP understand the promotional nature of the order.

Nextools Shopify App Suite (Quick Links)

Conclusion

Correctly reporting on products sold at a discount using compare-at prices is a critical step for any merchant looking to scale with data-driven precision. While Shopify’s native behavior favors simplicity, the engineering-minded merchant knows that “Gross Sales” data is the foundation of financial health. By moving toward a Functions-first approach, you can maintain your storefront’s conversion-friendly look while ensuring your backend analytics are beyond reproach.

To summarize the Nextools Playbook for this implementation:

Identify the reporting gap: Verify if your “Discounts” column in Sales reports is currently $0 for compare-at items.
Audit your data structure: Move intended sale prices into Metafields to prepare for Shopify Functions.
Choose a durable solution: Use a Cart Transform or a tool like SupaEasy to apply real discounts at checkout based on those Metafields.
Implement and Test: Use a sandbox environment to ensure shipping and taxes are calculated correctly.
Measure the impact: Verify that your “Sales by Product” report now correctly separates Gross Sales from Discounts.

If you are ready to fix your reporting and take full control of your checkout logic, explore the Nextools Shopify App Suite today. Our tools are built to handle the complexities of the modern Shopify platform, ensuring that your data, your checkout, and your business remain future-proof.

FAQ

Does using Shopify Functions to fix reporting require Shopify Plus?

Most advanced pricing transformations, such as Cart Transforms that modify how “Gross Sales” are recorded, require Shopify Plus because they rely on specific Shopify Functions APIs. However, some basic discount stacking and reporting can be improved on standard plans using apps like Multiscount.

Will moving from Compare-at pricing to real discounts affect my SEO?

No. SEO is primarily concerned with the content on your product pages. As long as your theme still displays the original and sale prices clearly for Google’s crawlers (often via Schema.org microdata), changing how the discount is technically applied in the cart will not negatively impact your search rankings.

How do I test these changes without breaking my live store’s analytics?

You should always use a Shopify Development Store or a Plus Sandbox store. Nextools apps like SupaEasy offer a Free Dev Store plan (as listed on the App Store at time of writing) specifically for this purpose, allowing you to build and test your logic without cost until you are ready to go live.

Can I migrate my existing Shopify Scripts to this new reporting model?

Yes. Shopify is deprecating Scripts in favor of Functions. A key part of the migration process is ensuring that your new Functions-based logic handles reporting even better than your old Scripts did. We recommend using the Scripts Migrator tool within SupaEasy Advanced to streamline this transition.

Table of Contents