We need to use the Inventory Item record type to update the vendor items in NetSuite via CloudExtend Excel Data Management for NetSuite. It is a workaround to use Inventory Item when updating the Vendor sublist.

There are multiple ways to manage your Vendor Prices using CloudExtend, also outlined in this article.

Watch the video below to learn how!

💡 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:

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 CloudExtend 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.

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 CloudExtend 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.

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.