Pallet Shipping Based on weight of an item

Hi,

I'm using Power Store 3 and try to add some extra shipping rules with eCart.
I have large and heavy items in the store which need to be shipped on a pallet. So what I want to apply is the next:

If a customer orders an item which is heavier than 25 kg than this item needs to be shipped on a palllet with extra shipping cost of 40 euro. So far not a problem at all.
But if a customer orders multiply of these kind of products than these extra shipping costs need be applied on every heavy item.

For example >

if customer orders the item a (30 kg) he needs to pay 40 euro extra.
if this customer oders more items which are all above 25 kg each than he needs to pay 40 euro extra for each item.

How can I set up a shipping rule in eCart to achieve this?

Regards.

Any suggestions or help will be appreciated.

add a new column to the cart object for over sized items that should have the 40 euro extra cost applied.


in the eCart add to cart button, set this new column to 0 for regular items, and 1 for over sized items.


then set the shipping rule as:

triggers:
Number of items with a specific column value:
If the number of items where 'OverSized' has a value of '1' is '>' a value of '0'



calculations:
Based on items with a specific value:
Total of 'Quantity' where 'oversized' has a value of '1' 'times' '40'

Jason,

So I guess this means that I have to add an extra field in the products table like "heavy or oversized = yes or 1" right?

yes, that is correct.

Jason,

Thanks a lot!

Your tip did the trick.

you're welcome.