Jump to content

Recommended Posts

  • Newbies

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!

Link to post
Share on other sites

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.

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.