|
Field Name
| Export/Import Wizard Path |
Field Type
|
Field Description
|
Field Restrictions
|
Example Input
|
|
Order ID
| Orders Table > Order ID |
Text
|
The Order ID. If not defined, an Order ID will be automatically generated.
|
Max Length: 15
|
ABC1234567
|
|
Group Orderlines By
| Group Orderlines By |
Text
|
Used to group order lines together. If not defined, Order ID will be used.
|
Max Length: 255
|
Order ID
|
|
Send Email Notification
| Send Email Notification |
Boolean
|
If Yes, an order receipt email will be sent to the email address defined on the order.
|
Yes | No
|
Yes
|
|
Parent Order ID
| Orders Table > Parent Order ID |
Text
|
The orders related parent Order. Used to define the order this order was created from.
|
Max Length: 15
|
ABC1234564
|
|
Purchase Order ID
| Orders Table > Purchase Order ID |
Text
|
The customers purchase order number. Used for reference purposes only. Shows on order print docs and in UI.
|
Max Length: 50
|
1234567890
|
|
Order Line Status
| Order Lines Table > Order Line Status |
Text
|
Order order status the order will be imported as. Options: Picked, Not Yet Picked).
|
Order Status Name (Picked, Not Yet Picked)
Export only
|
Not Yet Picked
|
|
Order Type
| Order Type |
Text
|
By default an order is a "Sales" order. For orders that are being dropshipped on a customer's behalf and that do not require invoices use the type "Dropshipping". Automatically the system will not allow warehouse users to print invoices for such orders.
|
Sales|Dropshipping
|
Sales
|
|
Approved
| Orders Table > Approved |
Boolean
|
Only approved orders can be shipped. Set this to "Yes" to approve an order on import.
|
Yes | No
|
Yes
|
|
User Group
| Orders Table > User Group |
Integer
|
The user group / price level used for pricing calculations of the order. Use the group ID. Eg: 1,2,3 etc
|
User Group Name
|
2
|
|
Order Payment Plan
| Orders Table > Order Payment Plan |
Text
|
The payment plan assigned to the order (for recurring payments module only). Must match a plan name that has already been setup in the system.
|
Order Payment Plan Name
|
Weekly
|
|
Document Template
| Orders Table > Document Template |
Text
|
The name of the document template set assigned to the order. Must match the name of a document template set that has already been setup in the system.
|
Document Template
|
test
|
|
Date Placed
| Orders Table > Date Placed |
Date & Time
|
The date and time the order was placed.
|
YYYY-MM-DD HH:MM:SS
|
2017-09-20 10:22
|
|
Date Required
| Orders Table > Date Required |
Date & Time
|
The date and time the order is required (for shipping purposes).
|
YYYY-MM-DD HH:MM:SS
|
2017-09-20 10:22
|
|
Payment Due Date
| Orders Table > Payment Due Date |
Date & Time
|
The date and time the order is due to be paid.
|
YYYY-MM-DD HH:MM:SS
|
2017-09-20 10:22
|
|
Date Completed
| Orders Table > Date Completed |
Date & Time
|
The date and time the order was completed (dispatched or cancelled)
|
YYYY-MM-DD HH:MM:SS
|
2017-09-20 10:22
|
|
Exported To 3rd Party Software
| Exported To 3rd Party Software |
Boolean
|
Defines whether of not the order has already been exported to an accounting system.
|
Yes | No
|
Yes
|
|
Date Invoiced
| Orders Table > Date Invoiced |
Date
|
The date the order was invoiced.
|
YYYY-MM-DD
|
2017-09-20 10:22
|
|
Username
| Orders Table > Username |
Text
|
The username of the orders related customer in Maropost Commerce. Username is the unique identifier of the customer in Maropost Commerce.
|
Max Length: 25
|
sample
|
|
Email
| Orders Table > Email |
Text
|
The email address of the order (order receipts etc sent here).
|
Max Length: 50
|
johnsmith@maropost.com
|
|
Ship Full Name
| Ship Full Name |
Text
|
The shipping first and last name separated with spaces.
|
Max Length: 100
|
John Smith
|
|
Ship First Name
| Orders Table > Ship First Name |
Text
|
Shipping first name.
|
Max Length: 50
|
John
|
|
Ship Last Name
| Orders Table > Ship Last Name |
Text
|
Shipping last name.
|
Max Length: 50
|
Smith
|
|
Ship Company
| Orders Table > Ship Company |
Text
|
Shipping company name.
|
Max Length: 50
|
Acme Co Pty Ltd
|
|
Ship Address Line 1
| Orders Table > Ship Address Line 1 |
Text
|
Shipping address Line 1
|
Max Length: 50
|
Unit 10
|
|
Ship Address Line 2
| Orders Table > Ship Address Line 2 |
Text
|
Shipping address line 2
|
Max Length: 50
|
12 Lilly Street
|
|
Ship City
| Orders Table > Ship City |
Text
|
Shipping city or suburb
|
Max Length: 50
|
Capalaba
|
|
Ship State
| Orders Table > Ship State |
Text
|
Shipping state
|
Max Length: 50
|
QLD
|
|
Ship Post Code
| Orders Table > Ship Post Code |
Text
|
Shipping post code
|
Max Length: 15
|
4157
|
|
Ship Country
| Orders Table > Ship Country |
Text
|
Shipping country code (eg: AU)
|
Country
|
AU
|
|
Ship Phone
| Orders Table > Ship Phone |
Text
|
Shipping phone number
|
Max Length: 30
|
07 3214 5236
|
|
Ship Fax
| Orders Table > Ship Fax |
Text
|
Shipping fax number
|
Max Length: 30
|
07 3214 5237
|
|
Bill Full Name
| Bill Full Name |
Text
|
The Billing first and last name separated with spaces.
|
Max Length: 100
|
John Smith
|
|
Bill First Name
| Orders Table > Bill First Name |
Text
|
Billing first name.
|
Max Length: 50
|
John
|
|
Bill Last Name
| Orders Table > Bill Last Name |
Text
|
Billing last name.
|
Max Length: 50
|
Smith
|
|
Bill Company
| Orders Table > Bill Company |
Text
|
Billing company name.
|
Max Length: 50
|
Acme Co Pty Ltd
|
|
Bill Address Line 1
| Orders Table > Bill Address Line 1 |
Text
|
Billing address Line 1
|
Max Length: 50
|
Unit 10
|
|
Bill Address Line 2
| Orders Table > Bill Address Line 2 |
Text
|
Billing address line 2
|
Max Length: 50
|
12 Lilly Street
|
|
Bill City
| Orders Table > Bill City |
Text
|
Billing city or suburb
|
Max Length: 50
|
Capalaba
|
|
Bill State
| Orders Table > Bill State |
Text
|
Billing state
|
Max Length: 50
|
QLD
|
|
Bill Post Code
| Orders Table > Bill Post Code |
Text
|
Billing post code
|
Max Length: 15
|
4157
|
|
Bill Country
| Orders Table > Bill Country |
Text
|
Billing country code (eg: AU)
|
Bill Country
|
AU
|
|
Bill Phone
| Orders Table > Bill Phone |
Text
|
Billing phone number
|
Max Length: 30
|
07 3214 5236
|
|
Bill Fax
| Orders Table > Bill Fax |
Text
|
Billing fax number
|
Max Length: 30
|
07 3214 5237
|
|
Payment Method
| Orders Table > Payment Method |
Text
|
The name of the payment method used for the order. Must match the name of a payment method already setup in the system.
|
Name of payment method.
|
Visa
|
|
BPAY CRN
| Orders Table > BPAY CRN |
Text
|
The Bpay CRN of the order. Leave blank for the system to auto generate a CRN.
|
Max Length: 20
|
123456789
|
|
Payment Terms
| Orders Table > Payment Terms |
Text
|
The orders payment terms. Must match the name of payment terms already setup in the system.
|
Payment Terms
|
Net 30
|
|
Sales Channel
| Orders Table > Sales Channel |
Text
|
The sales channel that the order was placed through. Eg: Website or eBay
|
Max Length: 15
|
Website
|
|
Currency Code
| Orders Table > Currency Code |
Text
|
The currency code used for order lines. Leave blank to use system default currency. 3 digit currency code.
|
Currency Code
|
AUD
|
|
Shipping Method
| Orders Table > Shipping Method |
Text
|
The orders shipping option. Must match the name of a shipping option already setup in the system.
|
Shipping Option
|
Standard
|
|
Signature Required
| Orders Table > Signature Required |
Boolean
|
If yes, signature required will print on shipping address labels.
|
Yes | No
|
Yes
|
|
Shipping Cost
| Orders Table > Shipping Cost |
Decimal
|
The total shipping cost to apply to the order.
|
Price
|
20
|
|
Shipping Discount Amount
| Orders Table > Shipping Discount Amount |
Decimal
|
The total shipping discount to apply to the order.
|
Price
|
10
|
|
Tax Free Shipping
| Tax Free Shipping |
Boolean
|
If yes tax will not be applied to shipping.
|
Yes | No
|
Yes
|
|
Tax Inclusive
| Orders Table > Tax Inclusive |
Boolean
|
If yes all pricing on the order will be deemed to be tax inclusive (tax will not be added on top)
|
Yes | No
|
Yes
|
|
Surcharge Percent
| Surcharge Percent |
Decimal
|
The percentage surcharge to apply to the order. Increases the order value by this percentage.
|
Percentage (%)
|
2
|
|
Payment Notes
| Payment Notes |
Text
|
Internal notes related to the payment. For reference purposes only.
| |
Sample payment notes.
|
|
Fraud Score
| Orders Table > Fraud Score |
Decimal
|
The fraud score associated with the order. For reference purposes only.
| |
5.2
|
|
Coupon Code
| Orders Table > Coupon Code |
Comma separated list
|
A list of coupon codes that apply to the order. The system will apply the discount rules of the codes on import.
|
Coupon codes separated by commas
|
ABC123
|
|
Customer Instructions
| Orders Table > Customer Instructions |
Text
|
The customers order instructions. These will print on shipping labels and other print docs.
| |
Leave at front door
|
|
Internal Notes
| Orders Table > Internal Notes |
Text
|
Internal notes for staff usage. Not visible to customers.
| |
Sample internal notes
|
|
Sales Person
| Orders Table > Sales Person |
Text
|
The sales person associated with the order. Must match the username of an existing staff member account.
|
Sales Person
|
admin
|
|
Password For New User
| Password For New User |
Text
|
If you select to have the system auto generate a user account for the related customer of the order you are importing, you can use this field to define the customers account password.
|
*RANDOM* = Create a random password ; Max Length: 25
|
kvwyc732vf62!
|
|
Amount Paid
| Orders Table > Amount Paid |
Decimal
|
The amount paid to the order.
|
Price
|
5
|
|
Date Paid
| Date Paid |
Date
|
The date the payment was made.
| |
2014-9-20
|
|
Card Holder
| Payment Details > Card Holder |
Text
|
The orders credit card holders name.
|
Max Length: 50
|
John Smith
|
|
Card Number
| Card Number |
Text
|
The orders credit card number. For PCI compliance reasons do not import full credit card numbers to this field.
|
Max Length: 30
|
4950******5
|
|
Card Expiry Month
| Card Expiry Month |
Integer
|
The orders credit card expiry month.
|
Month
|
11
|
|
Card Expiry Year
| Card Expiry Year |
Integer
|
The orders credit card expiry year.
|
Year
|
2014
|
|
Card Authorisation Code
| Card Authorisation Code |
Text
|
The orders credit card authorisation number returend by the processing bank or gateway at time of payment.
|
Max Length: 100
|
AUTH123
|
|
Authorisation Message
| Authorisation Message |
Text
|
The transaction number / ID of the payment.
|
Max Length: 50
|
TRANS1
|
|
Cheque Number
| Cheque Number |
Text
|
The cheque / check number used to make payment.
|
Max Length: 20
|
1235467
|
|
Cheque Account Name
| Cheque Account Name |
Text
|
The name of the customers cheque / check account.
|
Max Length: 50
|
Test Account Name
|
|
Cheque Account BSB
| Cheque Account BSB |
Text
|
The bsb of the customers cheque / check account.
|
Max Length: 10
|
123456
|
|
Cheque Account Number
| Cheque Account Number |
Text
|
The number of the customers cheque / check account.
|
Max Length: 20
|
123456789
|
|
Order Line SKU
| Order Lines Table > Order Line SKU |
Text
|
The SKU of the order line. Used to identify the product. This must match the SKU of a product already setup in the system.
|
Max Length: 25
|
SAMPLE_P1
|
|
Order Line Qty
| Order Lines Table > Order Line Qty |
Integer
|
The qty of a SKU on order.
|
Order Line Qty
|
2
|
|
Order Line Description
| Order Lines Table > Order Line Description |
Text
|
The description of SKU on order. If not defined, the products name will be used.
|
Max Length: 255 - Name of product on order.
|
Sample Product Name
|
|
Order Line Serial Number
| Order Lines Table > Order Line Serial Number |
Text
|
The serial number assigned to the order line. For warranty tracking purposes.
|
Max Length: 50
|
1234567889
|
|
Order Line Dropship Supplier
| Order Lines Table > Order Line Dropship Supplier |
Text
|
The dropship suppplier assigned to fulfill the order line. This must match the name of a supplier already setup in your system.
| | |
|
Order Line Warehouse Name
| Order Line Warehouse Name |
Text
|
The warehouse assigned to fulfill the order line. This must match the name of a warehouse already setup in the system.
| |
Secondary Warehouse
|
|
Order Line Options
| Order Lines Table > Order Line Options |
List
|
A list of options selected for the order line. These options must already be setup as options on the SKU in the system. Follow the format provided in the example.
|
[option_name]=[option_value] (for multiple separate with a semi colon (;). You can define the separator under admin > system setup advanced config)
|
Gift Wrapping=Gold;Warranty=12 Months
|
|
Order Line Kitting
| Order Line Kitting |
List
|
A list of SKUs and related quantities that make up a kit. For kitted / built products. Follow the format provided in the example.
|
[component_sku]=[component_qty];[component_sku]=[component_qty]; ...
| |
|
Order Line Unit Price
| Order Lines Table > Order Line Unit Price |
Decimal
|
The unit price of each SKU on the order line.
|
Price
|
19.95
|
|
Order Line Unit Cost
| Order Lines Table > Order Line Unit Cost |
Decimal
|
The unit cost of each SKU on the order line. Used for profit reporting.
|
Price
|
9.95
|
|
Order Line Shipping Weight
| Order Lines Table > Order Line Unit Shipping Weight |
Decimal
|
The weight in KG of each SKU on the order line.
|
Weight (kg)
|
0.25
|
|
Order Line Shipping Cubic
| Order Lines Table > Order Line Shipping Cubic |
Decimal
|
The cubic volume (CM) of each SKU on the order line.
|
Volume
|
0.001
|
|
Order Line Discount Percent
| Order Line Discount Percent |
Decimal
|
The discount percentage of an order line.
|
Percentage (%)
|
5
|
|
Order Line Discount Amount
| Order Lines Table > Order Line Discount Amount |
Decimal
|
The discount amount to apply to the order line.
|
Price
|
1
|
|
Shipping Discount Percent
| Shipping Discount Percent |
Decimal
|
The discount percentage to apply to shipping costs.
|
Percentage (%)
|
2
|
|
Order Line Tax Free
| Order Lines Table > Order Line Tax Free |
Boolean
|
If yes, the order line will be tax free. For example if the order line is a food item where tax does not apply.
|
Yes | No
|
No
|
|
Order Line Delivery Date
| Order Lines Table > Order Line Delivery Date |
Date & Time
|
The customers chosen delivery date for the order line.
|
YYYY-MM-DD HH:MM:SS
|
2017-09-20 10:22
|
|
Order Line Job
| Order Lines Table > Order Line Job |
Text
|
The job assigned to the order line. Used or reference or reporting purposes only. The job name must match a job name already setup in the system.
|
Name of job
|
Sample Job
|
|
Order Line Bin Location
| Order Lines Table > Order Line Bin Location |
Text
|
The order lines assigned pick bin. Used for mobile pick'n pack.
|
Max Length: 10
|
A-01
|
|
Order Line Notes
| Order Lines Table > Order Line Notes |
Text
|
Notes related to the order line. You can choose to show these to customers or not.
|
Max Length: 255
|
Sample order line notes.
|
|
Skip Record
| Skip Record |
Boolean
|
If yes, the order line will be skipped during import.
|
Yes | No
|
No
|