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

Sep 16, 2008 2 Replies
M

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


Vote
Twitter Facebook LinkedIn
J

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.

Vote
Twitter Facebook LinkedIn
M

Thanks it worked!

The barcodeformat = 8 is what gets me code 128 but it is the 3rd line down in MS POS 2.0. Not sure why but just in case anyone else tries this they should verify the value by running before and after queries on a specific item with the bar code set to none and then what ever value they want.

Thanks again for your help.

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