In NetSuite, you have the ability to define Price level for item record types. Item price level is a great benefit in NetSuite because it will allow you to define the rate of the items within transaction(s) by selecting the correct price level defined on Item records.
NetSuite Path: List >Accounting> Items
Updating pricing is not yet available in the newer CloudExtend Excel for Data Management application therefore we will need to rely on the legacy product called "SmartClient" which is available free of charge to customer that license our Enterprise Edition.
In this video, we will show you how to update the base price level for inventory records.
๐จ SmartClient still exists for some edge cases not supported by CloudExtend Excel Data Management for Netsuite. We expect to reach full feature parity between editions in 2022 at which point we will provide notice that we will end of life the SmartClient Classic Edition).
What fields are needed to update Price Level using Using SmartClient?
Step 1: Generate a template using Inventory Item record type then Add the Item Id.
You can add more standard and custom fields depending on your requirements.
Step 2: Select Sub-List Pricing Matrix to update Price Level and hit Next.
Step 3: Select the fields to be used and configure the template.
Template Fields
Basic Requirements to update Price Level is to use the following fields:
Price Level
Currency
Price
Quantity
Replace existing lines when updating
Replace Existing Lines When Updating is enabled by default. If you want to load individual price levels as shown in the video, then you will need to uncheck it, so the system will not override the existing price levels.
Results Layout
Select Standard.
Once configured, you are ready to load the template. Hit Finish.
Managing Price Level
This how your template will look like on the initial load.
To update the base price level, replace the Price Level fields with Base Price and populate the currency and price. Enter the NetSuite internal Id of the items to update.
This will update the to 1000 to all items.
See snippet on how to update using SmartClient Legacy application.