Order detail page 504 timeout due to large amount of order items

  • Resolved michaeledi

    (@michaeledi)


    11 months, 1 week ago

    Hi team,

    I’m using a custom plugin that turns 3D models into custom order items, and when a user ordered too many items, the back-end order detail page cannot be opened and display 504 time-out error instead.

    Is there a way to tune the PHP or MYSQL settings to make it work?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello michaeledi

    Thanks for contacting WooCommerce support.

    I understand you are facing a 504 time-out error when a user orders too many items. The 504 Gateway Timeout Error indicates that the server didn’t receive a timely response from an upstream server it needed to access to complete a request.

    To help you further, I’d like to understand more about your setup.
    Are you using a 3rd party API to process your orders?

    Also could you please send me a copy of your site’s System Status?
    You can find it via WooCommerce > Status.
    Select Get system report and then Copy for support.

    Once you’ve done that, you can paste the text in https://gist.github.com
    After that, you can paste the Gist link here in your reply.

    Looking forward to your response. ??

    Thread Starter michaeledi

    (@michaeledi)

    Hi @doublezed2,

    Thanks a lot for the fast response, here’s the system report: https://gist.github.com/michaeledi/6c099fc20611121bf80e467e9c2f287e, and I don’t think the plugin is using 3rd party API to process orders, the user directly order in woocommerce and all orders are also handled through woocommerce.

    • This reply was modified 11 months, 1 week ago by michaeledi.
    Plugin Support Beauty of Code (woo-hc)

    (@beautyofcode)

    Hey @michaeledi,

    While the issue you are experiencing appears to be more server-related that WooCommerce related, I’d be happy to provide some suggestions on how to ttroubleshoot the 504 timeout error.

    Total Database Size: 4113.24MB

    Checking your SSR, I am able to see that you have quite a large database. I’d suggest optimizing the database and see if this makes any difference. You can try using the free?WP-Optimize?plugin for this.

    PHP Version: 7.4.33

    Upgrading your PHP version to 8.1 (currently the highest recommended PHP version for WooCommerce) might offer performance improvements due to enhancements and optimizations in newer PHP versions.

    Check for any server-side errors that may indicate what may be contributing to the 504 timeout error.

    Additionally, this support article provides some helpful troubleshooting steps for this particular error:

    Cheers!

    Thread Starter michaeledi

    (@michaeledi)

    Thanks, I’ve solved it by increasing the PHP-FPM request_terminate_timeout, max_execution_time, memory_limit etc, it just needed more time to process the request…

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello michaeledi,

    Thank you for your reply.

    We’re thrilled to hear that you’ve successfully resolved the issue!
    Excellent work on identifying that your server just needed more time to process the request.

    Please don’t hesitate to contact us again if you have more questions or concerns. ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Order detail page 504 timeout due to large amount of order items’ is closed to new replies.