See every product and price in a Shopify store
Paste a store's address. You get its full product list, with variants, prices, sale prices and stock status, as a CSV you can open in Excel or Google Sheets. It runs in your browser, so nothing is sent to me.
| Product | Variant | Price | Compare-at | In stock | Type |
|---|
What's in the CSV
One row per variant, so a T-shirt in four sizes is four rows. For each one you get:
- Product title, variant, SKU, vendor, product type and tags
- Price and compare-at price. When the compare-at price is higher than the price, the variant is marked as on sale and the discount is worked out for you.
- In stock. Whether that variant can be bought right now. Stores don't publish how many units they have, only whether it's available.
- Product and image links, weight, and the dates it was published and created
- Currency. This is the store's main currency. Shoppers in other countries may see converted prices.
You also get a summary for each store: product and variant counts, price range, median price, how much is on sale or in stock, top product types and vendors, and the newest product.
How it works
Every Shopify store with an online store publishes its product catalogue at /products.json. That's the public list of products it sells, the same information you'd see by browsing the site. This tool reads that list 250 products at a time, pausing between pages so it doesn't hammer the store, and turns it into a spreadsheet.
It only sees products that are published to the store's online shop. Drafts, archived products and anything hidden from the online store won't appear. A few stores switch the list off; for those you'll see a message saying so.
What people use it for
- Competitor pricing. Compare a rival's prices and discounts with yours, and run it again in a month to see what changed.
- Supplier and wholesale catalogues. Pull a brand's full range into a sheet instead of copying it by hand.
- Checking your own store. Find missing SKUs, products with no type, or compare-at prices left on from an old sale. The Shopify store audit runs those checks for you and scores the catalogue. Either way, it's the quickest way to see your catalogue the way the internet does. If it's messy, start with your collection pages, because that's where most of your traffic should land.
- Before a migration or a Google Shopping feed. A clean product list makes both easier. Here's why Google Shopping takes more than uploading products.
Use it fairly
The tool only reads information the store already makes public, and it reads it slowly. Product descriptions and photos still belong to the store, so use the data for research and pricing. Don't copy someone else's content into your own shop. For reviews, the review analyzer works from your own review app's export, so there's nothing to scrape.
Want this done for you?
If you want ongoing price tracking, a clean product feed, or help with the parts of your Shopify store that matter most, message me. For the money side of your store, the free e-commerce profit tracker shows what you really make on each order.