I have different suppliers of similar products and I need to send a mail to the right supplier(s) when an order is placed…
When a customer completes the checkout, I imagine the pseudo-code would be something like:
1) Determine products in cart
2) Determine supplier(s) of product(s)
3) Send a mail to supplier(s) - e-mail address would likely be a product attribute
But how can I implement this - in particular, what is the mechanism for retrieving data (the text of an attribute) from the database ?
Any advice pointing out a direction will be greatly appreciated.