Mass Primary supplier change

This problem has me stumped, I've played around with the inventory wizard but still cant achieve what I want. At the moment I've got about 400 products (all their descriptions start with the same 4 letters eg. ABCD) and all the products have 3 suppliers setup (Supplier A, Supplier B & Supplier C). Problem is, that at the moment the PRIMARY supplier is Supplier A, but I need to change this for all 400 products to Supplier B. Is there any way I can avoid having make this change manually 400 times?

Cheers

Reply to
jetspeed
Loading thread data ...

You will need to use SQL queries to do this one. Be sure to take a backup before trying anything.

From Store Operations Manager, pick any item and set it's primary supplier to the one that you wish to use for all of these items. Keep note of the Item Lookup Code (suppose it's ABCD123)

Start Store Operations Administrator, open a new query (Ctrl-N), and type the following: SELECT SupplierID FROM Item WHERE ItemLookupCode'ABCD123'

Run the query (F5) and you should get a number back. This is the ID of the primary supplier (suppose it's 3)

Now open another new query and type the following: UPDATE Item SET SupplierID=3 WHERE ItemLookupCode LIKE 'ABCD%'

Note the percentage sign after the ABCD. This tells the query to update the records which match "ABCD" at the beginning of the item lookup code.

Reply to
Jason Hunt

Thanks for that, much appreciated.

I'll have to give it a go after hours.

Cheers

"Jas> You will need to use SQL queries to do this one. Be sure to take a backup

Reply to
jetspeed

Sorry forgot to ask, but in that last query you wrote, would I be able to change the ItemLookpCode to Description, because the the item lookup's vary a lot, but the descriptions all begin with the same 4 letters

Cheers

"Jas> You will need to use SQL queries to do this one. Be sure to take a backup

Reply to
jetspeed

Yes, you can replace "WHERE ItemLookupCode" with "WHERE Description" and it will work the same.

Reply to
Jason Hunt

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.