Mahmood has a new SQL Script to Mass Assign Items to Vendors in Dynamics GP.
Dynamics GP Essentials: Mass Assign Items to Vendors – SQL Script
Payables & ReceivablesSales, Purchasing & InventorySQL & Data
Archived post from 2015. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.