order product lookup table ?

Hello,

Thanks for reaching out!

The lookup table mentioned in that topic is a feature that was released with WooCommerce 6.3 a few months ago. You can read more about it here: https://developer.woocommerce.com/2022/02/02/new-product-filtering-by-attributes-rolling-out-in-woocommerce-6-3/

Hope this helps!

Hello,

thanks for your answer. It helps…but also not ??

Unfortunately we cannot update WC right now, but anyway we’d probably need a custom lookup table.

Do you have any information on how to create and maintain such a custom lookup table? I believe it shoul be created / filled in small steps and then updated with every new / changed / deleted order.

Thanks!

Hello,

Thanks for writing back!

Custom solutions are outside our scope of support, but I found this article that might be helpful to you.

https://www.codeable.io/blog/large-woocommerce-search-faster/

I’m going to leave this topic open for a bit to see if anyone from the community wants to suggest something else.

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

You can also visit the WooCommerce Facebook 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.

Hi,

thanks for answering. Meanwhile I have found the solution to my problem, it was a SQL query that was effective in the beginning but went ineffective as the number of customers and orders rose.

But the links you posted are of great value, I will bookmark them, because the next Woo problem will be just around the corner ??

Glad to hear that you have found a solution.

If you have any further questions, I recommend creating a new thread. I’ll go ahead and tag this thread as solved.

Cheers.