You can calculate the fee based on order quantity or weight.
Calculate weight
In the Edit page, click on the Add field button > enter the title Weight, select Textbox widget and click Create > Field settings page will be displayed > click Answer > enter the formula WEIGHT() in the Calculate option and click Save.
Note: You must have set up the unit weight for the products. In the Edit page, click on the gear icon next to the product > Product settings page will be displayed > click Advanced > enable Shipping, enter the unit weight for the product in kgs and click Save. Repeat the steps for all the products.
Calculate quantity
In the Edit page, click on the Add field button > enter the title Order Quantity, select Textbox widget and click Create > Field settings page will be displayed > click Answer > enter the formula QUANTITY() in the Calculate option and click Save.
Calculate delivery fee based on weight or quantity
In the Edit page, click on the Add price field button > select Delivery fee, click Next > select Custom calculation, click Next > Enter the below formula and click Create.
Example for quantity:
IFS(Order Quantity >= 10, 20, Order Quantity >= 5, 10, 5)
Example for weight:
IFS(Weight >= 5, 20, Weight >= 3, 12, Weight >= 1, 8, 2.50)
If it is a fixed price per weight (kg or lbs), then you just have the multiply weight by the unit price. For example, Weight * 2.50
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.
I want to add delivery fee based on order amount.
if order amount less then 300, delivery fee=50
if order amount between 301 to 400, delivery fee =30.
if order amount exceeds 400, delivery fee =0.
just an example.
how can i add delivery fee like this
You can use the IFS function to set the delivery fee based on order amount. For the criteria that you have listed above, you can use the following IFS formula.
IFS(Order Amount >= 400, 0, Order Amount >=300, 30, 50)
Comments (4)
Dec 29, 2023
You can calculate the fee based on order quantity or weight. Calculate weight In the Edit page, click on the Add field button > enter the title Weight, select Textbox widget and click Create > Field settings page will be displayed > click Answer > enter the formula WEIGHT() in the Calculate option and click Save. Note: You must have set up the unit weight for the products. In the Edit page, click on the gear icon next to the product > Product settings page will be displayed > click Advanced > enable Shipping, enter the unit weight for the product in kgs and click Save. Repeat the steps for all the products. Calculate quantity In the Edit page, click on the Add field button > enter the title Order Quantity, select Textbox widget and click Create > Field settings page will be displayed > click Answer > enter the formula QUANTITY() in the Calculate option and click Save. Calculate delivery fee based on weight or quantity In the Edit page, click on the Add price field button > select Delivery fee, click Next > select Custom calculation, click Next > Enter the below formula and click Create. Example for quantity: IFS(Order Quantity >= 10, 20, Order Quantity >= 5, 10, 5) Example for weight: IFS(Weight >= 5, 20, Weight >= 3, 12, Weight >= 1, 8, 2.50) If it is a fixed price per weight (kg or lbs), then you just have the multiply weight by the unit price. For example, Weight * 2.50 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.
Dec 29, 2023
I want to add delivery fee based on order amount. if order amount less then 300, delivery fee=50 if order amount between 301 to 400, delivery fee =30. if order amount exceeds 400, delivery fee =0. just an example. how can i add delivery fee like this
Dec 29, 2023
You can use the IFS function to set the delivery fee based on order amount. For the criteria that you have listed above, you can use the following IFS formula. IFS(Order Amount >= 400, 0, Order Amount >=300, 30, 50)
Dec 29, 2023
i tried but i didnt work
Add your comment
Add photo