Sales orders can be imported into Maropost Commerce through either a simple (predefined) or complex (custom) file format. For either method you will need to convert the order into a file type that can be imported by our system, either CSV (preferred) or XML.
In this Article
Simple Import
Simple imports use Maropost Commerce’s CSV template files to define the sales order data. Before importing your sales orders, download one of the template files below to populate your data:
We recommend only using the simple import if your data is not already in a format that Maropost Commerce can read. To import sales orders using the simple import:
-
In your Maropost Commerce control panel navigate to Sales orders > View orders.
-
Click the Import button at the top of the page.
-
Click the Choose File button and upload the CSV file with your sales order data.
-
Click the Upload file button.
-
You'll see a preview of your file headers and the first row of data. Confirm that they match, and click the Start import button.
Your sales orders will be imported into Maropost Commerce. Allow 10 minutes for them to appear.
Complex Import
Complex imports allow you to upload customised data files from other systems and platforms. Not only can you use it to populate information, it's also useful to make changes in bulk. To use complex import you will need to have your orders in a CSV file ready to upload:
-
In your Maropost Commerce control panel navigate to Settings & tools > Import data.
-
Select the Orders radio button.
-
Click the Perform complex import button and choose Start Data Import Wizard.
-
Click the Choose File button and upload your CSV file. Then click Continue to Next Step.
-
You'll now be on the field mapping step. On the left hand side are a list of the column names in Maropost Commerce (database field names). To the right of them are column headers from your file. To ensure data from your file goes into the correct field in Maropost Commerce, select the database field name that best matches your file field names.
Tip: Addresses, names and other values that are in multiple columns can be merged into one by selecting Join To in the dropdown menu next to the column name. You can also perform simple mathematical functions on number fields or insert separators (e.g. :,;).
Once complete, click the Continue to Next Step button.
-
In the Update Options section, you can change how certain fields are updated. For example, you can set a priority of how sales orders are matched between your file and the customer data with the search for customers when importing by drop down menu.
Set any update options you require, and click the Continue to Next Step button.
-
You're now ready to import your sales order file. If you want to save your settings select the checkbox and enter a template name. Click the Process File Now button to complete the import wizard.
The import process will be queued to run, and update the your sales orders.
Tip: Click on the export process ID to view a page with the status of your import. Click the Run Now button on this page to start the process immediately.
Related Articles