-
In your Maropost Commerce control panel navigate to Settings & Tools > Import Data.
-
Click Perform Complex Import > Create New Custom Import Template.
-
Only modify the following settings to match those below:
| Field Name | Value |
|---|
| Import Type | Orders |
| Template Name | Trade Me Orders |
| Template Description | Trade Me Orders |
| Import File Type | Delimiter-separated value file (eg: CSV file) |
| File Format | Comma separated values (CSV) |
-
Click Save & Continue.
-
Under Field Mapping tab, you will need to map the fields in Trade Me with the fields in Maropost Commerce for a smooth import. Here’s an example of how the first two fields are mapped:
Now, using this same method, map the remainder of the fields by using the table below:
| Database Field Name | Your Field Name (Use Column Name) |
|---|
| Purchase Order ID | Shipment Number |
| Bill Full Name | Customer |
| Custom Field 1 | CustomerOrderReference |
| Username | TradeMeMemberName |
| Bill Phone | Phone Number |
| Bill Address Line 1 | AddressLine1 |
| Bill Address Line 2 | AddressLine2 Join to AddressLine3) |
| Bill City | TownCity |
| Bill Post Code | PostalCode |
| Bill Country | Country |
| Bill State | TownCity |
| Order Line SKU | Product Code |
| Order Line Qty | Qty Requested |
| Customer Instructions | Notes |
| Sales Channel | Trade Me |
| Email | Email |
| Ship Country | New Zealand |
| User Group | Put your User Group here (Default is A) |
| Date Paid | Payment Date |
| Amount Paid | Amount Paid |
| Order Line Unit Price | Product Price |
| Shipping Cost | ShippingCost |
| Order Status | (Use Static Value from dropdown menu) Pick |
| Shipping Method | Put your Courier Name here (eg. Courier International) |
| Approved | (Use Static Value from dropdown menu) yes |
| Payment Method | (Use Static Value from dropdown menu) TradeMe Payment |
-
Click Save Changes.
-
Click on the Import Method & Schedule tab. Modify the following settings:
| Field Name | Value |
|---|
| Import Method | FTP |
| File Location | ftp://ftp.trademe.co.nz/mybusinessname_*.csv (the filename will be given by Trade Me) |
| Login Username | (Provided by Trade Me) |
| Login Password | (Provided by Trade Me) |
| Passive FTP | Yes |
| Binary Mode | Binary |
| Move File To | /archive/ |
| Import Schedule | Select an existing schedule from the drop down list, or create your own. |
Tip: The schedule determines when the orders will be imported automatically, so you won't need to manually intervene.
-
Click Save Changes.