# Shopify Scraper โ€” Products, Variants & Prices to CSV/Excel (`matrix-crawl/shopify-catalog-scraper`) Actor Shopify scraper that extracts any store's full product catalog โ€” products, variants, prices, stock โ€” into clean CSV/Excel/JSON rows. Automated variant flattening, numeric pricing, currency auto-detection, and deep variant linking. No API key. Built for dropshippers and price analysts. - **URL**: https://apify.com/matrix-crawl/shopify-catalog-scraper.md - **Developed by:** [Matrix Crawl](https://apify.com/matrix-crawl) (community) - **Categories:** E-commerce - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $1.00 / 1,000 results This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## ๐Ÿ›๏ธ Shopify Scraper โ€” Products, Variants & Prices to CSV/Excel **The fastest Shopify product scraper on Apify.** Pull any Shopify store's entire product catalog โ€” every product, every variant, every price โ€” into clean, spreadsheet-ready rows in one run. No API key, no app install, no Shopify login required. `shopify scraper` ยท `shopify product scraper` ยท `shopify price scraper` ยท `ecommerce data extraction` ยท `product catalog export` ยท `shopify inventory scraper` Built for dropshippers, price monitors, and competitive-intelligence teams who need Shopify catalog data that's actually usable โ€” not a wall of nested JSON you have to clean by hand before it touches Excel, Google Sheets, Power BI, or your ERP. --- ### ๐Ÿ‘ฅ Who Is This For? * **Dropshippers & E-commerce Operators:** Quickly extract competitor catalogs, monitor vendor shifts, and bulk-import clean variant data straight into your own store apps. * **Price Analysts & Retail Aggregators:** Track real-time markdowns, historical pricing adjustments, and stock variations across multiple domains concurrently. * **Competitive Intelligence Teams:** Maintain a fully updated, structured database of total active stock profiles without dealing with messy JSON transformations. --- ### โšก Why This Scraper Is Different: The Variant Flattening Engine Most Shopify scrapers hand you the raw API shape: one product object with all its variants trapped in a nested array. A T-shirt in 5 sizes becomes a single row with a sub-table buried inside one cell. Open that in Excel and you get `[object Object]` โ€” useless for sorting by price, filtering in-stock SKUs, or importing anywhere. This actor's **Variant Flattening Engine** explodes that into one clean row per variant โ€” the grain that pricing analysis, inventory tracking, and CSV imports actually need. #### Before (Standard scrapers โ€” nested layout): | title | variants | | :--- | :--- | | Wool Runner | `[{size:"S",price:"95.00",sku:"WR-S"}, {size:"M",price:"95.00",sku:"WR-M"}, ...]` | #### After (This actor โ€” clean flattened columns): | title | variantTitle | sku | price | available | | :--- | :--- | :--- | :--- | :--- | | Wool Runner | S | WR-S | 95.00 | โœ… | | Wool Runner | M | WR-M | 95.00 | โœ… | | Wool Runner | L | WR-L | 95.00 | โŒ | Sort by price. Filter to in-stock. Pivot by vendor. Import straight into anything โ€” zero cleanup. > ๐Ÿ’ก **Prefer the nested shape?** Simply flip the `flattenOutput` toggle to `false` and you will receive one rich row per product with the raw variants array entirely intact. --- ### ๐Ÿ’Ž Premium Features Out-of-the-Box * **Numeric Prices:** `price` and `compareAtPrice` come out as real numbers (not text), so spreadsheets can calculate sums, filters, and compute discount markdowns natively. * **Currency Auto-Detection:** The scraper executes a single pre-flight check to resolve the storefront's native currency code and attaches it to every single data row. * **One-Click Deep Links:** Generates distinct `productUrl` and variant-specific `variantUrl` links (`?variant={id}`) for immediate add-to-cart automation pipelines. * **Discount Detection:** Automatically extracts `compareAtPrice` to flag the retailer's original retail strike-through price. * **Multi-Store Concurrent Routing:** Paste multiple target domains at once; every output row explicitly tags its source hostname so aggregate data sets stay cleanly filterable. * **Wallet Protection Cost Controls:** A hard user-defined `maxItems` cap automatically forces the loop to terminate if a massive catalog risks running away with your platform bill. * **Advanced Anti-Block Hardening:** Deploys Apify Proxies by default, paired with native Crawlee session pools to automatically rotate IPs the second a `403` or `429` block is detected. --- #### ๐Ÿ’ฐ Transparent, Value-Driven Pricing This scraper charges strictly by delivery value at **$1.00 per 1,000 written dataset rows**. Because our Variant Flattening Engine safely outputs one unique row per distinct variant (e.g., separating a T-shirt into individual rows for sizes S, M, and L), your final item count will reflect total variation stock rather than the base product count. * *Example:* A collection containing 100 base products that average 5 variants each will output 500 total clean spreadsheet rows, costing just $0.50! --- ### ๐Ÿš€ How to Use 1. Paste one or more Shopify store root URLs into **Target Storefront URLs** (Any sub-page works; the scraper automatically strips paths back to the clean root domain). 2. Leave **Flatten Output Data Grid** enabled for immediate spreadsheet-ready integration (or toggle off for standard nested JSON extraction). 3. Configure your safe **Maximum Items** cost ceiling threshold and click **Start**. 4. Export your resulting data pool seamlessly as a CSV, Excel, JSON, or HTML grid directly from the platform interface. #### Sample Input Configuration (JSON) ```json { "startUrls": [ { "url": "https://www.allbirds.com" }, { "url": "https://www.gymshark.com" } ], "flattenOutput": true, "maxPagesPerStore": 100, "maxItems": 10000, "debugLog": false, "proxyConfiguration": { "useApifyProxy": true } } ```` *** ### ๐Ÿ“Š Output Data Dictionary Each row in **flattened** mode (`flattenOutput: true`): | Field | Type | Example | |-------|------|---------| | `productId` | number | `1234567890` | | `title` | string | `"Wool Runner"` | | `handle` | string | `"wool-runner"` | | `store` | string | `"www.allbirds.com"` | | `productUrl` | string | `"https://www.allbirds.com/products/wool-runner"` | | `vendor` | string | `"Allbirds"` | | `productType` | string | `"Shoes"` | | `tags` | string\[] | `["mens","wool"]` | | `createdAt` | string (ISO) | `"2023-01-04T12:00:00-05:00"` | | `updatedAt` | string (ISO) | `"2024-06-01T09:30:00-04:00"` | | `publishedAt` | string (ISO) | `"2023-01-05T00:00:00-05:00"` | | `imageUrl` | string | `"https://cdn.shopify.com/.../p.jpg"` | | `currency` | string | null | `"USD"` | | `variantId` | number | null | `987654321` | | `variantTitle` | string | null | `"US 9 / Grey"` | | `sku` | string | null | `"WR-9-GRY"` | | `price` | number | null | `95` | | `compareAtPrice` | number | null | `120` | | `available` | boolean | null | `true` | | `variantImageUrl` | string | null | `"https://cdn.shopify.com/.../v.jpg"` | | `variantUrl` | string | null | `"https://.../products/wool-runner?variant=987654321"` | | `option1` / `option2` / `option3` | string | null | `"US 9"` / `"Grey"` / `null` | | `grams` | number | null | `350` | | `scrapedAt` | string (ISO) | `"2026-06-27T10:00:00.000Z"` | In **nested** mode (`flattenOutput: false`) each row holds the product metadata above plus a raw `variants` array (the full unmodified variant objects) instead of the flattened variant fields. *** ### ๐Ÿ”€ Output Modes At a Glance | | Flattened (default) | Nested | |---|---|---| | Rows | one per **variant** | one per **product** | | Best for | Excel / CSV / BI / price monitoring | programmatic use, full fidelity | | Variant fields | top-level columns | inside `variants[]` | *** ### ๐Ÿ“ Notes & Limits - Only **published** products are returned, with clean camelCase field names. - Prices carry the store's default currency (auto-detected). Multi-currency markets may differ from a specific buyer's locale. - Pagination caps at Shopify's 25,000-item ceiling per store. Larger-catalog and blocked-store fallbacks are on the roadmap. - A product with zero variants still emits one row (with null variant fields) so nothing is silently dropped. ### โš–๏ธ Compliance & Responsible Use This actor reads **publicly available** catalog data. You are responsible for using it lawfully: respect each target site's Terms of Service and `robots.txt`, applicable data-protection and intellectual-property laws, and reasonable request rates. Do not use it to infringe rights or for any unlawful purpose. # Actor input Schema ## `startUrls` (type: `array`): One or more Shopify store URLs. Paste any page of the store (homepage, product, collection) โ€” only the domain is used. Example: https://www.gymshark.com ## `flattenOutput` (type: `boolean`): ON: one dataset row per product variant (Size/Color/SKU) โ€” clean for Excel/CSV/BI. OFF: one nested row per product with the raw variants array. ## `maxPagesPerStore` (type: `integer`): Each page returns up to 250 products. 100 pages = up to 25,000 products per store. ## `maxItems` (type: `integer`): Hard cap on total dataset rows across all stores, to control cost. Set 0 for unlimited. ## `debugLog` (type: `boolean`): Enable DEBUG-level logs to diagnose blocked or empty stores. ## `proxyConfiguration` (type: `object`): Defaults to Apify Proxy (automatic). Recommended to leave on โ€” some stores rate-limit by IP. ## Actor input object example ```json { "startUrls": [ { "url": "https://www.allbirds.com" } ], "flattenOutput": true, "maxPagesPerStore": 100, "maxItems": 10000, "debugLog": false, "proxyConfiguration": { "useApifyProxy": true } } ``` # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "startUrls": [ { "url": "https://www.allbirds.com" } ] }; // Run the Actor and wait for it to finish const run = await client.actor("matrix-crawl/shopify-catalog-scraper").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`๐Ÿ’พ Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // ๐Ÿ“š Want to learn more ๐Ÿ“–? Go to โ†’ https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "startUrls": [{ "url": "https://www.allbirds.com" }] } # Run the Actor and wait for it to finish run = client.actor("matrix-crawl/shopify-catalog-scraper").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("๐Ÿ’พ Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # ๐Ÿ“š Want to learn more ๐Ÿ“–? Go to โ†’ https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "startUrls": [ { "url": "https://www.allbirds.com" } ] }' | apify call matrix-crawl/shopify-catalog-scraper --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=matrix-crawl/shopify-catalog-scraper", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Shopify Scraper โ€” Products, Variants & Prices to CSV/Excel", "description": "Shopify scraper that extracts any store's full product catalog โ€” products, variants, prices, stock โ€” into clean CSV/Excel/JSON rows. Automated variant flattening, numeric pricing, currency auto-detection, and deep variant linking. No API key. Built for dropshippers and price analysts.", "version": "1.0", "x-build-id": "FqUvh2zKwTpn6Cct3" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/matrix-crawl~shopify-catalog-scraper/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-matrix-crawl-shopify-catalog-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/matrix-crawl~shopify-catalog-scraper/runs": { "post": { "operationId": "runs-sync-matrix-crawl-shopify-catalog-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/matrix-crawl~shopify-catalog-scraper/run-sync": { "post": { "operationId": "run-sync-matrix-crawl-shopify-catalog-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "required": [ "startUrls" ], "properties": { "startUrls": { "title": "Target Storefront URLs", "type": "array", "description": "One or more Shopify store URLs. Paste any page of the store (homepage, product, collection) โ€” only the domain is used. Example: https://www.gymshark.com", "items": { "type": "object", "required": [ "url" ], "properties": { "url": { "type": "string", "title": "URL of a web page", "format": "uri" } } } }, "flattenOutput": { "title": "Flatten Output (one row per variant)", "type": "boolean", "description": "ON: one dataset row per product variant (Size/Color/SKU) โ€” clean for Excel/CSV/BI. OFF: one nested row per product with the raw variants array.", "default": true }, "maxPagesPerStore": { "title": "Maximum Pages Per Store", "minimum": 1, "type": "integer", "description": "Each page returns up to 250 products. 100 pages = up to 25,000 products per store.", "default": 100 }, "maxItems": { "title": "Maximum Items (total)", "minimum": 0, "type": "integer", "description": "Hard cap on total dataset rows across all stores, to control cost. Set 0 for unlimited.", "default": 10000 }, "debugLog": { "title": "Verbose debug logging", "type": "boolean", "description": "Enable DEBUG-level logs to diagnose blocked or empty stores.", "default": false }, "proxyConfiguration": { "title": "Proxy configuration", "type": "object", "description": "Defaults to Apify Proxy (automatic). Recommended to leave on โ€” some stores rate-limit by IP.", "default": { "useApifyProxy": true } } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```