Errors A–Z
Errors A–Z
Last updated
- Error — row skipped
ID “7.2E+12” was shortened by your spreadsheet program (scientific notation).
- What it means
- Excel or Numbers turned a long ID into a rounded number. The real ID is lost in this file.
- How to fix
- Format the ID and Variant ID columns as Text, export again from Bulkvane, and redo your edits.
- Error — row skipped
“gid://shopify/Collection/…” is a Collection ID, not a product ID.
- What it means
- The ID column holds an ID for a different kind of object.
- How to fix
- Copy product IDs from a Bulkvane product export.
- Error — row skipped
“abc” isn't a valid product ID.
- What it means
- The value in ID or Variant ID isn't a Shopify ID.
- How to fix
- Leave ID empty to match by Handle, or paste the ID from an export.
- Error — row skipped
Row 12 has no ID, Handle or Title, so we can't tell which product it belongs to.
- What it means
- The row has data but nothing that identifies the product.
- How to fix
- Fill in the Handle on every row, including variant rows.
- Error — row skipped
The file needs an “ID”, “Handle” or “Title” column.
- What it means
- None of the identifying columns were found in the header row.
- How to fix
- Check the first row of your sheet holds the column names.
- Error — row skipped
Price “abc” isn't a number.
- What it means
- A price or number column contains text.
- How to fix
- Use digits only, for example 19.50.
- Error — row skipped
Price can't be negative (found “-5”).
- What it means
- Prices and quantities must be zero or more.
- How to fix
- Correct the value.
- Error — row skipped
Status “Live” isn't recognised. Use Active, Draft or Archived.
- What it means
- Shopify only has three product statuses.
- How to fix
- Change the value to Active, Draft or Archived.
- Error — row skipped
Handle “!!!” has no letters or numbers.
- What it means
- A handle needs at least one letter or number.
- How to fix
- Use a handle like “blue-linen-shirt”.
- Warning
These columns aren't used by Bulkvane and will be ignored: “Supplier ref”.
- What it means
- The column isn't one Bulkvane imports.
- How to fix
- Rename it if it should map to a Shopify field (see the column reference), or ignore the warning.
- Warning
Row 5: Title is different from row 3 of the same product. We'll use row 3.
- What it means
- Product-level fields should be the same on every row of a product.
- How to fix
- Put product fields on the first row only, or make them match.
- Warning
Compare-at price (20.00) isn't higher than the price (25.00), so no sale will be shown.
- What it means
- Shopify only shows a sale when compare-at is higher than price.
- How to fix
- Raise the compare-at price or clear it.
- Warning
Option1 Value is “M” but Option1 Name is empty.
- What it means
- Variant options need a name such as Size or Color.
- How to fix
- Add the option name on the product's first row.
- Warning
SEO Title is 84 characters. Search engines usually show about 70.
- What it means
- The title will probably be cut off in search results.
- How to fix
- Shorten it if you can.
- Warning
Image “photo.jpg” isn't a web address (it must start with https://) and will be skipped.
- What it means
- Shopify downloads images from public links; it can't read files on your computer.
- How to fix
- Upload images somewhere public (or to Shopify Files) and paste the https:// link.
- Fixed for you
Price “12,50 €” contains a currency symbol and a decimal comma — it will be saved as 12.50.
- What it means
- Bulkvane converted the value for you.
- How to fix
- Nothing to do. Check the preview shows the price you expect.
- Fixed for you
Handle “Blue Shirt” can only use lowercase letters, numbers and dashes — it will be read as “blue-shirt”.
- What it means
- Bulkvane cleaned up the handle.
- How to fix
- Nothing to do.
- Fixed for you
Row 8 has no Handle — we'll use “linen-shirt”, made from the title.
- What it means
- A new product will get a handle based on its title.
- How to fix
- Add your own Handle if you want a different URL.