Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Unable to deselect shipping to other countries  (Read 4061 times)

Offline Karlos

  • Newbie
  • *
  • Posts: 42
  • Karma: +4/-0
    • View Profile
Unable to deselect shipping to other countries
« on: February 03, 2014, 06:51:28 PM »
Hi all,
I am in England and only want to deliver to England at the moment.  I have gone to localization/countries and turned a few of the other countries status to off.  I have cleared the cache, but everytime I go to the cart all the countries are still there !

Can anyone help ?

Thanks


Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Unable to deselect shipping to other countries
« Reply #1 on: February 03, 2014, 11:48:38 PM »
Hmm. Interesting. Small bug,

Here is a fix:

Open file: storefront/model/localisation/country.php

Locate following line around line 50:

Code: [Select]
    $query = $this->db->query( "SELECT *
    FROM " . $this->db->table("countries") . " c
    LEFT JOIN " . $this->db->table("country_descriptions") . " cd
    ON (c.country_id = cd.country_id AND cd.language_id = '" . (int)$language_id . "')
    ORDER BY cd.name ASC");
   

Replace with
Code: [Select]
    $query = $this->db->query( "SELECT *
    FROM " . $this->db->table("countries") . " c
    LEFT JOIN " . $this->db->table("country_descriptions") . " cd
    ON (c.country_id = cd.country_id AND cd.language_id = '" . (int)$language_id . "')
    WHERE c.status = '1'
    ORDER BY cd.name ASC");
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline Karlos

  • Newbie
  • *
  • Posts: 42
  • Karma: +4/-0
    • View Profile
Re: Unable to deselect shipping to other countries
« Reply #2 on: February 04, 2014, 02:09:35 PM »
Many thanks for your reply, this sorted it out! :)

 

Powered by SMFPacks Social Login Mod