SHOPIFY CSV TROUBLESHOOTING

Start with the symptom you can see.

A failed import, a missing variant, a blank image, unchanged inventory, ignored product update, missing tag, missing metafield, absent export column, or missing collection assignment can all involve a CSV—but they need different repair paths. Order metafields require a separate export workflow. Choose the closest result below.

11 focused guides 87 practical checks 0 catalog uploads

CHOOSE A REPAIR PATH

What happened after the import?

01 The import failed or reported mixed errors

Start with the complete CSV error checklist

Use this first when Shopify rejects the file, names a row-level error, or several product fields fail together.

  • Headers, quoting, and encoding
  • Titles, handles, prices, and status
  • Images, categories, and references
Open the 12-error guide 02 The product exists, but variants are missing

Trace the product group and option combinations

Use this when the base product imports but some sizes, colors, or other option combinations do not.

  • Repeated handles and group boundaries
  • Option names, values, and duplicates
  • Variant prices, SKUs, and overwrite safety
Open the variant guide 03 The product exists, but images are missing

Check whether Shopify can reach each image

Use this when product or variant rows import but remote images fail, remain blank, or attach incorrectly.

  • Public URLs and private hosts
  • Product and variant image columns
  • Image positions and remote fetch limits
Open the image guide 04 The product exists, but stock did not change

Separate catalog fields from location inventory

Use this when quantities stay unchanged or update the wrong variant, location, or operational setup.

  • Product CSV versus inventory CSV
  • Tracker, quantity, policy, and service
  • SKU, location, and overwrite context
Open the inventory guide 05 The import finished, but product details stayed the same

Verify the product match and overwrite behavior

Use this when Shopify completes the import but titles, prices, statuses, or other existing product fields do not change as expected.

  • Matching handles and overwrite selection
  • Blank columns versus omitted columns
  • Variant dependencies and identity changes
Open the product update guide 06 The import finished, but the selling price stayed the same

Update the exact variant price—and check what customers actually see

Use this when the CSV import completes but one or more product prices remain unchanged, update the wrong variant, or look different on the storefront.

  • Variant Price values and numeric formatting
  • Matching handles, options, and overwrite behavior
  • Compare-at prices, markets, catalogs, and apps
Open the price update guide 07 The product imported, but a custom field stayed blank

Match the product metafield definition to the exact CSV column

Use this when a product metafield is ignored, rejected, cleared unexpectedly, or does not match the value you expected after a CSV import.

  • Definitions, namespaces, keys, and exported headers
  • Product versus variant metafield workflows
  • Typed values, references, blanks, and overwrite safety
Open the metafield guide 08 The product imported, but did not join a collection

Use Shopify’s Collection column without breaking the product CSV

Use this when an imported product is absent from the intended collection, creates an unexpected collection, or conflicts with a condition-based collection rule.

  • Exact Collection header and supported CSV shape
  • One collection per product and new-name behavior
  • Conditions, matching handles, and overwrite preview
Open the collection guide 09 The product export is missing metafield columns

Export the correct product metafield definitions and values

Use this when a Shopify product CSV export contains no metafield columns, omits an expected field, or needs to be prepared for a safe re-import.

  • Product definitions, resource owners, and store scope
  • Namespace and key header formats
  • Variant limits, typed values, and re-import safety
Open the metafield export guide 10 The import finished, but product tags stayed the same

Keep comma-separated tags inside the correct product group

Use this when tags disappear, remain unchanged, split into the wrong values, or unexpectedly affect automated collections.

  • Exact Tags header and matching product handles
  • CSV commas, quoting, and row grouping
  • Overwrite previews and automated collections
Open the product tags guide 11 Order metafields are absent from the standard order CSV

Retrieve order custom fields through the right workflow

Use this when Shopify's Orders export has no order metafield columns and you need values from one or many orders.

  • Standard order CSV field boundary
  • Order definitions and GraphQL access
  • Bulk JSONL output and safe CSV mapping
Open the order metafield guide

A SAFER DIAGNOSIS

Repair one product group before the whole catalog.

Keep the original export untouched, isolate one failing product or SKU, and make the smallest explainable change. Shopify’s preview remains the final decision point.

  1. 1
    Keep a backup

    Preserve a fresh export from the target store.

  2. 2
    Choose one symptom

    Start with the most specific guide above.

  3. 3
    Validate locally

    Find deterministic field and grouping problems without uploading the file.

  4. 4
    Preview in Shopify

    Confirm creates, updates, locations, and overwrites before applying them.