What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Quantity with special pricing does not calculate correctly. For quantity 0 it does calculate the amount.Asked by priromeiro on November 16, 2014 at 08:07 AM
I have a very troubling issue. The total on the form appears to be calculating correctly on the webpage but is sending a incorrect total to my customers in the order confirmation.
This is causing some major headaches.
incorrect total Order confirmation total too high
This is being caused by the payment field's settings. For each product, unchecking the Required and Selected by default boxes (shown below) will correct this.
Save the form after you've made the changes and it should total the orders correctly.
My apologies. The image in my last reply isn't being displayed. Here it is again:
Thank you for your reply.
Unfortunately, I require all fields to be filled – I use the excel export of my orders to populate my CRM tool. This helps me distinguish what is product 1, product 2 etc. from the text fields. When not all products are selected this logic no longer works….
This had worked fine for me for several months until last week. What changed? I would be very appreciative if you could help find me a creative, workable solution.
Ph 5416 8556
- New Menu on Fridays -
Description: Description: Description: cid:image003.png@01CFCE11.428DAA20
Well it took quite some time for me to figure out this issue.
Did you make any changes to your form recently? The issue is caused because of the special pricing you have set in your form. Please check the screenshot below:
Since all your purchase order products are selected by default and the quantity "0" is selected as well, it always displays the amount in the submission page even if the quantity is "0".
There are two issue here:
1. Your special pricing of products based on quantity is not correct which you need to resolve.
2. There seems to be some glitch where quantity field with special pricing does not calculated properly. The quantity "0" should not display any value.
I am reporting it to our back end team. We will get back to you as soon as we have any update form them.
For now, you may like to set right your form quantity calculations and set the amount for quantity "0" as zero only instead of any amount..
All the items in your payment form except "Antipasto Salad" do not have real quantity options. Rather, these quantity options are actually "custom" options. If you try to add an option to them, you will see that the "Quantity" option is still available.
For "Antipasto Salad"
For everything else
In short, the reason why the "0" quantity is still calculated is because the form does not recognize it as a quantity.
To resolve, simply replace them with real quantity options.
Hope this helps.
Thank you for the reply.
Please see where the Salad used to be. Now it is the sweet potato mash.
You will notice that price only changes when an order of 2 or above is entered. Both 0 and 1 contain show $0….?
I created a cloned version of your form here: http://form.jotformpro.com/form/43235077625960
And as suggested by @NeilVicente, I removed all the "custom" options for your products and added quantity properties for each product and the calculations are being made correctly.
Please take a look at it and let us know if it works for you.
Feel free to clone this form if you want to.