Question:
Is there some existing setting or perhaps a sproc we can use as a trigger to call a web service when a transaction completes? We have a client where we intend to use Smith Cart, but they will be using fsifullment as their 3rd party vendor.

Answer:
Yes in cart v2.93 there is a new feature in the cart settings under the general cart setup section called “Enable OnCheckout Complete Event”. This allows you to call a custom SQL Server stored procedure that you program. The event that triggers the stored procedure being executed is a successful checkout in the cart. Note: If you installed DNN with a database objectqualifier you must append it to your custom stored procedure.

I was the one who asked for the calling of a stored procedure. In retrospect, a nice (really nice) feature would have been to pass variables, and perhaps that is something that can be easily included at some later point. (I'm using a stored procedure to call a routine that imports to MAS90, and I've added a couple of fields to the database, like "EnteredIntoMAS" so I can keep track of which orders have been sent and which haven't).

However, it would be REALLY nice if we could pass a pseudo-variable, such as:

dbo.MyOrdersProcess [ORDERNO]

... where "ORDERNO" would be the order number that was just placed, passed as a variable to the SP.

Just a thought.

:)

--Greg