Skip to content

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

Bulkvane

Shopify product spreadsheet: every column explained

What each column in a Shopify product export means, which ones you can change on import, and which are read-only, with examples for products and variants.

The Bulkvane teamPublished Last updated 2 min read
Bulkvane's Import page, explaining that a product file uses one row per variant with product details on the first row.

One row per variant

A product spreadsheet has one row for every variant. Product-level fields (title, description, vendor, tags) are written on the first row of each product. When you import, the first non-empty value in a product's rows is used.

Handle,Title,Option1 Name,Option1 Value,Variant SKU,Variant Price
linen-shirt,Linen Shirt,Size,S,LS-S,42.00
linen-shirt,,,M,LS-M,42.00
linen-shirt,,,L,LS-L,44.00
Three variants of one product

Identity: ID, Handle, Variant ID

These columns decide which product a row updates. ID and Variant ID are Shopify's own numbers; keep them as they are. If a row has no ID, Bulkvane matches by Handle. No match means a new product is created from the row's Title.

Details, SEO and media

  • Title, Body HTML (the description), Vendor, Type, Tags and Status describe the product.
  • SEO Title and SEO Description control what search engines show.
  • Image Src takes a public image URL. Shopify downloads it during the import.

Options and variants

Option1–3 Name are set once per product (for example Size, Color). Option1–3 Value are set on every variant row. Variant SKU, Barcode, Price and Compare At Price belong to each variant.

Read-only columns

Variant Inventory Qty, Created At and Updated At are exported for reference and ignored on import. To change stock, add an “Inventory: <location name>” column per location. Bulkvane updates available stock there, and never overwrites stock that changed since the preview.

Frequently asked questions

Which columns does a Shopify product CSV need?

To create a product, a Title: if the Handle is empty, Bulkvane makes one from the title. To update a product, an ID or a Handle. Option and variant columns are only needed for products with variants.

What is the Handle column?

The product's URL slug, such as linen-shirt in /products/linen-shirt. It uses lowercase letters, numbers and dashes, and it goes on every variant row so the rows stay together.

Can I change stock with the Variant Inventory Qty column?

No. It's the total across all locations, exported for reference and ignored on import. Add an “Inventory: <location name>” column for each location instead.

Do Shopify's own CSV headers work in Bulkvane?

Yes. Bulkvane reads Shopify's native product CSV headers and Matrixify's, so a file exported from Shopify imports as it is.

Related guides

How to bulk edit Shopify productsFree CSV templatesBrowse the help center

Preview every change.Undo any import for 30 days.

Install free