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 '16 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 '16 at 5:10

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`
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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