Skip to main content
All CollectionsExtendInsights for Data Management NetSuiteBusiness Use Cases
Managing Vendor Price List via ExtendInsights Data Management
Managing Vendor Price List via ExtendInsights Data Management

ExtendInsights Data Management | Learn how to manage vendor price list

Updated over 3 months ago

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.

Did this answer your question?