Can I change vendors for items en mass

Aug 28, 2007 1 Replies

I need to change the vendor for about 1000 items, all to the same new vendor. Is there a way to do this other than 1 by 1?


Yes.

You can use a query in SO Admin (or HQ Admin, if you use HQ).

Use a SELECT query to find the IDs of the old and new Suppliers. Then UPDATE the SupplierList table with the new SupplierID.

If you need more detailed instructions, let me know.

Tom

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required