how to consult only the first product variation in the archive pages

  • Resolved cesarhr91

    (@cesarhr91)


    3 years, 6 months ago

    Hello there

    I have a problem with a web page that has more than 200 variable products, which each have more than 250 product variations, the problem is performance, the page load times are high.

    I have partially solved the problem optimizing the database as best I can, configuring the server to its maximum performance and using cache systems to save the pages, but I have conflict in the store archive pages, categories and filters, it is very complicated for my caching these pages because the server doesn’t give me enough to save so much information, it suddenly ends the execution processes and I can’t even query the pages.

    I have already verified that the problem is the amount of product variations since in pages with simple products the problem does not appear, I found that if I deactivate the prices of the products so as not to show them, the performance of the server allows me to consult these pages.

    So what I have been trying is to find a way to limit the requests for the products to databases to get only the first product variation and only show the price of that variation, but I have not been able to carry it out.

    That is why I am looking for your help to know if it is possible to do it, limit the queries to the product database so that only the first product variation returns and show the prices of that variation in the archive pages.

    Thank you very much in advance for reading my query and I hope I can count on your support.
    Greetings

    • This topic was modified 3 years, 6 months ago by cesarhr91.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi there,

    This is a fairly complex development topic. I’m going to leave it open for a bit to see if anyone is able to chime in to help you out.

    I can also recommend the WooCommerce Developer Resources Portal for resources on developing for WooCommerce.

    You can also visit the WooCommerce Facebook Community group or the #developers channel of the WooCommerce Community Slack. We’re lucky to have a great community of open-source developers for WooCommerce, and many of our developers hang out there, as well.

    Cheers!

    Thread Starter cesarhr91

    (@cesarhr91)

    Hi Mirko,

    Thank you for your answer and for your information, I will make use of it hoping to find a solution, and hopefully someone here can guide me in the same way.

    Greetings

    Mirko P.

    (@rainfallnixfig)

    You’re welcome! I’ll leave it open for a while although on this forum there aren’t many developers that can help you with the custom code. Hence, it’s much better to try the developer channels mentioned above.

    For customization, I can also recommend reaching out to a developer locally or to someone from our customizations page https://woocommerce.com/customizations/.

    Cheers.

    Mirko P.

    (@rainfallnixfig)

    Hi there,

    We’ve not seen any activity on this thread for a while, so I’m marking this thread as resolved.

    Hopefully, you were able to find a solution and the above resources for developers were helpful. If you have further questions, please feel free to open a new topic.

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘how to consult only the first product variation in the archive pages’ is closed to new replies.