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!

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

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, 20205 yr by bdphifer

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.

 

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

Yeah. Gotta work on that!  😁

Thank you!!!