Issue with API Making Batch Update

  • Resolved elmills81

    (@elmills81)


    5 years, 6 months ago

    Have my store created and the existing set of products sync’d without issue. Tried to add a t-shirt and it starts to add the shirt. The product is created on mysite, at least partially, but then reports a 500 error on Printful Site.

    Product was not added!

    500 Internal Server Error occurred! Please check your server logs for a detailed issue description.

    CODE: G76457870

    Searching through apache logs this is what is found. Keys removed, but I did check that they matched.

    “POST /wp-json/wc/v2/products/batch?consumer_key=REMOVED&consumer_secret=REMVOED HTTP/1.1” 500 149 “-” “Printful WooCommerce Integration/3.0.0”

    Information from Support Function in plugin:
    ##### Printful Checklist #####
    * Connection to Printful API => OK
    * Printful API key is set => OK
    * WordPress Permalinks => OK
    * WordPress version => OK
    * WooCommerce Webhooks => OK
    * WooCommerce API keys are set => OK
    * WooCommerce authentication URL access=> OK
    * WordPress remote requests => OK
    * WordPress Site URL => OK
    * Recent store sync errors => OK
    * Write permissions => OK
    * PHP memory limit => OK
    * PHP script time limit => OK

    ##### Printful Last Sync’s #####

    ##### Environment #####
    * home_url => https://bigebeardedcoffee.com
    * site_url => https://bigebeardedcoffee.com
    * version => 3.7.0
    * log_directory => /home/blueboat/webapps/bige/wp-content/uploads/wc-logs/
    * wp_version => 5.2.3
    * language => en_US
    * server_info => Apache
    * php_version => 7.1.31
    * php_max_execution_time => 30
    * php_max_input_vars => 1000
    * curl_version => 7.29.0, NSS/3.36
    * mysql_version => 5.6.44
    * mysql_version_string => 5.6.44-86.0
    * default_timezone => UTC
    * remote_post_response => 200
    * remote_get_response => 200

    ##### Database #####
    * wc_database_version => 3.7.0
    * database_prefix => wp_
    * maxmind_geoip_database => /home/blueboat/webapps/bige/wp-content/uploads/GeoLite2-Country.mmdb

    ##### Active Plugins #####
    * ManageWP – Worker (4.9.1)
    * Query Monitor (3.3.7)
    * BigE Custom Inventory Notice (1.0)
    * Akismet Anti-Spam (4.1.2)
    * Blue Boat Solutions Custom Features (1.3)
    * Enable Media Replace (3.3.6)
    * Facebook for WooCommerce (1.9.15)
    * Genesis Connect for WooCommerce (1.1.0)
    * Genesis eNews Extended (2.1.1)
    * Imagify (1.9.6)
    * Jetpack by WordPress.com (7.7.1)
    * Mailchimp for WooCommerce (2.2.2)
    * Order Delivery Date for WooCommerce (Lite version) (3.10)
    * Printful Integration for WooCommerce (2.1.6)
    * SendGrid (1.11.8)
    * UpdraftPlus – Backup/Restore (1.16.16)
    * WooCommerce Blocks (2.4.1)
    * Advanced Order Export For WooCommerce (3.0.3)
    * WooCommerce Admin (0.18.0)
    * WC Autoship Product Page Options (1.1.4)
    * WC Autoship (4.1.18)
    * WooCommerce Print Invoice & Delivery Note (4.5.2)
    * WooCommerce Stripe Gateway (4.2.3)
    * WooCommerce Order Status Manager (1.10.2)
    * WooCommerce Services (1.21.1)
    * WooCommerce (3.7.0)
    * Wordfence Security (7.4.0)
    * WP Rocket (3.3.7)
    * WPFront Notification Bar (1.7.1)

    ##### Theme #####
    * name => Essence Pro
    * version => 1.0.2
    * author_url => https://www.studiopress.com/
    * parent_name => Genesis
    * parent_version => 3.1.2
    * parent_author_url => https://www.studiopress.com/

    ##### WooCommerce settings #####
    * currency => USD
    * currency_symbol => $
    * currency_position => left
    * thousand_separator => ,
    * decimal_separator => .
    * woocommerce_com_connected => yes

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support zana.printful

    (@zanaprintful)

    Hi @elmills81, thanks for reaching out!

    Sorry to see you are running into this error in your integration, but thank you for providing some information on your store!

    The log you have mentioned refers to the request we make, it doesn’t provide actual information about what is causing the error.
    The “500 internal server error” comes from your server’s side which means that there is an issue with your server. It can be related to the server’s performance such as memory or timeout issues.

    You can try disabling the plugins you are using for your store, except for Printful and WooCommerce, and try adding a product then. It is possible that a conflicting plugin is causing the error. If the error disappears after adding a product with the plugins deactivated, you can enable the plugins one by one again to see which one of them is causing the error.
    In case the error still persists even with the plugins deactivated, we would recommend reaching out to your hosting provider for more details on why the request may be failing.

    Let us know if you have any other questions!

    @elmills81 I’m currently having the same issue right now; I changed nginx, PHP-FPM and php.ini timeout settings to 300s and post_max_size to 40M and i’m still having the same issues. Did you manage to fix it ?

    Thread Starter elmills81

    (@elmills81)

    @dukuo I was able to fix it, but it was a round about solution. I forgot that WooCommerce has its own logging after I spent too much time looking at the apache and php logs. It is under WooCommerce/Status/Logs. Look for the most recent fatal error log.

    Once I was in there, I found for me it was an issue in class-wp-image-editor.php. When I dug further it was actually call out to the image optimization tool I was using that was causing the process to run long and generating errors. I doubt this will be your particular issue, but the fix was pretty easy for me. Turn off auto optimization and then turn it back on after the store items had been bulk loaded.

    @elmills81 that’s interesting!

    Did by any chance your product had more mockups than the default ones? I was debugging too and talking with the Printful support team about the logs and indeed there’s a 502 code on their side and a 499 on my side, meaning in it indeed a timeout problem. Tried disabling all my optimization and cache plugins as you suggested, but the error persists. If I add a product with the default amount of mockups (which I believe is 2) then there’s no issue whatsoever.

    Anyways, I’ll add more when I get this working, I just received an email from the Printful support team with a possible solution.

    Thanks for everything so far!

    Thread Starter elmills81

    (@elmills81)

    I had 6 mockups since I had six colors that I was offering for the product. I never tried processing with fewer, but that would make sense.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Issue with API Making Batch Update’ is closed to new replies.