{"id":13193,"date":"2025-05-02T13:19:43","date_gmt":"2025-05-02T07:49:43","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/?p=13193"},"modified":"2025-05-02T13:19:45","modified_gmt":"2025-05-02T07:49:45","slug":"export-magento-orders-with-products","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/export-magento-orders-with-products\/","title":{"rendered":"Methods to Export Magento Orders with Products in CSV"},"content":{"rendered":"\n

Running a Magento store means dealing with lots of orders\u2014and sometimes, you need to get all that order info into a sheet. <\/p>\n\n\n\n

In this blog post, we will show you how to export Magento orders with products in CSV using different methods. <\/p>\n\n\n\n

Methods to Export Orders with Products<\/h2>\n\n\n\n

There are mainly four methods in Magento to export orders with products: <\/p>\n\n\n\n

Use Custom Order Grid – <\/strong>Here, you will need to extend the existing grid in your Magento 2 UI. The best way to do so is using a Magento 2 order export extension to add custom columns and filters.<\/p>\n\n\n\n

Custom Order Export Script –<\/strong> Create a PHP script to query order and related product data to export directly to a CSV file. This method is used for scheduled exports or dealing with an external system.<\/p>\n\n\n\n

Magento 2 API – <\/strong>You can export products using the API, where you need to use Magento REST and GraphQL APIs. This process can become complex for advanced reporting.<\/p>\n\n\n\n

Query Order DB – <\/strong>Directly access the Magento database and extract the order and product details. This method means expert supervision.  <\/p>\n\n\n\n

Of these four methods, three require you to manually add code where the risk of damage is high. <\/p>\n\n\n\n

The recommended one is using a custom order grid. <\/p>\n\n\n\n

How to Export Orders with Products Using a Custom Grid?<\/h2>\n\n\n\n

Here, we will use the Meetanshi Magento 2 Custom Order Grid extension<\/a> to add an order grid directly to your Magento 2 store and take mass action upon it instantly. <\/p>\n\n\n\n

Install the extension and follow these simple steps for exporting Magento orders with products CSV. <\/p>\n\n\n\n

Step 1: Head to Columns in The Order Grid  <\/h3>\n\n\n\n

First, you need to add a product column in the order grid. For that, navigate to Sales > Orders <\/p>\n\n\n

\n
\"Navigate<\/figure>\n<\/div>\n\n\n

Now, click Columns <\/strong>in the upper right-hand side corner. <\/p>\n\n\n

\n
\"Head<\/figure>\n<\/div>\n\n\n

Step 2: Select the Products from the Columns<\/h3>\n\n\n\n

Now, click Columns<\/strong> and select the product details you want to add to the order grid. The selected columns will automatically be added to the grid. <\/p>\n\n\n

\n
\"Select<\/figure>\n<\/div>\n\n\n

Then click Export<\/strong> and choose CSV <\/strong>as the file format. <\/p>\n\n\n

\n
\"Click<\/figure>\n<\/div>\n\n\n

Step 3: <\/strong>Open CSV file in Excel or Google Sheet <\/h3>\n\n\n\n

Now, open the exported CSV file in a Google sheet or Excel. <\/p>\n\n\n

\n
\"Open<\/figure>\n<\/div>\n\n\n

In just three steps, your Magento 2 export orders with products is done without any coding. <\/p>\n\n\n\n

\r\n
\r\nMagento 2 Custom Order Grid<\/span>\r\n

Add advanced order grids in your Magento 2 store quickly without coding anything.<\/p>\r\nAdd Now <\/a>\r\n<\/div>\r\n

\r\n\"Magento\r\n<\/div>\r\n<\/div><\/p>\n\n\n\n

Magento 2 Export Orders CSV Programmatically via PHP Script<\/h2>\n\n\n\n

Follow these three easy steps to export orders in CSV programmatically.<\/p>\n\n\n\n

Step 1: Create an Order file With Products <\/h3>\n\n\n\n

Go to your Magento 2 root directory and create a new file named export-orders-with-products.php<\/strong><\/p>\n\n\n\n

Step 2: Use this Order Code<\/h3>\n\n\n\n

Now, paste the following code into the newly created file.<\/p>\n\n\n\n

<?php\nuse Magento\\Framework\\App\\Bootstrap;\n\nrequire __DIR__ . '\/app\/bootstrap.php';\n$bootstrap = Bootstrap::create(BP, $_SERVER);\n$objectManager = $bootstrap->getObjectManager();\n\n\/\/ Set area code\n$state = $objectManager->get('Magento\\Framework\\App\\State');\n$state->setAreaCode('adminhtml');\n\n\/\/ Get order repository\n$orderRepository = $objectManager->get('Magento\\Sales\\Api\\OrderRepositoryInterface');\n$searchCriteriaBuilder = $objectManager->get('Magento\\Framework\\Api\\SearchCriteriaBuilder');\n\n\/\/ Build search criteria (e.g., all orders)\n$searchCriteria = $searchCriteriaBuilder->create();\n$orders = $orderRepository->getList($searchCriteria)->getItems();\n\n\/\/ Export to CSV\n$file = fopen('orders_with_products.csv', 'w');\nfputcsv($file, ['Order ID', 'Date', 'Customer', 'Status', 'SKU', 'Product Name', 'Quantity', 'Price']);\n\nforeach ($orders as $order) {\n    $customer = $order->getBillingAddress()->getFirstname() . ' ' . $order->getBillingAddress()->getLastname();\n    foreach ($order->getItems() as $item) {\n        fputcsv($file, [\n            $order->getIncrementId(),\n            $order->getCreatedAt(),\n            $customer,\n            $order->getStatus(),\n            $item->getSku(),\n            $item->getName(),\n            $item->getQtyOrdered(),\n            $item->getPrice()\n        ]);\n    }\n}\n\nfclose($file);\necho \"Exported to orders_with_products.csv\\n\";\n<\/pre>\n\n\n\n
Step 3: Get Your CSV File <\/h3>\n\n\n\n
Then, run this PHP script by using this command:<\/p>\n\n\n\n
php export-orders-with-products.php<\/code><\/pre>\n\n\n\n
Now, you can find your CSV saved in the root directory.<\/p>\n\n\n\n
\"Saved<\/figure>\n\n\n\n
Use Magento 2 API to Get Orders with Products<\/h2>\n\n\n\n
Step 1: Grant Order Permissions <\/h3>\n\n\n\n
From your Magento admin panel, head to System > Integrations > Add New Integration. <\/strong>Add integration details with your credentials. <\/p>\n\n\n\n
Then <\/strong>head to Sales > Orders permissions and grant the order pres<\/strong><\/p>\n\n\n\n
Step 2: Use API for Order Data With Products <\/h3>\n\n\n\n
Now, you can use the API to get the orders data with products. For e.g., here\u2019s the python script for it:<\/p>\n\n\n\n
import requests\nimport csv\nfrom oauthlib.oauth1 import Client\n\n# OAuth credentials\nconsumer_key = 'your_consumer_key'\nconsumer_secret = 'your_consumer_secret'\naccess_token = 'your_access_token'\naccess_token_secret = 'your_access_token_secret'\n\n# API endpoint\nurl = 'https:\/\/yourstore.com\/rest\/V1\/orders?searchCriteria[pageSize]=10'\n\n# OAuth client\nclient = Client(consumer_key, consumer_secret, access_token, access_token_secret)\nuri, headers, _ = client.sign(url)\n\n# Fetch orders\ntry:\n    response = requests.get(uri, headers=headers)\n    response.raise_for_status()\n    orders = response.json()['items']\n    print(f\"Fetched {len(orders)} orders.\")\nexcept Exception as e:\n    print(f\"API error: {e}\")\n    exit(1)\n\n# Export to CSV\nwith open('orders_with_products.csv', 'w', newline='') as csvfile:\n    writer = csv.writer(csvfile)\n    writer.writerow(['Order ID', 'Date', 'Customer', 'Status', 'SKU', 'Product Name', 'Quantity', 'Price'])\n    for order in orders:\n        customer = f\"{order['billing_address']['firstname']} {order['billing_address']['lastname']}\"\n        for item in order.get('items', []):\n            writer.writerow([\n                order['increment_id'],\n                order['created_at'],\n                customer,\n                order['status'],\n                item.get('sku', 'N\/A'),\n                item.get('name', 'N\/A'),\n                item.get('qty_ordered', 0),\n                item.get('price', 0.0)\n            ])\nprint(\"Exported to orders_with_products.csv\")\n<\/pre>\n\n\n\n
Query & Export Data from Magento 2 Database<\/h2>\n\n\n\n
For this last method, in your Magento 2 database, run the following query to fetch orders and product details.<\/p>\n\n\n\n
SELECT\n    so.increment_id AS order_id,\n    so.created_at AS order_date,\n    CONCAT(soa.firstname, ' ', soa.lastname) AS customer,\n    so.status AS order_status,\n    soi.sku,\n    soi.name AS product_name,\n    soi.qty_ordered,\n    soi.price\nFROM sales_order so\nJOIN sales_order_address soa ON so.entity_id = soa.parent_id AND soa.address_type = 'billing'\nJOIN sales_order_item soi ON so.entity_id = soi.order_id\nWHERE soi.parent_item_id IS NULL -- Exclude configurable product parents\nORDER BY so.increment_id, soi.item_id;\n<\/pre>\n\n\n\n
You can then export the data to a CSV file to get the orders with products.<\/p>\n\n\n\n
Finally, What\u2019s the Easiest Way to Get Orders with Products?<\/h2>\n\n\n\n
The easiest method for this task is to add a custom order grid and then directly download the CSV file. <\/p>\n\n\n\n
You get access to 50+ useful columns like customer info, shipping method, coupon codes, and more without the need to add any PHP code or use an API. <\/p>\n\n\n\n
A simple and safe method to export orders with products in Magento 2. <\/p>\n\n\n\n
\r\n
\r\nMagento 2 Custom Order Grid<\/span>\r\n
Add advanced order grids in your Magento 2 store quickly without coding anything.<\/p>\r\nAdd Now <\/a>\r\n<\/div>\r\n
\r\n\"Magento\r\n<\/div>\r\n<\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Running a Magento store means dealing with lots of orders\u2014and sometimes, you need to get all that order info into a sheet.  In this blog…<\/p>\n","protected":false},"author":5,"featured_media":13207,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-13193","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/13193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=13193"}],"version-history":[{"count":6,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/13193\/revisions"}],"predecessor-version":[{"id":13241,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/13193\/revisions\/13241"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media\/13207"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=13193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=13193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=13193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}