Important: If you haven't already, please complete the previous steps in the TradeMe setup guide. You will also need to create an offline payment method called TradeMe Payment that it isn't visible to your webstore.
Tip: Neto partners can set this up for you. Visit the job request portal for a quote.
- In your Neto 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 Neto 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.