Culprit: Human mistake: Flat Tables Were Enabled when order was set to 'process': Invoice is not generated.

I need to retrieve all processed orders with no invoice. An SQL query could do that. Has anyone experienced that issue and has suggestions ?

1 Answer 1


I ran this and got results, but it will return canceled orders, I guess I need to add other tables to get desired results:


_order.increment_id as 'Order Number', _invoice.increment_id as 'Invoice Number'

from sales_flat_order _order

left join sales_flat_invoice _invoice on _order.entity_id = _invoice.order_id


_invoice.order_id is null

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.