Bulk Update SKU Shopify Guide: Use the Editor, CSV or an App

To bulk update SKUs in Shopify, select your products in the admin, click Bulk edit, add the SKU column and type or paste the new values before saving. For large catalogs, export your products to CSV, change the SKU column and import the file back, keeping the option columns so your variants stay intact.

SKUs connect your products to inventory counts, reports, warehouses and supplier orders. Updating them in bulk saves hours when you introduce a new naming system or fill in missing codes, but a careless import can delete variants or create duplicate SKUs.

How to Bulk Update SKUs in Shopify With the Bulk Editor

The bulk editor is the simplest native way to change SKUs for a group of products. Each variant appears as its own row, so every size and color gets its own SKU cell.

1. In your Shopify admin, go to Products.
2. Filter the list if needed, then select the products you want to update.
3. Click Bulk edit.
4. Click Columns and add SKU.
5. Type or paste the new SKU into each variant’s row.
6. Click Save and wait for the confirmation before leaving the page.

You can paste a column of SKUs from a spreadsheet, as long as the rows are in the same order as the editor. Shopify also warns you when a SKU you enter is already used by another product or variant, which helps you keep codes unique.

The bulk editor handles up to 50 products at a time, so work through larger catalogs in batches. It’s best for typing or pasting values, since it can’t build SKUs from formulas.

Bulk Update SKUs With a CSV

A product CSV suits hundreds or thousands of variants, especially when you want to generate SKUs with spreadsheet formulas. Follow these steps:

1. Export your products. Go to Products > Export and download the products you want to update.
2. Keep a backup. Save an untouched copy of the file so you can restore the old SKUs.
3. Open the file with text formatting. Set the SKU column to text so your spreadsheet doesn’t strip leading zeros or convert long codes.
4. Update the SKU column. Enter the new SKU on each variant’s row.
5. Import the file. Go to Products > Import, select Overwrite products with matching handles and import.
6. Check a few products. Open several products and confirm each variant shows the right SKU.

Keep the option columns in your file

SKU is a variant-level column, so Shopify needs the variant’s option columns to know which variant each SKU belongs to. If you include the SKU column without Option1 name and Option1 value, Shopify creates a new default variant and deletes the existing ones.

To trim the file safely, keep the URL handle, Title, every option name and value column your products use and the SKU column. Removing unrelated columns, such as descriptions and images, leaves that data unchanged.

Blank cells in included columns clear existing values, so an empty SKU cell removes that variant’s SKU. If you use a custom fulfillment service, the SKU can’t be blank at all.

If you manage product data across Shopify, WooCommerce or Wix, Bulkflow supports bulk import, export and updates to existing product records with field mapping. That can help when you need to update SKUs or other product details for many records at once.

Generate SKUs with spreadsheet formulas

Formulas are useful when you’re adding SKUs to products that never had them or switching to a new naming pattern. You can combine short codes from the product type, style and option values into one SKU.

For example, if column A holds a category code such as TS, column B a style code such as CREW, and columns C and D the color and size codes, a formula like =UPPER(A2&"-"&B2&"-"&C2&"-"&D2) produces TS-CREW-BLK-M. Copy the formula down, then paste the results as plain values before importing.

After generating SKUs, check for duplicates with your spreadsheet’s conditional formatting or a COUNTIF formula. Two variants with the same SKU are easy to miss in a large file and cause problems in reports and fulfillment.

Use an App for Large SKU Updates

Import apps can update SKUs by matching on a variant’s ID instead of its handle and options. That makes the file simpler and reduces the risk of accidentally changing variants.

Matrixify, for example, exports variants with ID, Handle, Variant ID and Variant SKU columns, so you can edit just the SKUs and import the trimmed file. If rows fail, its import results file explains why, and you can fix and reimport only those rows.

Other tools, such as the Firebear Import & Export Tool, follow a similar export, edit and import workflow. Developers can also update SKUs through the Admin API, where the SKU is stored on each variant’s inventory item.

What Changes When You Update SKUs

A SKU change applies to the variant from the moment you save, but many other systems may still use the old code. Plan the update so everything stays in step.

• Past orders. Orders keep the SKU recorded when they were placed, so reports may show both old and new codes for the same product.
• Warehouses and fulfillment partners. 3PLs and fulfillment services often match items by SKU, so share the new codes before switching.
• Labels and POS. Shelf labels and printed stickers that show the SKU need reprinting.
• Connected channels and apps. Marketplaces, inventory apps and accounting tools that sync by SKU may need updating or remapping.
• Supplier orders. Purchase orders and supplier catalogs should reference the new codes.

Changing SKUs at the start of a reporting period makes comparisons easier. It also helps to keep a mapping sheet of old and new SKUs for your team and partners.

Note that the inventory CSV can’t change SKUs. It uses the SKU only to identify items, so update SKUs through the bulk editor, a product CSV or an app instead.

Tips for a Consistent SKU Format

A good SKU format makes products easy to identify at a glance and keeps your data clean as the catalog grows. Follow these guidelines when planning a bulk update:

• Keep every SKU unique. Each variant should have its own code so inventory and sales reports stay accurate.
• Use a consistent pattern. Build SKUs from the same parts in the same order, such as category, style, color and size.
• Keep them short. Short codes are easier to read, type and print on labels.
• Avoid spaces and special characters. Use letters, numbers and hyphens, and pick one letter case.
• Leave out details that change. Prices, years or supplier names can make a SKU outdated quickly.
• Keep SKUs separate from barcodes. SKUs are your internal codes, while barcodes such as UPCs identify products across retailers.

Common Problems When Bulk Updating SKUs

Most SKU issues come from CSV structure or spreadsheet formatting. Watch for these:

• Variants disappeared after an import. The SKU column was included without the option name and value columns.
• SKUs lost leading zeros. The spreadsheet treated them as numbers, so format the column as text.
• Some SKUs were cleared. Their cells were blank in a file imported with overwrite.
• Shopify shows a duplicate SKU warning. Another product or variant already uses that code.
• The bulk editor asks you to update invalid values. A variant is missing a required SKU, which often applies to custom fulfillment services.
• Reports show two SKUs for one product. Older orders keep the SKU recorded at the time of sale.
• An inventory CSV didn’t change SKUs. That file only uses SKUs to identify items.

Conclusion

Knowing how to bulk update SKUs in Shopify lets you organize your catalog and fix inventory data without editing each variant by hand. Whether you use the bulk editor, a CSV or an app, keeping SKUs unique and your variant structure intact protects your inventory, reports and fulfillment. We hope this guide helps you bulk update SKUs in Shopify with confidence. To import and update product data in bulk, you can explore Bulkflow.