Table Rate shipping PLUS a handling fee for certain items

[marvin]

HI,
I am using a table rate based on merchandise total. Ex: up to $40.00 = $4.95 shipping charge.

I am adding several items that are heavier than all my other items and want to add a fee to cover the extra weight .
I want this to be based on quantity ordered per item - Ex: $.75 per item.
3 of this item would add $2.25 to the $4.95 for a total of $7.20 for an order up to $40.00

I have searched and read dozens of posting but can't find an answer.
I thought that this might have been something simple to do. Am I wrong?

Please help.

Thanks,

Marvin

[kobra]

You will probably need to base this on weight instead of price

[marvin]

Thanks Kobra for reply.

If you mean switch my entire store to a weight based calculation I dont want to do that as ONLY about a dozen items are involved out of over 230 items.

I'm looking for a way to use the price rate table and add a fee to the 12 items based on the number of items.

I have another store where I us Miva Merchant and they have that option when setting up each item to add a fee per item.

I hope that that option is being added to Zen 2.0.

Marvin

[Ajeh]

If you are not using your products_weight for anything ... and all of these Products with an added fee are based on number of items ordered * added fee ... then you could add a products_weight to these few products and take the weight computed to be the added fee ...

So if products_id has a 2.25 added fee per quantity and 3 are ordered it would add 2.25 * 3 to the existing shipping cost already computed in the regular method you are using that is not weight based ...

Would that work?

[marvin]

Ajeh,

Thanks for your reply. You almost have it unless I am missing something.

I set it up activating the weight shipping option and putting 1.00 as the cost per unit.

I put the weight in my product_wgt as .75 (this is what I want to charge extra per item for the heavy items)

It calculated the shipping charge correctly BUT BUT BUT it shows as a shipping choice for the customer to pick

So when the customer orders 3 of this item she has a choice of $4.95 (the normal shipping charge) OR $2.25 which is the weight based charge.

How can I get this to combine as one charge of $7.20???????

Marvin

[Ajeh]

First ... are the calculations correct based on what you have tried, if they were combined?

IF so, that is half the battle ...

Next, uninstall the weight based shipping module, I am guessing you are using the Per Unit perweightunit shipping module ...

Now, you need to customize the shipping module that you are using for everything else ...

I believe you are using the Table Rate table setup based on Price ...

What you want to do is now get the total weight of the order and add it to the cost in that shipping module ...

How crafty are you at doing that?

[marvin]

Ayeh,
Yes, calculate is correct if they are combined.

Yes i am using the PerUnitn perweight module. I just disabled it

Yes I am using the Table Rate based on Price.

Crafty? i have done some modifications with help from my fellow Zenners.

Can you give me the code?

Thanks

[Ajeh]

See if this does it for you:

    $this->quotes = array('id' => $this->code,
    'module' => MODULE_SHIPPING_TABLE_TEXT_TITLE . $show_box_weight,
    'methods' => array(array('id' => $this->code,
    'title' => MODULE_SHIPPING_TABLE_TEXT_WAY,
    'cost' => $shipping + MODULE_SHIPPING_TABLE_HANDLING + $shipping_weight)));

[marvin]

Ajeh.
Thanks for the code.
I understand what it does & how.

But what file do I insert this in and where is it located.

Also, does it matter where in that file it goes???????????

Thanks,
Marvin

[Ajeh]

If you want to use the Table Rate table ... then I would add that weight, which is the extra charge, to the Table Rate table shipping module in:
/includes/modules/shipping/table.php

NOTE: there isn't an override for this so save your changes ...