Support » Plugin: WooCommerce » order product lookup table ?

  • Resolved Gerdski

    (@gerdski)


    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)

    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)

    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)

    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)

    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)

    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.