Hi All,
We've had a problem recently where a part order was missed... This has happened a couple of times now.
I might write myself a simple CMS system myself which would be totally independent form Prestashop to allow me to monitor orders which have been shipped and which orders still have items which are yet to be shipped.
To do this, i've been looking into the crazy Prestahop database structure and its not simple to understand. I plan to connect to the Prestashop database from a remote website and query this as needed. I'll then pull order details into a totally separate database and use this in my own CMS.
I can see order details in PREFIX_orders and the associated products in PREFIX_order_detail which is fine and i can work with this.
The issue i have is that i can't see how to get the delivery and invoice address which is associated with an order.
Customer address details are stored into the PREFIX_address table but i can't see how to correctly grab the correct delivery & invoice address for the order. I hope that makes sense?
proposed steps;
1) Goto PREFIX_orders and grab the id_order and id_customer.
2) Get the details from PREFIX_order_detail for which products are included in this sale. These 2 steps are simple enough.
3) Get the delivery and invoice addresses for this sale. <-its this bit i'm struggling with!
I know this is all a bit long winded and i'm only looking at options at the moment but i should be able to write something which will really help us out.
Any help or guidence with this would be appricated.
Ian