NSC | Item Record > Remove Vendor Through CSV Import

Scenario:

The user wants to remove a vendor from an item record.

Solution:

Here are the steps to do so: (You can try it on just 1 item first just to make sure it works for you before doing a massive CSV import)

1. Create CSV file with the following columns:
   1. Internal ID
   2. Vendor
   3. Code
   4. Preferred
   5. Purchase Price
2. Navigate to Setup > Import/Export > Import CSV Records
   1. Import Type = Item
   2. Record Type = Inventory Item (choose the appropriate item type)
   3. Click Select, then chose the file to import.
   4. Click Next.
   5. Set the Data Handling to Update.
   6. Click on Advanced Options and put a check mark on