order product lookup table ?

Resolved Gerdski
(@gerdski)

2 months ago

Hello all,
I came across this:
https://wordpress.org/support/topic/order-product-lookup-table/

And it’s probably what I would need, because at the moment I am querying all the orders of the last 365 days, sorted by customer, but tha database has gotten too big, and I’m running out of script time.

So, a lookup table would be nice.

But there is no such table in our database. How can I find this table? Or must I create it myself?

Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Support Paulo P – woo-hc
(@paulostp)

2 months ago

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!

Thread Starter Gerdski
(@gerdski)

2 months ago

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!

Plugin Support Paulo P – woo-hc
(@paulostp)

2 months ago

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.

Thread Starter Gerdski
(@gerdski)

1 month, 4 weeks ago

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 🙂

Plugin Support Igor H woo-hc
(@ihereira)

1 month, 4 weeks ago

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.

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

Views