What Is the Sales & Product Metafields Report?
The Sales & Product Metafields report shows product sales alongside the extra details saved in your Shopify product metafields. Review units sold, gross sales, discounts and net sales next to attributes such as material, fit, season or ingredients.
Use it to compare products that share an attribute and prepare a sales export for buying, merchandising or marketing. The report brings product details and sales into one view, reducing the need to match separate exports by hand. Choose a sales date range and review the relevant metafield before comparing results.
Report Overview
- Report type
- Product & Variants.
- Report period
- Sales within your selected date range.
- Data included
- Product title, product type, product metafield value and four quantity or sales measures.
- Best for
- Comparing product attributes and preparing buying or merchandising reviews.
- Export and automation
- Excel, CSV or PDF; scheduled delivery daily, weekly or monthly, as configured.
What Can You Learn from Product Attributes and Sales?
1. Compare revenue by product attribute
Review net sales alongside one consistent attribute to see which values contribute most to product revenue. Group or summarize the export by metafield value for an attribute-level comparison.
Example: For example, linen products generate more net sales than cotton products during the same month.
What you can do: Use the comparison to decide which materials deserve more collection space.
2. Separate unit demand from sales value
Read Net Quantity and Net Sales together. A product attribute associated with high unit sales may not generate the highest revenue when prices or discounts differ.
Example: For example, travel-size products sell more units, while full-size products generate more net sales.
What you can do: Balance the assortment using both unit demand and revenue.
3. Review discounts alongside sales
Compare discounts and net sales within the same period and product type. This helps you identify attributes worth reviewing for promotion dependence; totals alone do not prove that an attribute needs discounts.
Example: For example, winter styles show substantial discounts during an end-of-season sale.
What you can do: Review the affected products before repeating the promotion.
What Should You Check First in This Report?
Check the data behind the comparison before making assortment decisions.
- Metafield selection and blanks: Use the same attribute across products. Missing values can leave part of the catalog outside your comparison.
- Date range and product type: Keep periods consistent and compare similar categories, especially for seasonal products.
- Net quantity and net sales: Review both measures rather than treating the highest unit count as the highest revenue.
- Discounts and repeated values: Check promotion activity and confirm whether list-type values repeat sales before totaling groups.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Planning the next buying cycle | Compare units and net sales for materials, fits or seasons to guide the next assortment review. |
| Choosing products for a collection | Identify attribute values associated with strong sales and review the products to feature. |
| Reviewing a seasonal promotion | Compare discounts with sales for the relevant season or style. |
| Comparing ingredient or diet labels | Summarize sales for attributes such as fragrance-free or vegan within a relevant product type. |
| Preparing a merchandising export | Share product-level sales and the selected attributes in one file for team review. |
How to Create This Report in Data Export
Start with the Sales & Product Metafields premade report and review its configuration before saving.
- Open Data Export and go to Prebuilt Reports. Find Sales & Product Metafields.
- Open the report and review its product and sales columns. Select the product metafield you want to compare.
- Set the sales date range. Apply supported filters, such as product type, to keep the comparison relevant.
- Generate a preview, check blank or repeated metafield values, and save the report.
- Choose an export format or set daily, weekly or monthly email delivery. Review the recipients and schedule settings before enabling it.
Make the Most of This Report
Use these checks to keep attribute comparisons clear and reusable.
01 / CONSISTENT VALUES
Standardize attribute labels. Values such as “Linen” and “linen blend” should stay distinct unless you intentionally combine them.
02 / COUNTING
Check list-type fields. If sales appear under several values, compare those groups without adding them into a store total.
03 / VISUALS
Build a summary in Excel or Google Sheets. Total net sales by one metafield value, then add a bar chart.
04 / DELIVERY
Schedule a useful view. Share only the product attributes and sales columns the recipient needs for the buying or merchandising review.
Frequently Asked Questions
What is the difference between product type and a product metafield?
Product Type is a standard product field. A product metafield stores an additional detail you define, such as material, fit, origin or ingredient focus.
Can I compare sales by material, fit or season?
Yes, when those details are saved in the selected product metafield and included in the report. Summarize the exported sales by value to compare attribute groups.
Does this report include variant metafields?
The report uses product metafields. If you need variant-level attributes with sales, ask Data Export support about a custom configuration.
Why might sales repeat under more than one metafield value?
A list-type metafield can hold several values for one product. If the report expands those values into separate groups, the same sales may appear in each group; check the output before adding totals.
Can I export and schedule this report?
You can export it as Excel, CSV or PDF and schedule email delivery daily, weekly or monthly. Choose the format and recipients that fit your review.