Shopify CSV Import Audit

Check a Shopify product CSV before importing it. Paste your CSV and select whether you intend to create or update products. Receive a JSON audit report and a table of findings with row numbers, column names, severity, and explanations.

The tool checks the file you provide. It does not connect to your Shopify store, import products, change records, or rewrite the CSV. It is an independent tool, not affiliated with or endorsed by Shopify.

Input

• csvText: inline CSV text, with comma separators and standard quoted fields. URLs are not accepted as an input source.
• mode: create for new products or update for an intended update.
• Limits: 10 MiB of UTF-8 text and 50,000 data records, excluding the header. A quoted multiline cell remains part of a single record.

Example (deliberately reuses SKU 00123 across two different products):

{
  "csvText": "Title,URL handle,SKU,Price\nExample shirt,example-shirt,00123,19.95\nExample cap,example-cap,00123,12.95\n",
  "mode": "create"
}

Expect one SKU_REUSED warning on CSV row 3. This asks you to review the reuse; it does not mean Shopify universally forbids it. An excerpt of the expected report is:

{
  "summary": { "status": "review", "analysisComplete": true, "dataRows": 2, "warnings": 1 },
  "issues": [{ "row": 3, "column": "SKU", "code": "SKU_REUSED", "severity": "warning" }]
}

A successful audit with no findings has an empty default dataset. Read the canonical REPORT in the run's key-value store for the complete summary, supported checks, and limitations.

Checks and results

The audit checks supported current and legacy header names, required fields, explicit variant options, duplicate rows, conflicting identifiers, selected price/inventory/boolean/status formats, and conditional update risks. It also reports malformed CSV and inconsistent column counts. Every report includes the exact supported checks and limitations. Findings currently use French explanations; their stable codes support automated processing.

Read REPORT in the run's key-value store for the canonical JSON report. Open the default dataset for a table of retained findings, exportable as JSON, CSV, or Excel. A report can be complete while identifying errors that need correction. A clean report is not a guarantee of a successful Shopify import.

The report retains at most 1,000 findings. Check summary.truncated, the total counts, and the retained count. Findings identify logical CSV records and source text lines. Spreadsheet exports prepend an apostrophe to text beginning with a formula marker, including after whitespace; spreadsheetEscapedFields identifies changed export fields. The canonical JSON report retains the original finding text.

Pricing

USD 0.50 for one completed audit report, regardless of how many findings it contains. A completed audit with business-rule errors is still a completed report. Rejected input, an unparseable CSV, a size/record-limit failure, or a failure to persist the results does not trigger the completed-audit event. No charge is applied per finding or per CSV row. Check the Store pricing panel before starting the run.

Limitations and data handling

This is a partial pre-import audit based on documented CSV rules. It cannot compare against your existing products, verify store-specific settings, determine whether an image is accessible, or validate rights to use content. It makes no requests to URLs contained in the CSV. Review the report and test your import on a small sample before applying broad changes.

CSV values are kept as strings during analysis; leading zeros are not converted to numbers. The original CSV is excluded from the output report but remains in the run input stored by Apify. Submit product data you are authorized to process; do not include customer, payment, or credential data. Data retention and access follow your Apify run/storage settings.

Rules reference: Shopify product CSV documentation.