Order Import Export: live admin demo

1Open the admin demoOne click signs you in to a real Magento admin. No password, no sign-up.
2Follow the numbered dotsEach dot sits on the real admin screen and explains one feature. The same numbers are listed here.
3Try it yourselfFilter, sort and change settings. The demo account is limited to this extension.

Open the admin demo Get this extension

Demo account limited to this extension and the pages it needs.

45 Days Money Back · 1 Year Free Support

Feature guide 27

Export Orders · in admin

1 A profile for every jobSave as many export profiles as you need, each with its own orders, columns, file format and delivery.
2 Five ready-made profilesA daily 3PL feed, a warehouse pick list, an ERP sync in XML, a finance month-end file and guest checkouts for the CRM.
3 By cron or by handCron profiles make their file on their own at the time set in the configuration. Manual ones run when you press Generate.
4 Generate right from the gridOpen Select on any row and pick Generate: a new file is made at once, without opening the profile.

Warehouse Pick List by SKU · in admin

1 Make the file nowPress Generate and a fresh file is made with the matching orders. Find it under Run History.
2 Parent or child product rowsLeave out the parent or the size and colour variant, so a configurable item is not listed twice.
3 Only the orders you needFilter by order number, date range, customer group, status, shipment, shipping or billing country, payment method, SKU and more.
4 CSV or XML, sent where you wantChoose CSV or XML, the file name and folder, your own XML tags, and FTP, SFTP or email delivery with a ZIP copy.
5 Your columns, your headingsExport every field or only the ones you pick, each under the heading your warehouse or ERP expects, such as SKU or Ship City.
6 Every run, ready to downloadRun History lists each file with its date and size, as the CSV or XML file and as a ZIP.

Import Orders · in admin

1 Upload any order fileStart a new import profile, upload a CSV or XML file and map its columns. Each profile keeps its file and history.
2 Orders from anywhereLuma store orders, a marketplace XML feed, a Magento 1 export, a status update and a file with deliberate mistakes.
3 Who imported whatEvery profile records the admin user who uploaded the file and when.

Magento 1 migration file · in admin

See errors reportedGo back to Import Orders, open luma-orders-with-errors.csv and press Import Order: one order goes in, three are refused with their reasons.
1 Import with one clickPress Import Order: a progress bar runs, then you see how many orders were imported, updated or rejected.
2 Bring orders from Magento 1 or elsewhereThe file keeps its own column names, such as Order # and Bill Zip. Match each one to a Magento field and import.
3 Merge or replaceAn order already in Magento is updated, or deleted and created again from the file. New ones are added.
4 Errors explained, order by orderEach refused order is listed with its reason, such as a missing email or a total that does not add up.
5 Large files in the backgroundWith Automatic Execution on, cron imports the file a set number of orders at a time. This one takes 50 per run.
6 Customers created tooOptionally create a customer account from each order's billing details, so repeat buyers are recognised.
7 Fix wrong totalsRecalculate row totals, subtotal, tax and grand total from the prices and quantities, if the source file has them wrong.
8 Import progress at a glanceCron History shows each queued file with its total orders, how many are imported so far and its status.

Order Import Export Configuration · in admin

1 Scheduled exportsSwitch on cron and the profiles set to Automatic Execution make their files on their own.
2 Daily, weekly or monthlyChoose how often scheduled exports run, and the start time. This demo runs them daily.
3 Scheduled importsLet cron work through queued import files on its own schedule, so large files never time out in the browser.

Also in this extension

Imported orders are real ordersThey go into Magento's own sales tables. In the demo store, Orders and Returns finds LUMA-260042 with last name Delgado and email marcus.delgado@example.com.
Delivery is off in this shared demoFTP, SFTP and email settings can be saved, but no file leaves the server here. Sales > Orders is closed to this demo account.

Open the admin demo