Skip to content

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

Bulkvane

Importing

Edit products in the spreadsheet editor

Edit products in a grid inside Shopify, paste from Excel, fill down, and review changes before they're saved.

Last updated

Open the editor and load products

Choose Spreadsheet editor in the Bulkvane menu. Narrow down what to load, then click Load products:

  • Search: title, SKU or barcode.
  • Status: all statuses, or only active, draft or archived products.
  • Vendor, Product type and Tag.

Products load 50 per page. The counter shows how many are on this page and how many match in total; use Previous and Next to move between pages.

The Bulkvane spreadsheet editor in Shopify admin: filters for search, status, vendor, product type and tag above a grid of products with Handle, Title, Variant, Status, Vendor, Type, Tags, Variant SKU, Variant Barcode and Variant Price columns.
The spreadsheet editor with a store's products loaded. Variant rows sit under their product's first row.

How the grid is laid out

  • One row per variant, like a Bulkvane export.
  • Product details (title, status, vendor, type and tags) are on each product's first row. The rows under it are that product's other variants.
  • Variant columns (SKU, barcode and price) are on every row.
  • Handle and Variant show which product and variant a row belongs to; they can't be edited here.

Edit

  • Editable columns: title, status, vendor, type, tags, SKU, barcode, price, compare-at price, SEO title and description, and Body HTML.
  • Double-click a cell, or select it and start typing.
  • Copy cells from Excel or Google Sheets and paste them into the grid.
  • Drag the corner of a cell down to fill the cells below with the same value.
  • Ctrl+Z undoes, and the Undo and Redo buttons above the grid work the same way.

Cells are coloured as you work:

  • Changed: you edited the cell, and it will be part of the save.
  • Needs fixing: the value isn't valid, such as text in a price. Fix it before you save.
  • Can't be edited here: the cell is shown for reference only.

Save with Review changes

Nothing changes in your store while you edit. Click Review changes and Bulkvane turns only the edited products and columns into an import (Update only, or Replace where you emptied a cell), so it goes through the usual checks, before/after preview, Apply and 30-day Undo.

Plans

The spreadsheet editor is on every plan. One save can change as many products as your plan's products per job: 10 on Free, 5,000 on Starter, 50,000 on Growth and 100,000 on Pro. Save larger changes in several batches. See plans and billing.

Related guides