Payment Forms > Coupons/VAT: Ability to discount specific product quantity

  • Group_hana
    Asked on March 17, 2021 at 8:10 AM
    Coupons / Discounts - it was previously working in tests where I wanted to give a fixed amount off a ticket price. The tickets are £149 inc. 20% TAX and I want this WHOLE AMOUNT to be deducted from their price using codes. I've tried it a few ways, one is to fix the discount and apply to the Product and the other to the subtotal, neither works in the way that it should i.e. if it's product it takes it from all of them and therefore if someone orders 2 they pay nothing! If I do it from the subtotal it still adds 20% tax on top for the discounted tick
  • Jovanne JotForm Support
    Replied on March 17, 2021 at 8:57 AM

    Hi,

    To my understanding, you wanted to add a 100% discount if the user applies a coupon to the product. You can add a 100% discount rate to the products.

    1615985572 6051fba4798ad  Screenshot 10

    Please refer to this guide for more information.

    GUIDE: how-to-add-coupon-code-to-payment-forms

    Let us know if you need further assistance.

  • Group_hana
    Replied on March 19, 2021 at 8:47 AM

    Hi all


    Thanks for this and no I didn't want to do 100% discount as such. The tickets are £149 inc. VAT each. If someone buys 2 they should just pay £149 if they have a discount for 1.

    Some vouchers will be for 2 x £149 and some for £149 hence using the fixed price instead of the % discount.


    Any ideas to help further please?

  • Patrick_R
    Replied on March 19, 2021 at 10:36 AM

    Hello!

    - Thanks for this and no I didn't want to do 100% discount as such. The tickets are £149 inc. VAT each. If someone buys 2 they should just pay £149 if they have a discount for 1.

    Kindly note that you can created fixed amount discount coupons but it won't be possible to automatically apply discount based on how many products are being ordered.

    One solution to this is to use user defined payment method and this way you can use CALCULATE conditions to apply discount this way. The calculated amount can then be passed to the payment widget for billing the user.

    You'll need to create your own product list. You can use input tables or inventory widget for this purpose.

    Guide: how-to-pass-a-calculation-to-a-payment-field

    Here is a demo form that uses Inventory widget and user defined payment method to calculate and bill the user: https://form.jotform.com/61471146729964

    Does this answer your concern? If not, then please provide more details of your requirement.

    Thank you!

  • Group_hana
    Replied on March 19, 2021 at 12:24 PM

    Thanks it doesn't look like I can discount these though i.e

    I am selling tickets to an event. A few people will be given a CODE to get a discount for tickets to this event, the discount has to be fixed to 100% of a SINGLE ticket cost (£149). This code will be SECRET so the discounted tickets cannot be publicly available (which it looks like this inventory is as it doesn't allow for a code). Please advise?

    For a further example.

    JUDGES of the awards will be given 1 FREE TICKET = £149. If they want to buy additional tickets (however many they want) these will be paid.

    SPONSORS of the awards will be given 1-3 FREE TICKETS depending on what sponsor level they have so ranging between £149 - £447 discount. They may also want to buy additional tickets so I only want the range of £149 - 447 fixed as a discount off their total with their COUPON CODE.

  • Patrick_R
    Replied on March 19, 2021 at 2:34 PM

    Hello! Kindly note that it is possible to implement this functionality in Inventory widget as well but in your case, maybe that won't be required.

    In the product list widget, you can have just one product entry for the Ticket; then create FIXED discount of £149 (£124.17 + £24.83) and set 'Minimum Order Amount for Discount' to £149 (as shown in the screenshot below). This way, the discount can only be applied if user is ordering more than one ticket.

    1616178776 6054ee58c1e20 The Easiest Onl Screenshot 10

    For Judges you can use this coupon and for sponsors you can create FIXED discount coupons for different levels and set 'Minimum Order Amount for Discount' for these coupons accordingly.

    Let us know if this doesn't solve your purpose.

    Thank you!

  • Group_hana
    Replied on March 21, 2021 at 1:06 PM

    Thanks, yes that's not working as its not accepting the minimum amount as the min amount of £149 includes 20% VAT. If I set it to £124.17 as the minimum amount it adds the VAT on still (which is so odd as there's no spend!!) Doesn't really look like there's a way to do it... and I find that odd as fixed amount should surely work in all scenarios and not charge VAT?

    1616346340 60577ce4d5c44 Capture Screenshot 10

  • jonathan
    Replied on March 21, 2021 at 7:49 PM

    We apologize for inconvenience. Please note that the previous suggested workaround by our colleague will only work if the order is more than one(1).

    Example, the fixed discount amount of 149.00 will only apply if the Qty is 2.

    1616370501 6057db453d6fd zzz 2021 03 22 Screenshot 10

    Please test this form https://form.jotform.com/210797353759974

    Let us know why it does not work for what you need.

    We will wait for your updated response.



  • Group_hana
    Replied on March 22, 2021 at 5:24 AM

    Thanks for this, if you look it's still adding the VAT on for the ticket you've not bought though or adding in more VAT than it should - would be good to get this part developed so it works better with VAT as that seems to be the sticking point here. E.g. for a £149 total the VAT should be £24.83 and it's showing as almost £50 which is inaccurate and will then give them an inaccurate claim on HMRC here.

  • jonathan
    Replied on March 22, 2021 at 7:09 AM

    I apologize, but I am confused as to what you meant about the VAT.

    Are you saying that there should be no VAT amount?

    1616411276 60587a8cbd0a7 zzz 2021 03 22 Screenshot 10

    As far as I know, the VAT is mandatory on any type of payments.

    Please elaborate further how you meant and we will check again.

  • Group_hana
    Replied on March 22, 2021 at 8:43 AM

    Hi there, it is mandatory BUT it shouldn't be added where this is no ticket there e.g. the VAT of a ticket at £124.17 is NOT £49.67. The system is adding the wrong amount of VAT in, as if it were two tickets so it's throwing that off. The total is also not correct, at £149.01!

  • Jovanne JotForm Support
    Replied on March 22, 2021 at 9:53 AM

    Hi,

    I have checked your form and the Payment field calculation appears to be working correctly on my end.

    1616421192 6058a1480b9e6  Screenshot 10

    Could you please recheck and let us know if the issue persists?

  • Group_hana
    Replied on March 22, 2021 at 9:56 AM

    Yep, it works perfectly when there is no discount involved. But if you look at my above example the VAT for 2 tickets is incorrect as it should equate to the VAT of 1 ticket as in your example i.e. 1 x ticket is TOTALLY FREE with a coupon for 1 ticket; no VAT should be added to it. It should be subtotal, £0 and VAT £0 for that 1 and then for the payable ticket the same as a single ticket.

  • Jovanne JotForm Support
    Replied on March 22, 2021 at 11:17 AM

    Hi,

    Please allow me some time to check on this, and I will get back to you as soon as I have more information.

    Thank you.

  • Jovanne JotForm Support
    Replied on March 22, 2021 at 11:29 AM

    Hi,

    I have applied the coupon "JUDGE" to the order form, and it appears that the VAT and Subtotal equate to zero..

    1616426913 6058b7a16af04  Screenshot 10

    Could you please give us more details about each coupon's requirements so we can assist you properly?

    We look forward to your response.

  • Group_hana
    Replied on March 22, 2021 at 12:18 PM

    Thanks, yes this is not right though as the CODE should only discount 1 x ticket. Not 2, and then the VAT should only be present for 1 x ticket and not the 2 i.e. the discounted one is free.

  • Sonnyfer JotForm Support
    Replied on March 22, 2021 at 5:48 PM

    Unfortunately, you can only apply a discount on the checked products regardless of the quantity/product selected.

    1616449578 6059102a91e83  Screenshot 10

    The same goes for the VAT. You can only select a product to exempt, not a quantity.

    1616449696 605910a059ae5  Screenshot 21

  • Sonnyfer JotForm Support
    Replied on March 22, 2021 at 5:50 PM

    In addition, I must say the idea could be a great addition to our Payment Integration features so I'll be forwarding this ticket to our developers as a Feature Request. Though we cannot guarantee a timeline of implementation, rest assured you'll be apprised here of any updates.

  • Group_hana
    Replied on March 24, 2021 at 5:11 AM

    OK thanks, it would definitely be good as as it stands right now it's not fully functional so I've had to use discounts very manually.