We are adding a new supplier/distributor (Primo) to RMS. This supplier uses the exact same item information (reorder #, cost, min. order, mpq) that we have from our current supplier (Color). We may continue to use Color in the future, so the KB Article about merging suppliers does not apply.
Is there a way, probably in SQL, to change all of the Items with Color set as the "primary supplier" and have Primo be the new "primary supplier" and Color remain as a secondary supplier? If not, I'm looking at having to go manually into each item and manually add the supplier and the copy all of the supplier info.
Thanks.