Supplier CSV & Shopify Import Checker

Review a product CSV before using it. Compare supplier prices, stock and SKUs, or switch to Shopify mode to spot blank overwrites, missing variant dependencies and option changes that may recreate variant IDs. Get an HTML review, spreadsheet-safe CSV findings and structured JSON from one comparison.

Watch/download the 32-second synthetic portfolio demo. A quick walkthrough of all four tools using synthetic sample data.

Try the Shopify CSV blank-overwrite and variant-change example. Displayed Actor pricing applies when you run it.

Try a supplier comparison

1. Keep Supplier CSV comparison selected. The prefilled input is a small synthetic example.
2. Start one comparison, then open Review report in Output.
3. For your own comparison, replace both examples with your previous and new CSVs, or clear the text and upload two files.

Standard columns are sku, price, currency, with optional stock and unit. The Wholesale preset maps Item Code, Wholesale Price, Currency, Available and Pack. Explicit old/new mappings override the preset. Headers and SKUs are case-sensitive; surrounding whitespace is trimmed in supplier mode. Repeated SKUs are reported and excluded from pairwise checks.

{
  "mode": "supplier",
  "oldCsv": "sku,price,currency,stock\nMUG,10,USD,12\n",
  "newCsv": "sku,price,currency,stock\nMUG,15,USD,0\n",
  "priceChangePercent": 20
}

This example produces two warnings: a 50% price rise and stock dropping to zero. The generic checks also identify added/absent SKUs, currency/unit changes, duplicates and invalid values. Extra supplier fields are included when counting changed matches but do not each generate a finding.

Check a Shopify import

Choose Shopify product CSV import risks. Supply a current product export from the same store as the previous CSV and your proposed import as the new CSV. Set will you overwrite matching handles? to match your intended Shopify import choice. Clear supplier mappings. No store connection is required.

The native preset recognizes current headers such as URL handle, SKU, Price and Option1 value, plus legacy names including Handle, Variant SKU, Variant Price and Option1 Value. Both files need a handle and Title header. Mixing aliases for the same field is rejected. Unknown columns are listed for separate review.

Shopify matches products by handle. With overwrite enabled, included blank fields can clear existing values; omitted optional columns generally preserve them. Variant fields depend on option columns, and option-value edits can recreate variant IDs. The checker distinguishes those situations and warns about default/reset behavior separately. Omitting a product from an import does not delete it. These rules are based on Shopify's import guidance.

Product metadata is compared on each handle's first row. Blank metadata on subsequent variant/image rows is normal. Extra image-only rows do not become variants. Variant comparisons use handle plus option values; a unique SKU within the same handle supplies additional evidence of an option edit. Reordered variants are not paired by row position. Ambiguous option combinations or product grouping are excluded and reported. See Shopify's CSV structure.

Synthetic Shopify example — cleared vendor and renamed color:

{
  "mode": "shopify",
  "shopifyOverwriteExisting": true,
  "oldCsv": "Handle,Title,Vendor,Option1 Name,Option1 Value,Variant SKU,Variant Price\ntrail-mug,Trail Mug,Northwind Goods,Color,Blue,MUG-BLUE,12.50\n",
  "newCsv": "Handle,Title,Vendor,Option1 Name,Option1 Value,Variant SKU,Variant Price\ntrail-mug,Trail Mug,,Color,Azure,MUG-BLUE,12.50\n"
}

Expected findings: SHOPIFY_BLANK_OVERWRITE_RISK, SHOPIFY_VARIANT_SET_CHANGED and SHOPIFY_VARIANT_RECREATION_RISK. These are review warnings, not proof of the final store outcome. A fuller fixture in the source package includes a second variant and an additional image row.

Uploads and limits

For each side, provide exactly one source: pasted oldCsv / newCsv text or an oldFileUrl / newFileUrl upload. Clear the prefilled text when uploading. Uploads must use HTTPS Apify key-value-store record URLs at api.apify.com/v2/key-value-stores/{id}/records/{key}. For private uploads, select their stores in sourceStores to grant read access. Signed upload links do not need this selection. External file hosts and token-bearing URLs are unsupported. Process only files you are entitled to use.

Each CSV is limited to 2,000,000 characters and 10,000 nonempty rows. Uploads additionally have a 2,000,000-byte UTF-8 limit. Supplier mode allows 40 columns; Shopify allows 200, including image rows within the row limit. Comma delimiters, quoted cells, CRLF and a UTF-8 BOM are supported.

Supplier prices allow 1–12 digits and up to 6 decimal places, without symbols, thousands separators or exponents. Currency is checked for three-uppercase-letter syntax only; stock must be a nonnegative integer. Shopify permits negative inventory quantities and compares prices assuming the same store currency. Price threshold range: 0–1000%; zero-to-positive prices always trigger review.

Read and automate the result

• Review report: report.html, readable findings and suggested actions.
• JSON report: REPORT, summary, findings and recognized columns; Shopify adds matching context.
• CSV findings: findings.csv, a summary row and the returned findings. Formula-like cells receive a leading apostrophe; JSON preserves parsed values.
• Summary: exactly one dataset item per completed comparison, with mode, status, severity/code counts and report record keys.

Counts include all detected findings; at most 500 details are returned. Always check findingsTruncated. In Shopify mode, checks_passed allows informational findings; warnings or errors produce review_required. In supplier mode any finding produces review_required. Neither status certifies an import. Shopify's addedProducts means handles not in the supplied baseline, removedProducts is always zero, and handlesNotInImport counts omitted handles. report_schema.json and dataset_schema.json document the output contracts in the source package.

A recurring workflow can retain the last accepted export, supply each proposed replacement, and route review_required or truncated results to review. Read the dataset summary first, then retrieve REPORT from that run's default key-value store for details. Keep the old baseline until the new file is accepted. An empty finding list does not authorize an import. The Actor does not remember prior files, schedule checks, send messages or import data.

Scope and pricing

This is a bounded review tool, not Shopify's import engine or a full platform validator. It does not check a live store, image reachability, market-specific prices, metafield definitions, all required/default rules or every field dependency. A stale or partial baseline limits coverage. Missing/blank option identity limits variant comparison. Product-only changes can leave variant checks unavailable. Review the official import preview and your backup process separately.

USD 0.50 per completed comparison, plus 0.00005 per start at the configured memory allocation. Platform usage is included. One completed comparison writes one summary dataset item and charges once, whether it finds problems or not. HTML, CSV and JSON are included; there is no separate per-product or per-finding charge. A started run can incur the start fee even if invalid input prevents a completed report.

At these settings, set the spending limit to at least USD 0.50005; USD 0.51 covers one completed comparison. The Store may display USD 500 per 1,000 comparisons. Check the live price before running. Both supplier and Shopify modes use the same price.

Inputs and reports follow your Apify storage access and retention settings. For support, provide a small anonymized reproduction and finding code, without credentials or confidential product files. This Actor is independently developed and is not affiliated with Shopify.