Option 1: Shopify's product CSV

Export your products, change the codes, and import the file with Overwrite products with matching handles. Shopify's rules to know:

  • Updates need the URL handle and Title columns.
  • Keep Option1 name and Option1 value whenever the file has a SKU column. Without them, Shopify creates a new default variant and deletes the existing ones.
  • Codes go in the SKU and Barcodes columns. Separate several barcodes with a semicolon, up to 20. A file with both a Barcode and a Barcodes column fails to import.
  • A blank cell overwrites the value with a blank. Columns you remove from the file keep their values, so keep only what you're changing.

Option 2: change only the codes with SGT

  1. In SGT, on Manual Generation, click Import and upload a CSV file. Save an Excel sheet as CSV first.
  2. Each row needs a Variant ID column, or a column named Handle plus the option values. If your file says URL handle, rename it Handle.
  3. Check the results: each row is written, not found or failed, and you can read why.

Nothing else on the product changes.

Using Shopify? SGT is our app for this: see it on the Shopify App Store (free plan, 4.8 from 53 reviews).

What Excel does to barcodes

  • Leading zeros vanish: 036000291452 becomes 36000291452.
  • Long numbers break: they turn into 3.6E+11, and digits past the 15th become 0.
  • Some codes become dates: 1-2 turns into 2 January.

Format the column as Text before typing or pasting. Once Excel saves a damaged number, the digits are gone, so go back to your original numbers.

Check the numbers first

Check retail codes with the check digit calculator, and look for duplicates after importing: Shopify doesn't stop two variants sharing a code.

Want labels from your file? See how to print barcode labels from Excel.

Prefer video? Watch the 90-second SGT tour on YouTube.

Frequently asked questions

How do I undo or clear codes in bulk?

SGT has no undo. Use Shopify's bulk editor to clear them, or generate again with Overwrite ticked. Export your products first, so you have a copy of the old codes.

Which columns does Shopify need to update SKUs?

URL handle and Title are required for updates, plus SKU and the option columns so variants stay matched. Removed columns keep their existing values.

Why did my barcodes lose their first zero?

Excel treats the code as a number. Format the column as Text before entering codes, or keep the file in CSV and don't reopen it in Excel.

Can I print labels from a spreadsheet too?

Yes. SGT's print page reads Excel and CSV files. So does our free online tool, with no Shopify store needed.

Written by SingleTec, the team that builds and supports SGT, a Built for Shopify app on the Shopify App Store since 2023.