How to export each order into csv file when it will be placed?

This functionality will be done by and event observer. And Event is “checkout_onepage_controller_success_action”.

In this event you can get the current order data and you will be able to export this data in to csv.

Step 1: For add the event you have to make a events.xml in your module and paste the below code into it.

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
    <event name="checkout_onepage_controller_success_action">
        <observer name="customorderexport" instance="Magemonkeys\Customexport\Observer\Orderexport" />
    </event>
</config>

<?xml version="1.0"?>

</event>

</config>

Step 2: Now you have to create a Orderexport.php file in Observer folder and place the below code into it.

<?php

namespace Magemonkeys\Customexport\Observer;

use Magento\Framework\Event\ObserverInterface;
use Magento\Framework\App\Filesystem\DirectoryList;
use Magento\Framework\Filesystem;
use Magento\Framework\Filesystem\Directory\WriteInterface;
use Magento\Store\Model\ScopeInterface;

class Orderexport implements ObserverInterface
{
	protected $_request;
	protected $_order;
	protected $_productRepository;
	protected $_scopeConfig;
	protected $_customer;
	protected $_storemanager;

	public function __construct(
	    \Magento\Framework\App\RequestInterface $request,
	    \Magento\Sales\Model\Order $order,
     	\Magento\Framework\App\Response\Http\FileFactory $fileFactory,
		Filesystem $filesystem,
        \Magento\Framework\App\Config\ScopeConfigInterface $scopeConfig,
        \Magento\Customer\Model\CustomerFactory $customer,
    	\Magento\Store\Model\StoreManagerInterface $storemanager,
		\Magento\Catalog\Model\ProductRepository $productRepository
	) { 
		$this->_scopeConfig = $scopeConfig;
		$this->_customer = $customer;
		$this->_storemanager = $storemanager;
	    $this->_request = $request;
	    $this->_order = $order;
	   	$this->_fileFactory = $fileFactory;
        $this->directory = $filesystem->getDirectoryWrite(DirectoryList::VAR_DIR);
        $this->_productRepository = $productRepository;
 	}

	public function execute(\Magento\Framework\Event\Observer $observer) {
		
		$post = $this->_request->getPost();
		
		$orderids = $observer->getEvent()->getOrderIds();


	  	foreach($orderids as $orderid){

        	$order = $this->_order->load($orderId);


        	$websiteID = $this->_storemanager->getStore()->getWebsiteId();
			$customer = $this->_customer->create()->setWebsiteId($websiteID)->loadByEmail($order->getCustomerEmail());
        	$customerId = $customer->getId(); // using this 
        	$customerPoNumber = $customer->getCustomerNumber(); // using this 


			$headers = array('Magento_Account_Number','Back_Office_Account_Number','Transaction_Date','Transaction_Time','Magento_Transaction_Number','Client_Reference_Number','Item_Number','Quantity_Sold','Selling_Price','Discount');

			$name = strtotime("now");
		    $file = 'customorderexport/'.$name.'_detailed_orderexport.csv';
		    $this->directory->create('customorderexport');
		    $stream = $this->directory->openFile($file, 'w+');
		    $stream->lock();
		    $stream->writeCsv($headers);
		    
	        

	        $items = $order->getAllItems();
			foreach ($items as $item) {
				$orderdetail['Magento_Account_Number'] = $orderdata->getData('created_at');
		        $orderdetail['Order_Number'] = $orderdata->getData('increment_id');
		        $orderdetail['Transaction_Date'] = date('Y-m-d',strtotime($order->getCreatedAt()));
		        $orderdetail['Transaction_Time'] = date('h:i A',strtotime($order->getCreatedAt()));
		        $orderdetail['Magento_Transaction_Number'] = $order->getIncrementId();
		        $orderdetail['Client_Reference_Number'] = $customerPoNumber;
				$id = $item->getProdcutId();
				$product = $this->_productRepository->getById($id);
		        $orderdetail['Item_Number'] = $product->getAutoKoolNumber();
		        $orderdetail['Quantity_Sold'] = $item->getQtyOrdered();
		        $orderdetail['Selling_Price'] = $item->getPrice();
	        	$orderdetail['Discount'] = $order->getDiscountAmount();
	        	$stream->writeCsv($orderdetail);
		    }

		    $stream->unlock();
		    $stream->close();
        }
	}

}
?>

<?php

namespace Magemonkeys\Customexport\Observer;

use Magento\Framework\Event\ObserverInterface;

use Magento\Framework\App\Filesystem\DirectoryList;

use Magento\Framework\Filesystem;

use Magento\Framework\Filesystem\Directory\WriteInterface;

use Magento\Store\Model\ScopeInterface;

class Orderexport implements ObserverInterface

{

protected $_request;

protected $_order;

protected $_productRepository;

protected $_scopeConfig;

protected $_customer;

protected $_storemanager;

public function __construct(

\Magento\Framework\App\RequestInterface $request,

\Magento\Sales\Model\Order $order,

\Magento\Framework\App\Response\Http\FileFactory $fileFactory,

Filesystem $filesystem,

\Magento\Framework\App\Config\ScopeConfigInterface $scopeConfig,

\Magento\Customer\Model\CustomerFactory $customer,

\Magento\Store\Model\StoreManagerInterface $storemanager,

\Magento\Catalog\Model\ProductRepository $productRepository

) {

$this->_scopeConfig = $scopeConfig;

$this->_customer = $customer;

$this->_storemanager = $storemanager;

$this->_request = $request;

$this->_order = $order;

$this->_fileFactory = $fileFactory;

$this->directory = $filesystem->getDirectoryWrite(DirectoryList::VAR_DIR);

$this->_productRepository = $productRepository;

}

public function execute(\Magento\Framework\Event\Observer $observer) {

$post = $this->_request->getPost();

$orderids = $observer->getEvent()->getOrderIds();

foreach($orderids as $orderid){

$order = $this->_order->load($orderId);

$websiteID = $this->_storemanager->getStore()->getWebsiteId();

$customer = $this->_customer->create()->setWebsiteId($websiteID)->loadByEmail($order->getCustomerEmail());

$customerId = $customer->getId(); // using this

$customerPoNumber = $customer->getCustomerNumber(); // using this

$headers = array('Magento_Account_Number','Back_Office_Account_Number','Transaction_Date','Transaction_Time','Magento_Transaction_Number','Client_Reference_Number','Item_Number','Quantity_Sold','Selling_Price','Discount');

$name = strtotime("now");

$file = 'customorderexport/'.$name.'_detailed_orderexport.csv';

$this->directory->create('customorderexport');

$stream = $this->directory->openFile($file, 'w+');

$stream->lock();

$stream->writeCsv($headers);

$items = $order->getAllItems();

foreach ($items as $item) {

$orderdetail['Magento_Account_Number'] = $orderdata->getData('created_at');

$orderdetail['Order_Number'] = $orderdata->getData('increment_id');

$orderdetail['Transaction_Date'] = date('Y-m-d',strtotime($order->getCreatedAt()));

$orderdetail['Transaction_Time'] = date('h:i A',strtotime($order->getCreatedAt()));

$orderdetail['Magento_Transaction_Number'] = $order->getIncrementId();

$orderdetail['Client_Reference_Number'] = $customerPoNumber;

$id = $item->getProdcutId();

$product = $this->_productRepository->getById($id);

$orderdetail['Item_Number'] = $product->getAutoKoolNumber();

$orderdetail['Quantity_Sold'] = $item->getQtyOrdered();

$orderdetail['Selling_Price'] = $item->getPrice();

$orderdetail['Discount'] = $order->getDiscountAmount();

$stream->writeCsv($orderdetail);

}

$stream->unlock();

$stream->close();

}

That’s it.

Note- I have use the field and data as per my requirements. You will change this as per your requirements.

Fill the below form if you have any Magento programming need.

Add an image programmatically from any url in Magento 2
[crayon-63e0931182ac2821395151/] Using above fucntion Images can be imported directly from...
Magento 2 : Override the Category view block file
Override view block using di.xml and add the below code...
How to check list of Layout XML called for a specific page in Magento 2?
You can check a list of called layout XML for...
Magento 2 : Setup PWA from Scratch
Follow the below steps to install and set up PWA...
How to remove leading zero’s from the order, invoice and shipment number in Magento 2?
If you want to remove all leading zero's from order,...

Author Info

Hire A. Patel

Let’s have a call

Fill the form & Get Installation Support