Supplier Merge

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

Reply to
jetspeed
Loading thread data ...

needs to be done i a few steps.

  1. Backup DB
  2. open so admin and connect to DB
  3. 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.
  4. run a new query based on that info. update item set supplierid =x where supplierid =y
Reply to
Michael Santinon

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.