How to export all products from any Shopify store to CSV or JSON
Updated 2026-11-16 ยท Tool used: Shopify Products Scraper - Variants, Stock & Store Leads on Apify ยท Price: $0.70 per 1,000 products (+$0.50 per 1,000 for optional stock details)
Shopify's admin export only works for your own store. For competitor research, dropshipping catalogs or price monitoring you need the public product data of other stores, including every variant, the compare-at price and availability.
This guide shows how to export the complete catalog of any Shopify store (or just one collection) to CSV or JSON in a single run, and how to schedule it to track price changes.
Open Shopify Products Scraper on Apify โSteps
- Add store domains or collection URLs to
stores(custom domains work, headless stores too). - Choose
outputMode: one row per product or one row per variant (better for spreadsheets). - Download as CSV/Excel, or schedule daily runs to monitor prices and discounts.
Example input
{
"storeName": "Allbirds",
"currency": "USD",
"productId": 7205191974992,
"url": "https://www.allbirds.com/products/mens-dasher-nz-anthracite",
"title": "Men's Dasher NZ - Anthracite (Dark Anthracite Sole)",
"vendor": "Allbirds",
"productType": "Shoes",
"price": 140,
"compareAtPrice": null,
"onSale": false,
"available": true,
"availableVariants": 3,
"variantsCount": 13,
"options": [
{
"name": "Size",
"values": [
"8",
"8.5",
"9"
]
}
],
"featuredImage": "https://cdn.shopify.com/s/files/1/1104/4168/files/...png",
"variants": [
{
"id": 41271176757328,
"title": "8",
"sku": "A12417M080",
"price": 140,
"available": false
}
],
"publishedAt": "2026-08-24T09:53:01-07:00"
}
Example output (one item, shortened)
{
"storeUrl": "https://deathwishcoffee.com",
"storeName": "Death Wish Coffee",
"currency": "USD",
"storeCountry": "US",
"productId": 6756917837879,
"handle": "klean-kanteen-camp-mug",
"url": "https://deathwishcoffee.com/products/klean-kanteen-camp-mug",
"title": "Crossbones Klean Kanteen Mug",
"vendor": "Klean Kanteen",
"productType": "On-The-Go Drinkware",
"tags": [
"Classics",
"Gifting",
"Merch",
"..."
],
"price": 25,
"maxPrice": 25,
"compareAtPrice": null,
"onSale": false,
"discountPercent": null,
"available": true,
"availableVariants": 1,
"variantsCount": 1,
"options": [],
"featuredImage": "https://cdn.shopify.com/s/files/1/0271/7209/products/MetalCore-101.jpg?v=1674569558",
"images": [
"https://cdn.shopify.com/s/files/1/0271/7209/products/MetalCore-101.jpg?v=1674569558",
"https://cdn.shopify.com/s/files/1/0271/7209/products/MetalCore-103.jpg?v=1674569558",
"https://cdn.shopify.com/s/files/1/0271/7209/products/MetalCore-106.jpg?v=1674569558",
"..."
],
"variants": [
{
"id": 40064390660151,
"title": "Default Title",
"sku": "UMKKCM23",
"price": 25,
"compareAtPrice": 0,
"available": true,
"option1": "Default Title",
"option2": null,
"option3": null,
"grams": 300,
"requiresShipping": true,
"imageUrl": null
}
],
"createdAt": "2023-01-03T16:35:36-05:00",
"publishedAt": "2026-09-30T09:47:05-04:00",
"updatedAt": "2026-10-04T07:10:42-04:00",
"descriptionText": "METAL TO THE CORE.\n\nFor when you need to get cracking while you crush your coffee. Serving on-the-go readiness in a shadowy colorway that can withstand even the loudest of living. So turn it up, hit t",
"scrapedAt": "2026-10-04T11:15:49.860Z"
}
Every run's dataset can be downloaded as JSON, CSV, Excel, XML or HTML from the Apify Console, or via https://api.apify.com/v2/datasets/<datasetId>/items?format=csv.
Run it from code
Python
from apify_client import ApifyClient # pip install apify-client
client = ApifyClient("<YOUR_APIFY_TOKEN>")
run_input = {
"storeName": "Allbirds",
"currency": "USD",
"productId": 7205191974992,
"url": "https://www.allbirds.com/products/mens-dasher-nz-anthracite",
"title": "Men's Dasher NZ - Anthracite (Dark Anthracite Sole)",
"vendor": "Allbirds",
"productType": "Shoes",
"price": 140,
"compareAtPrice": null,
"onSale": false,
"available": true,
"availableVariants": 3,
"variantsCount": 13,
"options": [
{
"name": "Size",
"values": [
"8",
"8.5",
"9"
]
}
],
"featuredImage": "https://cdn.shopify.com/s/files/1/1104/4168/files/...png",
"variants": [
{
"id": 41271176757328,
"title": "8",
"sku": "A12417M080",
"price": 140,
"available": false
}
],
"publishedAt": "2026-08-24T09:53:01-07:00"
}
run = client.actor("tinyrex/shopify-products-scraper").call(run_input=run_input)
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
print(item)JavaScript / Node.js
import { ApifyClient } from 'apify-client'; // npm i apify-client
const client = new ApifyClient({ token: process.env.APIFY_TOKEN });
const run = await client.actor('tinyrex/shopify-products-scraper').call({
"storeName": "Allbirds",
"currency": "USD",
"productId": 7205191974992,
"url": "https://www.allbirds.com/products/mens-dasher-nz-anthracite",
"title": "Men's Dasher NZ - Anthracite (Dark Anthracite Sole)",
"vendor": "Allbirds",
"productType": "Shoes",
"price": 140,
"compareAtPrice": null,
"onSale": false,
"available": true,
"availableVariants": 3,
"variantsCount": 13,
"options": [
{
"name": "Size",
"values": [
"8",
"8.5",
"9"
]
}
],
"featuredImage": "https://cdn.shopify.com/s/files/1/1104/4168/files/...png",
"variants": [
{
"id": 41271176757328,
"title": "8",
"sku": "A12417M080",
"price": 140,
"available": false
}
],
"publishedAt": "2026-08-24T09:53:01-07:00"
});
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items);curl (no SDK)
# Runs the actor and returns the results directly (CSV here; use format=json for JSON)
curl -X POST "https://api.apify.com/v2/acts/tinyrex~shopify-products-scraper/run-sync-get-dataset-items?format=csv" \
-H "Authorization: Bearer $APIFY_TOKEN" \
-H "Content-Type: application/json" \
-d '{"storeName": "Allbirds", "currency": "USD", "productId": 7205191974992, "url": "https://www.allbirds.com/products/mens-dasher-nz-anthracite", "title": "Men's Dasher NZ - Anthracite (Dark Anthracite Sole)", "vendor": "Allbirds", "productType": "Shoes", "price": 140, "compareAtPrice": null, "onSale": false, "available": true, "availableVariants": 3, "variantsCount": 13, "options": [{"name": "Size", "values": ["8", "8.5", "9"]}], "featuredImage": "https://cdn.shopify.com/s/files/1/1104/4168/files/...png", "variants": [{"id": 41271176757328, "title": "8", "sku": "A12417M080", "price": 140, "available": false}], "publishedAt": "2026-08-24T09:53:01-07:00"}' > results.csv
Get your API token in Apify Console โ Settings โ API & Integrations. The free Apify plan includes monthly credit that is enough to try this.
Use it from an AI agent (MCP)
The Apify MCP server exposes this actor as a tool for Claude, Cursor, VS Code, n8n and other MCP clients. Add this to your client's MCP config (or use the OAuth flow at mcp.apify.com instead of a token):
{
"mcpServers": {
"apify": {
"url": "https://mcp.apify.com?tools=tinyrex/shopify-products-scraper",
"headers": {
"Authorization": "Bearer <YOUR_APIFY_TOKEN>"
}
}
}
}
Then ask in plain language, e.g. "Export shopify store products to csv for this list and give me a table".
Use cases
- Competitor price monitoring: schedule daily runs and alert on price or compare-at price changes.
- Dropshipping and reseller catalogs: pull a supplier's full catalog with variants, SKUs and images.
- Market research: compare assortment, vendors and price bands across many stores in one run.
- New product tracking: use
publishedWithinDaysto see only what a store launched recently.
No-code: n8n and Make
Ready-to-import n8n and Make example workflows call this actor through the Apify API. Import the JSON, add your Apify token, edit the input and run.
Pricing
Pay per result: $0.70 per 1,000 products (+$0.50 per 1,000 for optional stock details). You can cap the cost of every run in the run options.
FAQ
Does it work on stores with a custom domain or a headless frontend?
Yes. Custom domains work, and for headless stores you can pass the shop's myshopify.com domain if the custom domain does not expose the product feed.
How do I get stock levels?
Turn on includeInventory. It costs an extra $0.50 per 1,000 products and only works where the store publishes inventory quantities.
Can I export products from a Shopify store that isn't mine?
Yes, as long as the products are publicly visible on the storefront. The actor reads the same public product data that the storefront serves to every visitor.
Why not just open /products.json?
It is paginated, limited to 250 items per page, omits some fields and is not available on every store. The actor handles pagination, collections, headless stores and normalization for you.
How do I monitor competitor prices?
Schedule the actor daily and compare price and compareAtPrice across runs; onSale and discountPercent are calculated for you.
Related guides
- How to export products from any WooCommerce store to CSV or JSON
- Bulk tech stack lookup: a Wappalyzer / BuiltWith alternative for thousands of domains
More guides
- Bulk tech stack lookup: a Wappalyzer / BuiltWith alternative for thousands of domains
- How to scrape Greenhouse, Lever and Ashby jobs (plus Personio, Teamtailor, Recruitee)
- How to scrape jobs from Workday career sites (myworkdayjobs.com)
- How to export products from any WooCommerce store to CSV or JSON
- How to export EU public tenders from TED (Tenders Electronic Daily) to CSV or JSON
- How to scrape remote jobs from Himalayas, Remote OK, We Work Remotely and more in one run
- How to export open EU funding calls (Horizon Europe, Digital Europe, cascade funding) to CSV or JSON
- How to turn any RSS or Atom feed into JSON or CSV (bulk, with monitoring)
- How to extract emails, phone numbers and social links from a list of company domains
- How to take bulk website screenshots from a URL list and save them to CSV or Google Drive
- How to export US federal (SAM.gov) and UK (Contracts Finder) tenders to CSV or JSON
- How to look up French companies by SIREN or SIRET and build a B2B list from Sirene
- How to look up Norwegian companies by organisation number and build lead lists from Brreg
- How to download SEC filings (10-K, 10-Q, 8-K, Form 4) by ticker and search EDGAR full text
- How to validate NPI numbers in bulk and build US healthcare provider lists from NPPES
- How to look up hundreds of UK companies on Companies House at once (profile, officers, PSC)
- How to look up Finnish companies by Y-tunnus and build B2B lead lists from the YTJ register
- How to extract all URLs from a website's sitemap (and find broken links)
- How to transcribe hundreds of audio and video files to text and subtitles with Whisper
- How to extract text from hundreds of PDFs, including scanned ones, in one run
- How to clean an email list before a campaign: bulk MX, disposable and typo check
- How to get Dutch public tenders from TenderNed into a spreadsheet, with daily alerts
- How to audit titles, meta descriptions, H1s and canonicals for hundreds of pages at once
- How to find every broken link and redirect on a website, with the pages to fix
- How to validate LEI codes and find the LEI for a list of companies in bulk
- How to run Lighthouse on hundreds of URLs and get Core Web Vitals in one table