Email Confirmations/Checkout_process (Help, shopping mall)

[Aodhan]

Hey all...still working on the multiple store stuff.

 

I have the table STORES that contains store information such as the Store ID, email address, etc.

 

In the PRODUCTS and ORDERS_PRODUCTS tables I have the store id associated with each store.

 

When I checkout, I am trying to send extra emails to each store outlining purchases from their store only.

 

Now, since I already have all the information in the $order contained in checkout_process, I should just be able to rebuild the emails, pull the email address for each store, and build and send the email.

 

However, I can't ensure that the products will be in store order. Is there a way to sort it? Or would it be easier to have a temporary table, stick the orders in it and then query with a join statement? Or is there a better way to do the whole mess?

 

Any and all suggesstions are welcome...

 

Aodhan