1. Home
  2. Point-Of-Sale Software
  3. Change Suppliers Barcode Format

Change Suppliers Barcode Format

We are using the 3 of 9 barcode format with all of our products and all labels have been scanning great. However we recently got a company in that when we create the Item Lookup Code it has Uppercase, Lowercase, and Spaces. So when we printed off Labels for inventory control they did not scan right. I quickly came to the conclusion that I need to be using the 128b barcode format for this company. Since all other suppliers are scanning good I was thinking of just running an SQL Query for just the specific company that is having the problem. I know that this statement

UPDATE Item SET BarcodeFormat = '7'

will work for changing all items to the 128b format. However I just want to do one supplier. Also will having two different types of barcodes cause any harm? If so maybe I should just run the above statement. Any advice is welcome. Thanks in advance.

Neil

Reply to
nt8378
Loading thread data ...

Neil,

It would be tough to change just for that one company as the program is set up to allow for multiple companies for the same item.

Go ahead and run that script and it will change all items to the new bar code format. When the new items are received and bar codes printed, they will print with the new format.

Depending on your bar code scanner, you could have 8-20 different styled bar codes in the store. Some scanners have the capability to read more than others, but 39, 128 and UPC/EAN are the most common in retail.

Reply to
Jeff

Thanks for the fast reply Jeff. I will go ahead and use that SQL Script then. Again thank you for the input.

Neil

"Jeff" wrote:

Reply to
nt8378

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.