Does anybody know how to export from PhpMyAdmin the Quantity sold by products and by Order Number ?

I've already found Sku and Qty Sold in the table Sales_flat_order but I really don't know how to join with order number.

Any idea ?

Thank you very much.

  • Can you send what you have tried so far?
    – Charlie
    May 18, 2016 at 4:53
  • I've simpy exported the table from DB, then open it with MS Excel, then remove all columns except "SKU" and "Qty Ordered".
    – Eric Ly
    May 18, 2016 at 5:10

1 Answer 1


Try this query:

SELECT `item`.`sku`, `item`.`qty_ordered`, `main`.`increment_id` 
FROM `sales_flat_order_item` as `item` 
LEFT JOIN `sales_flat_order` as `main` 
ON `main`.`entity_id` = `item`.`order_id`

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.