Shopify & WooCommerce Product CSV Validator and Auto-Fixer
Pricing
$590.00 / 1,000 product file validated (per 10,000 rows)s
Pre-flight check for Shopify and WooCommerce product import CSV/XLSX files. Replays ~40 importer rules (Default Title trap, variation linking, duplicate SKUs, prices, image links, Excel mangling, mojibake), auto-fixes safe issues with a change log and splits importer-safe chunks.
You can access the Shopify & WooCommerce Product CSV Validator and Auto-Fixer programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.
{ "openapi": "3.0.1", "info": { "version": "0.1", "x-build-id": "y3JXRdC8drDPvb9cj" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/naricky~product-csv-import-validator/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-naricky-product-csv-import-validator", "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/naricky~product-csv-import-validator/runs": { "post": { "operationId": "runs-sync-naricky-product-csv-import-validator", "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/naricky~product-csv-import-validator/run-sync": { "post": { "operationId": "run-sync-naricky-product-csv-import-validator", "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", "properties": { "files": { "title": "Product files (URLs)", "type": "array", "description": "Links to your product import files (CSV, TSV or XLSX). Google Drive, Dropbox and Google Sheets share links are converted to direct downloads automatically; the file must be readable by anyone with the link.", "items": { "type": "object", "required": [ "url" ], "properties": { "url": { "type": "string", "title": "URL of a web page", "format": "uri" } } } }, "csvContent": { "title": "Or paste CSV content", "type": "string", "description": "Paste a product CSV here instead of (or in addition to) URLs. The prefilled sample is a broken Shopify file showing the traps this tool catches; it is ignored when you also provide file URLs." }, "fileName": { "title": "Name for pasted content", "type": "string", "description": "File name used in the report and for the fixed-file keys when you paste CSV content.", "default": "pasted-products.csv" }, "platform": { "title": "Target platform", "enum": [ "auto", "shopify", "woocommerce" ], "type": "string", "description": "Which importer's rules to replay. Auto-detect reads the header row.", "default": "auto" }, "mode": { "title": "Mode", "enum": [ "validate_and_fix", "validate" ], "type": "string", "description": "Auto-fix only applies safe, deterministic repairs and logs every changed cell. Findings that need a human are reported, never guessed.", "default": "validate_and_fix" }, "decimalComma": { "title": "Decimal comma", "enum": [ "auto", "yes", "no" ], "type": "string", "description": "How to read numbers such as 12,50 or 1,234 in price, weight and stock columns.", "default": "auto" }, "includeWarnings": { "title": "Include warnings", "type": "boolean", "description": "Also list warnings (data-quality issues the importer accepts). Errors are always listed. Warning fixes are still applied and logged.", "default": true }, "ignoreRules": { "title": "Ignore rules", "type": "array", "description": "Rule IDs to skip, e.g. shopify.sku.duplicate or barcode.check_digit. Ignored rules are neither reported nor fixed.", "items": { "type": "string" } }, "splitChunks": { "title": "Split into importer-safe chunks", "type": "boolean", "description": "Also write FIXED_part_01..N.csv files. A Shopify product (all rows of a handle) or a WooCommerce variable product with its variations is never split across files.", "default": false }, "chunkMaxRows": { "title": "Max rows per chunk", "minimum": 0, "type": "integer", "description": "Row cap per chunk. 0 = no row cap for Shopify (size cap only) and 5,000 rows for WooCommerce.", "default": 0 }, "chunkMaxMb": { "title": "Max MB per chunk", "minimum": 1, "maximum": 50, "type": "integer", "description": "Size cap per chunk in MB. Shopify rejects product CSVs over 15 MB.", "default": 14 }, "delimiter": { "title": "Delimiter override", "type": "string", "description": "Leave empty to detect (comma, semicolon, tab or pipe). Use \\t or tab for tab-separated files." }, "sheetName": { "title": "XLSX sheet name", "type": "string", "description": "Worksheet to read from XLSX files. Leave empty for the first sheet." } } }, "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 }, "PROXY_UNBLOCKER_UNITS": { "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 }, "PROXY_UNBLOCKER_UNITS": { "type": "integer", "example": 0 } } } } } } } } }}OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.
OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.
By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.
You can download the OpenAPI definitions for Shopify & WooCommerce Product CSV Validator and Auto-Fixer from the options below:
If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.
You can also check out our other API clients: