cancel
Showing results for 
Search instead for 
Did you mean: 

UK Shipping Zones

Highlighted
Occasional Contributor

UK Shipping Zones

We have the problem that weather MatrixRates or TableRates will work for our shipping requirement.

 

Mainland: 0 - 200 Subtotal 7,99

e.g.Northern Ireland 0 - 200 34,99 

 

So far so good. It works only if the postcode for outwards eg BT1 5GS it shows the shipping from mainland 7,99 and not 34,99.

 

Tried with changing Tablerate.php

 

$select = $adapter->select()

            ->from($this->getMainTable())

            ->where('website_id = :website_id')

            ->order(array('dest_country_id DESC', 'dest_region_id DESC', 'dest_zip DESC', 'price DESC'))

            ->limit(1);

 

        // Render destination condition

$orWhere = '(' . implode(') OR (', array(

"dest_country_id = :country_id AND dest_region_id = :region_id AND INSTR(Smiley Tongueostcode, dest_zip) = 1",

"dest_country_id = :country_id AND dest_region_id = :region_id AND dest_zip = ''",

 

// Handle asterix in dest_zip field

"dest_country_id = :country_id AND dest_region_id = :region_id AND dest_zip = '*'",

"dest_country_id = :country_id AND dest_region_id = 0 AND dest_zip = '*'",

"dest_country_id = '0' AND dest_region_id = :region_id AND dest_zip = '*'",

"dest_country_id = '0' AND dest_region_id = 0 AND dest_zip = '*'",

 

"dest_country_id = :country_id AND dest_region_id = 0 AND dest_zip = ''",

"dest_country_id = :country_id AND dest_region_id = 0 AND INSTR(Smiley Tongueostcode, dest_zip) = 1",

"dest_country_id = :country_id AND dest_region_id = 0 AND dest_zip = '*‘",

)) . ')';

 

It works now but, free shipping rule in mainland from subtotal 200 and above is not working. So i get tnt shipping option with 7,99.

 

How can we solve this?

  • magento1