How to export any Shopify store's products to CSV
A step-by-step guide to pulling a Shopify catalogue into Excel or Google Sheets, including collection-only exports and keeping SKUs intact.
5 min read
Shopify's products.json feed, explained
What the public /products.json endpoint returns, how pagination and collections work, what it leaves out, and why some stores refuse it.
6 min read
Every column in a Shopify catalogue export, explained
A field-by-field reference for the CSV and JSON exports: SKUs, variant IDs, prices, compare-at prices, discounts, availability, dates and their quirks.
6 min read
Shopify variants, SKUs and options: why your export has so many rows
How Shopify structures products into options and variants, why exports are one row per variant, and how to roll them back up to products in a spreadsheet.
6 min read
Competitor price monitoring for Shopify stores, with just a spreadsheet
A repeatable workflow for tracking competitor prices, discounts, launches and sell-outs from public Shopify catalogues using weekly CSV snapshots.
7 min read
A 10-point checklist for auditing your Shopify catalogue
Find missing and duplicate SKUs, zero prices, broken compare-at prices, image-less listings and stale sold-out products using a single catalogue export.
6 min read
How to tell if a store uses Shopify
Five quick checks, from products.json to page source and checkout URLs, that reveal whether an online store is built on Shopify.
4 min read
Using public catalogue data responsibly
Practical principles for working with scraped Shopify catalogue data: facts versus creative content, good and bad uses, request frequency and personal data.
5 min read