Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 08-05-2016 07:42:46

Graham
Member
Registered: 09-30-2004
Posts: 981
Website

Abandoned Carts

In v8, if a customer puts goods into their cart, starts the checkout process, but then abandons the cart before completing payment, there's a record of it in the Pending and Cancelled Orders list.

If they don't go to the checkout, however, there doesn't seem to be a simple way of seeing what they were interested in which means it's difficult to send them a follow up e-mail offering them a deal if they complete their purchase.

Will there be a way of doing this in v9?

Offline

 

#2 08-08-2016 12:50:02

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19774
Website

Re: Abandoned Carts

We have a module for Listrak that tracks abandoned carts in V9 and sends customers emails, etc.  It's awesome, but expensive (not the module, Listrak fees are high).

I have programmed an abandoned cart email function that works well on early V9 betas which I would like to port to the final V9 and release in the fall, if there's interest.


Nick Hendler

Offline

 

#3 08-09-2016 16:53:54

Iceit88
Member
From: Fairview, PA
Registered: 11-19-2003
Posts: 549
Website

Re: Abandoned Carts

Add me to the interested.


Bryan

Hat Trick Sports, LLC

Offline

 

#4 08-10-2016 08:30:53

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19774
Website

Re: Abandoned Carts

10-4.  It's kind of neat that it can all be tracked that way.  As soon as someone has entered an email address anywhere in the system and has a cart we can potentially fire off reminder emails when we don't see recent orders.


Nick Hendler

Offline

 

#5 08-10-2016 12:06:52

meshugy
Member
Registered: 12-18-2004
Posts: 349

Re: Abandoned Carts

You can also count me in for this...

Offline

 

#6 08-11-2016 07:34:08

Graham
Member
Registered: 09-30-2004
Posts: 981
Website

Re: Abandoned Carts

I'm definitely interested.

Offline

 

#7 01-19-2017 15:50:34

juanstg
Member
From: Evansville, IN
Registered: 02-26-2010
Posts: 77

Re: Abandoned Carts

I know it's a bit old, but I would be interested.  I currently use ShipWorks with v8 and it has a Pending Order filter.  Periodically I send emails from that, but I do it manually cause sometimes abandon carts turned into orders just with a different order number than original.



Offline

 

#8 03-10-2017 06:15:04

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Abandoned Carts

Is there any progress on this?

I see no way to send prompt emails for abandoned carts on K9 like we could in CCP8 BOM or am I missing a link? I see no Order Incomplete email in the Mail Messages list so I guess not.

Quite often people just did not realise they had not completed the order process especially when checking out with PayPal Express.


Simon

Offline

 

#9 03-10-2017 11:29:00

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19774
Website

Re: Abandoned Carts

This functionality is being added into K9 in a future update.  Currently update 9.0.2 is finished and pending release.  The functionality you're looking for should be in update 9.0.3.


Nick Hendler

Offline

 

#10 01-20-2022 07:32:18

SQ-Julia
Member
Registered: 01-20-2022
Posts: 2

Re: Abandoned Carts

Old post I know but did anyone ever come up with a solution to extracting the abandon cart information.

It looks like the information is probably there in the session data and cart ID.

Would love to link it up to Mailchimp/Mandrill like you can on other platforms so we can follow it up.

Any pointers greatly received? Will share if we find a method.

Julia
System Q UK

Offline

 

#11 01-20-2022 09:08:52

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19774
Website

Re: Abandoned Carts

We are currently working on this functionality to include in K9.  Technically, here is the info required:

- core_users.sessdata holds a serialized array of session data for logged in users.  In that array, (if present) the key 'ecom.cartid' holds the id for the shopping cart. core_users.id holds the user's email address.

- core_sessions.data holds a serialized array of session data for guests.  In that array, (if present) the key 'ecom.cartid' holds the id for the shopping cart. In that array, (if present) the key 'email' holds the user's email address.

- ecom_cart.cartid is equal to the ecom.cartid value for every user.  ecom_cart may contain multiple rows (multiple cart items) matching ecom_cart.cartid=ecom.cartid.

- ecom_cart.time is the epoch timestamp when the cart item was last updated.  For reference to send mails in a timely fashion.


Nick Hendler

Offline

 

#12 02-15-2022 04:09:50

SQ-Julia
Member
Registered: 01-20-2022
Posts: 2

Re: Abandoned Carts

Hi Nick,

Our programmer used your suggestions from 20th Jan and we now have it working so thank you.

Julia

Offline

 

Board footer