A single Shopify product can have dozens of variants — sizes, colors, materials, bundles. The Variant Explorer expands every product into one row per variant, with its price, options, SKU, and live stock status, so you can analyze a catalog at the variant level instead of the product level.
What the Variant Explorer gives you
- One row per variant across the whole catalog
- Option values (size / color / etc.)
- Price and compare-at price
- Live in-stock / sold-out status
- Exportable variant table
How it works
The tool reads the store’s public /products.json endpoint — the same feed Shopify themes use to render products. It paginates through the catalog (up to about 5,000 products) and assembles the full list. No login, API key, or admin access is involved; only data the storefront already publishes is read.
How to use it, step by step
- Open the Variant Explorer and paste the Shopify store URL (for example, allbirds.com).
- Click “Explore Variants”. The tool reads the store’s public data — no login, password, or API key is involved.
- Review the result on screen, then download it as CSV, JSON, or Excel, or copy it to your clipboard.
What you can use it for
- Size/color assortment analysis
- Understanding how a store structures options
- Finding which variants sell out
- Detailed competitor catalog audits
Things to keep in mind
Everything here comes from public data, so a few caveats apply. Password-protected and headless stores may not expose every endpoint, and a merchant can choose to disable the public JSON feeds. Very large catalogs are capped at around 5,000 items. And remember: public storefront data never includes private figures such as exact inventory counts or actual sales — any tool claiming to reveal those is estimating, not reporting fact.