Shopify Bulk Editor: How to Bulk Edit Products, and When to Use a CSV

October 1, 2026

The Shopify bulk editor is a spreadsheet-style table inside your Shopify admin. You tick the products you want to change on the Products page, click Bulk edit, choose the columns you need, type the new values and click Save. It is the fastest way to change short fields like prices, SKUs, tags or vendors across many products. For a very large catalogue, or for long text like descriptions, Shopify points you to a CSV file instead. This guide covers both routes step by step, the mistakes that wipe data, and how to handle the part neither tool does for you: writing new copy for every product.

All the Shopify behaviour quoted below comes from Shopify’s own help centre, as of October 2026. Shopify changes its admin often, so check the help page if a button has moved.

What the Shopify bulk editor is for

Shopify’s help centre describes the bulk editor as a tool “to make changes to multiple products and product variants at the same time.” Each row in the table is a product or a variant, and each column is a property such as price, SKU or compare-at price. You can also use it for collections and customers.

It sits beside two other bulk tools, and picking the right one saves most of the effort.

If every product gets the same change, you probably want a bulk action, not the bulk editor. Adding a “sale” tag to forty products is one action. Changing forty prices to forty different numbers is a bulk edit.

How to bulk edit products in Shopify, step by step

These are the steps from Shopify’s bulk editing help page.

1. From your Shopify admin, click Products.
2. Use the checkboxes to select each product you want to edit. To select a range, click one product, hold Shift and click another.
3. Click Bulk edit.
4. Click Columns and select every property you want to change. Deselect the ones you do not need, so the table stays readable.
5. Click a cell and type the new value.
6. Click Save. If Shopify reports errors, fix them and click Save again.

To select more than one page of products, tick the checkbox at the top of the list and choose the option to select all results. If you filter the list first (by vendor, type, tag or collection), “select all results” picks every product that matches the filter. Filtering before you select is the safest way to bulk edit, because the table then holds only the products you meant to change.

Shortcuts that make the table faster

Shopify’s bulk editor behaves much like a spreadsheet. The help centre lists these shortcuts:

• Arrow keys move between editable cells.
• Shift and click selects a range of adjacent cells.
• Alt and click (PC) or Command and click (Mac) selects cells that are not next to each other.
• Click and drag across cells to edit them all at once. This works for text, numbers, checkboxes and drop-down menus.
• Drag the fill handle of a cell to copy its value to the cells above or below.

When several cells are selected, whatever you type into the outlined active cell is applied to all of them. That is how you set the same compare-at price on twenty variants without typing it twenty times.

When the Save button refuses

The most common error is “Update the invalid values, then save again”. Shopify says this can happen even when the problem is in a column you have not added to the table. The usual causes are a variant missing a required SKU, or a metafield that fails validation. Add the SKU and metafield columns, look for the invalid value, fix it and save again.

Two more limits from the same help page are worth knowing before you start:

• A product with several variants can only have its inventory bulk edited from the Inventory section, not from the Products bulk editor.
• Shopify warns that Microsoft Edge can cause errors in the bulk editor because of a URL length limit, and suggests Chrome, Firefox or Safari instead.

Common bulk edits, and which tool to use

When to use a CSV file instead

Shopify’s own bulk editing page says that the more you change at once, the longer the save takes, and that “You can also use a CSV file to bulk edit a larger number of list items.” A CSV round trip works like this:

1. Go to Products and click Export. Choose all products, the current page, the products you selected, or the ones matching your filters, and pick the CSV format for Excel, Numbers or another spreadsheet program.
2. Open the file and change only the cells you mean to change.
3. Go back to Products, click Import, click Add file and choose your file. Select Overwrite products with matching handles.
4. Click Upload and continue, review the details, then click Import products. Shopify emails you when the upload finishes.

Shopify’s import help page asks you to make a backup of your product data before you start. The export from step 1 is that backup, so keep an untouched copy of it.

The three ways a CSV edit goes wrong

These all come from Shopify’s import and export help pages, and each one has cost sellers real data.

• Blank cells overwrite. With the overwrite option selected, “if a non-required column in the import CSV file is blank, then the matching value in the product list is overwritten as blank.” Delete any column you are not changing instead of leaving it empty.
• Sorting breaks rows. Shopify warns that sorting the file in a spreadsheet program can separate variants and image URLs from their product, and that importing a sorted file “might overwrite your existing products with bad data, which can’t be recovered.” Do not sort. Filter if you need to, then clear the filter before saving.
• The file has a size limit. A product CSV cannot exceed 15 MB. Split a large catalogue into several files.

One more detail matters if you are editing search fields. Shopify’s export page says the SEO title and SEO description columns are only filled in when you have customised them by hand. Blank means Shopify is generating them from your product title and description, which is normal. Shopify also allows up to 70 characters for an SEO title and 320 for an SEO description, as of October 2026.

Import two or three rows first and check them in the admin before you import the rest. It costs five minutes and is the only cheap way to catch a mapping mistake.

How to rewrite product descriptions in bulk

The bulk editor and the CSV both move text around. Neither writes it. If your catalogue has thin descriptions, copied manufacturer text or no SEO fields at all, the hard part of the bulk edit is the writing, and that part scales badly by hand. Shopify’s own product help suggests avoiding duplicate manufacturer descriptions for better search visibility, so there is a real reason to do it.

The manual way

Export your products, add a column of notes for each product (material, size, who it is for, what makes it different), and write each description in the Description column. Then write an SEO title and SEO description for each product while the details are fresh. A careful writer can do this well for a few dozen products. At a few hundred it becomes weeks of work, and the last hundred are rarely as good as the first ten.

If you are doing it by hand, our guide to writing a Shopify product description that converts covers what each paragraph should do, and Shopify meta description examples has patterns for the search fields.

The faster way: draft the batch, then edit

ListingBrief AI turns rough product notes into the Shopify fields that are made of words: product title, description, SEO title, meta description, category and product type, vendor, tags, and options with variants. It fits a bulk edit in two ways.

• A batch of drafts. Paste your products one per line in bulk mode and generate them in one batch. Each result can be copied field by field into your exported CSV, keeping that file’s existing handles so the import updates the products you already have. For brand new products, the batch also downloads as a CSV with Shopify’s product columns, with price, SKU, weight and image columns left empty for you to fill and every product set to draft, so nothing goes live before you review it.
• One product at a time, in place. The free Chrome extension adds a panel to the Shopify admin product editor and fills the generated fields into the product you have open. That suits a slow refresh of your best sellers more than a store-wide import.

It does not change prices, inventory or images, and it does not import anything into Shopify for you. Those stay with the bulk editor and the CSV. Read each draft before it goes live, since you know things about your products that notes do not say. You can try the description step on its own with the free Shopify description generator, with no signup. An account gets 5 free generations a day, and pricing covers larger batches.

When the manual way is enough

Plenty of stores never need more than the built-in tools.

• The change is the same for every product. A bulk action or a drag-select in the bulk editor handles it in a minute.
• You have a small catalogue. Twenty descriptions written with care will do more for you than two hundred drafted and never read.
• You are only changing numbers. Prices, SKUs, weights and inventory are what the bulk editor is built for. No writing tool helps there.
• Your copy already exists elsewhere. Moving descriptions from another platform is a CSV import, not a rewrite. Sellers who also list on Etsy can read how to connect Shopify to Etsy first.

A checklist before you save a bulk edit

• Filter the product list so the selection holds only the products you mean to change.
• Export a CSV of your products first and keep it untouched as a backup.
• In the bulk editor, add only the columns you are changing.
• If Save refuses, add the SKU and metafield columns and look for the invalid value.
• In a CSV, delete the columns you are not changing rather than leaving them blank.
• Never sort the product CSV.
• Import a few rows first, check them in the admin, then import the rest.
• Read every rewritten description before the product goes back on sale.

For adding products rather than editing them, see how to add a product on Shopify, which walks through every field on the product page.