mod-m2-oie.png

Order Import/Export
M2

TOTAL:
$149.99
Compatible With: Community 2.0, 2.1, 2.2, 2.3 Enterprise 2.0, 2.1, 2.2, 2.3

Tech Specifications

Seller:
Current Version:
1.2.7
Type:
Stable Build
Updated:
11 December, 2018
Categories:
Extensions, Sales
Supported Browsers:
Chrome Linux: 42, 43, 44 Mac: 39, 44 Windows: 39, 40, 42, 43, 44 Firefox Linux: 31, 38, 39, 40, 41 Mac: 31, 38, 39, 40, 41 Windows: 31, 38, 39, 40, 41 Opera Linux: 7, 7.1, 8, 9 Mac: 7, 7.1, 8, 9 Windows: 7, 7.1, 8, 9 Safari Linux: 7, 7.1, 8, 9 Mac: 7, 7.1, 8, 9 Windows: 7, 7.1, 8, 9 Edge Windows: 42 IE Windows: 10, 11, 8, 9
Policy:

Overview

Import Orders, Invoices, Credit Memos, Payments, Shipments and more in bulk with CSV from the admin panel or the command line. This is a feature-rich order import extension.

Other Extensions by MageModule, LLC

Overview

Back to top

MageModule Order Import/Export is quite possibly the most robust order import and export extension on the market for Magento 2 today. The module can quickly export orders into CSV format using either the admin panel GUI or from the command line. Equally, the extension can import large CSV files from either the admin panel GUI or the Magento command line interface.

Additionally, it is built in such a way that any moderately code-savvy person can make minor customizations to suit their order import and export needs. Order Import/Export is also different from almost all other import/export modules on the market today for a variety of reasons, which are outlined below. The vast majority of order import/export modules on the market today use direct SQL and other unsafe hacks to make the software manipulate the data in a specific way and then force that modified data into the database. However, this lends itself to database corruption that can be hard to diagnose and even harder to fix. Order Import/Export uses only native Magento functionality to accomplish its goals in a safe and integral manner.

 

Import Features:

  • Safely imports orders and related information
  • Allows for the import of 250+ order data points, although, orders can be imported with much less data in the file
  • Matches customer by e-mail and if customer doesn't exist, will create customer if the order is not flagged as a "guest" order
  • Adds order addresses to customer's address book
  • Properly creates order line items for all product types: Simple, Grouped, Configurable, Bundle, Downloadable, and Virtual
  • Allows for the import of custom order numbers if the custom order number is not already in use by another order
  • Allows for the creation of invoices, credit memos, and shipments upon order import
  • Imports order items even if those products don't exist in the catalog
  • Imports order item taxes and discounts
  • Imports order item quantities: invoiced, shipped, refunded, canceled
  • Performs some basic helper calculations in the case of missing order item data
  • Imports payment methods even if the payment methods don't exist in the system
  • Imports shipment methods even if the shipment methods don't exist in the system
  • Imports order status history/comments
  • Allows user to input the CSV file's field delimiter and field enclosure characters
  • Provides a summary of how many orders were imported and how many errors (if any) occurred during import
  • Uses ACL permissions to restrict the ability to import orders as needed
  • Follows Magento best practices and can be customized by other developers as needed

 

Export Features:

  • Exports 250+ order data points
  • Exports a high level of detail about order items: quantity invoiced, quantity shipped, quantity canceled, quantity refunded, taxes, discounts, subtotal, row total, and more
  • Exports status and comment histories, payment data, shipment data, and more
  • Exports customer information and customer addresses
  • Exports information regarding all aspects of the order, including, but not limited to: taxes, discounts, shipping charges, amounts refunded, etc
  • Exports all iterable items in a human-readable and machine-readable format, e.g., order items, order comments, etc
  • Allows user to specify the CSV file's field delimiter and field enclosure characters
  • Allows user to specify date range to narrow down the selection of orders to be exported
  • Exports CSV in a format that can directly re-imported back into the system without any additional modification
  • Uses ACL permissions to restrict the ability to export orders as needed
  • Follows Magento best practices and can be customized by other developers as needed

 

Order Import/Export Can Be Used From:

  • Admin Panel GUI
  • Magento's command line interface

 

Order Import/Export Will Not:

  • Will not trigger order, invoice, shipment, or credit memo emails to customers
  • Will not perform any sort of payment processing
  • Will not create products in the catalog
  • Will not use any direct SQL, dangerous methods, or unconventional hacks to modify any data
  • Will not halt importation of orders if an error occurs. Instead, the specific order that contains an error will be skipped and the import will continue. Information regarding the error will be logged

 

Demo:

  • Admin Panel
  • Username: oie-demo
  • Password: oie-demo-123

Release Notes

Back to top

1.2.7:

  • Compatible with CE: 2.0 2.1 2.2 2.3
  • Compatible with EE: 2.0 2.1 2.2 2.3
  • Stability: Stable Build
  • Description:

    Updated the invoice creation functionality to ensure that coupon codes and discounts are properly recorded as part of the invoice

1.2.1:

  • Compatible with CE: 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    Changed CSV-reading strategy to a stream, reading one line at a time to significantly improve memory usage

1.2.0:

  • Compatible with CE: 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    Added more detailed error reporting to the terminal when running imports from the command line
    Added logic so that when customer_firstname and customer_lastname are not present in the csv, the module will attempt to use billing data to create the customer if the customer does not exist
    Added an error limit field to force the stop of order imports if too many errors occur
    Fixed issue in which the error limit, when set via CLI, would be ignored and a limit of 1 would be used
    Fixed issue in which credit memos were not being created because due to the qty to refund calculation returning 0
    Added a Transaction processor class to create a transaction record in the database when appropriate
    Added invoice efficiency improvements in order to avoid additional queries to the database
    Added a check to make sure that the attempt to record a transaction doesn't throw a fatal error
    Fixed issue in which order export options being set from the command line were not being used
    Updated the export controller so that the config object gets passed into the exporter instead of allowing the export to use the global config object
    Fixed calculations in the class that creates invoices
    Moved the data sanitization functionality out of the Importer class and into the MageModule_Core module since this is commonly used functionality
    Added additional fields to exported order items
    Adjusted the CLI import script to ensure that any command line arguments passed in are respected by the various functions within the extension
    Added some additional required fields to the order item import
    Updated the OrderItem processor class to calculate accurately for each order item type. Also updated it to make sure it works properly with multiple currencies and fixed product taxes
    Fixed an issue in the order item processor class where bundle items children were not all getting their property quantities and names set
    Added field ignore lists to make sure that refunded, invoiced, shipped, backordered, canceled data doesn't improperly influence the entry of the order and its ability to be invoiced or shipped at a later date if necessary
    Added default values to avoid excpetion from being thrown when a billing/shipping lastname or telephone field is missing
    Removed numerical payment data from payment processor class because this information should only be imported/created at the time of invoice creation
    Cleaned up the credit memo class and made sure that it is creating accurate credit memos and also that it's skipping all refund info when 'Create Credit Memos' is set to No
    Added transaction ID to invoice so that online refunds could be made
    Typecast Creditmemo, Invoice, Shipment items quantities as float because the strings were returning true even though the actual number was 0

1.1.2:

  • Compatible with CE: 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    Replaced the CreditMemoDocument class with the appropriate class for creating credit memos. The replaced class did not exist in earlier versions of Magento and throws a fatal error when instantiated.

1.1.0:

  • Compatible with CE: 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    Added functionality that matches an imported order item to the product in the catalog if the SKU exists in the catalog. Otherwise, the product still imports like normal.

1.0.7:

  • Compatible with CE: 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    Added warning about the format of date fields to help users avoid errors

1.0.3:

  • Compatible with CE: 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    Initial release to Magento Marketplace

Support

Back to top
The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Q & A

Back to top

Reviews

Back to top