joomla template, virtuemart, phpBB styles, virtuemart, drupal theme, virtuemart, phpBB styles, virtuemart, mootools, virtuemart, phpBB styles, virtuemart, drupal theme, virtuemart, phpBB styles, virtuemart, jQuery, virtuemart, phpBB styles, virtuemart, drupal theme, virtuemart, phpBB styles, virtuemart, mootools, virtuemart, phpBB styles, virtuemart, drupal theme, virtuemart, phpBB styles, virtuemart

I decided to create this page because of the absolute lack of information for UK/GB Magento users on the Table Rate Shipping Module.
Below is a very simple solution to what has been a huge problem for some of my clients.

I would grade this as the following:

• Difficulty Level: 2/10
• Time Taken: 30 Minutes

Update 28/06/2012 - This article is still useful, but outdated for the latest community release. On a 1.7.0 cart I believe you will need to create a local copy of app/code/core/Mage/Shipping/Model/Resource/Carrier/Tablerate.php and make the change on line 123 (’:postcode’ ⇒ $request→getDestPostcode()). Step 1 - The CSV Table Rate File

Step one is to create a file that completely handles UK/GB shipping table rates like so:

GBR,*,*,0,9.99
GBR,*,*,50,0
GBR,*,BT,0,29.99
GBR,*,AB,0,29.99
GBR,*,FK,0,29.99
GBR,*,HS,0,29.99
GBR,*,IV,0,29.99
GBR,*,KW,0,29.99
GBR,*,PA,0,29.99
GBR,*,PH,0,29.99

The csv file contents above asume that you offer UK Mainland delivery for £9.99 under £49.99 and FREE delivery for orders £50 and above.

Then it moves on to the specific post code areas e.g. “BT” for Nothern Ireland etc.

Save this file as “tablerates.csv” on your desktop.

Step 2 - Create A Local Copy of "Tablerate.php" File

Copy the following file from:

app/code/core/Mage/Shipping/Model/Mysql4/Carrier/Tablerate.php

to:

app/code/local/Mage/Shipping/Model/Mysql4/Carrier/Tablerate.php

Step 3 - Edit The "Tablerate.php" File

Find the following: (Was on line 84 in community ver 1.3.2.4)

$read->quoteInto("  AND dest_zip=?) ", $request->getDestPostcode()).

replace with:

$read->quoteInto("  AND dest_zip=?) ", substr($request->getDestPostcode(),0,2)).

Step 5 - Upload the "tablerates.csv" file

In Admin Panel go to the following page:

System → Configuration → Shipping Methods → Table Rates

Next, from the “Current Configuration Scope” dropdown on the top-left select your specific store you want to associate these table rates with. By default it’s the first store in the list below “Default Config”.

You will see an “Browse” button in the “Table Rates” field-set. Find the “tablerates.csv” file that you previously saved to your desktop and then click the “Save Config” button on the top-right.

Once the page refreshes you will see the green message “Configuration successfully saved”.

Finally

Add something to your basket and try it out.

NOTE: Please never edit your core files, always copy the file you edit to your local counterpart folder. If you don’t do this, your next Magento upgrade is very likely to overwrite your changes.