Sorting stops working 4 categories deep

  • I’ve made a blank site using Twenty Twenty One theme with the following category structure

    Level 1 A
    -Level 2 C
    –Level 3 E
    —Level 4 G
    —-Level 5 I
    —–Level 6 K
    —–Level 6 L
    —-Level 5 J
    —Level 4 H
    –Level 3 F
    – Level 2 D

    I changed each category to show subcategories. I assigned a product to each category.

    I then went into the Term Order plugin and went through each level changing the order. I also set the taxonomy to use the custom order set above.

    It worked until I was editing Level 4 – then my order changing in the Term Order plugin did not take effect. It did not take effect on level 5 either.

    Changing the order of the categories worked on level 1, 2 and 3.

    The only plugins I have activated are Woocommerce, Custom Taxonomy Order and ACF.

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

    (@mpol)

    Hi,
    Thank you for reporting this.
    I made an improvement in 3.4.1. It isn’t really fixed, but now it should cause problems only on deeper levels. Here it works on level 6 as well now.

    I am using a float type for ordering sub-terms, but it turns out floats are not really precise in computers.

    Thread Starter user9876789

    (@user9876789)

    Thanks for this, I’ve updated to the latest version and it’s working for me now. I’ve updated our client’s website and asked them to check it’s working for them. I’ll update/ close this once I’ve heard back from them.

    Thread Starter user9876789

    (@user9876789)

    Hello, although the update fixed the order issue, it caused the admin loading times of products and categories to be incredibly slow to the point of being unusable. It’s taking a couple of minutes to load up a category page in the admin.

    This particular client does have a lot (30k products and 5k categories). Please could the fix be revisited?

    Plugin Author Marcel Pol

    (@mpol)

    Hi,
    Ouch, that is not funny. WooCommerce is not that lightweight anymore, I have seen that more.

    I just relaesed 3.4.2. It doesn’t do the calculation on the admin dashboard that was added in the previous update.
    Is this a good compromise for you? The front-end is still having good responses?

    Regards,
    Marcel

    Thread Starter user9876789

    (@user9876789)

    I have applied the latest update and the admin speeds are same as 3.4.0.
    However, the front end speed is really degraded. I’ve ran Query Monitor, on version 3.4.0 it took 1.33 seconds to load a category page, on version 3.4.2 it’s taking 15.29 seconds.

    Plugin Author Marcel Pol

    (@mpol)

    Ouch, I don’t like anything about this.
    These calculations are way too expensive. I think it is all using cache, right? With QM, it doesn’t do more database queries between 3.4.0 and 3.4.2, right? Here it is using cache.
    I decided to use the simple padding again if there are more than 700 terms, on admin and frontend. That means that sorting might not be correct.

    Sorry to other people that this change took 3 updates. I should have requested feedback based on a development version.

    Thread Starter user9876789

    (@user9876789)

    Hi Marcel, just to confirm, are you saying you’ve put it back how it was in version 3.4.0 so it wont order categories correctly after 4 levels deep?

    Plugin Author Marcel Pol

    (@mpol)

    Basically, yes, in case where there are more than 700 terms. With less it does execute all these more expensive calculations.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Sorting stops working 4 categories deep’ is closed to new replies.