Scenario

A user wants to blank out the Purchase Price field for multiple items simultaneously due to thousands of records with existing purchase prices.

Solution

This can be achieved by executing a CSV import to set the Purchase Price field to blank.

1. Create a Saved Search with the following Criteria.
   
   Note: The user can add or update the Filters according to user requirements.
2. Under the Results tab, click Remove All button
3. Add Purchase Price field
4. Click Save & Run
5. Export the results as an Excel File
6. Access the file and save it in CSV Format, then set a name (e.g., Update Purchase Price.csv)
7. In NetSuite, go toSetup>Import/Export>Import CSV Records
8. Import Type:SelectItems
9. Record Type:SelectInventory Item
10. CSV File:Select the CSV File created in Step 3.
11. ClickNext
12. Data Handling:SelectUpdate
13. ClickNext
14. Field Mapping:Click thePencil Iconbeside thePurchase Pricefield as seen below:
    
15. Default Value:SelectSet Value to Null then clickOK
    
16. ClickNext
17. EnterImport Map Name
18. ClickSave & Run