Two of my suppliers have merged into the one company. Problem is, Supplier A has about 1000 products and supplier B, 600 products, so doing it manually would be a last resort. Is there some sort of query I could run to merge them?
Cheers
Supplier Merge
Jul 24, 2006
1 Replies
needs to be done i a few steps.
- Backup DB
- open so admin and connect to DB
- run a select * from item query and find the supplierid of the items you wish to change supplier info for. and find the supplierid of the items you wish to change them to.
- run a new query based on that info. update item set supplierid =x where supplierid =y
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required