mc-woocommerce icon indicating copy to clipboard operation
mc-woocommerce copied to clipboard

[BUG] Sync Breaks When Creating New Staging Environments

Open ricardoaraujo330 opened this issue 6 months ago • 4 comments

Describe the bug Whenever I create or update a staging environment using Cloudways, the Mailchimp for WooCommerce plugin is copied over along with everything else from the live site. Even though I deactivate and delete the plugin from the staging site immediately, Mailchimp assumes I have two stores, causing the sync on the live site to break. This results in a lengthy re-sync process and pauses all of my automation/journeys.

To Reproduce Steps to reproduce the behavior:

  1. Go to Cloudways platform.
  2. Create a new staging environment or update an existing one using "Pull from live".
  3. The Mailchimp plugin is copied to the staging environment.
  4. Deactivate and delete the plugin from the staging environment.
  5. See the sync on the live site break, leading to a re-sync of 50,000 users and 50,000 orders, which takes almost a month.

Expected behavior I expected the live site to maintain its sync with Mailchimp without disruption, regardless of the creation or update of a staging environment. Ideally, the plugin should be tied to a specific domain, so that the integration is not broken when a new staging site is created.

Screenshots don't have

Operating environment (please complete the following information):

Store URL: floresnocais.pt Plugin version: 4.2.1 WooCommerce version: 9.1.4 WordPress version: 6.6.1 PHP version: 7.4

Things to verify before submitting a ticket:

  • [x] I have verified that I am using the most up-to-date plugin version.
  • [ ] I have enabled "Remote Diagnostics" from the plugin's Settings tab (if possible).
  • [ ] I have checked if there are any fatal errors in WooCommerce (WooCommerce -> Status -> Logs).
  • [x] I have confirmed with my hosting provider that WP_CRON is activated and that the queue powered by Action Scheduler is functioning properly.
  • [ ] I have verified that caching plugins or services are not interfering, especially with Redis, Nginx, or MemCache, and have ensured the necessary paths are excluded from the REST API and /wp-json/mailchimp-for-woocommerce. I have referred to the Wiki help page on this topic for more information.
  • [x] I have ensured that my server memory limit is sufficiently high (1GB or more) to accommodate the sync.

Additional context Given the significant impact this issue has on large stores with high numbers of users and orders, I strongly suggest that the plugin be tied to a specific domain. This would prevent sync disruptions when creating or updating staging environments. Please consider this or any other solution to avoid breaking the live site's connection with Mailchimp when a staging site is created.

Thank you for your attention to this issue, as it is highly frustrating and has a substantial impact on our operations.

ricardoaraujo330 avatar Aug 15 '24 09:08 ricardoaraujo330