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(
ostcode, 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(ostcode, 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?