Help - I need to collect information on abandoned carts

[skinnybloke]

Hi - I need to collect information on abandoned carts in Sellerdeck (still can't believe that Sellerdeck is on v12 and still can't do this).

I want to collect customer's details and the contents of the cart

Are there any plugin's available that will do this.

If not, any recommendations on how to write something myself?

[Mike Hughes]

1. You'll need to do it yourself. I'm not aware of anything that exists at the moment.

2. I suspect everything you need is stored in the session files. Each one will have all the information present at the stage the customer abandoned the cart, including at what stage they left.

A relatively simple script should be able to pop the contents into a database for you. Maybe run it every hour and gather the data from session files more than an hour old.

IIRC mysql can save the contents to a csv file for you which can then be downloaded and analysed in excel.

Mike

[skinnybloke]

Thanks for the reply Mike - I'll take a look at that.

[cbarling]

It's worth noting that any orders that have buyer details but where the buyer abandoned after clicking to a PSP site will appear in SellerDeck under the PSP pending tab. They normally stay there 30 days - it's a setup parameter how long to keep them.

Chris

[skinnybloke]

Hi Chris - what I'm really looking for is anyone who abandons their cart once they have added their email address or telephone number.

[Mike Hughes]

If you don't want anything fancy a really quick way to do this is just to run a script every hour that copies each session file and saves it with a different extension.

To avoid files from people just browsing, you could always make it only save files that have at least one product in the cart, have started checkout, or have an email or telephone number stored, etc.

Mike

Edit: An even simpler way would be modify the sellerdeck clear up routine that deletes the session files. Just tell it to rename the session files rather than delete them.

[skinnybloke]

Thanks for the reply Mike - I'll give this a go.