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.
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.
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.
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.
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
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.
Anders,
Can you direct us to the tabel that finalizedDate can be found in? We are not seeing that column in the orders table.
You should see it in the TeaCommerce_Order table. DateFinalized
is working on a reply...