We need to use the Inventory Item record type to update the vendor items in NetSuite via ExtendInsights for Data Management NetSuite. It is a workaround to use Inventory Item when updating the Vendor sublist.
There are multiple ways to manage your Vendor Prices using ExtendInsights, also outlined in this article.
Watch the video below to learn how!
Template Layout
๐ก Tip: It is best to check out the forms and fields and identify the header, column, and required fields in NetSuite that you may need to build the template.
Sample for Inventory item template for managing vendor price list:
Item Id
Item Vendor List: Vendor
Item Vendor List: Vendor Code
Item Vendor List: Preferred Vendor
Item Vendor List: Purchase Price
Adding multiple Vendors to an Item
Step 1: On the internal Id column put the internal Id of the item to update. Repeat, depending on how many vendors you'd like to add.
Step 2: Add the vendor name in the Vendor field, you can type ahead on the cell, choose from the cell operations, or enter the internal ID value of the vendor enclosed in double brackets.
For NetSuite One World users, the subsidiary will be dependent on the vendor.
This is how to add the details to the ExtendInsights template:
This will be loaded in the Item Vendor subtab in NetSuite
Step 3: Once you are ready, hit Upload > Upload Records to add the vendors to the item.
Adding Multiple Items to a Vendor
Step 1: On the internal Id column put the internal Id of the items to update.
Step 2: Add the vendor name in the Vendor field, you can type ahead on the cell, choose from the cell operations, or enter the internal ID value of the vendor enclosed in double brackets. Repeat depending on how many items you'd like to add.
This is how to add the details to the ExtendInsights template:
This will be loaded in the Vendor Item subtab in NetSuite
Step 3: Once you are ready, hit Upload > Upload Records to add the items to the vendor.
Append Items to a Vendor Record
Step 1: Add the Replace All field in your Inventory Item template. To edit, go to Menu> Templates, look for your current template, and click the 3 dots then Edit.
Step 2: Add Item Vendor List: Replace All. Mark to FALSE if you want to append the data without affecting the existing values of the record that you are updating then load the template.
Step 3: On the internal Id column put the internal Id of the items to update.
Step 4: Add the vendor name in the Vendor field, you can type ahead on the cell, choose from the cell operations, or enter the internal ID value of the vendor enclosed in double brackets. Repeat depending on how many items you'd like to add.
Step 5: Mark the lines as FALSE in the Replace All field.
Step 6: Once you are ready, hit Upload > Upload Records to add the items to the vendor.