19000 products gradually began to move to ‘not synced’

This sounds very similar to my problem, I would also like to be looped in with the resolution to this. I have posted my issue on forum as well.

Hello @timgood85,

No worries, we’ll help you get to the bottom of this. But first, could you please share 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, paste it here in your response.

Look forward to hearing back from you.

Morning Saif,

Sure.

### WordPress Environment ###

WordPress address (URL): https://vitesse-ltd.co.uk
Site address (URL): https://vitesse-ltd.co.uk
WC Version: 7.0.0
REST API Version: ? 7.0.0
WC Blocks Version: ? 8.5.1
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0.3
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.30
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 2500
cURL Version: 7.79.1
OpenSSL/1.1.1g-fips

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.24-MariaDB-log
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.9.4
WC Database Prefix: 23_
Total Database Size: 786.91MB
Database Data Size: 482.89MB
Database Index Size: 304.02MB
23_woocommerce_sessions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
23_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
23_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_woocommerce_order_itemmeta: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
23_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
23_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_actionscheduler_actions: Data: 122.44MB + Index: 137.25MB + Engine InnoDB
23_actionscheduler_claims: Data: 0.13MB + Index: 0.08MB + Engine InnoDB
23_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_actionscheduler_logs: Data: 37.56MB + Index: 24.06MB + Engine InnoDB
23_cmplz_cookiebanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_cmplz_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_cmplz_services: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_comments: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
23_dgwt_wcas_index: Data: 8.52MB + Index: 0.42MB + Engine InnoDB
23_dgwt_wcas_invindex_cache: Data: 0.23MB + Index: 0.03MB + Engine InnoDB
23_dgwt_wcas_invindex_doclist: Data: 7.52MB + Index: 8.03MB + Engine InnoDB
23_dgwt_wcas_invindex_wordlist: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
23_dgwt_wcas_stats: Data: 0.27MB + Index: 0.00MB + Engine InnoDB
23_dgwt_wcas_var_index: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
23_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
23_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
23_e_submissions: Data: 0.05MB + Index: 0.27MB + Engine InnoDB
23_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
23_e_submissions_values: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
23_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
23_gla_merchant_issues: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
23_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
23_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_options: Data: 20.03MB + Index: 7.50MB + Engine InnoDB
23_postmeta: Data: 182.72MB + Index: 69.17MB + Engine InnoDB
23_posts: Data: 19.55MB + Index: 8.06MB + Engine InnoDB
23_termmeta: Data: 0.38MB + Index: 0.38MB + Engine InnoDB
23_terms: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
23_term_relationships: Data: 4.52MB + Index: 2.52MB + Engine InnoDB
23_term_taxonomy: Data: 0.16MB + Index: 0.11MB + Engine InnoDB
23_tm_taskmeta: Data: 2.52MB + Index: 0.34MB + Engine InnoDB
23_tm_tasks: Data: 1.52MB + Index: 0.13MB + Engine InnoDB
23_usermeta: Data: 0.48MB + Index: 0.06MB + Engine InnoDB
23_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
23_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
23_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wc_category_lookup: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
23_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
23_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
23_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wc_product_meta_lookup: Data: 4.52MB + Index: 6.09MB + Engine InnoDB
23_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
23_wfconfig: Data: 0.47MB + Index: 0.00MB + Engine InnoDB
23_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wffilemods: Data: 16.55MB + Index: 0.00MB + Engine InnoDB
23_wfhits: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
23_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
23_wfknownfilelist: Data: 7.52MB + Index: 0.00MB + Engine InnoDB
23_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wflogins: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
23_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
23_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
23_wfstatus: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
23_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wpf_meta_data: Data: 5.52MB + Index: 11.58MB + Engine InnoDB
23_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wpf_meta_values: Data: 0.02MB + Index: 0.81MB + Engine InnoDB
23_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_wpml_mails: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
23_wpr_rocket_cache: Data: 3.52MB + Index: 3.33MB + Engine InnoDB
23_wpr_rucss_used_css: Data: 0.36MB + Index: 0.61MB + Engine InnoDB
23_xyz_ips_short_code: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
23_yoast_indexable: Data: 26.55MB + Index: 18.09MB + Engine InnoDB
23_yoast_indexable_hierarchy: Data: 1.52MB + Index: 1.09MB + Engine InnoDB
23_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
23_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
23_yoast_seo_links: Data: 0.16MB + Index: 0.11MB + Engine InnoDB

### Post Type Counts ###

attachment: 33240
br_product_tab: 2
br_tabs_location: 1
custom_css: 3
customize_changeset: 3
elementor_icons: 1
elementor_library: 30
jet-menu: 5
nav_menu_item: 51
page: 12
post: 3
product: 19546
revision: 492
shop_coupon: 5
shop_order: 73
shop_order_refund: 10
wp_global_styles: 4

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (30) ###

ManageWP - Worker: by GoDaddy – 4.9.14
FiboSearch - AJAX Search for WooCommerce (Pro): by FiboSearch Team – 1.20.2
Complianz | GDPR/CCPA Cookie Consent: by Really Simple Plugins – 6.3.4
Elementor Pro: by Elementor.com – 3.7.7
Elementor: by Elementor.com – 3.7.8
Facebook for WooCommerce: by Facebook – 2.6.27
Feefo Ratings & Reviews: by Feefo – 1.0.8
GazChap's WooCommerce Auto Category Product Thumbnails: by Gareth 'GazChap' Griffiths – 1.4
Google Listings and Ads: by WooCommerce – 2.1.4
OMGF: by Daan from Daan.dev – 5.4.1
Insert PHP Code Snippet: by xyzscripts.com – 1.3.3
JetMenu: by Crocoblock – 2.2.3
HubSpot All-In-One Marketing - Forms, Popups, Live Chat: by HubSpot – 9.0.123
Limit log in attempts reloaded: by Limit log in attempts reloaded – 2.25.7
Product Tabs Manager for WooCommerce: by BeRocket – 1.1.5.6
Vitesse Stock Import: by Pagecode – 1.0.0
WooCommerce Manual Payment: by bfl – 2.6.11
Product Filter by WooBeWoo: by WooBeWoo – 2.2.1
Payment Plugins for Stripe WooCommerce: by Payment Plugins
[email protected] – 3.3.28

WooCommerce Google Analytics Integration: by WooCommerce – 1.5.15
WooCommerce Min/Max Quantities: by WooCommerce – 2.4.24
WooCommerce PayPal Payments: by WooCommerce – 1.9.4
WooCommerce: by Automattic – 7.0.0
Wordfence Security: by Wordfence – 7.7.1
Yoast SEO: by Team Yoast – 19.8
Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.8.7
WP Mail Logging: by Wysija – 1.10.4
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.2.9

WP Rocket: by WP Media – 3.12.1.1
Sequential Order Numbers for WooCommerce: by WebToffee – 1.4.8

### Inactive Plugins (1) ###

Woo Align Buttons: by 320up – 3.6.7

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (2) ###

ManageWP - Worker Loader: by GoDaddy – 1.0.0
StackCache: by Stack CP –

### Settings ###

API Enabled: –
Force SSL: –
Currency: GBP (￡)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #14 - /shop/
Basket: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
My account: #17 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Hello Elementor Child
Version: 1.0.1
Author URL: https://elementor.com/
Child Theme: ?
Parent Theme Name: Hello Elementor
Parent Theme Version: 2.6.1
Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
WooCommerce Support: ?

### Templates ###

Overrides: –

### WooCommerce PayPal Payments ###

Onboarded: ?
Shop country code: GB
WooCommerce currency supported: ?
PayPal card processing available in country: ?
Pay Later messaging available in country: ?
Webhook status: ?
Vault enabled: ?
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –
Tracking enabled: –

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
settings

Daily Cron: ? Next scheduled: 2022-10-18 09:49:53 +01:00
Options: ?
Notes: 52
Onboarding: completed

### Action Scheduler ###

Complete: 154
Oldest: 2022-10-18 08:06:05 +0100
Newest: 2022-10-18 08:57:49 +0100

Pending: 476,746
Oldest: -0001-11-29 23:58:45 -0001
Newest: 2022-10-18 08:42:59 +0100

In-progress: 2
Oldest: –
Newest: –

Failed: 475
Oldest: 2022-09-09 10:14:31 +0100
Newest: 2022-09-08 05:42:03 +0100

### Status report information ###

Generated at: 2022-10-18 09:06:49 +01:00

Howdy @timgood85,

Can I ask you to please open a ticket with us via: https://woocommerce.com/my-account/create-a-ticket/

You can reference this case when you submit the ticket.

Kind regards,

This turned out to be due to an error with WPRocket stacking up jobs that would not run.

Thanks for sharing it here @timgood85, thus enabling others to find help faster!

Plus, I’m glad we were able to help! If you have a few minutes, we’d love if you could leave us a review: https://www.ads-software.com/support/plugin/google-listings-and-ads/reviews/