What Is the All Product Report?
The All Product report gives you a single view of the products and variants in your Shopify store. It brings together product names, SKUs, status, vendors, categories, barcodes, prices, product costs, and inventory quantities so you can review your catalog without checking products individually.
Each variant can appear as its own row. That means a T-shirt offered in three sizes can be reviewed by size, with its own SKU, barcode, price, and inventory quantity. You can also include descriptions, tags, collections, and product options to organize the export for your team.
Use this as a catalog review and cleanup report, not a product sales ranking. The supplied fields describe products and stock; they do not, on their own, show units sold, sales revenue, or bestsellers.
Report Overview
- Report type
- Product & Variant Reports.
- Reporting basis
- Shopify product and variant records; not a sales-by-date report.
- Data included
- Product details, variant identifiers, status, categorization, price, product cost, and inventory quantity.
- Best for
- Catalog audits, SKU cleanup, inventory checks, product updates, and team exports.
- Export and delivery
- Download in supported formats or schedule delivery through Data Export's available destinations.
What Can You Learn from Your Shopify Product Catalog?
1. Find Missing SKUs and Variant Identifiers
Compare Product Title, Variant Title, SKU, and Barcode to identify variants with incomplete identifiers. Clear identifiers make product records easier to match during inventory and operational reviews.
Example: A shirt has separate blue and black variants, but the black variant has no SKU.
What you can do: Fill in missing identifiers and review inconsistent naming before sending the catalog to other teams.
2. Review Product Status and Visibility
Use Product Status and Visible to distinguish products that need attention before merchandising changes. An archived product can still appear in a catalog export, depending on the filters applied.
Example: An older gift-card variant appears as archived while another gift card remains active.
What you can do: Filter by status to review outdated listings and check visibility settings in Shopify before making changes.
3. Identify Variants That Need a Stock Check
Review Inventory Quantity alongside Product Title, Variant Title, SKU, and Vendor. This helps you locate variants with low or zero recorded quantities without confusing them with other versions of the same product.
Example: One size of a jacket shows zero inventory while the other sizes have stock.
What you can do: Verify stock and inventory tracking settings, then decide whether that particular variant needs replenishment.
4. Check Pricing and Cost Data for Gaps
Compare Price and Product Cost to find missing cost entries or values that warrant review. The difference between these two fields is not net profit because discounts, shipping, fees, and other expenses are not included.
Example: A product is priced at $25, but its recorded product cost is $30.
What you can do: Confirm that both amounts are accurate before reviewing pricing or correcting the cost record.
What Should You Check First in This Report?
Start with the columns that reveal common catalog maintenance issues:
- SKU and Barcode: Look for empty, duplicate, or inconsistent identifiers across variants.
- Product Status and Visible: Review active and archived records and check whether visibility needs attention.
- Inventory Quantity: Find variants with quantities that should be verified, especially zero or unexpectedly low values.
- Price and Product Cost: Look for missing amounts or cost values that exceed selling prices.
Product Category, Product Type, Vendor, Tags, and Collections provide useful follow-up checks when catalog organization is the priority.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a catalog cleanup or seasonal refresh | Review the full catalog before a product cleanup or seasonal refresh. |
| Checking variant stock and SKU identifiers | Locate variants that need stock checks and validate SKU identifiers. |
| Reviewing product types and catalog groupings | Review product types, categories, tags, and collections. |
| Sharing a product-and-variant reference list | Share a consistent product-and-variant list with colleagues. |
| Checking recorded costs and vendor details | Review recorded product costs and vendor details for follow-up. |
For example, before a seasonal catalog update, an operations team can filter by Product Status and Vendor, then export only the fields needed for its review.
How to Create This Report in Data Export
Data Export includes an All Product premade report under Product & Variant Reports, so you can start with a prepared layout instead of building every column manually.
- Open Data Export and select the All Product premade report.
- Review the existing columns, including Product Title, Variant Title, SKU, Product Status, Vendor, Product Category, Product Type, and Barcode.
- Select Add Column to include fields such as Price, Product Cost, or Inventory Quantity. Use Manage Columns, Filter, and Sort to refine the view.
- Click Save to keep the report setup, then use Export when you need a file.
- Select Schedule if you want recurring delivery using a supported schedule and destination.
If you use the date selector shown in the interface, verify which product-related date field or filtering rule it applies to. A date displayed in the toolbar does not make this catalog report a product sales report.
Make the Most of This Report
Use these quick checks to keep your catalog export accurate and easy to share.
01 / VARIANTS
Count variants, not just product titles. A product with several sizes or colors may occupy several rows.
02 / EMPTY FIELDS
Review blanks carefully. An empty SKU, barcode, or product cost may mean the value was never entered; it is not automatically zero.
03 / FILTERS
Make the review specific. Filter by Product Status, Vendor, or Category to tackle one catalog issue at a time.
04 / SHARING
Export a focused view. Remove unnecessary columns before sharing your product list with another team.
Frequently Asked Questions
Can I export all Shopify products and variants into one file?
Yes. The All Product report brings product and variant information together, and Data Export lets you export the configured report in a supported format. Apply or remove filters according to which records you need.
Why does the same product appear on several rows?
One product can have multiple variants. For example, a shoe sold in four sizes may appear four times so each size can have its own SKU, price, barcode, and inventory quantity.
Does this report include archived Shopify products?
The example report includes both active and archived product records. Use Product Status filters if you want to review only selected statuses.
Can this report tell me which products sell the most?
Not from the listed fields alone. This is a product catalog report; a best-selling products analysis needs sales or order data, such as units sold or revenue, from an appropriate sales report.
Can I schedule the All Product report for automatic delivery?
Yes. After saving the report, select Schedule and choose an available schedule and delivery destination in Data Export. Check the report configuration before sharing recurring files.
