This week we received 4 separate calls about Vendor Prices and how to manage them in NetSuite. Autumn is a common time for manufacturers and other market suppliers to raise prices, and evidently many NetSuite users were affected. We have written about this before, but another installment seems like the right thing to do. Vendor prices are the prices a company pays for the products that it, in turn, sells to others. This might be anything from software to cell phones, and everything in between. If you have an item catalog of 10,000 items it may be a real challenge to upload new price lists. Here's a couple of tips to make the job easier. First, the nature of your business will determine how you import new prices. If you buy most, or even some, of your products from multiple vendors, then you should turn on the switch for Multiple Vendors on the Items tab of Enable Features. When you use Multiple Vendors, you can import the price list right from the vendor record, under the Financial Tab > Items. You'll see a Button that says 'Import Price List.' It's very simple and the system directions are good. However, if you do not use multiple vendors, then you can import new prices via the Import CSV records function, under Setup > Import/Export. All you need in your file is a header record with 2 columns: The 'Name' of the item, and the new purchase price. Very straightforward. But, as I learned this week, not everyone understands header records and csv imports. So just a quick tutorial. A header record is the first row of the file. The column names in the header row identify what fields of data you are importing. There should be no rows above the header record and all rows below must have data - so you cannot have an empty row before the data rows begin, or an empty row in the middle of the data. Of course, once all of you data is in the csv file you will have empty rows at the bottom of the file- no worries. This is normal. If you are still having an issue importing vendor prices, then contact a NetSuite Solution Provider for assistance. They should be able to walk you through the process. | 
