item barcodes and sql query

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.

Reply to
BD
Loading thread data ...

Database> Backup

UPDATE Item SET BarCodeFormat = 9

(9 = UPCA)

Reply to
jocelynp

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.