WooCommerce Orders not transparent with Mailchimp Transactional email Audience

[SpencerBarron]

I have 305 WooCommerce orders
My Mailchimp audience is 206 contacts 166 of them are subscribers
Of the 166 subscribers:
67 did place a WooCommerce order but the order details are not showing in Mailchimp

Of the remaining 40 audience members:
5 have unsubscribed - these audience members didn't place a WooCommerce order
5 are Transactional emails - these audience members didn't place WooCommerce an order
30 are Transactional emails - these audience members did place a WooCommerce order but the order details are not showing in Mailchimp
2 have been cleaned and were Transactional emails, both had placed an order but the order details are not showing in Mailchimp

In addition 104 WooCommerce orders have not appeared as Transactional Audience members in Mailchimp
I've de-installed and reinstalled the plugin
There has been no change to the Audience members

[ryanhungate]

@SpencerBarron the first thing that I would recommend would be to open up your plugin logs, switch to DEBUG mode - maybe run a re-sync... and search for the emails in question. I would like to know whether or not you got a "successful" response while submitting them or if there's an error message next to these folks you say are not in Mailchimp.

Also - I would reach out to your support team at Mailchimp - as they have the better insight to your actual account information. Here at the plugin team we really don't have much to go by other than asking questions and having you look into the debug logs.

The plugin also only syncs "completed" orders during the initial sync. Could that be the problem? Order statuses not being "complete"?

[SpencerBarron]

@ryanhungate are you able to comment on this from technical [email protected];

MailChimp
We added one more condition to the list to check from Woocommerce to Mailchimp and when we did that we could see ourselves in the list. We purchased one of the courses, using the code you provided but didn't initially see that purchase in Mailchimp. The reason why it was not working is that it was not filtering both Woocommerce segments. We added that condition; we were then able to see the order, the number, the revenue, everything is now in there. Retrospectively, adding those is not possible, we were unable to find a solution.

Since writing to you three weeks ago, we reinstalled Mailchimp for WooCommerce. That decision resulted in the loss of the WooCommerce orders that were visible in Mailchimp i.e. 305 - 104 - 67 = 134

The solution Hiveminder are unable to find is:

• how to get historical WooCommerce order details into Mailchimp - those made before the 23/3/21 going back to December 2016
• how to recover the 104 WooCommerce orders and associated email addresses mentioned in my first post above

@ryanhungate please comment on the following from this link https://woocommerce.com/products/mailchimp-for-woocommerce/?quid=8ce037dbf905cd8be2fc36e8e36b90ca

A note for current integration users:

This plugin supports our most powerful API 3.0 features and is intended for users who have not yet integrated their WooCommerce stores with Mailchimp.
You can run this new integration at the same time as your current WooCommerce integration for Mailchimp. However, data from the older integration will display separately in subscriber profiles, and can’t be used with e-commerce features that require API 3.0.

[ryanhungate]

@SpencerBarron i'm not familiar with hiveminder, and don't know what part they play in this, but I can speak for the plugin and Mailchimp here.

If you're having trouble getting orders submitted, the first thing I would ask you to do is send logs to us so we can see if there's any failures. I had requested that we first look there after a "re-sync" was initiated. Have you had a chance to do that yet?

If you would like to send them to ryan (at) vextras.com i'll be more than happy to take a peek for you and see if I can spot anything goofy. Also, I would be able to assist if you send an admin account to me as well. That might be the easiest thing to do.

[SpencerBarron]

@ryanhungate you say: The plugin also only syncs "completed" orders during the initial sync. Could that be the problem? Order statuses not being "complete"?

I do apologise. I passed your comment on to the technicians but they haven't changed the status.

I've just gone into the plugin myself, the status was 'processing,' the status is now 'completed' this has resolved the issue.

Do I need to change the status of 'cancelled' 'refunded' and 'failed'?

Can they also appear in Mailchimp?

Is there a set of instructions on what has to be done to manage the plugin?

Thank you

[ryanhungate]

@SpencerBarron yes - that is correct - the plugin will only sync "completed" orders during the initial sync because the refunded, cancelled and failed are not valid orders at this stage. Moving forward, you will get the ongoing order updates, and those will of course be synced up, but the plugin team along with many other store owners have determined that these should not be synced during the initial sync process.

This seems like it's the solution to the problem - you can't keep the orders in the "processing" state typically, that would be more of a company workflow that needs to be addressed. Once you do that, you'll be all good :)