Jump to content

SOLVED Shipping problem


Recommended Posts

Hi all

When my customers (only UK at present) get to the checkout, and they agree to terms etc, a message comes up telling them " There is no carrier available that will deliver to this address! ". I have only got one carrier on the shipping list, which is in the UK.

Please can anybody tell me how to correct this problem. I am not a programmer so be gentle please.

hippooflove

www.bmhtrading.co.uk

Link to comment
Share on other sites

Hi,

I started looking at this issue this morning.

I have used this successfully on 1.1.x. However after upgrading yesterday to 1.2.2.0 final it now says "There is no carrier available that will deliver to this address!"


Ive checked the SVN to which they compare as identical.

I have zones, i have countries assigned to those zones and I have weights and prices defined.

if ((Configuration::get('PS_SHIPPING_METHOD') AND $carrier->getMaxDeliveryPriceByWeight($id_zone) === false)
OR (!Configuration::get('PS_SHIPPING_METHOD') AND $carrier->getMaxDeliveryPriceByPrice($id_zone) === false))
{
unset($result[$k]);
continue ;
}

This part seems to be causing the issue, entering echo "hello world"; it is display on the output.

Configuration::get('PS_SHIPPING_METHOD') returns '11'


Which runs these 2 queries:

SELECT d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` w ON (d.`id_range_weight` = w.`id_range_weight`) WHERE d.`id_zone` = 6 AND 6 <= w.`delimiter2` AND d.`id_carrier` = 8 ORDER BY w.`delimiter1` ASC

SELECT d.`price` FROM `ps_delivery` d LEFT JOIN `ps_range_weight` w ON (d.`id_range_weight` = w.`id_range_weight`) WHERE d.`id_zone` = 6 AND 6 <= w.`delimiter2` AND d.`id_carrier` = 8 ORDER BY w.`delimiter1` ASC

On checking the table: ps_delivery is empty?

Can you advise?

Pierce

On checking

Link to comment
Share on other sites

×
×
  • Create New...