custom script/function to commit order details to database?

[filfish]

[MODS] if this is in the wrong forum sorry, please move if needed.


I'm creating an inhouse epos system for our shop, we currently use zencart for our online shop and I wanted to commit orders from the epos system to the database as orders, I don't want to just update the stock levels, if it goes in as an order from a customer then it is easier for me to audit it later.

What I need to know is either, is there a single sc ript used to commit orders to the database and if so where? or what fields in which tables need to be updated in order to create a new order.

A single sql command would be great!

many thanks in advance.

[filfish]

I've managed to sort it.

I created a test site on my local server, created a customer then made a dump of the DB, I then made a purchase as the new user and once completed I dumped the DB again and ran a diff between the two files and found there are 3 insert into commands that changed, I poped them into my script and it all works nicely.

[solo_400]

Thx for sharing !

[moosesoom]

Could you please tell us the 3 insert lines?
Thanks

[DrByte]

Could you please tell us the 3 insert lines?
Thanks

You'll find them in the orders.php class file.

But if you're going to add your own, you should use the notifier hooks in that file to intercept the inserts and use the same data to do your own additional inserts. That way you won't have to redo the custom code when an update is issued.