How can I create invoices from orders in mysql

[iloris]

Hi all!

 

I migrated from woocommerce to prestashop and I imported all orders, customers and products. Everything is fine but all the imported orders does not contains invoices. 

 

From each order in the prestashop dashboard, if I click on generate invoice, it works but I have more than 5000 to create :/ so I wondered if I could generate those invoices from a quick mysql request.

 

What are the table used to create an invoice from an order? 

 

Thanks for your help,

 

Loris

[vekia]

you can't do it with mysql request because whole invoice system is based on php script, not mysql (mysql stores only data) - whole generation process is a part of php script.