How to export products from any WooCommerce store to CSV or JSON
Updated 2026-11-16 · Tool used: WooCommerce Products Scraper - Export Prices, Stock & CSV on Apify · Price: $0.60 per 1,000 products
WooCommerce's built-in exporter and REST API need admin keys, so they only work for your own shop. To analyse a competitor or build a supplier catalog you need the products the store already shows publicly.
This guide shows how to export the complete public catalog of any WooCommerce store, including variations, regular vs sale price and stock status, to CSV or JSON, without API keys.
Open WooCommerce Products Scraper on Apify →Steps
- Add store URLs (homepage, shop page or category URL) to
stores. - Choose
outputMode(products or variations) and optionallyonlyInStock. - Export as CSV/Excel or schedule it for price monitoring.
Example input
{
"storeName": "Mandarin Stone",
"productId": 499641,
"url": "https://www.mandarinstone.com/product/terrazzo-ivory-honed/",
"title": "Terrazzo Ivory Honed",
"type": "variable",
"price": 0.66,
"maxPrice": 13.68,
"currency": "GBP",
"inStock": true,
"categories": [
"All Terrazzo",
"New arrivals"
],
"attributes": [
{
"name": "Size",
"values": [
"200x200x12",
"200x50x12",
"406x406x18"
],
"usedForVariations": true
}
],
"variationsCount": 4,
"variations": [
{
"id": 500195,
"title": "Size: 200x50x12",
"sku": "TCTEIVOSC20X5",
"price": 0.66,
"inStock": true,
"stockText": "4094 in stock"
}
],
"featuredImage": "https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg"
}
Example output (one item, shortened)
{
"storeUrl": "https://www.mandarinstone.com",
"storeName": "Mandarin Stone",
"productId": 499641,
"sku": null,
"slug": "terrazzo-ivory-honed",
"url": "https://www.mandarinstone.com/product/terrazzo-ivory-honed/",
"title": "Terrazzo Ivory Honed",
"type": "variable",
"price": 0,
"maxPrice": 13.68,
"regularPrice": null,
"salePrice": null,
"onSale": false,
"discountPercent": null,
"currency": "GBP",
"currencySymbol": "£",
"inStock": true,
"onBackorder": false,
"stockStatus": "in-stock",
"stockText": null,
"lowStockRemaining": null,
"purchasable": true,
"averageRating": 0,
"reviewCount": 0,
"categories": [
"All Terrazzo",
"New arrivals"
],
"tags": [
"High Traffic",
"Straight Edge Finish"
],
"brands": [],
"attributes": [
{
"name": "Size",
"values": [
"200x200x12",
"200x50x12",
"406x406x18",
"..."
],
"usedForVariations": true
},
{
"name": "Colour",
"values": [
"White"
],
"usedForVariations": false
},
{
"name": "Finish",
"values": [
"Honed"
],
"usedForVariations": false
},
"..."
],
"featuredImage": "https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg",
"images": [
"https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg"
],
"weight": null,
"dimensions": null,
"variationsCount": 4,
"variations": [
{
"id": 499642,
"title": "Size: Sample",
"attributes": [
{
"name": "Size",
"value": "sample"
}
],
"sku": "TCTERIVOSAMP",
"price": 0,
"regularPrice": 0,
"salePrice": null,
"onSale": false,
"inStock": true,
"stockText": null,
"lowStockRemaining": null,
"imageUrl": "https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg",
"url": "https://www.mandarinstone.com/product/terrazzo-ivory-honed/?attribute_pa_size=sample"
},
{
"id": 500195,
"title": "Size: 200x50x12",
"attributes": [
{
"name": "Size",
"value": "200x50x12"
}
],
"sku": "TCTEIVOSC20X5",
"price": 0.66,
"regularPrice": 0.66,
"salePrice": null,
"onSale": false,
"inStock": true,
"stockText": "4094 in stock",
"lowStockRemaining": null,
"imageUrl": "https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg",
"url": "https://www.mandarinstone.com/product/terrazzo-ivory-honed/?attribute_pa_size=200x50x12"
},
{
"id": 500197,
"title": "Size: 200x200x12",
"attributes": [
{
"name": "Size",
"value": "200x200x12"
}
],
"sku": "TCTERIVOSC20X20",
"price": 2.84,
"regularPrice": 2.84,
"salePrice": null,
"onSale": false,
"inStock": true,
"stockText": "1128 in stock",
"lowStockRemaining": null,
"imageUrl": "https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg",
"url": "https://www.mandarinstone.com/product/terrazzo-ivory-honed/?attribute_pa_size=200x200x12"
}
],
"shortDescriptionText": null,
"descriptionText": "Please note: Products such as FILA PRW200 should be applied before grouting to create a barrier against grout penetration.\n\nTerrazzo Honed tile installation is more complex than porcelain, so it’s essential to use an exp...",
"scrapedAt": "2026-10-04T16:24:33.823Z"
}
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": "Mandarin Stone",
"productId": 499641,
"url": "https://www.mandarinstone.com/product/terrazzo-ivory-honed/",
"title": "Terrazzo Ivory Honed",
"type": "variable",
"price": 0.66,
"maxPrice": 13.68,
"currency": "GBP",
"inStock": true,
"categories": [
"All Terrazzo",
"New arrivals"
],
"attributes": [
{
"name": "Size",
"values": [
"200x200x12",
"200x50x12",
"406x406x18"
],
"usedForVariations": true
}
],
"variationsCount": 4,
"variations": [
{
"id": 500195,
"title": "Size: 200x50x12",
"sku": "TCTEIVOSC20X5",
"price": 0.66,
"inStock": true,
"stockText": "4094 in stock"
}
],
"featuredImage": "https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg"
}
run = client.actor("tinyrex/woocommerce-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/woocommerce-products-scraper').call({
"storeName": "Mandarin Stone",
"productId": 499641,
"url": "https://www.mandarinstone.com/product/terrazzo-ivory-honed/",
"title": "Terrazzo Ivory Honed",
"type": "variable",
"price": 0.66,
"maxPrice": 13.68,
"currency": "GBP",
"inStock": true,
"categories": [
"All Terrazzo",
"New arrivals"
],
"attributes": [
{
"name": "Size",
"values": [
"200x200x12",
"200x50x12",
"406x406x18"
],
"usedForVariations": true
}
],
"variationsCount": 4,
"variations": [
{
"id": 500195,
"title": "Size: 200x50x12",
"sku": "TCTEIVOSC20X5",
"price": 0.66,
"inStock": true,
"stockText": "4094 in stock"
}
],
"featuredImage": "https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg"
});
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~woocommerce-products-scraper/run-sync-get-dataset-items?format=csv" \
-H "Authorization: Bearer $APIFY_TOKEN" \
-H "Content-Type: application/json" \
-d '{"storeName": "Mandarin Stone", "productId": 499641, "url": "https://www.mandarinstone.com/product/terrazzo-ivory-honed/", "title": "Terrazzo Ivory Honed", "type": "variable", "price": 0.66, "maxPrice": 13.68, "currency": "GBP", "inStock": true, "categories": ["All Terrazzo", "New arrivals"], "attributes": [{"name": "Size", "values": ["200x200x12", "200x50x12", "406x406x18"], "usedForVariations": true}], "variationsCount": 4, "variations": [{"id": 500195, "title": "Size: 200x50x12", "sku": "TCTEIVOSC20X5", "price": 0.66, "inStock": true, "stockText": "4094 in stock"}], "featuredImage": "https://www.mandarinstone.com/app/uploads/2026/08/Terrazzo-Ivory-Honed-scaled.jpg"}' > 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/woocommerce-products-scraper",
"headers": {
"Authorization": "Bearer <YOUR_APIFY_TOKEN>"
}
}
}
}
Then ask in plain language, e.g. "Export woocommerce products from another store for this list and give me a table".
Pricing
Pay per result: $0.60 per 1,000 products. You can cap the cost of every run in the run options.
FAQ
Can I export products from someone else's WooCommerce store?
Yes, the publicly visible products. The actor reads the store's public storefront data; no admin access is involved.
Does it get variations?
Yes, with attributes, prices, SKUs and stock per variation.
What if the store isn't WooCommerce?
Run the Tech Stack Detector first to check, or use the Shopify Products Scraper for Shopify stores.
Try it on Apify →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 export all products from any Shopify store to CSV or JSON
- How to scrape jobs from Workday career sites (myworkdayjobs.com)
- 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