Zone Shipping Cost based on Individual item weight, not total order weight

[pohnean]

Hi, this question is probably asked before but I couldnt find the answer to it after scouring the forum.

Im now using the Zone Rates module and 4 zones. Rates are based on weight and rates for each zone is different.

All of that is fine and dandy except when there are more than 1 item in the cart.

Now, all my items will be shipped in individual boxes and not altogether one 1 box. I want my shipping cost to be based on individual item weight instead of the total order weight.

For example, there are 2 items in the cart:
1) Product 1, weight 1.5kg
2) Product 2, weight 2.0kg

And the shipping table is as such (weight, price):
0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5
29.5 34.5 41.0 52.0 58.5 64.5 71.0 75.0 81.5 87.0 93.0

Based on Zone 3 shipping rates above, the shipping costs should be:
1) Product 1 - $41
2) Product 2 - $52
Total: $93

However, zen cart calculates it as follows:
(1.5kg + 2.0kg = 3.5kg) which is $71 based on the table.



What should I do in order to achieve the desired result?

[Ajeh]

Do you actually have this "exact" information in your Zone Rates?

0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 5.5
29.5 34.5 41.0 52.0 58.5 64.5 71.0 75.0 81.5 87.0 93.0

If so, it is written wrong ... it has to be punctuated correctly to delimit the weight and price for each amount ...

Based on the need to have the shipping based on a "per Item" basis, you may want to look at the Per Unit perweightunit where the products_weight is the shipping cost of that item ...

Then, as you want different rates for different Zones, you could clone the Per Unit perweightunit shipping module and set the Unit Rate proportionally for each Zone ...

Example, if setting the weight to 2 meant $2.00 for US, and 2 meant $4.00 for Canada then you just change the Unit Rate to 2.00 ...

Example, if setting the weight to 2 meant $2.00 for US, and 2 meant $3.00 for Canada then you just change the Unit Rate to 1.50 ...

[pohnean]

Ajeh, thanks for your swift response.

The zone rates above are for reference only.

I've input them in the delimited format and it works well except that I need my shipping rates to be computed individually for each item instead of computed using the sum of the weight of all items.

That method you've proposed using perweightunit works if my rates for each zone is porportionate. However, they are not exactly proportionate thus I cannot use that method.

[Ajeh]

How much off would they be if you used the Per Unit perweightunit method?

The current shipping methods do not work for 1 product per box and you would have to do quite a bit of customization to re-write everything for this ...

[Ajeh]

NOTE: remember you also have the Handling Fee that can be worked in there as well per Zone (cloned) copy of the module to help with the rates ...

[klog]

Hi all,
I think this thread is similar if not identical to what I am working towards accomplishing. For sure I experienced the same issue with multiple items in the cart, throwing the shipping cost to zero. The zone rate module works exactly the way I wish as long as there is only ONE item in the cart.
My reason for working in this direction is that I drop ship many of my products and ship to many countries. The final shipping charge varies GREATLY sometimes from country to country. To me there is no ryhme nor reason as why, but I can't change it, that's for sure. For example it may cost $30 to ship to the UK, and $50 to ship to Germany (just a hypothetical)
Here's how I set it up: I used numeric "codes" in the item weight field for each product I have, eg. 1.01, 1.02, 1.03, etc. Defining the zone rates for example - Zone-1:
1.01:2.95,1.02:14.95,2.01:10.00,2.02:12.00,3.01:5.95, & so on.

Zone-2:
1.01:5.90,1.02:33.45,2.01:13.60,2.02:23.20,3.01:11.90, & so on.

At the moment I have 4 zones set up, but anticipate more.

I understand now why the module is making the cost ZERO if there is more than one item, because the module is taking the SUM of the weights (my "ship codes"), adding them and coming up with a value that I have not defined (with a cost). The thing is, there are simply too many (infinite perhaps) combinations (permutations?) of "codes" for me to anticipate, and thereby assign a total cost for the itemS being shipped to the particular zone the customer wants shipped to.
SO, after my long winded explanation, HOW can I make the zone rates module keep the charge assigned for each "code" and add them together, instead of adding the "codes" (weights) together and then looking for a zone definition that doesn't exist.
IS the perunitweight module the answer? I've looked at it several times, but can't get my head around how I can make that module accomplish want I want.
Any ideas?
Cheers & all the best,
Kevin
PS: http://kevinlogan.com/gallery2/main.php if anyone wants to see my cart in action.

[Ajeh]

The Per Unit perweightunit shipping module is designed to assign a shipping cost to each Product ...

Let's say you ship to the US and Canada and the UK ...

If you have a Product with the products_weight set to 2 for $2.00 to the US, then you would set the Unit Rate on the Per Unit shipping module to 1.00 ...
1 x 2 = $2.00

Now if you clone the Per Unit perweightunit shipping module for Canada so that this Product ships for $2.50, you would set the Unit Rate on the cloned Per Unit shipping module to 1.25 ...
1.25 x 2 = $2.50

Then, if you clone the Per Unit perweightunit shipping module for the UK so that the Product ships for $4.00, you would set the Unit Rate on the cloned Per Unit shipping to 2.00 ...
2.00 x 2 = $4.00

You are basically building the rates proportionally for each cloned copy of the Per Unit perweightunit shipping module ...

NOTE: be sure in the Configuration ... Shipping/Packaging ... that you are setting the Maximum Weight to 5000 and both the Tare Rates to 0:0 ...

[klog]

Hi Linda,
Thanks for the info.
Question: are you saying that I should clone the perunitweight module for every country I ship to?

Cheers,
Kevin

[klog]

Hi again,
Having slept on this idea of cloning the perweightunit pages, and actually working a bit on it, I've come to realize that as far as I can tell, this approach won't work for me, unless I make like a million clones (and zones), as I realized that there is NO consistency to the multiplier factor, eg 1.5X, 2X, 3X etc. the intital price I put in the weight fields. For example, it may cost $5 to ship product1 to the USA and $10 to Ireland (2X factor), but cost $10 to ship product2 to the USA and $40 to Ireland (4X factor).
I really wish I could get the zone rates approach to work as I attempted (which it does for single cart-items, not multiple cart items). If anyone has any ideas, word love to hear them. For example, is there any way to fake-out the php script, treating the weight fields (my "ship codes") simply as "identifiers" and not to be added?
Any way, thanks again for your help.
Cheers & all the best,
Kevin

[Ajeh]

Could you define a bit more specifically what you mean by "identifiers" and how you envision using them?