Zen Cart Logo
Forums / Built-in Shipping and Payment Modules / Table Rate shipping PLUS a handling fee for certain items

Table Rate shipping PLUS a handling fee for certain items

Locked

Views: 2,475

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
17 Apr 2009, 3:07 PM
#1
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Table Rate shipping PLUS a handling fee for certain items

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

18 Apr 2009, 12:51 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Table Rate shipping PLUS a handling fee for certain items

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

18 Apr 2009, 1:37 PM
#3
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: Table Rate shipping PLUS a handling fee for certain items

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

19 Apr 2009, 12:36 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Table Rate shipping PLUS a handling fee for certain items

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?

19 Apr 2009, 1:17 AM
#5
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: Table Rate shipping PLUS a handling fee for certain items

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

19 Apr 2009, 1:28 AM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Table Rate shipping PLUS a handling fee for certain items

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? :cool:

19 Apr 2009, 3:39 AM
#7
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: Table Rate shipping PLUS a handling fee for certain items

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

19 Apr 2009, 4:21 AM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Table Rate shipping PLUS a handling fee for certain items

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[B] + $shipping_weight[/B])));
19 Apr 2009, 1:12 PM
#9
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: Table Rate shipping PLUS a handling fee for certain items

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

19 Apr 2009, 1:43 PM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Table Rate shipping PLUS a handling fee for certain items

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 ...

19 Apr 2009, 2:30 PM
#11
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: Table Rate shipping PLUS a handling fee for certain items

Ajeh,

Great!!

I think we are now 2/3 of the way there. 2 shipping options still are shown to customers for this item.

1- the correct $7.20 "Best Way" and

2- $2.25 "Best Way" - which is the add-on charge for heavy items.

How do we get rid of that option??

Thanks,

Marvin

19 Apr 2009, 3:15 PM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Table Rate shipping PLUS a handling fee for certain items

Go to your Modules ... Shipping ... and REMOVE any shipping module that you are not using besides the Table Rate table shipping module ...

19 Apr 2009, 3:42 PM
#13
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: Table Rate shipping PLUS a handling fee for certain items

Ajeh,

excuse the capital letters but its only my way to express my thanks.

It worked.

Oba-san is not a high enough rating for you.

Thanks a million

19 Apr 2009, 4:20 PM
#14
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Table Rate shipping PLUS a handling fee for certain items

You are most welcome ... thanks for the update that you were able to work in the extra charges for your odd items and manage your normal shipping methods ... :smile: