How can I set a cap for the amount of products left to sell?

  • florencejhill
    Asked on September 14, 2017 at 10:35 AM

    Hello, our customers fill out a form online to order bunches of flowers from us. We pre-make a certain amount of bunches throughout the week and we would like to be able to enter the amount of units left so that people cannot place an order once these have run out. At the moment we have to do this by manually counting orders which means monitoring these at all hours!

    The only problem we have is that customers can order a small sized bunch (1 unit) or a large sized bunch which counts as 2 units, so the form would need to recognise when someone orders a bigger bunch and to account for this being 2 units.

     

    Are you able to help us set this up?

    Thank you!

  • John_Benson
    Replied on September 14, 2017 at 12:13 PM

    Hello,

    You can use the Inventory widget to track the number of the product that is still available. For more information about the Inventory widget, please visit this link: https://widgets.jotform.com/widget/inventory

    After that, you need to use the Form Calculation for the Total price. For more information, please visit this link: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    Lastly, you need to pass the Form Calculation total to the Payment field. To do that, please follow this guide: https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

    If you have any questions, please contact us again.

  • florencejhill
    Replied on September 20, 2017 at 10:11 AM

    Thank you for this. Please view the image I have attached. We are already asking people to select a regular bunch or a bigger bunch in the 'my products' field. I don't want customers to have to select again how many regular / large bunches they would like as this would be answering the same question twice - can we incorporate the inventory widget to the my products section? Or do we need to remove the My Products section and replace with the inventory widget?


    Thanks


    How can I set a cap for the amount of products left to sell? Image 1 Screenshot 20

  • florencejhill
    Replied on September 20, 2017 at 10:22 AM

    Customers can only buy one product at a time so we don't really need them to select a quantity from a drop down menu - ideally, we want jotform to know if the customer selects 'regular' this counts as 1 and if they select 'bigger' this counts as 2 - is that possible?

  • John_Benson
    Replied on September 20, 2017 at 12:41 PM

    Unfortunately, you cannot incorporate the Inventory widget inside the payment field. 

    Do we need to remove the My Products section and replace with the inventory widget?

    If you want to use the Inventory widget, I suggest to remove the Products in the Payment field and use the widget so it will not get duplicated.

    You can check the demo form on this link: https://form.jotformpro.com/72624828747973

    In the demo form, I added the form calculation widget and use the pass the value to another field condition. 

    How can I set a cap for the amount of products left to sell? Image 1 Screenshot 30 How can I set a cap for the amount of products left to sell? Image 2 Screenshot 41

    You can clone my form if you want to check the configuration and settings by following this guide: How-to-Clone-an-Existing-Form-from-a-URL

    Can the customers buy one product at a time?

    Yes, you need to change the settings of the Inventory widget of the Quantity range.

    I hope this information helps. If you 

  • florencejhill
    Replied on October 6, 2017 at 6:05 AM

    Thanks John. What we really need to do is use the inventory widget, with 2 products, but where the first product reduces our inventory by "1" and the second reduces our inventory by "2". Is this possible? Our second product is basically a double version of our first so despite having 2 products we only have one total inventory value. Cheers

  • aubreybourke
    Replied on October 6, 2017 at 10:04 AM

    Unfortunately it is not possible to combine the two remaining values into one remaining value.

    Best you can do is to use the demo provided by John above.