How to calculate total price based on different product selection?

  • rsgrafica
    Asked on December 15, 2016 at 4:42 AM

    Hi, i have a printing site and I would need a form that allows me to choose the type of product, paper and quantity.

    according to these characteristics, the form will have to calculate the price of the product.

    Just as on this website:

    https://www.pixartprinting.co.uk/digital-litho-printing/printing-business-cards/

     

    Thank you

     

     

     

  • Chriistian Jotform Support
    Replied on December 15, 2016 at 5:15 AM

    Thanks for contacting us.

    If you would like to create a form based from your requirements, I would suggest you to create an Order Form. In this guide you can see the different types of Order Form: Order Form Types

    Here's a guide on Setting Up Your First Order Form.

    You can also check our available Order Form Templates in this link: https://www.jotform.com/form-templates/category/order-form.

    Do let us know if you need further assistance.
    Regards

     

     

  • rsgrafica
    Replied on December 15, 2016 at 5:45 AM

    thanks for the answer but i need a database that calculate the price of the every single product.

    for example:

    select: 1000 or 2000 or 5000 

    select: type paper1 / type paper 2 / type paper 3

    select: delivery fast / delivery slow

    total price $100

    each product has a different price and needs a database that calculates the final price depending on the selected image.  

    because if I select 5000 cards will have a different price from 5000 flyers

  • emily
    Replied on December 15, 2016 at 6:22 AM

    Hi,

    Unfortunately, we do not offer that feature. However, you can achieve your request by using Conditional Logic. 

    1. I created a simple demonstration with 2 Drop Down fields and a Form Calculation widget.

     

    How to calculate total price based on different product selection? Image 1 Screenshot 80

     

    There are three options for both first Drop Down menu; 100, 200 and 500 and second Drop Down menu; paper1, paper2 and paper3.

    2. Kindly click on Conditions.

     How to calculate total price based on different product selection? Image 2 Screenshot 91

    3. Create New Condition and select Update/Calculate Field.

    How to calculate total price based on different product selection? Image 3 Screenshot 102

    How to calculate total price based on different product selection? Image 4 Screenshot 113

    4. For each option, you need to create different condition. In the below screenshots, 

    For the first option;

    If the number of cards equal to 100 AND paper type is paper1 calculate its price.

    If the number of cards equal to 100 AND paper type is paper2 calculate its price.

    If the number of cards equal to 100 AND paper type is paper3 calculate its price.

    You need to apply these conditions to 200 and 500 as well.

    if the number of cards equal to 200 AND paper type is paper1 calculate its price.

    If the number of cards equal to 200 AND paper type is paper2 calculate its price.

    If the number of cards equal to 200 AND paper type is paper3 calculate its price.

     

     

    If the number of cards equal to 100 AND paper type is paper1 calculate its price.

    How to calculate total price based on different product selection? Image 5 Screenshot 124

    If the number of cards equal to 100 AND paper type is paper2 calculate its price.

    How to calculate total price based on different product selection? Image 6 Screenshot 135

    If the number of cards equal to 100 AND paper type is paper3 calculate its price.

    How to calculate total price based on different product selection? Image 7 Screenshot 146

    You can add more fields and add more conditions according to those fields.

    I hope this helps. Please have a look at the user guides below. 

    https://widgets.jotform.com/widget/calculation 

    https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic 

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    Thank you.

  • emily
    Replied on December 16, 2016 at 9:34 AM

    Hi again,

    Here is the video of the form I created in the previous post.

    How to calculate total price based on different product selection? Image 1 Screenshot 90

    I also created a demonstration including PayPal integration. Please have a look at the screenshots below.

    1. Add PayPal integration to the form. 

    How to calculate total price based on different product selection? Image 2 Screenshot 101

    2. Fill out the credentials needed for the integration and click on Create New Product.

     

    How to calculate total price based on different product selection? Image 3 Screenshot 112

    3. I created 2 products named PaperType1 and PaperType2. 

    How to calculate total price based on different product selection? Image 4 Screenshot 123

    4. To add quantity for your product, click on Add Quantity button. You will be able to select the number of the items you want to purchase.

    How to calculate total price based on different product selection? Image 5 Screenshot 134

    5. Click on Add Option button of the product. Enter the price for the paper type + delivery type as shown in the screenshot below.

    How to calculate total price based on different product selection? Image 6 Screenshot 145

    6. Kindly do these steps for the second product. 

    Enter the price for the paper type 2 + delivery type.

    How to calculate total price based on different product selection? Image 7 Screenshot 156

     

    Please have a look at the video below to see the resulting form.

    How to calculate total price based on different product selection? Image 8 Screenshot 167

    If you need further guidance, please let us know.

    Thank you.