Support » Plugin: Calculated Fields Form » Price Calculator varying quantity

  • Resolved philsafc

    (@philsafc)


    Hi

    How can I create a pricing calculator or slider where the number of items purchased affects the price in the following way.

    For example:

    I want to sell apples at £2 each if a customer buys 1-20 apples.

    If they buy 21-50 apples I want to charge them £2 for the first 20 and then £1.75 each for the rest.

    If they buy 51 to 100 apples I want to charge them £2 for the first 20, £1.75 for the numbers 21-50 and then £1.50 for apples 51-100.

    Example total if they buy 100 = (20×2) + (30*1.75) + (50*1.50)

    • This topic was modified 1 month, 1 week ago by philsafc.
Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @philsafc

    The process is really simple. Assuming the fieldname1 is the number or slider field for the quantity, the equation’s code would be:

    
    MIN(fieldname1,20)*2+MAX(MIN(50,fieldname1)-20, 0)*1.75+MAX(fieldname1-50,0)*1.5
    

    And if you want the result with two decimal places:

    
    PREC(MIN(fieldname1,20)*2+MAX(MIN(50,fieldname1)-20, 0)*1.75+MAX(fieldname1-50,0)*1.5, 2)
    

    Best regards.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.