Alert for shopping cart held status.

[Former Member]

Hi ,

I have a requirment where i need to get all the shopping carts

from last 1hr from the system time from the database table which are under held status and if they are more than 5 shopping carts in held status then it should send a alert mail.

Is there any standard program? If any body worked on this requirement please guide me.

Thanks in Advance,

Savitha.

[Former Member]

Problem resolved thanks

[Former Member]

You can then use function SO_OBJECT_SEND or SO_DOCUMENT_SEND_API1 or SO_NEW_DOCUMENT_SEND_API1 to send e-mails to whoever.

Regards,

Dave.

[Former Member]

Hi. I don't think there is anything standard like this. You will have to write a program that selects in carts created in the last hour (Table CRMD_ORDERADM_H will show you this).

Then either call function BBP_PD_SC_GETDETAIL structure E_STATUS or check table CRM_JEST for status I1009 with inactive = space. That status means the cart is on hold.

Regards,

Dave.