Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

Shopify CSV import error

“Validation failed: Value must be a valid product reference”: what it means and how to fix it

A metafield in your file points to a product that doesn't exist in the store yet, or the value isn't a product reference at all.

Why it happens

  • The file creates the products and references them in the same import.
  • The value is a title or handle instead of a product reference.
  • The referenced product was deleted.

How to fix it

  1. Import the file once without the reference metafield values, so every product exists.
  2. Import it again with the metafield values, overwriting the products.
  3. Check that each value refers to an existing product.

How Bulkvane handles it

Bulkvane passes reference values such as gid://shopify/Product/7234567890123 to Shopify, which checks them, and the results file names each row that failed. The same two-pass approach works: import products first, then the references. See bulk editing metafields.

Every file is checked before anything changes, with problems named by row in plain words, and any import can be undone for 30 days. All of Bulkvane's messages are in Errors A–Z.

Questions

What does a product reference value look like?

A Shopify ID in the form gid://shopify/Product/ followed by the product's number. You can find the number in the product's URL in Shopify admin.

Message, cause and fix from the Shopify Help Center: common product CSV import issues, checked . Still stuck? See Shopify CSV import not working? or ask us.

Preview every change.Undo any import for 30 days.

Install free