Postage costs based on cart weight. Can’t figure it out

So I’m trying to add postage and packing to checkout. The cart ads the product weights into a database table “Cart Weight”.

I then need to add postage to the total of the cart.

If Cart weight is under 1500 add postage of £5
If cart weight is above 1500 add postage of £10

I can only see the way of doing it is using a conditional formula but can’t seem to get the cart weight and use an if statement.

Does anyone have any other ideas?

Thanks

Yeah the idea I have is you should have like a visibility condition that determines this and adds up to the price

Or I use something like a sometimes action

I thought of this also but I then need to grab the visible field of £5 or £10 and add it to the order total which I’m not sure if that’s possible.

its possible

So ive managed to figure it out.
I created a database entry call postage cost. The checkout button forwards you to modal where you select your postage. The buttons have conditions to only display if cart weight is under 1500 and another button if cart weight is over 1501. The user then selects which ever button shows ( kind of like a confirmation of the service ) this updates the postage field in the database to the relevant cost. It then forwards through to the checkout page where you can pull the postage cost from the database again to add to the order total.

awesome

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.