Title: AutomateWoo Problem
Last modified: May 27, 2022

---

# AutomateWoo Problem

 *  Resolved [herng77](https://wordpress.org/support/users/herng77/)
 * (@herng77)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/)
 * Anybody is using AutomateWoo and faced this issue? [https://snipboard.io/qDNx1A.jpg](https://snipboard.io/qDNx1A.jpg)
 * Our website is pretty large, many optimization was done, page load speed was 
   usually around 2-3 seconds per page.
 * However, when we tried to run manual workflow with AutomateWoo, for around 50k
   orders, it will take at least 5-6 hours to load where my rules is just to capture
   a list of customer that purchased XXX products before.
 * I have tested to take the records with database with the same result, it will
   just take < 1 seconds. Not sure why is it taking so long do search.
 * Steps I have done:
 * Optimizing the wc_orders_itemmeta(Which will be the table the workflow search
   for)
 * Deactivating all plugins except AutomateWoo and Woocommerce.
 * Server Spec:It is an AMD Epyc 7451 – 24c/48t & SSD + RAID. (I dont think it is
   the hardware issue)
 * I have also tried to contact support for this issue, and all they say is
 * <<Querying large sets (100k+) of Orders based on metadata is a known bottleneck
   for AutomateWoo and WooCommerce itself, and one that is being actively worked
   on….
 * Ultimately, we may not have a solution to improving the workflow run time in 
   the near future, XXX>>
 * I have already shortened the duration to like 10 days (~10K orders) it still 
   takes so long! Does that mean if I have more than 5-6k orders lifetime (very 
   very likely to happen and I can’t use the plugin anymore?)
    -  This topic was modified 3 years, 10 months ago by [herng77](https://wordpress.org/support/users/herng77/).
    -  This topic was modified 3 years, 10 months ago by [herng77](https://wordpress.org/support/users/herng77/).

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

 *  [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * (@rainfallnixfig)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15685921)
 * Hi [@herng77](https://wordpress.org/support/users/herng77/),
 * Thanks for reaching out!
 * > Wouldn’t mind to give a small tip if you are able to help me on this!
 * These are free forums and are not the right place to offer a reward for help.
   Any thread that offers any service for money can be closed at any time by a moderator.
   You can read the forum guidelines here:
 * * [https://wordpress.org/support/guidelines/#do-not-offer-to-pay-for-help](https://wordpress.org/support/guidelines/#do-not-offer-to-pay-for-help)
 * For paid assistance, we usually recommend contacting developers or customization
   experts listed at [https://woocommerce.com/customizations/](https://woocommerce.com/customizations/).
 * **Note:** Per the [Forum Guidelines](https://wordpress.org/support/guidelines/#do-not-post-about-commercial-products)
   paid extensions are not meant to be supported on this public forum which is only
   focused on WooCommerce core, but through official support channels instead.
 *  Thread Starter [herng77](https://wordpress.org/support/users/herng77/)
 * (@herng77)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15685937)
 * Sorry about that, have edited it away, I still need help on this! hopefully someone
   can help!
 *  [Juan G. (woo-hc)](https://wordpress.org/support/users/judagutor/)
 * (@judagutor)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15686393)
 * Hi [@herng77](https://wordpress.org/support/users/herng77/)!
 * If you reached AutomateWoo support at [WooCommerce.com > My Account > Support](https://woocommerce.com/my-account/create-a-ticket/?form=ticket)
   to discuss this issue and still want to improve it, you could achieve it through
   custom code.
 * In this case, you can visit the [WooCommerce Facebook group](https://www.facebook.com/groups/advanced.woocommerce/)
   or the `#developers` channel of the [WooCommerce Community Slack](https://woocommerce.com/community-slack/),
   where you could find help from the community of open-source developers for WooCommerce
   that hangs in there.
 * Anyway, I am leaving this thread open for a while to see if anyone can chime 
   in to help you out.
 * Cheers!
 *  Thread Starter [herng77](https://wordpress.org/support/users/herng77/)
 * (@herng77)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15686395)
 * I have already reached out to them and all they say was we are unable to support
   orders more than 100,000 but it was not the case, even for 1k orders it will 
   take at least 20-30mins to load.
 *  [Margaret S. woo-hc](https://wordpress.org/support/users/margaretwporg/)
 * (@margaretwporg)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15687437)
 * Hi [@herng77](https://wordpress.org/support/users/herng77/)
 * Thanks for the update.
 * As the problem is related to the premium [AutomateWoo](https://woocommerce.com/products/automatewoo/)
   extension, please contact us at [WooCommerce.com > My Account > Support](https://woocommerce.com/my-account/create-a-ticket/?form=ticket).
 * Feel free to include a link to this forum topic on the ticket, so we can use 
   this topic as a reference.
 * We will be able to help you further there.
 * As Mirko already stated above, paid extensions are not meant to be supported 
   on this public forum, but through official support channels instead.
 * Thanks
 *  Thread Starter [herng77](https://wordpress.org/support/users/herng77/)
 * (@herng77)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15687441)
 * I have contacted you all through official support channel and you guys said you
   were unable to help on that. I am currently looking to do some modification so
   it can support me.
 *  [Igor H](https://wordpress.org/support/users/ihereira/)
 * (@ihereira)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15687497)
 * Hello,
 * Sorry to hear that, It looks that in this scenario the number of orders is higher
   than the standard.
 * To request further assistance please check the resources provided by Mirko, and
   Juan.
 * You can recommend a plugin feature at [Ideas Board](http://ideas.woocommerce.com/forums/133476-woocommerce),
   which is where developers go to look for future plugin features and improvements.
 * Thank you.
 *  [Margaret S. woo-hc](https://wordpress.org/support/users/margaretwporg/)
 * (@margaretwporg)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15707912)
 * This thread has been inactive for a bit, so I’m going to mark it closed. Hopefully,
   the above information was useful to you and helped point you in the right direction.
 * Please feel free to open a new thread if you have any other questions related
   to core WooCommerce.

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

The topic ‘AutomateWoo Problem’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [AutomateWoo](https://wordpress.org/support/topic-tag/automatewoo/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 8 replies
 * 5 participants
 * Last reply from: [Margaret S. woo-hc](https://wordpress.org/support/users/margaretwporg/)
 * Last activity: [3 years, 10 months ago](https://wordpress.org/support/topic/automatewoo-problem/#post-15707912)
 * Status: resolved