Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Tom Madden 253 posts 455 karma points MVP 4x c-trib
    Jun 21, 2020 @ 10:26
    Tom Madden

    Has anyone implemented a Mailchimp abandoned carts integration?

    I'm interested in integrating Vendr with Mailchimp to automate abandoned carts emails. Has anybody tried this with Umbraco before?

    While this topic could apply to any ecommerce package, I'm planning to create an integration for Vendr (and TeaCommerce for an existing site) and hopefully any replies here will help other Vendr users (or result in a package).

    At the moment I'm just trying to get my head around the Mailchimp aspects and having an issue adding a Cart to a Campaign, currently getting an error that "A campaign with the provided ID does not exist in the account for this list." so it looks like I haven't linked everything together in MailChimp.

    At this stage I'm just using the MailChimp API Playground so so code to share.



  • Matt Brailsford 4124 posts 22220 karma points MVP 9x c-trib
    Jun 22, 2020 @ 09:21
    Matt Brailsford

    Hi Tom,

    I don't have an answer in terms of how to do this at the MailChimp end as I haven't looked at doing it myself, but I would just like to point a few things about being GDPR compliant (not necessarily for, but anyone else who comes across this post.

    I just want to say that Abandoned Cart emails can be GDPR complaint under the "legitimate interest" banner as a potential customer adding something to a cart does indicate a level of business interest and so you can email them to help close the sale.

    It's important to note though that there are a number of required steps you must include, such as:

    1. Ensure your emails have an ability to opt out of future abandoned cart notifications
    2. Your email must be clear about which cart / order this email is with regards to
    3. You must include your address on your communication emails
    4. You must state that you are processing their email under the "legitimate interest" banner
    5. You must email these email addresses with anything other than legitimate interest emails unless they explicitly opt-in the marketing communications.

    There may be other things that need to be considered, so just wanted to note that people should do the relevant research before implementing such a feature.

    With that covered, as I say I haven't looked in detail myself, but have you looked at the MailChimp eCommerce APIs?


  • seanrock 242 posts 463 karma points
    Jun 23, 2020 @ 08:57


    Do you mean 'GDPR compliant'?

  • Matt Brailsford 4124 posts 22220 karma points MVP 9x c-trib
    Jun 23, 2020 @ 09:00
    Matt Brailsford

    Lol, yea 😂

    This is why I get for replying using my phone

    I'll update my spelling mistake.

  • Francis Benyah 35 posts 112 karma points
    Jun 23, 2020 @ 06:56
    Francis Benyah

    Hi Tom

    I am actually going to be doing that once I am done with all the aspects of the cart on our current project.

    I am doing our implementation through sendgrid though using a handful of email templates.

    Just have to figure out from the vendr side though what the trigger will be for an "abandoned" cart.

    @Matt any pointers there?


  • Matt Brailsford 4124 posts 22220 karma points MVP 9x c-trib
    Jun 23, 2020 @ 08:25
    Matt Brailsford

    I'm not quite sure how it works on other platforms, but I guess you'd do something like look for orders with an update date older than 24 hours where there are items in the order, the order has an email assigned to it and the order isn't finalized.

    I think at the moment our search API may not be strong enough for you to be able to perform this level of search so it might have to be a custom SQL statement for now. I'd probably suggest retrieving the list of Order IDs and then using the Vendr API to fetch those specific orders. From here you'd then loop through and send the emails.

    You'd also want to store an order property to say the email has been sent so you don't keep emailing them and then you'd also need to incorporate that into the intial SQL statement so you don't bring back Order IDs for orders that have already been notified.

    This is how I would approach this currently.


  • Francis Benyah 35 posts 112 karma points
    Jun 23, 2020 @ 08:43
    Francis Benyah

    Okay cool thanks for that.

    I was hoping that there might be a quick call or two through the API

    Luckily we have a way of tracking the orders against a member that are not finalized in umbraco so I will just use umbraco api to get those that need to be emailed for now and hopefully at some point we can change that to work via the vendr api

    Thanks Matt, much appreciated

  • Matt Brailsford 4124 posts 22220 karma points MVP 9x c-trib
    Jun 23, 2020 @ 08:55
    Matt Brailsford

    Yea, Improving the search API is something I want to do. It's very much just a port over from TC at the moment. We do have an issue for it here and I have made a start on a new API along the lines of

        .Where(order => !order.IsFinalized && order.UpdateDate < DateTime.UtcNow)

    It's still in progress though and it is still a bit limited as I need to ensure it a) stays performant but also b) works with the NPoco query API and an Expression visitor written by HQ which can convert the Where lambda into a SQL query (which isn't fully featured itself)

    It'll be a step forward, but might take a few iterations to get it where it needs to be.


Please Sign in or register to post replies

Write your reply to: