Execution time: regenerate product lookup tables

  • Resolved stevewhitmore

    (@stevewhitmore)


    2 years, 7 months ago

    I have an automated script which pulls in new products and deletes old ones to keep in sync with another online store. At the end of each run I do a REST call to hit the the WooCommerce regenerate product lookup tables endpoint.

    Is there a way for me to find out exactly how long it takes for the table regeneration to take? I have over 3,000 products with inventory that fluctuates every hour and I’d like to know how much strain I’m putting on my database.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @stevewhitmore,

    Is there a way for me to find out exactly how long it takes for the table regeneration to take?

    If you go to WP Dashboard > WooCommerce > Status > Scheduled Actions and search for the hook wc_update_product_lookup_tables it will show you all the actions performed and the logs with info about the time when the action was created and when the action was completed via WP-Cron.


    Link to image: https://i.imgur.com/DLOFgsP.png

    Hope this helps.

    Thread Starter stevewhitmore

    (@stevewhitmore)

    This is exactly what I was looking for! Thanks @rainfallnixfig.

    For anyone who finds this in the future, be sure to sort by Scheduled Date ascending to see the most recent execution as it seems to default the other way.

    Mirko P.

    (@rainfallnixfig)

    Great! Thank you for letting me know it was helpful 👍

    I’ll mark this thread as resolved now. If you have any further questions, I recommend creating a new thread.

    Cheers.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Execution time: regenerate product lookup tables’ is closed to new replies.