Community

how to use Shipping weight (in kg) when product unit of measure is Quantity how to calculate delivery fee Example one box weight 3kg Qty Weight Delivery Charges GBP 1 3 7 2 6 7 3 9 7 4 12 11 5 15 11 6 18 14 7 21 18 8 24 18 9 27 22 10 30 22 11 33 28 12 36 28 13 39 29 14 42 33 15 45 33

Onkar Pathre

May 21, 2024

Comments (1)

Vipin

May 21, 2024

You can calculate the shipping fee based on the the total weight of the products ordered. Setup unit weight for each product You can set up the unit weight for the products. In the Neartail Edit page (new editor), click on the product to select it > click on the gear icon for that product > Product settings page will be displayed > click Advanced > enable Shipping, enter the unit weight for the product and click Save. Repeat the steps for all the products. Calculate total weight In the Neartail Edit page (new editor), click on the Add field icon > enter the title Total Weight, select Short answer question > click on the gear icon for this field > Field settings page will be displayed > click Answer > enter the formula WEIGHT() in the Calculate option and click Save. Calculate shipping fee In the Neartail Edit page, click on the Add price field button > select Delivery fee, click Next > select Custom calculation, click Next > Enter the one of the formula below and click Create. Fee based on order weight IFS(Total Weight >= 42, 33, Total Weight >= 39, 29, Total Weight >= 33, 28, Total Weight >= 27, 22, Total Weight >= 21, 18, Total Weight >= 18, 14, Total Weight >= 12, 11, Total Weight >= 3, 7, 0) 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