Importing Vendor Price Lists in...

TL;DR Opening

You can import vendor price lists in NetSuite using CSV files, which facilitates the management of vendor item pricing efficiently. This process supports multiple currencies if the feature is enabled, streamlining updates to vendor records.

How to Import a Vendor Price List

Importing a vendor price list involves several steps, including preparing a CSV import file and navigating within NetSuite to the appropriate vendor record. Follow these steps:

Step 1: Create the Import File

The import file should contain specific fields in a precise order, without a header row. Ensure that each row has values separated by commas or other supported column separators (e.g., semicolon, pipe, space, tab). The required fields for the import file are:

Field Name	Type	Description
Item Name	Text	Essential for the initial import. For updates, the vendor code suffices.
Vendor Code	Text	Up to 60 characters for vendor-specific item naming.
Purchase Price	Currency	The price of the item.
Price Schedule	Text (optional)	The schedule for pricing, if applicable.
Currency	Currency (if Multiple Currencies enabled)	The currency of the price.

Important: All listed items must exist in your NetSuite account, and their names must match exactly.

Step 2: Navigate to the Vendor Record

Go to Lists > Relationships > Vendor.
Click Edit next to the specific vendor record.
Click the Financial subtab.
Click the Items subtab.
Click Import Price List to access the import pop-up window.

Note: The Multiple Vendors feature must be enabled to import a price list.

Step 3: Upload the File

Click Browse and select the vendor price list file you created.
Click Save.

Once the import is successful, the items from the imported vendor price list will appear on the Items subtab alongside their vendor codes and associated prices. The vendor's details will also show in the Vendor subtab of each relevant item's record.

Additional Information

More resources regarding vendor management include:

[Vendor Record Management]
[Enabling the Vendor Access Feature]
[Assigning a Role to a Vendor]

Who This Affects

This change primarily impacts:

Administrators who set up vendor records.
Procurement Managers who maintain supplier pricing information.
Finance Teams handling transactions with vendors.

Key Takeaways

Use CSV files for importing vendor price lists accurately.
Ensure all item names in the CSV file match those in NetSuite.
The Multiple Vendors feature must be enabled for imports.
You can manage item prices in multiple currencies if enabled.

Source: This article is based on Oracle's official NetSuite documentation.

Frequently Asked Questions (4)

Can I import vendor price lists if I have multiple currencies enabled?

Yes, you can import vendor price lists with multiple currencies, but you must ensure the 'Multiple Currencies' feature is enabled in your NetSuite account.

What fields are required in the CSV file for importing vendor price lists?

The required fields in the CSV file are Item Name, Vendor Code, Purchase Price, and Currency (if Multiple Currencies is enabled). The Price Schedule is optional.

Do I need to enable any specific NetSuite features to import a vendor price list?

Yes, the 'Multiple Vendors' feature must be enabled to import a vendor price list in NetSuite.

What should I do if the items in my CSV file do not appear in NetSuite after import?

Ensure that all item names in the CSV file match exactly with those in your NetSuite account, as items must exist in the account with matching names for a successful import.

Importing Vendor Price Lists in NetSuite