Hop Designer
Bhavya Ratra
Category
Revenue
This report provides aggregated sales performance metrics at the product variant level. It includes essential profitability insights such as total gross profit and gross margin, along with total orders, quantity sold, gross and net sales, discounts, and returns value for each of your product variants.
Integration(s)
How to use this Hop.
Simply create an Airboxr account and connect your Shopify store to automatically run this export/analysis for your store. If you already have an account, click on the Add to my Collection button above.
Product Profitability Analysis: Evaluate how much profit each product variant contributes. This helps you identify your most and least profitable SKUs and understand their role in your overall business performance.
Revenue Sharing & Collaboration Accounting: Use this report to support profit-splitting on collaborative products, such as brand or influencer partnerships. Having total gross profit and sales tied to each variant makes revenue sharing more accurate.
Strategic Product Decisions: Guide decisions around which products to scale, discontinue, or bundle based on their cumulative performance. The report enables focused product management without distraction from short-term fluctuations.
Discount Efficiency Analysis: Review how discounts have affected overall profitability at the product variant level. Determine which variants benefit most from promotions and which may be losing margin unnecessarily.
Returns Impact Assessment: Assess how returns influence the profitability of each variant, helping refine product descriptions, quality control, or customer education to reduce return rates and protect margin.
In This Report
Metrics
Quantity Sold
Gross Sales
Discount
Returns
Net Sales
Tax
Total Sales
Cost of Good Sold
Gross Profit
Gross Margin
Grouped By
Variant ID
Vendor
Product Title
Product Type
Variant SKU
Connect your Shopify store and automate this report. You will never have to manually work with data again.