Welcome to the Revel Support Center

How Can We Help?

How to add leading 0’s to existing barcodes

By Amelia Dwyer | Updated

If you've imported barcodes intended to have leading zeroes, you may notice that these leading zeroes do not appear in Revel. This is a limitation of Excel not allowing leading zeroes by default.

You can add leading zeroes to your barcodes by exporting your products and barcodes, adding the zeroes with text, and then re-importing the codes.

  1. From the Management Console ([yoursubdomain].revelup.com), navigate to Products.
  2. Click Import/Export and select Products from the dropdown menu:
  3. For Export Type, select Advanced. This displays additional fields to customize your export.
  4. In the Filter Items menu, select the products you want to edit in bulk. You may select categories, subcategories, product groups, product classes, barcode, or SKU.
  5. In the Export Contents menu, check the box next to Reset Barcode:
  6. From the Auto Field dropdown menu, select Neither:
  7. Click Export.
  8. Open this spreadsheet in Excel. In an empty column that has no heading, add a 0 into a field and change the field to Text. To do this, under Number click the dropdown box and select Text:
  9. Copy this field to all the rows below that need leading zeroes added to product barcodes:
  10. In the cell next to the zeroes, type =(select field with 0)&(select field with barcode):
  11. Then drag that value down to all the rows that need the leading zeroes added:
  12. Copy and paste these fields into the Reset Barcode field.
  13. Save this spreadsheet.
  14. In the Management Console, navigate back to Products.
  15. Click Import/Export and select Products from the dropdown menu.
  16. In the Import Products area, click Choose File. Select the file you want to import and click Import:

Note: After your import is complete, check your barcode numbers to make sure that this process was successful.


Have more questions? Submit a request

How to add leading 0’s to existing barcodes

By Amelia Dwyer | Updated

Follow

If you've imported barcodes intended to have leading zeroes, you may notice that these leading zeroes do not appear in Revel. This is a limitation of Excel not allowing leading zeroes by default.

You can add leading zeroes to your barcodes by exporting your products and barcodes, adding the zeroes with text, and then re-importing the codes.

  1. From the Management Console ([yoursubdomain].revelup.com), navigate to Products.
  2. Click Import/Export and select Products from the dropdown menu:
  3. For Export Type, select Advanced. This displays additional fields to customize your export.
  4. In the Filter Items menu, select the products you want to edit in bulk. You may select categories, subcategories, product groups, product classes, barcode, or SKU.
  5. In the Export Contents menu, check the box next to Reset Barcode:
  6. From the Auto Field dropdown menu, select Neither:
  7. Click Export.
  8. Open this spreadsheet in Excel. In an empty column that has no heading, add a 0 into a field and change the field to Text. To do this, under Number click the dropdown box and select Text:
  9. Copy this field to all the rows below that need leading zeroes added to product barcodes:
  10. In the cell next to the zeroes, type =(select field with 0)&(select field with barcode):
  11. Then drag that value down to all the rows that need the leading zeroes added:
  12. Copy and paste these fields into the Reset Barcode field.
  13. Save this spreadsheet.
  14. In the Management Console, navigate back to Products.
  15. Click Import/Export and select Products from the dropdown menu.
  16. In the Import Products area, click Choose File. Select the file you want to import and click Import:

Note: After your import is complete, check your barcode numbers to make sure that this process was successful.

prev Next Article

Log in to your Management Console

Let the data inform your business decisions

Can't find what you're looking for?

Help is right around the corner!

Submit a Ticket Other Options

Sign up for our newsletter to receive monthly revel updates

Thanks for signing up!

Want to request a new feature? Click here!
Powered by Zendesk