Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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.
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:
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? https://mailchimp.com/ecommerce-retail-marketing/
Do you mean 'GDPR compliant'?
Lol, yea 😂
This is why I get for replying using my phone
I'll update my spelling mistake.
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?
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.
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
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 https://github.com/vendrhub/vendr/issues/110 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.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted