[Skip to main content](#vessel-content)

#   Can I use the total order price in the shipping formula?

##

- **[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")**
- [![ianspeed's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1602-ianspeed "View ianspeed's Profile") Topic Author
- [ Offline](/forum/user/1602-ianspeed)

Less More

- Posts: 173
- Thank you received: 8
-
-

1 year 9 months ago [\#365348](#365348) by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")  *[Can I use the total order price in the shipping formula?](/forum/28-shipping-methods/909054-can-i-use-the-total-order-price-in-the-shipping-formula#365348 "-- HikaShop version -- : 5.1.0 -- Joomla version -- : 5.1.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : None  Hi All, Hope you had a good new year. Can I access the total order price in the shipping formula? What I need to do is adjust the shipping cost by x amount if the value exceeds the current insurance level.  If total&#95;price &gt; £50 shipping&#95;cost + £2 etc If so, what are the formula fields? Is there any way to do this with the formula?  Many thanks Ian")* was created by *[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")*

-- HikaShop version -- : 5.1.0
-- Joomla version -- : 5.1.0
-- PHP version -- : 8.2
-- Browser(s) name and version -- : All
-- Error-message(debug-mod must be tuned on) -- : None

Hi All,
Hope you had a good new year.
Can I access the total order price in the shipping formula? What I need to do is adjust the shipping cost by x amount if the value exceeds the current insurance level.

If total_price &gt; £50 shipping_cost + £2 etc
If so, what are the formula fields?
Is there any way to do this with the formula?

Many thanks
Ian

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3NoaXBwaW5nLW1ldGhvZHMvOTA5MDU0LWNhbi1pLXVzZS10aGUtdG90YWwtb3JkZXItcHJpY2UtaW4tdGhlLXNoaXBwaW5nLWZvcm11bGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86289
- Thank you received: 14265
-
-

1 year 9 months ago [\#365349](#365349) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can I use the total order price in the shipping formula?](/forum/28-shipping-methods/909054-can-i-use-the-total-order-price-in-the-shipping-formula#365349 "-- HikaShop version -- : 5.1.0 -- Joomla version -- : 5.1.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : None  Hi All, Hope you had a good new year. Can I access the total order price in the shipping formula? What I need to do is adjust the shipping cost by x amount if the value exceeds the current insurance level.  If total&#95;price &gt; £50 shipping&#95;cost + £2 etc If so, what are the formula fields? Is there any way to do this with the formula?  Many thanks Ian")*

Hi,

Thanks. Happy new year to you !

In the shipping formula field, you can use the tags {price}, {volume}, {weight} and {quantity}
The tag {price} corresponds to the subtotal amount.

However, you can't use conditions in there. You can only use normal operations.
For example, if you have the formula: {price}*0.1
it means that the shipping fee would be 10% of the subtotal amount.

So I don't think you can use the shipping formula in order to do what you want.
However, you can do what you want without this field.
Suppose you currently have one shipping method, with a shipping price of £10.
Then, you could enter 50 in its "maximum price" field.
Then, configure another shipping method with the same settings, but instead of a shipping price of £10, set it to £12, leave the "maximum price" field empty, and enter 50.001 in the "minimum price" field.

That way, on the checkout, if the subtotal amount is 50 or lower, the second shipping method will be filtered out and the only shipping method left will be the £10 shipping method which will be automatically selected. Similarly, if the subtotal amount is higher, the first shipping method will be filtered out and the only shipping method left will be the £12 shipping method, which will be automatically selected.

The following user(s) said Thank You: [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3NoaXBwaW5nLW1ldGhvZHMvOTA5MDU0LWNhbi1pLXVzZS10aGUtdG90YWwtb3JkZXItcHJpY2UtaW4tdGhlLXNoaXBwaW5nLWZvcm11bGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")**
- [![ianspeed's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1602-ianspeed "View ianspeed's Profile") Topic Author
- [ Offline](/forum/user/1602-ianspeed)

Less More

- Posts: 173
- Thank you received: 8
-
-

1 year 8 months ago [\#365405](#365405) by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")  Replied by *[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")* on topic *[Can I use the total order price in the shipping formula?](/forum/28-shipping-methods/909054-can-i-use-the-total-order-price-in-the-shipping-formula#365405 "-- HikaShop version -- : 5.1.0 -- Joomla version -- : 5.1.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : None  Hi All, Hope you had a good new year. Can I access the total order price in the shipping formula? What I need to do is adjust the shipping cost by x amount if the value exceeds the current insurance level.  If total&#95;price &gt; £50 shipping&#95;cost + £2 etc If so, what are the formula fields? Is there any way to do this with the formula?  Many thanks Ian")*

Thanks Nicolas,
I'll have a look at that, but Royal Mail changed all their international postage rates, so that would be a huge amount of individual replications per certain countries, France being one of them as they are now individually costed.
Just wondering if I could put a request in for this feature in the future?
i.e
if price &gt; xxx.xx then shipping cost + xxx.xx = shipping cost
This would save having to duplicate all of the shipping methods?

Many thanks
Ian

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3NoaXBwaW5nLW1ldGhvZHMvOTA5MDU0LWNhbi1pLXVzZS10aGUtdG90YWwtb3JkZXItcHJpY2UtaW4tdGhlLXNoaXBwaW5nLWZvcm11bGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86289
- Thank you received: 14265
-
-

1 year 8 months ago [\#365406](#365406) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can I use the total order price in the shipping formula?](/forum/28-shipping-methods/909054-can-i-use-the-total-order-price-in-the-shipping-formula#365406 "-- HikaShop version -- : 5.1.0 -- Joomla version -- : 5.1.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : None  Hi All, Hope you had a good new year. Can I access the total order price in the shipping formula? What I need to do is adjust the shipping cost by x amount if the value exceeds the current insurance level.  If total&#95;price &gt; £50 shipping&#95;cost + £2 etc If so, what are the formula fields? Is there any way to do this with the formula?  Many thanks Ian")*

Hi,

In that case, you want to use this shipping plugin:
[ www.brainforge.co.uk/shop/downloads/prod...pping-extra-features](https://www.brainforge.co.uk/shop/downloads/product/56-shipping-extra-features)
It has that specific capability implemented already.

The following user(s) said Thank You: [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3NoaXBwaW5nLW1ldGhvZHMvOTA5MDU0LWNhbi1pLXVzZS10aGUtdG90YWwtb3JkZXItcHJpY2UtaW4tdGhlLXNoaXBwaW5nLWZvcm11bGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.177 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
