Can I change vendors for items en mass

Aug 28, 2007 1 Replies

First reply

Terrible Tom

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

Read the full reply
J

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?


Vote
Twitter Facebook LinkedIn
T

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

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