Multiple Emails to Manufacturers / Suppliers on Purchase

[gareth456]

I would like to set up OSCommerce to automatically email different manufactures or suppliers of my products letting them have details of each purchace (who supply directly to customer) upon an item or items being purchased. Buyers might buy items which are supplied by multiple manufacturers, so more than one email may need to be sent each time with different details in each (depending on the items bought and the suppliers who they come from).

 

Complicated eh!! Any ideas on where I start? All ideas gladly received.

 

Gareth

[wizardsandwars]

This is something that I have though about as well.

 

You could start with a couple of tables. 1 table with

 

Distributor_id, distributor_name, distributor_email

 

And one table with

 

product_id, distributor_id

 

Once you have that set up, you could just find where it send the email out each time an order is placed, and query those talbes to determine who to send extra emails to.

[Aodhan]

I would like to set up OSCommerce to automatically email different manufactures or suppliers of my products letting them have details of each purchace (who supply directly to customer) upon an item or items being purchased.  Buyers might buy items which are supplied by multiple manufacturers, so more than one email may need to be sent each time with different details in each (depending on the items bought and the suppliers who they come from).

 

Complicated eh!!  Any ideas on where I start?  All ideas gladly received.

 

Gareth

 

Gareth-

 

My contribution does something very similar to this, where the top category name determines the "store" that it was bought from, and each store owner gets details of purchases from their store. It would take very little modification to change it from store ID controlled to manufacturer ID controlled.

 

http://www.oscommerce.com/community/contri...ions,577/page,4

 

Aodhan