How would you sort {host}/categories by name?

I ended up doing this via SQL. [图片] Ordering categories using SQL Development The following code changes the order of categories to be alphanumeric using SQL. Preconditions. Postgres backend UPDATE categories SET POSITION = subquery.position FROM ( SELECT POSITION , CASE WHEN category_id = 0 THEN parent_category_id ELSE category_id END category_id , CASE WHEN category_id = 0 THEN parent_category_name ELSE category_name END category_name FROM ( SELECT ROW_NUMBER - 1 AS POSITION , parent_category_id , parent_category_name , category_id , category_name F…

Are you trying to order categories on the Category page? If so, that can be done by enabling the fixed category positions Site Setting. When that setting is enabled, an option to Reorder Categories is added to the staff menu on the top-right of the category page. If this isn’t what you’re looking for, let us know.

If you have more than 20 or so, a bit of ruby at the console can sort them all.

Do you know off hand the field that would have to be changed?

[图片] simon: If this isn’t what you’re looking for, let us know. That looks cool and it looks like it would work. It doesn’t work well with Categories with SubCategories. Which I click on a main category to move up it doesn’t move. Sub categories within a main category do move. Is that a bug?

It works here. Could be customisations interfering with the page.

[图片] Stephen: It works here It works here as long as the item above is a parent category. It fails when the item above is a subcategory. Is there an official way I can add a test that shows the problem (or not) … do the UI tests use Puppeteer or something similar?

按名称对分类进行排序

产品支持

csmu (Keith John Hutchison - Ceiteach Seán Mac Úistin) 2019 年3 月 13 日 23:03 8

The issue I’m seeing is pretty much the same as Reorder Categories behaving strangely

话题		回复	浏览量
Ordering categories using SQL Development	8	900	2021 年3 月 13 日
Ordering categories is quite glitched when the numbers get high Bug	1	153	2025 年5 月 27 日
How to order Categories? Product Support	14	12567	2021 年10 月 24 日
Reorder categories doesn't recognize subcategory order Feature	11	2499	2021 年11 月 8 日
Manually sort subcategories in a specific parent category? Product Support	2	154	2024 年10 月 24 日

按名称对分类进行排序

相关话题