Timeouts updating categories

  • Resolved marvc

    (@marvc)


    5 years, 3 months ago

    This is my first woocommerce store so apologies in advance if my inquiry is associated with a common issue in woocommerce. In this scenario I have woocommerce integrated with a print on demand service called Printful. Once I upload a new item into Printful it appears in the assigned woocommerce category but there are no tags associated with it. Whenever I attempt to bulk edit over 5 products I get timeout errors and the site basically crashes. After a page refresh I can see that no more than 5 products may have been updated. This is an error I usually see in the logs:

    [25-Dec-2019 03:56:38] script_filename = /var/web/site/public_html/wp-admin/edit.php; mysqli_query() /var/web/site/public_html/wp-includes/wp-db.php:2030; _do_query() /var/web/site/public_html/wp-includes/wp-db.php:1918; query() /var/web/site/public_html/wp-includes/wp-db.php:2536; get_var() /var/web/site/public_html/wp-includes/taxonomy.php:3720; _update_post_term_count() /var/web/site/public_html/wp-includes/taxonomy.php:3152; wp_update_term_count_now() /var/web/site/public_html/wp-includes/taxonomy.php:3124; wp_update_term_count() /var/web/site/public_html/wp-includes/taxonomy.php:2517; wp_set_object_terms() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wpPostStore.php:115; save_action_group() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_wpPostStore.php:29; save_action() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_ActionFactory.php:109; store() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/classes/ActionScheduler_ActionFactory.php:59; single() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/libraries/action-scheduler/functions.php:18; as_schedule_single_action() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/queue/class-wc-action-queue.php:44; schedule_single() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/queue/class-wc-action-queue.php:31; add() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/wc-webhook-functions.php:33; wc_webhook_process_delivery() /var/web/site/public_html/wp-includes/class-wp-hook.php:288; apply_filters() /var/web/site/public_html/wp-includes/class-wp-hook.php:312; do_action() /var/web/site/public_html/wp-includes/plugin.php:478; do_action() /var/web/site/public_html/wp-content/plugins/woocommerce/includes/class-wc-webhook.php:112; process() /var/web/site/public_html/wp-includes/class-wp-hook.php:290

    Again, I’m basically new to woocommerce but in my efforts to track down the problem I ‘think’ I can safely rule out the hosting environment & plugins. So I’m wondering if anyone can help shed some light on this issue. I’ve got a lot of products but can’t imagine having to edit tags on each individual item.

    Any responses appreciated

    The page I need help with: [log in to see the link]

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

  • Hi @marvc,

    I would suggest to export data using WooCommerce inbuilt functionality and import using the same, Where you can edit product more faster. Please make sure you’re taking full database backup before importing anything.

    Product CSV Importer and Exporter Documentation

    Thomas Shellberg

    (@shellbeezy)

    Automattic Happiness Engineer

    Hi @marvc,

    It sounds like the update may be timing out either because of execution script limits on your server(the script runs too long) or the memory limits are exceeded. You could check for any more specific logs for those types of errors.

    As @princebhalani143 mentioned, it might be best to do bulk updates with a CSV export & import. The CSV import process has asynchronous jobs to perform work so it shouldn’t time out.

    Moderator Hari Shanker R

    (@harishanker)

    Hi @marvc

    Just checking-in on this for you. I hope that the suggestions we provided helped guide you in the right direction.

    Since we haven’t heard from you in a while, I’m going to mark this topic as Resolved. Let us know if you keep running into troubles. You can either reply here to follow-up with the same problem, or create a new thread to report your troubles to us.

    All the best!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Timeouts updating categories’ is closed to new replies.

Tags