Search code examples
magentomagento-1.9

Magento table rate shipping - exclude some regions from shipping

I have setup a table rate shipping in Magento 1.9. I need to exclude some region from shipping.

For eg., In CSV there are 2 rows, in this format:

Country code - Region - postal - thrashhold - shipping cost
1. FR     - Corsica -   * -         0   -            18
2. *      -  *      -   * -         0   -            50

Currently, If I select France - Corsica in shipping calculator, then it returns shipping cost as 18, which is correct. If I select France - any other region then it shows shipping cost 50, which is not as requirement. Is it possible to restrict other regions, if I select France - any other region?

Solution

  • I think, I got it. I need to remove the regions from tables: directory_country_region and directory_country_region_name, then it wont give option to select other regions of France. Then the shipping can be restricted for these regions.