Limiting number of variations returned per product

  • Hi, thanks for the great plugin.

    Our store has a mix of simple and variable products. Some of the variable products have over 100 variations, and we’ve set the plugin to show child products in the search results.

    The problem comes when, for certain queries, the search returns >100 variations for one product, pushing other products out of the results.

    Is it possible to limit the number of child variations returned per parent product? This would have to be at query level, because I can’t really raise the query results over 100 as this leads to the search becoming too slow.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author ILLID

    (@mihail-barinov)

    Hi,

    I am afraid that you can limit the number of displayed product variations. Have you thought about just disabling product variations display at all and show only parent products?

    Regards

    Thread Starter maxington26

    (@maxington26)

    Yes, I have considered only displaying parent products, but as we use so many products with lots of colour variations, it’s preferable that the results for e.g. “green chair” or “black desk” actually show the individual variation images rather than just the parents.

    If there’s no way to limit the number of variations per product, I’ll just have to accept sometimes the results will be flooded out by one variable product, unless there is another solution?

    • This reply was modified 2 years, 9 months ago by maxington26.
    Thread Starter maxington26

    (@maxington26)

    Hi again, I just had a thought about this.

    I’m not a woocommerce expert – can variation children be flagged up for inclusion in search results or not?

    And if not, is it possible to set up a boolean custom variable per variation within woo, to eliminate the ‘false’ variation search results at sql query level?

    So I could go through each product and manually set the boolean variable to ‘true’ for the best variations, and then they would be the only ones with ability to appear in the search results. It does slightly defeat the colour-choice aim, but I could find a balance I reckon.

    Any thoughts would be great to hear

    • This reply was modified 2 years, 9 months ago by maxington26.
    • This reply was modified 2 years, 9 months ago by maxington26.
    • This reply was modified 2 years, 9 months ago by maxington26.
    • This reply was modified 2 years, 9 months ago by maxington26.
    • This reply was modified 2 years, 9 months ago by maxington26.
    • This reply was modified 2 years, 9 months ago by maxington26.
    • This reply was modified 2 years, 9 months ago by maxington26.
    • This reply was modified 2 years, 9 months ago by maxington26.
    Plugin Author ILLID

    (@mihail-barinov)

    I understand that you can use search results filters for this.

    So you can set filter to show only product variations with certain attribute/category/tag/custom field and hide all other.

    Regards

    Thread Starter maxington26

    (@maxington26)

    Ok, thanks. I’ll give it a try. Thanks for the help

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Limiting number of variations returned per product’ is closed to new replies.