CSV Import for Assembly Items : Update Assembly Items and the Preferred Vendor Field

Updating the Preferred Vendor field of assembly items is possible via CSV import however, the Preferred Vendor field is not always available at the NetSuite Mapping Fields since it is dependent on a standard feature. By design, the Preferred Vendor is available at the Basic tab of the Assembly Item but may this set up means the Preferred  Vendor field cannot be modified via CSV Import update.

To update  Assembly Items and the Preferred Vendor field:

1. Enable Multiple Vendor feature: Setup > Company > Enable features > Items & Inventory > Multiple Vendors = True

2. Run the Import Assistant: Setup > Import/Export > Import CSV records:

• Import Type = Items
• Record Type = Assembly/Bill of Materials
• Data Handling = Update
• Map the fields:
• Internal id = Internal id
• Vendor name = Vendors 1 : Vendor
• Preferred = Yes

3. Set Mapping name.

4. Click on  Save and Run.

5. Refresh CSV Import Status until completed.

6. After the update, check any assembly item  to confirm if a vendor subtab under the Basic tab will appear with the Preferred Vendor name.

Note: If users want to see it under the Basic tab, go back to Setup > Company > Enable features > Items & Inventory > Multiple Vendors and unmark it.