Why does the Special pricing property in Options overwrites main product price?

  • mytotalblend
    Asked on February 6, 2021 at 10:49 PM

    Is there anyway to stop this from happening? When a selection is made, the price listed changes to zero. Then, when an option is selected, the subtotal changes to the option price. This cant happen. Please help me correct this. Thank you.

  • roneet
    Replied on February 6, 2021 at 11:00 PM

    May we know how you would like to set up the product price in the form?

    Do you want to add both the original price and the special pricing together?

    Looking forward to further details.

    Thanks.


  • mytotalblend
    Replied on February 7, 2021 at 9:33 AM

    Hello,

    The set up should be...If I select an item that cost $5 and I would like to add an optional item that cost $3, then the subtotal should be $8, not $3.

    For example, the selected price of $5 disappears when the optional price of $3 is selected also, and that should not be the function.

    The set up is the way I want it displayed, but the function is not correct.

  • Richie JotForm Support
    Replied on February 7, 2021 at 11:43 AM

    I have checked your form and it seems you have already set the product with special pricing.

    1612716133 6020186542d93 1 Screenshot 10

    The sub total is also correct.

    Please check again and let us know how it goes.


  • mytotalblend
    Replied on February 7, 2021 at 4:38 PM

    No, the subtotal is not correct.

    The example presented should first display $5.00, not $0.00. (The item selected cost $5.00 first.)

    Then, when you select an option in this example of $3.00, the subtotal should display $8.00 ($5.00 + $3.00 = $8.00).

    I do not want the special pricing of the option to override the main price.

    Please help me to correct this function.


  • roneet
    Replied on February 7, 2021 at 9:27 PM

    These special prices override the general price set for the product.

    If you actually intend to use special prices, you will have to ignore the default pricing and change the prices through the special pricing table.

    You may directly add the total amount in the Special Pricing option.

    For example, on the selection of Almond Milk, you may directly show the product as $8 that is 5+3:

    1612751208 6020a1686c6c0  Screenshot 10

    Thanks.

  • mytotalblend
    Replied on February 7, 2021 at 10:10 PM

    Yes, that is a temporary solution.

    The problem that continues is when the customer selects the main item that is $5.00, and do not want the optional selection...then the main item price of $5.00 disappears to $0.00.

    That should not happen.

    Also, the $5.00 does not appear in the item subtotal, the subtotal, and the Total.

    What is the correction or another solution?

  • roneet
    Replied on February 7, 2021 at 11:24 PM

    Another solution would be to configure the products outside the payment field.

    1) You will need to split your products into native fields such as "Single choice" or "Multiple Choice" fields, and assign a value to each option: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    2) You can show the products based on user's answers by applying conditions: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    3) Next, perform the calculations: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    4) Pass the total to the payment field: https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

    Let me share a demo form with you.

    Thanks.


  • roneet
    Replied on February 10, 2021 at 11:51 AM

    Please check this demo form:

    https://form.jotform.com/210377935576971

    1612975673 60240e397d842 888888888 Screenshot 10

    I have assigned the prices in the Multiple choice and dropdown button.

    Next, using the Form calculation button, I have written formula to calculate the sub-total.

    Syntax is--> subtotal=Price for option+(Quantity*Price for Liquid Base)

    Let us know if this would work for you.

    Thanks.