Export and Import Orders for Magento 2

Export Import Orders

Introduction

The extension allows to export and import customers and guest orders including all order data as well as product, customer-related data.

Installation

Installation using archive

  1. Download the extension's package from your Ulmod account.
  2. Unpack the extension ZIP file on your computer.
  3. Connect to your website source folder with FTP/SFTP/SSH client and upload all the files and folders from the extension's package to the corresponding root folder of your Magento installation.
  4. Log into the Magento server (via SSH) as a user who has permissions to write to the Magento file system.
  5. Via SSH, navigate to the root Magento folder and perform the command:
    php bin/magento module:enable Ulmod_Core Ulmod_OrderImportExport
  6. And finally, update the database, flush cache and deploy content:
    php bin/magento setup:upgrade
    php bin/magento cache:flush
    php bin/magento setup:static-content:deploy
    

Export and Import Orders

Export Orders

The extension allows store administrator to export orders in the admin panel. To export orders, please go to SYSTEM ⟶ Data Transfer by Ulmod ⟶ Export/Import Orders.

Export Orders

Under the Export Orders section :

In the From/To Date set a time interval to export the orders.

Set Include Customer Account Information?to Yes to export customer account information such as firstname, lastname, middlename.

In the field, Separator enters the field separator. The default value is a comma (,)

In the fields, Enclosure enters the enclose value for each field. The default value is ("")

Click the Export Orders button to export orders. The orders will be exported to a CSV file. eg. export_orders_DD_MM_YY hh_mm_ss.csv

Note: A comma (,) is the default separator in a CSV file. To use a different character, make sure that the data in the CSV file matches the character that you define

Import Orders

Under the Import Orders section :

Set Update Customer Billing and Shipping Addresses? field to "Yes" to update customers billing and shipping address during the import

Set Create Invoice(s) field to "Yes" to create invoices during the import

Set Create Shipment(s) field to "Yes" to create shipments during the import

In the field, Separator enters the field separator. The default value is a comma (,)

In the fields, Enclosure enters the enclose value for each field. The default value is ("")

In the Select CSV File to Import field, tap choose the file to select the CSV file to import

Click the Import Orders button to export orders. The orders will be exported to a CSV file. eg. export_orders_DD_MM_YY hh_mm_ss.csv

Note: Please edit the CSV file to import on google docs or similar tools. If you edit on google docs, make sure to download as CSV (File ⟶ Download as ⟶ Comma-separated values(.csv, current sheet))

Command Line(CLI)

CLI settings

To access the CLI configuration settings of the extension, log into the Magento Admin panel and go to STORES ⟶ Configuration ⟶ ULMOD EXTENSIONS ⟶ Export/Import Orders.

The module’s configuration contains only one section: CLI. Under the section :

In the field, Separator enter the field separator. The default value is a comma (,)

In the fields Enclosure enter the enclose value for each field. The default value is ("")

Set Update Customer Billing and Shipping Addresses? field to "Yes" to update customers billing and shipping addreess during the import

Set Create Invoice(s) field to "Yes" to create invoices during the import

Set Create Shipment(s) field to "Yes" to create shipments during the import

CLI Import

List all commands :

php bin/magento

To Import a single CSV file:

    • Upload the CSV file on magento directory;
    • Run the import command ;
php bin/magento ulmod:order:import-single

To Import multiple CSV files (Batch import):

    • Create a import directory. Example : var/importorder;
    • Upload all CSV files into the import directory( var/importorder);
    • Run the command to import all CSV files on the directory;
php bin/magento ulmod:order:import-multi

Sample Downloads

Sample Downloads

Click to download samples :

 Download Sample Import Export Orders File

Extension Support

Need Help?

Ulmod Support team is always ready to assist you, no matter which part of the world you are in. If something does happen and you think you might be experiencing an issue or bug, please contact us via [email protected] or submit a ticket from our Helpdesk Ticket and we will help you out.

Got Questions?

Should you have any questions or feature suggestions, please Contact Us. Your feedback is welcome!

Extension Product Page