Shopify CSV Tools API
Validate, de-duplicate, and variant-check Shopify product CSV files programmatically — a simple JSON API for agencies and developers scripting store migrations. The same engine behind our free browser tools.
Get the API on RapidAPI → — free tier available.
Endpoints
POST /validate— checks a product CSV against Shopify's import rules and returns every issue with its row number.POST /dedupe— removes duplicate rows and SKUs, regroups split product blocks, and returns a cleaned CSV plus a removed count.POST /variants— flags variant-structure problems: duplicate option combinations, option-name mismatches, and products over the 100-variant limit.
Example
Send raw CSV text, get structured JSON back. Request body:
{ "csv": "Handle,Title\nmug,\n" }
Response:
{
"issues": [
{ "code": "MISSING_TITLE", "severity": "error", "row": 2, "column": "Title",
"message": "The first row for handle \"mug\" has no Title. The first row of each product must include the Title." }
]
}
RapidAPI gives you ready-to-paste code snippets (curl, JavaScript, Python, and more) with your key on the listing page.
Who it's for
- Agencies and freelancers running bulk Shopify migrations.
- Pre-import validation gates in data pipelines.
- Automated CSV clean-up before importing to Shopify.
Your data is processed in-request and never stored. The API is the same validation engine that powers the free Merchant CSV Tools.