Hi all ! , thanks in advance for your help.
I have a multi step form calculation cost. User selects from multi repeating groups the product they want. On the last step, they are able to fill out a quantity for each item they selected (auto binding input on a repeating group).
I’d like on a final step to update the price of the products they selected according to the quantity they filled out on the input.
Each product has a global price and the price decreases according to quantity. Let’s say :
Product 1, when QTY is < 10 = $23
Product 1, when QTY is > 10 = $18
Product 1, when QTY is > 40 = $10
Quantity can be a different type according to the product selected : meters, unit, length, square meters … But the final price is always QTY * product selected price.
Right now, i have theses data types :
PRODUCTS
-
name (name of the product)
-
price (the original price)
SELECTED PRODUCT
-
product(product)
-
Quantity(number)
CART
-
List of products
-
list of selected product
For the cart, i display all the product selected from different categories.
I’m not sure how to do this one ;( Should I create another data type ? If yes, of am i supposed to set up this one ? Or should I work with back end api to work on a list and update the price ?
As per your information : each product can have +/- 6 price variation, i have +/- 20 categories and +/- 400 products. THANK you if you can help or send me any good ressource …