The quick answer
Go to Lists > Mass Update > Swap Prices Between Price Levels. Pick one level in the first Price Level field and the other level in the second, then click Save. NetSuite exchanges the prices stored in those two levels for every item that has them, in every currency and quantity column, as soon as you save. Only the two levels you pick change. The page has no preview and no undo, so export the current prices first.
This is the fix for one specific mistake: a price import or mass edit put one level's prices into another level's column, so the two levels hold each other's prices. Instead of correcting items one at a time or rebuilding the import file, you swap the two levels back in one save.
The example company is Fernhill Coffee Works. An import loaded the online prices into List Price and the list prices into Online Price, so every brewing item shows an Online Price higher than its List Price. All people, companies, items and prices in the screenshots are fictional example data.
Before you start
The account needs the Multiple Prices feature, both price levels have to exist and be active, and your role needs access to item mass updates and to item pricing. The example uses the Administrator role. If you'll run this with a custom role, check that it can see the menu entry first.
Export the current prices before you save, with the item, price level, currency, quantity and price on each row. The swap applies immediately to every item with prices in either level, including items you didn't look at. It has no criteria, so you can't limit it to a class or a few items. Running the same swap again puts the prices back only if neither level changed in between.
Swap two levels whose prices are entered by hand. A level with a Default Discount % is calculated from the base price, and NetSuite can recalculate it later and overwrite whatever the swap put there, so don't pick one. The swap also doesn't change any level's Default Discount % setting. If you swap the base price level, NetSuite may not refresh the stored prices of the calculated levels you left out. Handle them separately, as described in step 06.
01 · Check the reversed prices
Go to Lists > Accounting > Items.
The example uses a list view called Price Review that shows Base Price next to Online Price. Base Price is the value of the base price level, which this account names List Price. You can build a view like it with Edit View, or skip the list and check items one by one.
The five brewing items read, Base Price first:
- BR-110 Gooseneck Kettle: 41.50 and 46.00
- BR-125 Conical Burr Grinder: 132.00 and 149.00
- BR-140 Glass Carafe 1L: 22.75 and 26.00
- BR-155 Espresso Tamper 58mm: 31.00 and 35.50
- BR-170 Cold Brew Tower: 214.00 and 239.00
Every Online Price is higher than its Base Price. The two levels hold each other's prices.
02 · Check one item's pricing matrix
Click BR-125 Conical Burr Grinder and open the Sales / Pricing subtab. In the US Dollar matrix, List Price is 132.00 and Online Price is 149.00. Dealer is 118.00 and Wholesale is 99.00. Those two are correct, and neither has a Default Discount %, so they're hand-entered levels that the swap should leave alone.
Look at one item like this before every swap. It tells you which levels are wrong, which are right, and whether any of them is calculated from a discount.
03 · Open Swap Prices Between Price Levels
Go to Lists > Mass Update > Swap Prices Between Price Levels. It sits just below Update Prices, which raises or lowers prices by an amount or percentage instead.
The page has two Price Level fields, Save and Cancel. In this account, both fields start on the base price level, List Price. The warning says the action will affect the pricing of all the items in these price levels.
04 · Choose the two price levels
Leave the first Price Level on List Price. Open the second Price Level and select Online Price. The order of the two fields doesn't matter; the prices are exchanged either way.
Check the pair before you go on. Picking Dealer by mistake would swap two levels that were right.
05 · Save the swap
Click Save. NetSuite swaps the prices right away, and in the example it returns to the Items list. In the Price Review view, every row has traded its two prices. Base Price and Online Price now read:
- BR-110 Gooseneck Kettle: 46.00 and 41.50
- BR-125 Conical Burr Grinder: 149.00 and 132.00
- BR-140 Glass Carafe 1L: 26.00 and 22.75
- BR-155 Espresso Tamper 58mm: 35.50 and 31.00
- BR-170 Cold Brew Tower: 239.00 and 214.00
06 · Confirm the item's pricing
Click BR-125 Conical Burr Grinder and open Sales / Pricing again. List Price is now 149.00 and Online Price is 132.00. Dealer is still 118.00 and Wholesale is still 99.00, because only the two selected levels change.
Check the result
- Items list: Base Price is higher than Online Price on all five items, starting with 46.00 and 41.50 for BR-110.
- BR-125: List Price 149.00 and Online Price 132.00.
- Other levels: Dealer 118.00 and Wholesale 99.00 haven't moved.
If your items price in more than one currency or use quantity breaks, check a representative item in each currency and quantity column you use.
If any price level carries a Default Discount %, it wasn't part of the swap. Because the base price changed, open that price level, use Update Existing Prices if existing item prices should follow the new base price, and then check an item.
Sales orders, invoices and other transactions you already saved aren't repriced. New transactions pick up the swapped prices, and so can an existing transaction if you edit it in a way that makes NetSuite source the price again. The swap doesn't change which price level a customer is assigned, customer-specific item prices or pricing groups, so a fixed customer price or a manually entered rate can still override the swapped item price on a new order.
For other ways to change item prices, see how to raise item prices by a percentage and how to set up quantity pricing with price levels.
Common questions
Can I undo a price level swap?
Not from the swap page. It has no preview and no undo, so export the prices before you click Save. Running the same swap again puts the prices back only if neither level changed in between.
Does swapping price levels affect every item?
Yes. Every item with prices in either of the two levels is swapped, including items outside the list view you checked. The page has no criteria, so confirm the pair before you save.
Can I swap prices for only some items?
No. The swap covers every item in the two levels and can't be limited by item, class or any other criteria. If only some items are wrong, fix those items directly or correct them with a targeted CSV import.
What happens to discount price levels when I swap the base price level?
Only the two levels you pick are swapped, so a level with a Default Discount % keeps its stored prices. Those prices were calculated from the old base price. To recalculate them, open that price level and use Update Existing Prices, then check an item.
Will existing sales orders be repriced?
No. Saved sales orders, invoices and other transactions keep their rates. New transactions use the swapped prices, and an existing order can pick them up if you edit it in a way that makes NetSuite source the price again.
Does the swap change customer pricing?
No. A customer's assigned price level, customer-specific item prices and pricing groups stay as they were. The swap only exchanges the item prices stored in the two price levels.
Does the swap cover other currencies and quantity breaks?
It swaps the prices stored in the two levels, including the matching currency and quantity columns in each item's pricing matrix. Check one item's Sales / Pricing subtab in each currency and quantity column you use afterward.
When should I use Update Prices instead?
Use Swap Prices Between Price Levels when two levels hold each other's prices. Use Update Prices when you want to raise or lower prices by an amount or a percentage, or change only the items that match criteria.
Why don't I see Swap Prices Between Price Levels in the menu?
The account needs Multiple Prices turned on, and your role needs access to item mass updates and item pricing. If either is missing, the entry won't appear under Lists > Mass Update. Ask an administrator to check the feature and your role.