Product sync keeps loading
-
I have about 850+ products in my woocommerce site. Those are added to Merchant center via this plugin. But now, the products have stopped syncing and keeps loading. Attaching the screenshot:

-
Hey @rnkdsh,
I have about 850+ products in my woocommerce site. Those are added to Merchant center via this plugin. But now, the products have stopped syncing and keeps loading. Attaching the screenshot:
I understand the data for your Product Feed is not loading and instead the loading icon continues to display.
Could you please confirm if you have previously been able to load this page without issue? Additionally, could you please share your
System Status Reportwith us? You can find the report by going toWooCommerce > Statusclicking onGet system reportand thenCopy for support. You can paste the report into a reply on this thread. Please feel free to redact your website URL from the report if you would rather not share that information publicly.Yes previously this this wasn’t an issue. This issue has been happening only since a month I think.
Here’s the system report:WordPress Environment<br><br>WordPress address (URL): https://redacted.com<br>Site address (URL): https://redacted.com<br>WC Version: 9.0.2<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ✔ 3.8.1<br>Log Directory Writable: ✔<br>WP Version: 6.5.5<br>WP Multisite: –<br>WP Memory Limit: 2 GB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: en_US<br>External object cache: ✔ Server Environment<br><br>Server Info: LiteSpeed<br>PHP Version: 8.1.27<br>PHP Post Max Size: 2 GB<br>PHP Time Limit: 360<br>PHP Max Input Vars: 5000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.11.7-MariaDB-cll-lve<br>Max Upload Size: 2 GB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔ Database<br><br>WC Database Version: 9.0.2<br>WC Database Prefix: wp_<br>Total Database Size: 72.52MB<br>Database Data Size: 56.01MB<br>Database Index Size: 16.51MB<br>wp_woocommerce_sessions: Data: 0.25MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 2.52MB + Index: 1.63MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 2.52MB + Index: 0.88MB + Engine InnoDB<br>wp_commentmeta: Data: 1.52MB + Index: 0.55MB + Engine InnoDB<br>wp_comments: Data: 1.52MB + Index: 0.91MB + Engine InnoDB<br>wp_cr_local_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_cr_reminders_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB<br>wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_budget_recommendations: Data: 0.19MB + Index: 0.11MB + Engine InnoDB<br>wp_gla_merchant_issues: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_litespeed_avatar: Data: 0.30MB + Index: 0.20MB + Engine InnoDB<br>wp_litespeed_img_optming: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>wp_litespeed_url: Data: 0.19MB + Index: 0.27MB + Engine InnoDB<br>wp_litespeed_url_file: Data: 0.50MB + Index: 1.42MB + Engine InnoDB<br>wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 5.50MB + Index: 0.47MB + Engine InnoDB<br>wp_options1: Data: 1.52MB + Index: 0.03MB + Engine InnoDB<br>wp_postmeta: Data: 21.50MB + Index: 5.70MB + Engine InnoDB<br>wp_posts: Data: 12.52MB + Index: 0.75MB + Engine InnoDB<br>wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_rank_math_internal_links: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wp_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_sbi_feed_caches: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sbi_instagram_posts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 1.52MB + Index: 0.28MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 0.27MB + Index: 0.06MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.08MB + Index: 0.13MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.13MB + Index: 0.36MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wpte_product_layout_style: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_indexable: Data: 1.52MB + Index: 0.33MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.06MB + Index: 0.08MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB Post Type Counts<br><br>attachment: 3959<br>custom_css: 2<br>customize_changeset: 5<br>elementor_library: 1<br>elementskit_content: 1<br>emailkit: 9<br>nav_menu_item: 41<br>order_status: 2<br>page: 14<br>product: 858<br>revision: 881<br>seedprod: 1<br>shop_coupon: 1<br>shop_order_placehold: 21<br>sp_wcslider: 1<br>templately_library: 1<br>wp_navigation: 1<br>wpcf7_contact_form: 1<br>wpmm_theme: 3 Security<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (29)<br><br>Custom Order Status Manager for WooCommerce: by Bright Plugins – 1.1.3.2<br>Breadcrumb NavXT: by John Havlik – 7.3.0<br>Click to Chat: by HoliThemes – 4.5<br>Contact Form 7: by Takayuki Miyoshi – 5.9.6<br>Customer Reviews for WooCommerce: by CusRev – 5.52.1<br>Elementor: by Elementor.com – 3.22.3<br>EmailKit: by wpmet – 1.5.3<br>Essential Addons for Elementor: by WPDeveloper – 5.9.24<br>Estimated Delivery for WooCommerce: by Daniel Riera – 1.4.5<br>Favicon by RealFaviconGenerator: by Philippe Bernard – 1.3.30<br>Google Listings and Ads: by WooCommerce – 2.7.5<br>Site Kit by Google: by Google – 1.130.0<br>Hostinger Tools: by Hostinger – 3.0.2<br>Smash Balloon Instagram Feed: by Smash Balloon – 6.4.3<br>Kirki Customizer Framework: by Themeum – 5.1.0<br>LiteSpeed Cache: by LiteSpeed Technologies – 6.2.0.1<br>Nimbuspost: by Bulbul Islam – 2.0.0<br>Perfect Brands WooCommerce: by QuadLayers – 3.3.9<br>PRO Elements: by PROElements.org – 3.22.1<br>Rank Math SEO: by Rank Math – 1.0.222<br>Side Cart WooCommerce: by XootiX – 2.5<br>Delete product images for WooCommerce: by Eduard V. Doloc – 1.1<br>Category Slider for WooCommerce: by ShapedPlugin LLC – 1.4.21<br>Woo Image SEO: by Danail Emandiev – 1.4.3<br>1 Razorpay: Signup for FREE PG: by Team Razorpay – 4.6.7<br>Google Analytics for WooCommerce: by WooCommerce – 2.1.4<br>PPOM for WooCommerce: by Themeisle – 32.0.22<br>WooCommerce: by Automattic – 9.0.2<br>StoreCustomizer: by Kaira – 2.5.6 Inactive Plugins (5)<br><br>Bosa Elementor Addons and Templates for WooCommerce: by Bosa Themes – 1.0.13<br>ElementsKit Lite: by Wpmet – 3.2.0<br>Image optimization service by Optimole: by Optimole – 3.13.3<br>Product Layouts for Woocommerce: by WPTOFFEE – 1.2.3<br>Templately: by Templately – 3.0.8 Dropin Plugins ()<br><br>object-cache.php: object-cache.php Settings<br><br>API Enabled: –<br>Force SSL: –<br>Currency: INR (₹)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ✔<br>HPOS feature enabled: ✔<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: – Logging<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 3 MB WC Pages<br><br>Shop base: #9 - /shop/<br>Cart: #10 - /cart/<br>Checkout: #11 - /checkout/<br>My account: #12 - /my-account/<br>Terms and conditions: #609 - /terms-conditions/ Theme<br><br>Name: Bosa Decor Shop<br>Version: 1.0.0<br>Author URL: https://bosathemes.com<br>Child Theme: ✔<br>Parent Theme Name: Bosa<br>Parent Theme Version: 1.4.9 – 1.5.2 is available<br>Parent Theme Author URL: https://bosathemes.com<br>WooCommerce Support: ✔ Templates<br><br>Archive Template: Your theme has a woocommerce.php file<br>you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.<br><br>Overrides: – Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br><br>Disabled Features: minified-js<br>new-product-management-experience<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>launch-your-store<br>product-editor-template-system<br><br>Daily Cron: ✔ Next scheduled: 2024-07-03 13:36:30 +05:30<br>Options: ✔<br>Notes: 82<br>Onboarding: completed Action Scheduler<br><br>Complete: 6,199<br>Oldest: 2024-06-01 22:10:17 +0530<br>Newest: 2024-07-02 20:51:54 +0530<br><br>Failed: 756<br>Oldest: 2024-04-20 16:52:44 +0530<br>Newest: 2024-06-22 05:33:05 +0530<br><br>Pending: 4<br>Oldest: 2024-07-02 21:19:01 +0530<br>Newest: 2024-07-22 05:33:05 +0530 Status report information<br><br>Generated at: 2024-07-02 21:18:12 +05:30<br>Hi @rnkdsh,
Thanks for the additional details. A few more questions, if you may:
- You mentioned this has been happening since a month give or take. Do you remember making any changes to your site around that time? Installing a new plugin, updating anything, changing your theme or any settings anywhere?
- When you go to the product feed page and the syncing keeps loading, do you find any errors on your browser’s console?
- Have you checked your WooCommerce > Status > Logs for any fatal error logs or Google Listings & Ads logs? Please share them here. You can use https://gist.github.com/ to do that.
Thanks!
-OPHi @omarfpg
You mentioned this has been happening since a month give or take. Do you remember making any changes to your site around that time? Installing a new plugin, updating anything, changing your theme or any settings anywhere?
Many changes ofcourse. Product titles fixes, product images, new products, deleted duplicate products, installed some plugins (SEO, etc) and removed some unnecessary plugins. I don’t remember exactly what date this issue started and what changed on that exact date.
When you go to the product feed page and the syncing keeps loading, do you find any errors on your browser’s console?
None.
Have you checked your WooCommerce > Status > Logs for any fatal error logs or Google Listings & Ads logs? Please share them here.
Here are the log files. This folder contains yesterday’s as well as today’s log files.
HI @rnkdsh
Thanks for sharing the log and further information.
It seems to be an issue with Merchant Center product ID 443, which is not found in your WooCommerce store. This could be due to the product being deleted or unavailable in your WooCommerce store, but it still exists in Google Merchant Center. You can manually remove the product from the Google Merchant Center to resolve this issue.
If this makes no difference, follow these steps refreshing the connection:
- 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
Next, go to Marketing > Google Listings & Ads and set up the connection again.
Additionally, head over to WooCommerce → Status → Tools, and do the following:
- WooCommerce transients – Clear
- Expired transients – Clear
- Clear template cache – Clear
- Capabilities – Reset Capabilities
- Clear customer sessions -Clear
- Product lookup tables – Regenerate
- Regenerate the product attributes lookup table – Regenerate
Next, please clear your browser cache and then check again.
I hope this helps! Please let us know how it goes or if you need further assistance.
Hi there 👋 ,
We haven’t heard from you in a while; this is to check if you’ve been able to proceed with the troubleshooting steps provided before and if you still need help.
Thanks!
-OP
The topic ‘Product sync keeps loading’ is closed to new replies.