item barcodes and sql query

Mar 30, 2008 1 Replies

Hello,



Customer forgot to set the right barcodes for the items they left it blank. Customer would like to print labels but since they did not specify the right barcode types in the item properties I guess it will not work. So is there a sql query that can do that? For example I would like to it to use upca for all items, since almost all of their products are upca's.



Thank you.


Database> Backup

UPDATE Item SET BarCodeFormat = 9

(9 = UPCA)

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required