[BUG] Products Not Syncing to Mailchimp - Sync Status Remains at Zero

[maxor389]

The Mailchimp for WooCommerce plugin sync is stuck at zero for contacts, promo codes, orders, and products (0, 0, 0, 0). Existing products (approximately 1600) are not syncing to Mailchimp. New products created via the WooCommerce admin interface do not sync. For context, the sync was not bringing new products to the mailchimp website/app, hence we cleared all the data from the app/website and tried to sync again.

Interesting observation: 


• I Created a product via the WC-API (POST to /wp-json/wc/v3/products endpoint) and it syncd. Did it again for another product and it also syncd. However any product created by the admin UI, does not sync.

Steps to reproduce the behavior:

1. Go to the WordPress admin dashboard of the WooCommerce store.
2. Create a new product using the WooCommerce admin interface.
3. Wait for the Mailchimp sync process to initiate.
4. Check Mailchimp to verify if the new product has synced, or view the settings page of MC.
5. Observe that the product has not synced, and the sync status remains at 0 contacts, 0 promo codes, 0 orders, and 0 products.

Expected behavior All existing products should sync to Mailchimp during the initial sync process. New products created via the WooCommerce admin interface should automatically sync to Mailchimp.

• Staging URL: https://tccfast.staging.tempurl.host/
• Production URL: the-coin-chest.com
• Plugin version: 4.4
• WooCommerce version: 9.3.2
• WordPress version: 6.6.2
• PHP version: 8.2.23
• Theme: Twenty Twenty-Four (in staging environment)

Additional Information

• The issue began about a week ago when new products were not syncing to Mailchimp.
• Disconnecting and reconnecting the store from Mailchimp did not resolve the issue.
• The problem persists in both production and staging environments.
• In the staging environment, all plugins except WooCommerce and Mailchimp were deactivated and deleted, but the issue remained.
• I have a staging environment available for further testing and am willing to provide additional information if needed.