# How to bulk edit SKUs and barcodes in Shopify

Updated 30 Oct 2026 · 7 min read · https://apimate.chat/blog/shopify-bulk-edit-sku

In the bulk editor. Products, tick the products, Bulk edit, then add the SKU and Barcodes columns under Columns. Each variant is a row, so you type or paste one value per cell and save. For thousands of variants, export the product CSV, edit the SKU and Barcodes columns, and import with "Overwrite products with matching handles" on. Both are free. The [overview of every Shopify bulk edit method](/blog/bulk-edit-shopify-products) compares them with apps.

The editing is the easy part. A SKU is different on every variant, so there is no "set all to X" shortcut, and spreadsheets damage barcodes on the way through: a 13-digit EAN opened in Excel becomes 8.71234E+12, the digits after the fourth are gone from the cell, and Shopify imports the damaged value without complaint. So this page starts with what goes wrong.

## Why SKUs come back wrong

Both fields are per variant. A T-shirt in four sizes and three colours has twelve variants, each with its own SKU and barcode, so the unit of every bulk job is the variant row. And both fields look like numbers to a spreadsheet, which is where most of the damage comes from.

| What you see | What happened | Fix |
| --- | --- | --- |
| 8.71234E+12 | The barcode was read as a number and shown in scientific notation. The trailing digits are gone. | Re-export, set the column to text before opening. |
| 12345678901 (11 digits) | A UPC lost its leading zero. | Restore it only if the check digit confirms the 12-digit value. |
| 1.2E+04 in SKU | A numeric SKU was converted the same way. | Text column, re-export. |
| Same SKU on every variant | A fill-down copied one cell to the whole column. | Undo in the sheet before import. |
| Every SKU one variant off | A paste into the bulk editor started one row too high or low. | Check the first and last pasted row against their variant names. |
| Two products share a SKU | Shopify does not enforce uniqueness, so nothing stopped it. | Sort by SKU and look for repeats. |

_Every row here saves or imports without an error. Shopify accepts the damaged value as written._

## Edit in the bulk editor

Products, select the products, Bulk edit. Under Columns, add SKU and Barcodes. Every variant of the selected products appears as a row. Type, or paste a column from a spreadsheet, and click Save. If a row fails, the editor shows the error on that row; fix it and save again.

This is the right tool up to a few hundred variants. Past that, scrolling and pasting become the risk, and the one-row-off paste in the table above is the usual result. Shopify stores up to 20 barcodes per variant, which is why the column is called Barcodes.

Sources: [Shopify Help: bulk editing](https://help.shopify.com/en/manual/shopify-admin/productivity-tools/bulk-editing)

## Edit by CSV without the traps

Products, Export. Each variant is a row with SKU and Barcodes columns; several barcodes on one variant are separated by semicolons. A file can carry the older Barcode column or the newer Barcodes column, not both, and Shopify converts Barcode to Barcodes on the next export.

Do not open the export by double-clicking it. The spreadsheet converts the barcode column on open, and the damage is in the file before you edit anything. Import the CSV into the sheet with the SKU and Barcodes columns set to text, then edit.

Keep URL handle and Title (required for updates), the variant option columns (so each row maps to the right variant), SKU and Barcodes. Save as UTF-8 and import with "Overwrite products with matching handles" on. A blank cell in a kept column is written as blank, so a missing SKU in the sheet becomes a missing SKU in the store. The inventory CSV is a different file: it updates quantities by location, not SKUs.

Sources: [Shopify Help: using CSV files for products](https://help.shopify.com/en/manual/products/import-export/using-csv), [Shopify Help: inventory CSV](https://help.shopify.com/en/manual/inventory-and-locations/setup/inventory-csv)

## Check digits on barcodes

A barcode is usually a GTIN (UPC 12 digits, EAN 13, ISBN 13) that marketplaces and Google Merchant Center check. Its last digit is computed from the others, so a mistyped or damaged number almost always fails the check. That makes the check digit the cheapest audit you can run after an import.

It also tells you what not to do. A barcode that fails is not fixed by changing one digit until the check passes: that produces a valid number that belongs to someone else's product. The only safe repairs are the ones the check digit proves, such as a stray space or hyphen, or a leading zero lost in a spreadsheet. Everything else goes back to GS1 or the manufacturer. The [Google Merchant Center audit case](/cases/google-merchant-center-audit) runs the same check as part of a feed review.

> **Nobody can invent a barcode** An app can copy or clear barcodes. A valid GTIN comes from GS1 or the manufacturer, not from a tool.

## A SKU pattern you can keep

SKUs are your own codes, free text, so the work is choosing a pattern that stays readable at 5,000 variants. Test it on a product with many options before you apply it anywhere, as in [bulk editing variants](/blog/shopify-bulk-edit-variants).

- Build it from fields every variant has: vendor code, product type, then option values such as size.
- Decide what happens when a field is empty, so a variant with no option value does not end in a stray hyphen.
- Keep it unique. Fulfilment and inventory apps that match by SKU break on repeats even though Shopify accepts them.
- Count variants, not products, before you start.
- Export first. With the bulk editor and CSV it is the way back; [how to undo a bulk edit in Shopify](/blog/how-to-undo-bulk-edits-in-shopify) covers the rest.

## Generating SKUs from a pattern

Bulk-edit apps generate SKUs from templates, such as "{vendor}-{product id}-{option1}", and apply them to a filtered set of variants. Check what the app does with a variant that has no option value or no vendor; some leave a stray hyphen, some skip the row.

In ApiMate you say the pattern ("NL, then the product type in three capital letters, then the size, only for variants with no SKU") and it computes a value per variant from that variant's own data. The preview lists every variant with its current and new SKU before anything is written, and the old values are kept for a revert. One literal value written to many variants is rejected, because one SKU on 300 variants is almost always a mistake. It can also list every barcode that fails its check digit, as a read, without guessing a fix. The free plan covers a small catalog.

## Questions

### Can I bulk edit SKUs in Shopify?

Yes. Add the SKU column in the bulk editor, or edit the SKU column of the product CSV and import with "Overwrite products with matching handles" on.

### How do I bulk update barcodes in Shopify?

The same way: the Barcodes column in the bulk editor or the product CSV. Several barcodes on one variant are separated by semicolons in the CSV, up to 20.

### Why does my barcode show as E+12 after export?

The spreadsheet read it as a number. Re-export and open the file with the barcode column set to text; the digits in the damaged cell cannot be recovered.

### Why is my 12-digit UPC now 11 digits?

The spreadsheet dropped the leading zero. Restore it only if the check digit confirms the 12-digit value.

### Does the inventory CSV update SKUs?

No. It updates quantities. Use the product CSV or the bulk editor for SKUs.

### Can Shopify have duplicate SKUs?

Yes, Shopify accepts them. Fulfilment and inventory tools that match by SKU usually do not, so check for repeats.

### Can ApiMate generate barcodes?

No. Valid barcodes come from GS1 or the manufacturer. ApiMate checks the existing ones and lists the invalid and duplicate values.

## Related

- [How to bulk edit Shopify products](https://apimate.chat/blog/bulk-edit-shopify-products): Admin, CSV, apps and chat: which fields each one reaches.
- [Google Merchant Center audit](https://apimate.chat/cases/google-merchant-center-audit): Barcodes, check digits and the other feed fields Google rejects.
- [How to bulk edit variants in Shopify](https://apimate.chat/blog/shopify-bulk-edit-variants): Options, prices and fields per variant row.
- [How to undo a bulk edit in Shopify](https://apimate.chat/blog/how-to-undo-bulk-edits-in-shopify): What each method gives you after a bad write.
