Cron job for displaying cart which is not converted in order

[Former Member]

Hi Experts, I have to create one cron job in which we have to display the cart which is not converted in order . I want to create one flexible search query for this but unable to understand how to create .

Could anyone help me or guide me on this ?

Thanks in advance ......

Regards, Satish

[Former Member · Accepted solution]

Hi Satish, When you click on place order button on website then cutomatically converts to an order. if cart is unable to convert it will give error to customer that cart is not placed and cart status will be as it is. If this is not the case in your application then play with the cart status or add one more status as SUBMITTED by extending OrderStatusModel to check get all cart which are in this status.

select {c.code},{c.pk},{os.code} from {cs c join orderstatus as os on {c.status}={os.pk} } where {os.code} = 'SUBMITTED'

[Former Member · Accepted solution]

Hi Ravi ,

Thanks for providing me above flexible search query with explanation .

It really helped me too much for clearing my concept .

Regards,

Satish

[Former Member]

Hi Saurabh ,

Thanks for your reply .

But i have to find that cart only which are not converted in order and accordingly flexible search query also .

Please suggest me on this .

Regards,

Satish

[Former Member]

HI Satish, both CartModel and OrderModel extends from AbstractOrderModel

CartModel gets converted into OrderModel when order is placed. Before conversion you have the CartModel.

So your query should be: select {pk} from {Cart!}

[Former Member]

Hi Saurabh , Thanks for your help and suggestion .