Free previewCheck your first catalog CSV ↗

Documentation

Check a catalog, step by step.

Review the files and the matching rules before preparing a Shopify import.

Input files

Choose the current supplier CSV and a full Shopify product export. Add a prior supplier CSV with the same mapped headers to compare deliveries. Use UTF-8 comma-separated files with unique headers, up to 1 MiB, 500 data rows, and 256 columns each.

Map title, handle, SKU, and intended selling price. Vendor and up to three option pairs are optional. The tool keeps source currency and units as supplied. It does not convert currencies, turn wholesale prices into selling prices, or infer option values.

Matching rules

Shopify overwrites by handle. CatalogPreflight also requires a unique, exact SKU on that handle before preparing a price update. The entire affected product is held if an ambiguous row could change it. Missing prior SKUs generate a report entry without deleting products.

Shopify can clear values when an optional column is present with an empty cell. Omitting the column usually leaves the existing value alone. Changes to option values can recreate variant IDs. CatalogPreflight holds variant changes, linked options, title changes, and vendor edits for manual review. Updates carry the export's existing product status and sibling variant data.

See Shopify’s product CSV rules.

Download and review in Shopify

  1. Download the report and resolve any held rows at the source.
  2. Confirm the preview and price assumptions. Download draft and price update files separately when available.
  3. Import drafts with matching-handle overwrite off. For price updates, use a fresh full export and compare Shopify’s import preview before enabling overwrite. Validate against a development store first.

The report escapes formula-like cells for spreadsheets. Open Shopify import files directly with Shopify. Avoid resaving them in spreadsheet software, which can change SKUs, prices, or quoting.

Browser files stay in the page’s memory until you clear, replace, or leave it. Downloads go to your device. The site has no CSV upload endpoint. Its local preview server logs no row contents.

Agent contract

Call preview_catalog_csv with CSV text in supplier, shopify, and optionally prior. Use mapping to pass the same JSON saved by the browser. The response includes counts, source line numbers, mapped fields, and a report. Shopify files require confirmed and currencyConfirmed after user review.

Connect an Agent