Importing a Vendor Price List

On the vendor record, you can list items available from that vendor and specify the vendor codes and prices for that item. You also can use CSV import to import vendor price lists from an existing comma delimited file.

If you use the Multiple Currencies feature, you can import prices for an individual item in multiple currencies.

For more information, see Vendors and Multiple Currencies.

To import a vendor price list:

1. Create the import file.

   The import file should contain the following fields in order, with no header row:

   Note:

   For the import to succeed, each row of the CSV file must contain values separated by commas or other supported column separators. For example, semicolon, pipe, space, and tab.

   • Item Name (For initial import, the item name must be present. For later updates, it is not required as the vendor code is used to identify each item.)

   • Vendor Code (If your vendor uses a name for this item that is different from the name you use, note the following. You can enter up to 60 characters as the vendor's name for this item.)

   • Purchase Price

   • Price Schedule (optional)

   • Currency (This field is present only if you use the Multiple Currencies feature.)

   Important:

   The items listed in the file must already exist in your NetSuite account and the names must exactly match those in your account.

2. Go to Lists > Relationships > Vendor.

3. Click Edit next to the vendor record.

4. Click the Financial subtab.

5. Click the Items subtab.

6. Click Import Price List.

   The Import Vendor Price List popup window opens.

   Note:

   You must use the Multiple Vendors feature to import a price list.

7. Click Browse and go to the vendor price list file.

8. Click Save.

Upon successful import, each item from the imported vendor price list is listed on the Items subtab with the associated vendor codes and prices. The vendor record also is displayed on the Vendor subtab of each item's record with the vendor name, vendor's item code and purchase price.

Additional Information

• Vendor Record Management

Related Topics

• Enabling the Vendor Access Feature
• The Vendor Center Role
• Assigning a Role to a Vendor
• Giving Vendors Access to Time Tracking
• Vendor Records for 1099 Contractors
• Vendor Credit Limits
• Associating a Vendor With an Item
• Associating a Vendor With a Payroll Item
• Preferred Transaction Delivery on Vendor Records
• The Multiple Vendors Feature
• Vendor Record Configuration

General Notices