Which tables to populate?

[Guest]

Hi guys

 

Im writing a little script to pull certain order information and place it directly into our oscommerce store so we can manage invoices/despatches from one central place.

 

Ive got the script as far as pulling the information and putting it into a mysql table, but what is apparant to me at the moment is that an order in oscommerce is actually made up of a couple of different tables in the sql db.

 

Can anyone tell me what tables need to be filled in to create an order?

 

thanks

[♥geoffreywalton]

Try all the tables caler order........

 

What needs completing depends on the type of order. Just enter a few and look would be my advice.