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.

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
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 products in Shopify (2026 guide, 3 methods)
Bulk edit Shopify product data three ways (the admin bulk editor, a CSV import or an app), with steps for prices, tags, SEO, metafields, variants and stock.
· 14 min read
Import supplier CSV files into Shopify over FTP or SFTP
A practical guide to importing supplier CSV files via FTP, FTPS or SFTP into Shopify: SKUs, inventory locations, preview and safe updates.
· 2 min read
How to schedule Shopify product exports daily or weekly
Set up recurring Shopify CSV or Excel exports with saved templates, daily or weekly schedules, job history and completion notifications.
· 2 min read
How to bulk edit Shopify productsFree CSV templatesBrowse the help center
Preview every change.Undo any import for 30 days.
Install free