Check a product CSV before import
csv_import_preflightBest for: "will this Shopify CSV import?" or "what is wrong with my product file?". Checks the Shopify import rules: columns, handles, options, duplicate variants, statuses, value types (price, weight, quantity, true/false), image URLs, GTIN check digits and barcodes a spreadsheet mangled. Returns: blocking findings (Shopify rejects them or imports them wrong) and warnings, up to 200 each, each with row, handle, rule, fix and doc (the rule's source page), plus totals. Input tips: send csv, the full file text from Shopify admin (Products > Export), header row first, up to 2 MB; a larger file is refused with csv_too_large, split it by rows. Not for: Merchant Center title and description rules or a store address (use merchant_feed_check), or listing text (use listing_text_audit).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"csv": "<csv>"
},
"name": "csv_import_preflight"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | Yes | The full text of a Shopify product CSV, header row first, such as "Title,URL handle,Description,Vendor,Price,...". Paste the file exported from Shopify admin (Products > Export) as it is. At most 2 MB; split a larger file by rows and repeat the header in each part. Example call: {"csv": "Title,URL handle,Price\nWool Beanie,wool-beanie,24.00"} |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | Data rows in the file, header not counted | |
| totals | Yes | Counts before the lists were cut to 200 | |
| blocking | Yes | Problems Shopify rejects or that make the import wrong, at most 200 | |
| products | Yes | Products found, one per URL handle | |
| warnings | Yes | Problems that import but probably not as intended, at most 200 | |
| truncated | Yes | True when either list had more than 200 findings |