Hi Christal, when you set up a product, you have the option to enable Bulk discount and specify prices for different quantity options. For example,
Price: $3
Quantity options with bulk discount:
1
2 - $5
3 - $8
4 - $10
5 - $13
If the user selects 2 quantities for this product, $5 will be added to the order amount. If the user selects 5, $13 will be added to the order amount.
If would like to apply a discount across different products, then you can calculate the total order quantity and write a formula to apply the discount instead of using bulk discounts for each product.
Calculate order quantity
In the Neartail edit page, click on the Add field button. Enter the title (for example, Order Quantity) , select the Textbox widget and click create. Click on the gear icon next to this Quantity question. Click Answer. Enter the QUANTITY() formula in the Calculate option and click Save.
Calculate discount
In the Edit page, click on the Add price field button > select Discount, click Next > select Custom calculation, click Next > Enter the below formula and click Create.
If the pricing is 1 for $3 or 2 for $5, then you can use this formula to apply a $1 discount for every 2 quantities.
Math.floor(Order Quantity/2) * 1
Calculate total amount
In the Edit page, click on the Add price field button > select Net amount, click Next > select Standard calculation using NETTOTAL() formula, click Next > click Create.
Please try this and confirm.
Comments (1)
Jan 5, 2024
Hi Christal, when you set up a product, you have the option to enable Bulk discount and specify prices for different quantity options. For example, Price: $3 Quantity options with bulk discount: 1 2 - $5 3 - $8 4 - $10 5 - $13 If the user selects 2 quantities for this product, $5 will be added to the order amount. If the user selects 5, $13 will be added to the order amount. If would like to apply a discount across different products, then you can calculate the total order quantity and write a formula to apply the discount instead of using bulk discounts for each product. Calculate order quantity In the Neartail edit page, click on the Add field button. Enter the title (for example, Order Quantity) , select the Textbox widget and click create. Click on the gear icon next to this Quantity question. Click Answer. Enter the QUANTITY() formula in the Calculate option and click Save. Calculate discount In the Edit page, click on the Add price field button > select Discount, click Next > select Custom calculation, click Next > Enter the below formula and click Create. If the pricing is 1 for $3 or 2 for $5, then you can use this formula to apply a $1 discount for every 2 quantities. Math.floor(Order Quantity/2) * 1 Calculate total amount In the Edit page, click on the Add price field button > select Net amount, click Next > select Standard calculation using NETTOTAL() formula, click Next > click Create. Please try this and confirm.
Add your comment
Add photo