Bug Report: "out the box" alphabetical province order error, unable to reorder

Phoca Cart - complex e-commerce extension
morphinestyle
Phoca Professional
Phoca Professional
Posts: 118
Joined: 19 Jan 2022, 19:55

Bug Report: "out the box" alphabetical province order error, unable to reorder

Post by morphinestyle »

Hello everyone,
i'm searching a way to re-order the province/region order because of alphabetical error of listing in italian regions/provinces on Phoca Cart:
Image: https://ibb.co/xjcZ43W

because of this:
Image: https://ibb.co/XWKxyVH

The list of region province follow the "ID creation order" in database, that in this case is wrong on "out the box" italian provinces/region list on Phoca Cart, but if the order could be changed i can reorder correctly the provinces/regions.

How can set Phoca to follow my ordering instead creation ID order?
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Bug Report: "out the box" alphabetical province order error, unable to reorder

Post by Jan »

Hi, for now, there is no such option.
The simplest way to solve it for now is to delete all the regions, download fixed file:
https://github.com/PhocaCz/PhocaCart/re ... s.utf8.sql
copy it to:
administrator/components/com_phocacart/install/sql/mysql/ folder and import the regions again. Then the ordering should be OK.

Jan
If you find Phoca extensions useful, please support the project
morphinestyle
Phoca Professional
Phoca Professional
Posts: 118
Joined: 19 Jan 2022, 19:55

Re: Bug Report: "out the box" alphabetical province order error, unable to reorder

Post by morphinestyle »

Pefect Jan!
It works, thank you very much!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Bug Report: "out the box" alphabetical province order error, unable to reorder

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Post Reply