Change Suppliers Barcode Format

Jun 22, 2006 2 Replies
N

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



Vote
Twitter Facebook LinkedIn
J

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.

Vote
Twitter Facebook LinkedIn
N

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:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required