Bulk pricing

  • Resolved philsafc

    (@philsafc)


    4 years, 7 months ago

    Hi

    How do I do bulk pricing? So the price decreases depending on quantity.

    ie

    if someone buy 1-10 apples the cost is: number-of-apples * £1
    if someone buys 11-20 apples the cost is: number-of-apples * 0.50

    So if someone bought 5 apples they would pay £5 total (£1 per apple)
    if someone bought 20 apples they would pay £10 total (50p per apple)

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    4 years, 7 months ago

    Hello,

    You can use conditional statements or conditional operations in the equations. For example, assuming the quantity field is the number field fieldname1, the equation would be similar to:

    fieldname1*IF(fieldname1<=10,1,0.5)

    You can nesting multiple “IF” operations:

    fieldname1*IF(fieldname1<=10, 1, IF(fieldname1<=20, 0.5, 0.45))

    Best regards.

    Thread Starter philsafc

    (@philsafc)

    4 years, 7 months ago

    Hi thats perfect.

    Can i also add a minimum price. So if they buy any amount of apples up to 10 for example the price is £10 no matter what. So 1 apple is £10. 5 apples is £10.

    Then when they get to 11 the bulk pricing kicks in as above.

    the image here is what I want to do

    View post on imgur.com

    • This reply was modified 4 years, 7 months ago by philsafc.
    Plugin Author codepeople

    (@codepeople)

    4 years, 7 months ago

    Hello @philsafc

    Yes, of course. You can use the MAX operation to ensure you charge a minimum value. Continuing with the previous example, and assuming you want to charge a minimum of $5, the equation can be edited as follows:

    MAX(5, fieldname1*IF(fieldname1<=10, 1, IF(fieldname1<=20, 0.5, 0.45)))

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Bulk pricing’ is closed to new replies.