So, at the end of the checkout process (where it becomes an order) I want to fire off an SQL query wrapped inside AJW export (which creates an xml file).
However, within the confines of ExpressionEngine and Expresso respectively how precisely would I do this?
The idea would be:
User hits submit --> No Errors --> Turn into order --> Fire off AJE\SQL XML --> Redirect user to whatever page.
I'm guessing I'd use a hook or something like this, right?
Any suggestions for how this might be most suitably accomplished? The documentation is kind of thin when it comes to this stuff.
On the other hand, would it be possible for me to put the code in a template and do a 'next' on the checkout tag instead of 'return' so when the user hits "confirm" it takes them to a template with the code, which automatically creates the order and returns them to a page with the hash?
If I'm over thinking this, I'm totally open to any solution that proves to be simpler\superior.
Edit: No, this won't work. Because it hasn't been put into the database by the time this script executes...