Sliding Scale for Pricing

[bdphifer]

Is there a simple way to have a pricing point for a product based on number of products sold?

Something like:

1-10 - $100
11-15 - $90
16-20 - $80
etc.

I know I can set up different products and then use the correct version, but I'd like to automate it to avoid errors.

Thanks!

[comment]

Is this related to the FM Starting Point product, or are you asking in general?

[bdphifer]

7 hours ago, comment said:

Is this related to the FM Starting Point product, or are you asking in general?

I was looking to use it with FMSP. 
 

Thanks for any help you can give!!

Edited December 24, 2020 by bdphifer

[comment]

I am afraid I know nothing about FMSP.

In general, you need a pricing table - which in your example would look something like:

ProductID	From	Price
123	1	100
123	11	90
123	16	80
123	21	70

Then lookup the price from this table using a relationship defined as:

LineItems::ProductID = Prices::ProductID
AND
LineItems::Quantity ≥ Prices::From

with the records on the Prices side sorted by From, descending.

 

[bdphifer]

Perfect. I was thinking about Starting Point as a program, forgetting that it was still within FM.
 

Yeah. Gotta work on that!  😁

Thank you!!!