Shopify product data · New products only · Updated November 2026

Supplier spreadsheet to Shopify CSV: a pre-import QA checklist

A supplier CSV or Excel sheet may contain 100 rows and still be unsuitable for Shopify. Map the data, separate exceptions, and review every source before allowing an import to create products.

This checklist is for ecommerce teams and agencies importing new products. It is educational content, not a live import validation service or a recommendation to overwrite existing store data.

Ten checks before your first product import

Confirm that you are creating new products, not overwriting existing ones. Obtain the store owner's approval and compare proposed URL handles with existing products. Shopify's overwrite-with-matching-handles setting can replace existing values. Leave it off unless that is the expressly agreed operation.
Identify each source column and its meaning. Ask the supplier what SKU, parent product ID, color, size, price, cost and stock fields actually represent. Do not guess a mapping just because column names look similar.
Separate products from variant rows. One product offered in three sizes can require multiple variant rows. Confirm that product handles group the correct variants, and that the available option combinations are unambiguous.
Check uniqueness, missingness and exceptions. Identify blank or duplicate SKUs, repeated product IDs, inconsistent handles, unknown option values and records with incomplete key fields. Hold uncertain records for manual review instead of silently fabricating information.
Check prices and decimals. Determine supplier currency and whether a price is retail price or cost. Shopify's import fields expect the intended price structure; never silently apply an exchange rate or markup without an agreed business rule.
Keep text encoding, quoting and delimiter rules correct. Confirm the supplier file's delimiter, UTF-8 handling, embedded commas, quotes and multiline descriptions. Shopify recommends UTF-8 CSV files; test representative rows before processing the full dataset.
Validate publication status, tax and inventory intent. Decide whether new products should start as drafts; do not assume an unknown supplier stock number can be imported safely. Inventory across locations, product taxes and fulfillment rules need store-side decisions.
Review image URLs separately. Shopify product CSVs use accessible image URLs rather than binary images embedded in the file. Verify image ownership, URLs and intended assignment; a file-only data service cannot promise to source or host images.
Check dependencies before changing existing variant options. Shopify warns that option changes can create new variant IDs and affect third-party integrations. Test any update-to-existing workflow separately, outside a new-products-only service.
Run a small authorized test and preserve a source audit trail. Review output rows, exceptions and source references. Test import in a development store or approved safe workflow first; keep the owner responsible for the final import.

Free local browser check · New tool

Run a basic CSV check before paying

Check a supplier CSV for candidate field-count problems, duplicate SKU values and price-format warnings in your own browser. Nothing is uploaded. This is deliberately a limited first pass, not Shopify import certification.

Open the free local CSV quick check

Fixed-scope file preparation

SupplierPreflight — from $49 per batch

For new products only, prepare a Shopify product-import candidate CSV from one supplier CSV/XLSX sheet and receive an exceptions file, an HTML QA report and cell-level source tracing.

Inspect the full synthetic delivery demo (CSV, exceptions and QA report)

Ten made-up supplier rows demonstrate four converted candidates and six rows held for review. Files, source lineage and QA outputs are inspectable; no customer data or live Shopify import.

Starter: $49 for up to 100 variant rows, 30 source columns and 8 MiB. Up to three product option dimensions. Delivery within three calendar days after agreed input and funded scope; includes one rerun using corrected source data with the same mapping.

It does not perform your store import, scrape supplier sites, update existing products, synchronize inventory, host images, configure metafields or install integrations. Larger defined tiers are available on the purchase listing.

Pay $49 with Stripe — first two Starter pilots Alternatively order on Upwork

Direct checkout is for one human-reviewed new-product file batch only. Payment processor: Mille-owned DK STORE REVIEW Stripe account; service operated by Philip Lind. After payment we confirm the schema and arrange secure transfer. If the source is outside published scope, a full refund or written revised quote is offered. Never send confidential files by email.

Standard (101–500 new-product variant rows): $99. Buy the separate SupplierPreflight Standard on Freelancer — up to 500 rows, 30 columns, 8 MiB, 4 calendar days. Or contact us through the existing Contra Standard listing. Each marketplace handles its own payment, fulfilment and terms. Do not purchase the $49 Stripe Starter for a file above 100 rows.

Ask about fit and scope by email before sharing confidential data. One paid order is not guaranteed by a quote request.

For Shopify agencies and implementation partners

Hand off one messy supplier file, not the client relationship.

If your team handles Shopify builds or catalog launches, SupplierPreflight can support a single defined new-product CSV/XLSX preparation batch before your team performs a controlled import. You keep ownership of the Shopify project and all store access.

Your handoff: one supplier file or worksheet, approximate variant-row count, intended import requirements and known exceptions. Agree a safe transfer method before sending private customer or supplier data.
Our return: an import-candidate CSV, an exception list, HTML QA summary and cell-level source lineage. Blocked/ambiguous items are flagged for your approval rather than silently imported.
Starter scope: $49 for up to 100 source variant rows, 30 columns and 8 MiB; three calendar days after requirements and funding are agreed. One corrected-source rerun within the same scope.
Boundaries: no store credentials, live import, existing-product overwrites, inventory synchronization, recurring SLA or claimed Shopify certification. Larger batches need separate written scoping.

Ask about an agency batch by email

Written collaboration only. Any white-label deliverable or direct commercial terms must be agreed before work begins. You do not need to disclose real customer data just to request a price or ask a question.

Related independent export-review services

Need to review historical purchase orders instead?

Stocky shut down in August 2026. For existing Stocky CSV exports, the read-only archive integrity audit checks row counts, structural issues and missing values, but does not migrate historic POs.

For separate purchase-order, receipt and supplier-invoice CSVs, see the human-reviewed three-way discrepancy pilot, with a complete synthetic output example.

When another tool is a better fit

If you need automatic ongoing inventory sync, API integration, product image hosting or a full migration, use a service specializing in those activities. If you only need general data cleaning rather than Shopify new-product output, the separate CSV/Excel QA service is a more suitable scope.

Expanding into Danish? Our Danish Shopify localization checklist and free single-page language scanner are separate services and do not validate product-import data.

Official Shopify references

Important: This is an independent supplier-file readiness checklist, not an official Shopify verification tool, endorsement or guarantee that any import will succeed. Shopify's format can change; check its latest official documentation before importing.