Copied to clipboard

Flag this post as spam?

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


  • Loyan Roylance 10 posts 51 karma points
    Apr 11, 2014 @ 00:47
    Loyan Roylance
    0

    Cart Abandonment Detection

    Is there any existing method for detecting an abandoned cart in Tea Commerce? 

    If not, is there any advice? 

    We are flexible as to the exact event defination of an abandoned cart. The spirit of the request is to allow a sales person to follow up on the sales lead the abaondoned cart may represent. 

     

     

  • Anders Burla 2560 posts 8256 karma points
    Apr 11, 2014 @ 10:23
    Anders Burla
    0

    Hi Loyan

    I think the most easy way is to use some simple sql to select the order id of orders that are still in the cart stage (use the column finalizedDate to determin if its not completed). Then load those using the Tea Commerce API (use OrderService.Instance) and then send email using EmailService.Instance. Then register somehow the email has been send. Now just make it a service that run over and over again.

    Sounds like a plan?

    Kind regards
    Anders

  • Loyan Roylance 10 posts 51 karma points
    Apr 11, 2014 @ 17:39
    Loyan Roylance
    0

    Anders,

    Thank you. It definately sounds worth a try.I think the tip to use the finalizedDate column should be very helpful. We'll post back here if it works for reference.

     

  • Loyan Roylance 10 posts 51 karma points
    May 08, 2014 @ 00:17
    Loyan Roylance
    0

    Anders,

    Can you direct us to the tabel that finalizedDate can be found in? We are not seeing that column in the orders table.

     

  • Anders Burla 2560 posts 8256 karma points
    May 08, 2014 @ 09:51
    Anders Burla
    0

    You should see it in the TeaCommerce_Order table. DateFinalized

Please Sign in or register to post replies

Write your reply to:

Draft