Need a custom db call when a certain product is sold.

[madk]

Hello all,

I'm in the process of doing some research for an upcoming project. Essentially what I need to do is to make a call to a db and insert customer info when a certain product is sold. I'm just looking at some basic guidance to see where I should begin looking.

When the customer purchases this specific product, they will be added to a special mailing list. The db only needs to know their user id and date/time of the purchase.

Any suggestions will be appreciated.

[bunyip]

Best option is to develop a special observer class that is attached to the NOTIFY_ORDER_AFTER_ORDER_CREATE_ADD_PRODUCTS notifier - when it gets triggered it checks the order to see if your special product was purchased and if so adds an entry to your db table.

[madk]

Could you possibly provide a simple example of how I would do this. I am finding the documentation a bit over my head.