Google Listings & Ads infinity loading

Hi @stwinssmithfield,

Please follow this steps to disconnect your account properly:

• Go to https://example.com/wp-admin/admin.php?page=connection-test-admin-page (replace example.com with your domain name)
• Under Merchant Center, click MC Disconnect
• Under Google Account, click Disconnect Google Account
• Under Jetpack, click Disconnect Jetpack (if you have installed it)

Next, go to Marketing > Google Listings & Ads and set up the connection again.

If the issue continues, you can run a conflict test to help you identify the cause of the issue. More info: https://woo.com/document/how-to-test-for-conflicts/

Let us know how it goes! Looking forward to helping you.

Ok fixed that issue now have another.

Also we have over 52k products and only 37k products showing in merchant Centre
https://stwins.com.au/wp-content/uploads/2024/01/wordpress3.jpg

https://stwins.com.au/wp-content/uploads/2024/01/googlemerchant-2.jpg

Hey, @stwinssmithfield!

I’m glad the previous issue is resolved. Let’s work on the new one.

The product feed page does quite a bit of processing and because of that it might take a while for it to be displayed when the number of synced products is large. It’s probable that the script has timed out, which we’ve seen in some cases with similar error messages.

Those cases were resolved by increasing the maximum execution time of PHP scripts by setting the max_execution_time config and also increase the memory_limit settings in the php.ini file.

It might also help if you have a look at the server logs if the same error appears after making these changes.

Can you also please go to Google Merchant Center and check if there are any errors showing there?

Looking forward to your reply.

Have a wonderful day!

Sorry for delay been very busy, still will not load products and less products showing each day instead of adding the new products, we have over 51k products, after I fixed it the first time there was 48k products on line, now down to 44k products.This is error message it throws after sitting there for long time.

https://stwins.com.au/wp-content/uploads/2024/02/error.message.jpg

These are settings in PHP.ini

max_execution_time = 60

memory_limit = 512MB

What else can we do to fix this issue ?

Hello stwinssmithfield,

Thank you for your reply.

I understand that despite your efforts in addressing the issue, your product count is decreasing rather than increasing with over 51,000 products, and you are experiencing long load times accompanied by an error message.

To help you further, I’d like to understand more about your setup.
Could you please send me a copy of your site’s System Status Report?
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.

Could you also share a copy of the fatal error log? You can find this under WooCommerce > System Status > Logs. Then click on the dropdown menu on the right-hand side and look for logs that contain the words “Fatal Error”. This log will help me determine what might be causing the decrease in product count and the error you’re encountering.

Once I have the specific error details, I will be in a much better position to give you precise advice on how to resolve this issue.

Looking forward to your response. ??

Best regards.

Get System report

This is last Fatal error log
2024-02-11T05:24:26+00:00 CRITICAL Allowed memory size of 2147483648 bytes exhausted (tried to allocate 20480 bytes) in /var/www/s2/wp-content/plugins/google-listings-and-ads/vendor/google/apiclient/src/Http/REST.php on line 142

Hi @stwinssmithfield,

The error message you’re seeing indicates that your website has exhausted the allocated memory limit. This is often caused by a plugin or theme that is consuming more memory than the limit set in your WordPress configuration.

To resolve this issue, you could try increasing your PHP memory limit. This can be done by editing your wp-config.php file, which is located in the root directory of your WordPress installation. Add the following line of code to the file:

define(‘WP_MEMORY_LIMIT’, ‘256M’);

This will increase your memory limit to 256MB. If you continue to experience issues, you might need to increase the limit further or identify the plugin or theme that is causing the high memory usage.

Please back up your site before making any changes. If you’re uncomfortable making these changes yourself, we recommend reaching out to a professional developer or your hosting provider.