General structuring question. We're looking to restructure our pricing model to have 3 pricing levels, (3 tiers). Each tier will have specific markup percentages for each product category. Each customer will be assigned to a tier and the price for each item will be calculated based on looking up the markup percentage of the associated tier and category (price group). What would be the recommended way of setting up this "table" of markup percentages using the price tier and category? Is there a better way to go about this?

This is standard price level set up as far as I know.

Nice, glad to know we're moving in the right direction. And what would be the way to set up this reference table in NetSuite?

You already have a price level sublist in netsuite. You need to configure it beforehand with the Quantities you plan to use.

Can you expound a bit on that please?

message has been deleted

Got it, so we're looking to do more than that. We want to configure the price for each level per item, based on a specific markup percentage assigned to that item category and that specific price level

You want to only configure the first column, and the others populate automatically ?

We don't do different pricing by quantity.

So you would be using price levels as tier pricing ?

Correct.

And you want the prices to calculate automatically considering the same percentage always ?

It should be in

Setup -> Accounting -> Accouting Lists -> Price Level

To switch over, we would do a mass price change/CSV import. And then I would write some kind of Suitelet/Restlet that would calculate the prices using search/lookup when creating a new item.

all you need to do is setup base price on each item

@Sandii So I would use to create the 3 tiers but the amounts would hard coded based on looking up the markup percentage from a table. Kind of 2 steps, instead of 1.

This is native NS behavior, there is no special customization needed

The thing is that management doesn't like the idea of using base prices. They want the prices to be pulled off of the vendor cost and marked up specific percentages.

Right, customize that part to get base price set on item level

That's what I was pushing. But accounting and sales didn't like that because then the price levels are a mark up based off of a markup.

That's pretty common behavior, if you base (basically 0% markup) needs to be calculated for each item based upon purchase price/tariff/tax/etc, then you need to script/workflow on item record to set the 0% price

So that would mean a base price and many price levels. The problem with that is they customer's aren't assigned to one price level. They're assigned to price level specific to the item category.

You can put a default price level on the customer level, and then when making the sales order, you select the price level per item to override

Got it, so we're looking to make the transaction work flow and maintenance as smooth as possible. I'll bring these options to management.