Trying to do mass update on label field in MS POS 2.0

I am trying to do a mass update on all of our items to make the labels be code 128. I am doing this so that we can print new shelf tags with the bar code on them. I am trying to make sense of the database and not having much luck. Can anyone tell me the table name and column name to do this? This is the field that appears on items in the option tab under label and bar code type. There is a drop down box that allows you to select the type of bar code. My goal is to do this in a SQL statement instead of opening up each of our 1500 items and choosing this manually.

Thanks Patrick

Reply to
mathews_patrick
Loading thread data ...

Patrick,

To update MSPOS barcode type on all items:

Backup the database Go into Manager | Inventory | Items | select any item | Options tab | decide which bar code you wish to use and count down the number of lines for it, for example Code 39 is the third line down, EAN 13 is the 6th line down Go into Manager | Tools | Database | Query Tool | type UPDATE Item Set BarCodeFormat = x where X is the line number you wish to use Press Run at the top and you're done.

Reply to
Jeff Faul
Reply to
mathews_patrick

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.