Update ordering for all in once.

  • Hello there,

    I hope you are doing well.

    I have an ecommerce website with more than 2700 product cats. Is it possible to update their order alphabetically in bulk instead of going into one by one parent and sub parent categories?

    Also, after I do that new ordering, I would like to have it also on the database. Not just working on the frontend or backend. Is this possible?

    Thanks in advance,

    George.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Marcel Pol

    (@mpol)

    Hello George,

    I am doing well. I hope you too.

    I am not sure what to answer. I do understand the sorting of subcategories is a bit unwieldy in this context. I have no good solution. Maybe there is an approach in changing the plugin and have it get all subcategories, so you can change them manually in one go. That would only be needed once, so afterwards you can just install regular updates.

    If there is some pattern in the sort order that you want to apply, like for example alphabetically, or the number of posts that are in that category. You could write some custom PHP code to sort them and save a term_order.

    The sort order is saved in the database in the term_order field. Standard queries are not using that field for sorting. The sorting is often done after getting the terms from the database, which does make it CPU intensive. With 2700 categories, you will want to look into how this affects your page speed.

    Thread Starter toulip

    (@toulip)

    Hello @mpol,

    Thanks for your response.

    I understand your point of view. I will deep further into the code and see what I can do that way.

    Also, thanks for clarifying how the plugin works and what takes from the database to generate the sorting.

    I will let you know if I have any other questions or concerns.

    Best Regards,

    George.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Update ordering for all in once.’ is closed to new replies.