I have a shipping cost scenario where costs are calculated based on postcode and also based on number of pallettes required.
I was thinking i could add the pallette required to the "weight" attribute and calculate costs that way.
i.e. product 1 = 0.5 pallettes
But products cant be shared every time. i.e.
palette = 100
2 x @0.3
1 x @0.5
1 x @0.9
Total = 2.0 (which would mean 2 palettes)
But the 0.5 product cant be chopped up and shared across the remaining space on the other pallettes!
how can i calculate this? is there a magento addon that will do this or do i need to write my own? ( and if so pointers appreciated)