change one attribute for all items

Thanks,

This seems to require listing all item lookup codes in the inventory.

I'm w> 1) Backup your database

1) Backup your database

2) Pick an Item and write down it's lookupcode ( I'll use '12345' in the following samples)

3) go to Item Properties for your selected Item ('12345')

4) Set the Barcode Format and Item Tax that you want to apply

5) Close Manager

6) Open SO Administrator, use File/Connect to connect to your database

7) Open a new query window and enter the following:

UPDATE Item set BarcodeFormat = i.BarcodeFormat, TaxID = i.TaxID from (Select BarcodeFormat, TaxID from item where ItemLookupCode = '12345') i

8) Run the query

Go back to SO Manager and check your results... If you see any problems, restore from your backup.

Step 7 is as quick and dirty as it gets - it's going to set all items to the Tax and Barcode values you entered for your "template item".

By the way, you can set tax codes using the Inventory Wizard - anytime you can use the wizard instead of a query you should...

Thanks, I might have to go through the wizard and update each item, after getting the scanner to scan one of the barcodes :(

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Retail Realm has a store and HQ Misc Utilities with a whole bunch of small applications in it. One of which is a set of 36 new wizards [similar to RMS Wizards] that do a whole bunch of new mass updates like changing barcodes, changing department and categories, schedules, etc...

YOu can test this on sample database for free. Contact me for additional info.

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm

Kay,

Here's the same instruction in a simpler format:

UPDATE Item set BarcodeFormat = 6

In this case, '6' is RMS-ese for Code 128A. If you want to use a different Barcode Format, find it's place in the list (starting with 0 = NONE) and use the corresponding value.

This will set the Barcode format for ALL ITEMS.

As previously recommended, backup your database first. If something goes wrong, you can restore and try again.

Tom