504 error on /wp-admin/edit.php?post_type=product

Hello silent2000,

Thank you for contacting WooCommerce Support

I understand you are facing an issue with accessing the Products tab in your WP admin after importing a significant number of products from another OpenCart site. It seems you are encountering a 504 error.

To assist you more effectively, could you please share a screenshot of the exact 504 error message you’re seeing? As there are different types of 504 errors, having a visual reference will help me pinpoint the cause of the issue more precisely.

You can use a tool like https://snipboard.io to share screenshots with me.

Additionally, to further understand your website’s environment, please send a copy of your site’s System Status Report.
You can obtain this report by:
1. Navigate to WooCommerce > Status.
2. Click on ‘Get system report’.
3. Then click on ‘Copy for support’.

Once you have a copy of the report, please paste it into a Gist at https://gist.github.com and share the Gist link here in your reply.

Providing this information will allow me to have a clearer picture of your setup and guide you toward the best possible solution for managing the large number of products you’ve added to your site.

Looking forward to your response to help you resolve this. ??

Hi again. I fixed 504 error by increase some nginx variables like “max execution time” etc. But I still have problem with perfomance. For example, page /wp-admin/edit.php?post_type=product loading ~45s. My opinion, it’s because we have hube amount of attributes, ~9000. As I see in WP Query Monitor, it’s slow query for get_terms() call:
https://snipboard.io/8RzBji.jpg

Link for system status report:
https://disk.yandex.ru/d/e8fkdjedfAyZQA

Also I already tried plugin Index WP MySQL For Speed anc created indexes, but it’s not helped.

Hi @silent2000,

?I fixed 504 error by increase some nginx variables like “max execution time” etc.?

Thanks for confirming you were able to fix this by simply increasing some variables in your Nginx.

But I still have problem with perfomance.

Let us fix this together.

First, I was able to notice that you are using an outdated version of the WooCommerce plugin. I’d recommend updating the plugin to the latest version and check if the issue with performance gets any better.

If the above don’t resolve the issue, please consult our in-depth troubleshooting guides for perceived slow site performance below:

• https://woocommerce.com/document/troubleshooting-a-slow-site/
• https://woocommerce.com/posts/woocommerce-site-slow-fixes/

Let us know how it turns out!

Hi. I already read this articles, not relevant for me unfortunately

Hello @silent2000,

Thanks for getting back to us.

Hi. I already read this articles, not relevant for me unfortunately

Were you able to update the WooCommerce plugin to the latest version as requested? Did you notice any difference in the site speeds?

As a next step, I’d recommend performing a conflict test, this will help narrow down the issue and identify the possible culprit. You can find a more detailed explanation on how to run a conflict test here.

Let us know how it goes,

Hi. Updating to latest version didn’t help dramatically.

Conflict tests I already done before write here. I’m sure that problem is huge amount of attributes and variaiotns (~10000). What you suggest to optimize DB and queries for big amount of variations?

Hi @silent2000,

Thanks for sharing an update on this.

As a next step, could you please enable the High-Performance Order Storage by following the steps outlined here and let us know if this help in any way.

You can learn more on HPOS from this guide.

Looking forward to your reply.

Hi, My store haven’t any orders for now, it’s totally zero, why you suggest this?
Also you again ignored my opinion about variations and attributes

Hi @silent2000,

The slow load time you’re experiencing on your Products page could indeed be due to the large number of attributes (~9000) on your site. The get_terms() function, which retrieves the terms in a taxonomy, can be slow when dealing with large data.

To improve the performance, consider reducing the number of attributes if possible. Alternatively, you could look into optimizing your database. A plugin like WP-Optimize could help with this task.

Here are few others resources that might also helps:

• https://wp-rocket.me/blog/how-to-speed-up-slow-woocommerce-backend/
• https://www.codeable.io/blog/speed-up-woocommerce-admin/
• https://onlinemediamasters.com/slow-woocommerce-admin-panel/
• https://10web.io/blog/speed-up-woocommerce-backend/

I hope these suggestions help. f you have any other questions, feel free to ask.