How can I change order of list of States by ISO code in address fields?

[tatamimimi]

Hi!!!

I'm making prestashop shopping site in Japanese.
I want to change order of "states" in the page of address registration or change address .

It's now in alphabetical order, but I want to make it order by ISO code.

I can't find which file should I change...
Please help me!

Thank you in advance.

[shokinro]

Have you tried to change that in getCountries() method in Country.php class file?

 

/classes/Country.php

 

It is better to create override class and then change it in the override class

/override/classes/Country.php

 

 

 

    public static function getCountries($id_lang, $active = false, $contain_states = false, $list_states = true)

    {

        $countries = array();

        $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('

SELECT cl.*,c.*, cl.`name` country, z.`name` zone

FROM `'._DB_PREFIX_.'country` c '.Shop::addSqlAssociation('country', 'c').'

LEFT JOIN `'._DB_PREFIX_.'country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = '.(int)$id_lang.')

LEFT JOIN `'._DB_PREFIX_.'zone` z ON (z.`id_zone` = c.`id_zone`)

WHERE 1'.($active ? ' AND c.active = 1' : '').($contain_states ? ' AND c.`contains_states` = '.(int)$contain_states : '').'

ORDER BY cl.name ASC');

        foreach ($result as $row) {

            $countries[$row['id_country']] = $row;

        }

[tatamimimi]

Thank you shokinro for your quick reply!

I tried to change the Country.php and put it in override foulder.

 

As my version is 1.6.1.4, actually the code was not same.
It was like below.
 

  if ($list_states) {
            $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('SELECT * FROM `'._DB_PREFIX_.'state` ORDER BY `name` ASC');
            foreach ($result as $row) {
                if (isset($countries[$row['id_country']]) && $row['active'] == 1) { /* Does not keep the state if its country has been disabled and not selected */
                        $countries[$row['id_country']]['states'][] = $row;
                }
            }
        }
        return $countries;

I changed the part of"name" to "iso_code".

 

It works now perfectly!
Thank you sooooooo much!!

[shokinro]

Hi tatamimimi

I am glad it worked, thanks for your feedback.

[MojoSwift]

Anyone know how to do this in 1.7.6.4?

I did that same as above, but the Japanese version of my store in unchanged. The states are still ordered alphabetically. Anywhere else I need to fix the code?

Specifically, I'm looking at the addresses on the account page. 

Thanks

[MojoSwift]

Can anyone help with this?

[MojoSwift]

On 12/19/2020 at 10:07 AM, MojoSwift said:

Anyone know how to do this in 1.7.6.4?

I did that same as above, but the Japanese version of my store in unchanged. The states are still ordered alphabetically. Anywhere else I need to fix the code?

Specifically, I'm looking at the addresses on the account page. 

Thanks

Never mind. There are 2 similar areas where the code needs to be edited (Line 220 and 254). I missed the 1st one.  😋