Magento Forum

   
Page 1 of 2
Multiple table rate shipping methods
 
Yarhajile
Sr. Member
 
Avatar
Total Posts:  90
Joined:  2008-08-28
Spokane, WA
 

I was gonna begin coding up a new shipping module for this, but I thought I’d run it by everyone to see if it it’s already in the works.

Our company does their shipping strictly by table rates. Our setup is as such.

United States (lower 48 states)
1.  Ground Shipping
1a.  Up to $60 is standard shipping table
1b.  $60 and over is free.

2.  3 day select
3.  2nd Day Air
4.  Next day air

United States (Alaska, Hawaii)
1.  3 day select
2.  2nd day air
3.  Next day air

Canada
1.  International Priority Mail

US Protectorates
1.  Priority Mail
2.  Express Mail

Each one of those numbered shipping methods is, in effect, it’s own separate shipping table. (Order total $0-$15 is $4.95 shipping, $15.01 - $25 is $6.95 shipping, and so on)

What we’re looking for looks very similar to user amwhite2008’s post here http://www.magentocommerce.com/boards/viewthread/12054

Any work being done on this functionality yet at all?

 
Magento Community Magento Community
Magento Community
Magento Community
 
greggsand
Jr. Member
 
Avatar
Total Posts:  29
Joined:  2008-04-19
 

I am looking to do the exact same thing… Did you find a solution?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Nexus Rex
Sr. Member
 
Avatar
Total Posts:  139
Joined:  2008-07-10
Utah, USA
 

Yarhajile,

Did you already start coding on this? We also need a “Dollar Based Ship Table” for Magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mistcooling
Jr. Member
 
Avatar
Total Posts:  11
Joined:  2008-09-18
Houston-Texas-USA
 

I got successed to set up only one Standard Table as below under following Heads
and looks working.  I am also doing to add priority and express module, let me see if it works

Country /State ZipPostal Code/ Order Subtotal/ Shipping Price

USA * * 0 7.95
USA * * 50 9.95
USA * * 75 11.95
USA * * 100 13.95
USA * * 150 15.95
USA * * 200 17.95
USA * * 300 19.95
USA * * 400 22.95
USA * * 500 26
USA * * 600 28
USA * * 700 34
USA * * 1000 70
USA AK * 0 17.95
USA AK * 50 19.95
USA AK * 75 21.95
USA AK * 100 23.95
USA AK * 150 25.95
USA AK * 200 30
USA HI * 0 17.95
USA HI * 50 19.95
USA HI * 75 21.95
USA HI * 100 23.95
USA HI * 150 25.95
USA HI * 200 30

 
Magento Community Magento Community
Magento Community
Magento Community
 
WebShopApps
Guru
 
Avatar
Total Posts:  460
Joined:  2008-05-30
London, UK
 

Hi,

I believe I have written what you are looking for, or very similiar.  It is effectively multiple table rates, controlled via a CSV file.  It’s very new, still under test.  Also allows for collection only, and exclusion of items from free delivery.

PM me for details & demo. I will be releasing as an extension, at present it is in zip format and installs into the community area.

Rgds

Karen

 
Magento Community Magento Community
Magento Community
Magento Community
 
mistcooling
Jr. Member
 
Avatar
Total Posts:  11
Joined:  2008-09-18
Houston-Texas-USA
 

Karen,

Yes please, send me more info and file,
as it it possible to set up all three usps methods like Standard, Priority & Express in one table.
It will be really helpful as most of shopping carts have this option.

Mak

 
Magento Community Magento Community
Magento Community
Magento Community
 
QA
Jr. Member
 
Total Posts:  2
Joined:  2008-10-15
 

I’m also looking for something like Paul said. It will be really helpful..

Thanks in advance.. smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
WebShopApps
Guru
 
Avatar
Total Posts:  460
Joined:  2008-05-30
London, UK
 

Hi,

The way it works currently is that if you have 2 products with different weights, then the cumulative weight is used to calculate the table rates that apply.  This is the same as with the existing table rates.  The difference with mine is that it will be able to display a range of rates, rather than just one.

Here is an example of the csv file for the module I have created. 

“Country”,"Region/State","Zip/Postal Code","Weight from”, “Weight to","Shipping Price","Delivery Type”
“GBR”,"*”,"*”,"0”,"5”,"2.99","1st Class Recorded”
“GBR”,"*”,"*”,"0”,"32”,"7.99","ParcelForce 24-48”
“GBR”,"*”,"*”,"32”,"1000”,"80.00","Special Pallet Delivery”
“GBR”,"*”,"*”,"2000”,"2100”,"0","Collection Only”
“GBR”,"*”,"BT”,"0”,"5”,"11.99","1st Class Recorded”
“GBR”,"*”,"BT”,"0”,"32”,"14.99","ParcelForce 24-48”
“GBR”,"*”,"BT”,"0”,"1000”,"200","Special Pallet Delivery”
“IRL”,"*”,"*”,"0”,"5”,"17.99","1st Class Recorded”
“IRL”,"*”,"*”,"0”,"32”,"17.99","ParcelForce 24-48”
“*”,"*”,"*”,"0”,"10”,"50”,"Worldwide"

I’m based in the UK so the example is UK specific, but I believe it the module will translate worldwide.

If an item is excluded from free delivery then I have created a custom attribute that you select on the product that deals with this.

I have now uploaded this to Magento and am awaiting approval on it.

Rgds

Karen

 
Magento Community Magento Community
Magento Community
Magento Community
 
wolfdog85
Jr. Member
 
Total Posts:  12
Joined:  2008-09-29
Biloxi, MS, USA
 

birches, I have a furniture retail business and am very interested and anxious for this module. We have different types of delivery all based on table rates such as premium delivery, threshold delivery, and such. PM me more info and I will be willing to do test runs for you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
WebShopApps
Guru
 
Avatar
Total Posts:  460
Joined:  2008-05-30
London, UK
 
wolfdog85 - 14 November 2008 02:54 PM

birches, I have a furniture retail business and am very interested and anxious for this module. We have different types of delivery all based on table rates such as premium delivery, threshold delivery, and such. PM me more info and I will be willing to do test runs for you.

You have been PM’ed. 

Magento seem to be taking a while to approve this.  If you require the zipped version of this extension please PM me directly, as I don’t always check this message board.

Rgds

Karen

 
Magento Community Magento Community
Magento Community
Magento Community
 
Yarhajile
Sr. Member
 
Avatar
Total Posts:  90
Joined:  2008-08-28
Spokane, WA
 

I’ve finished my multiple table rate module and it can be downloaded via magento connect here.

Cheers!

 
Magento Community Magento Community
Magento Community
Magento Community
 
WebShopApps
Guru
 
Avatar
Total Posts:  460
Joined:  2008-05-30
London, UK
 

Hi,

I’ve now got the multiple tablerate extension live rather than the zip install- it can be found here

It has been tested and is running on several live environments.

Rgds

Karen

 
Magento Community Magento Community
Magento Community
Magento Community
 
NeilA
Moderator
 
Avatar
Total Posts:  1372
Joined:  2007-09-17
Blue Mountains, Oz
 

Hi Karen,

Just wanted to say thank you so much for writing this extension, and documenting it so well!
It is a real lifesaver for me, and soon as my store goes live in a couple of weeks, a donation will be on it’s way..

Thanks again!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Nick Sloan
Jr. Member
 
Total Posts:  19
Joined:  2009-01-12
 

Karen, just like to say thanks for the extension.

I’m currently converting a site over from Actinic and was finding the built-in Magento solution far too simplistic. Fortunately your MatrixRate module is exactly what I needed.

Once again thanks, and the documentation is excellent.

Cheers, Nick

 
Magento Community Magento Community
Magento Community
Magento Community
 
WebShopApps
Guru
 
Avatar
Total Posts:  460
Joined:  2008-05-30
London, UK
 

Thanks for your kind words Nick, Neil - always good to hear that it is being of use.

I’ve done quite a lot of enhancements to this now, including support for filtering based on cities, and also enhanced the postcode options.  It seems to be very stable now, and has been used across the world including USA, UK, France, Romania, Spain, Australia, and so on. 

Rgds

Karen

 
Magento Community Magento Community
Magento Community
Magento Community
 
eddieb
Sr. Member
 
Avatar
Total Posts:  87
Joined:  2008-04-17
Rio de Janeiro, Brazil
 

hello

i’ve checked out karen’s extension, but i’m not sure it is what i need. i need 3 different shipping methods. they are all weight X destination, but each applies to a different group of countries.

1) weight X destination to country A
2) weight X destination to countries B,C,D
3) weight X destination to countries E,F,G

im pretty confident this cant be done without an extension. is there an extension suitable to my needs?

thanks in advance!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 1 of 2