I need to change the vendor setting on nearly all of my product records. Is there any easy way to do that (like exporting data to Excel, updating the vendor field then importing it back in)? If so, can you provide steps on how to do that? I do have Admin access.
Yes. Go to Products > Export/Traffic Tools > Product Excel > Export. You can then save and open the file. Make your changes to the Vendor column in the file and save > Go back to the Products section in the Order Management System and this time click Import > Product Import > then scroll to the bottom of the page and import your file. This will update all the products with your vendor changes.