ANS-0068 · SAVED SEARCHES & FORMULAS
How to Export Item Pricing Data in NetSuite for Re-import
NetSuite users can efficiently export item pricing data using a dedicated 'Pricing' search, which is ideal for subsequent re-import operations.
Short answer
To export item pricing in NetSuite, use a saved search of type 'Pricing'. This method directly retrieves all necessary pricing information without complex joins from item records. It is particularly effective when the exported data is intended for re-importation, simplifying the process and ensuring data integrity.
Scenario
Users often require the ability to export item pricing data from NetSuite. This need typically arises when preparing for mass updates, migrations, or when the data needs to be re-imported into NetSuite at a later date. The challenge is to find an efficient and direct method to extract this specific information.
Solution
When the export of item pricing is required, especially for subsequent re-importation, NetSuite provides a direct method. Users can create a saved search of type "Pricing". This specific search type is designed to return all relevant pricing information directly, eliminating the need for complex joins from the item records themselves.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support