This tutorial will instruct how to import a Pricing update for inventory items.
​

A common task is to update Pricing on current products.

Requirements

1. A “NetSuite Pricing Update Import” .csv file
2. NetSuite account with Administrative access

NetSuite

1. In NetSuite, navigate to Setup > Import/Export > Saved CSV Imports (click on Saved CSV Imports)
2. Locate “Item - Pricing Update (Product Manager)” in the list, right-click & open in a new tab.
3. In Import Assistant, verify default fields [in italics] & complete steps as follows:

• 1 Scan & Upload CSV

• Import Type = Items
• Record Type = Inventory Items
• Character Encoding = Western (Windows 1252)
• CSV Column Delimiter = Comma
• CSV File(s) = One File To Upload

• Click the “Select…” button
• In pop up window, navigate to the csv file, select & click Open button

• Click “Next>” button
  
  

• 2 Import Options

• All default options are set.
• Click “Next>” button
  
  

• 4 Field Mapping

• Your Fields : Verify that any pricing fields you want updated are marked with a green check. This indicates that the CSV field values are being mapped to Netsuite.
• Click the “Next>” button
  
  

• 5  If you need to add additional pricing tiers, locate ‘Item - Pricing’ within the Netsuite field section and click on the + icon. Add the following fields:
  

• Price (Req) - This will need to be mapped to the price field on your CSV
• Price Level - You will need to manually set this value by clicking on the pencil icon within the mapping list. Select the pricing tier in which it applies.
  
• Quantity (Req) - Should always be 0.
  
  
  
      

• 5  Run Mapping & Start Import

• All default fields are set
• Click the dropdown button in lower right corner & select “Run”
  ***Do NOT select “Save As & Run” or “Save As”

• A pop up will appear “Data you entered…...Press OK to proceed”, click OK button

4. CONFIRMATION SCREEN:  Right-click the “Import Job Status” hyperlink, and open in a new tab.

5. JOB STATUS Page:

• Filters : Date > verify it is set to today’s date
• File update will appear in the job queue:  Status = “Processing”  and Percent Complete “XX.X%”.  
• Periodically click “Refresh” button until import is completed  [Status = “Complete”]
• Check MESSAGE column, verify that all records imported successfully.
  
  
  
  

• ***IN THE EVENT THERE WERE ERRORS IN THE IMPORT [as pictured above]:

• Click the “CSV Response” hyperlink.  A Results file will be automatically downloaded.
• Open the Results.csv file in Excel and determine cause of error(s)
• Rename the Results.csv file to “original files name_RESULTS.csv”, email this error list back to the original creator of the update.