These are all the fields to map on the presets screen.
Order Parameters Tab
- Order Number – The customer’s order name as represented by a number. Must
be unique. - Order Date – The date and time when the order was imported. This value can
be set to dates in the past when importing from other systems. If no value
is provided, it will be auto-generated. - Payment Method – The list of all payment gateways used for the order.
- Notes / Comments – The text of an optional note that a shop owner can
attach to the order. - Total Tax – The sum of all the taxes applied to the order (must be
positive). - Order Subtotal – Price of the order before shipping and taxes
- Order Total – The sum of all the prices of all the items in the order,
taxes and discounts included (must be positive). - Financial status – Possible values are: “pending” (The finances are
pending), “authorized” (The finances have been authorized),
“partially_paid” (The finances have been partially paid), “paid” (The
finances have been paid. This is the default value.), “partially_refunded”
(The finances have been partially refunded), “refunded” (The finances have
been refunded), “voided” (The finances have been voided) - Total discounts – The total amount of the discounts to be applied to the
price of the order. - Currency – The three letter code (ISO 4217) for the currency used for the
payment. - Total weight – The sum of all the weights of the line items in the order,
in lbs. - Browser IP – The IP address of the browser used by the customer when
placing the order. - Password: Optional – if you want to set a customer password.
This is to import an existing customer password, some merchants requested this feature whom had customer passwords stored in another cart platform. This works for new customer accounts only. - Import Customers Only (Checkbox) – This is used for merchants whom are just importing customers with passwords, the second checkbox is to send them a new account welcome email.
Customer Parameters:
- Accepts Marketing – Indicates whether or not the customer would like to
receive email updates from the shop. Valid values are true and false. - Email – The customer’s email address.
- Note – Extra information about the customer
- Tags – Tags are additional short descriptors, commonly used for filtering
and searching, formatted as a string of comma-separated values. For
example, if an order has three tags: tag1, tag2, tag3.
Address Tab
Billing Address:
- Address 1 – The street address of the billing address.
- Address 2 – An optional additional field for the street address of the
billing address. - City – The city of the billing address.
- Company – The company of the person associated with the billing address.
- Country – The name of the country of the billing address.
- Country code – The two-letter code (ISO 3166-1 alpha-2 two-letter country
code) for the country of the billing address. - First name – The first name of the person associated with the payment
method. - Last name- The last name of the person associated with the payment method.
- Name – The full name of the person associated with the payment method.
- Phone – The phone number at the billing address.
- State/Province – The name of the state or province of the billing address.
- Zip Code – The zip or postal code of the billing address.
Shipping Address:
- Address 1 – The street address of the shipping address.
- Address 2 – An optional additional field for the street address of the
shipping address. - City – The city of the shipping address.
- Company – The company of the person associated with the shipping address.
- Country – The name of the country of the shipping address.Country code – The two-letter code (ISO 3166-1 alpha-2 two-letter country
code) for the country of the shipping address. - First name – The first name of the person associated with the payment
method. - Last name- The last name of the person associated with the payment method.
- Name – The full name of the person associated with the payment method.
- Phone – The phone number at the shipping address.
- State/Province – The name of the state or province of the shipping address.
- Zip Code – The zip or postal code of the shipping address.
Line Items Tab
- SKU – A unique identifier of the item in the fulfillment.
- Title – The title of the product.
- Price – The price of the item before discounts have been applied.
- Quantity – The number of products that were purchased.
- Lbs – The weight of the item in lbs.
- Fulfillment status – How far along an order is in terms line items
fulfilled. Valid values are: fulfilled, null or partial. - Taxable – States whether or not the product was taxable. Values are: true
or false. - Total discount – The total discount amount applied to this line item. This value is not subtracted in the line item price.
Details Tab
Shipping Lines:
- Shipping Charges – The price of this shipping method.
- Shipping Method – The title of the shipping method.
Discount Codes:
- Coupon / Discount Amount – The amount of the discount.
- Coupon Code – The discount code.
- Type – The type of discount. Can be one of: “percentage”, “shipping”,
“fixed_amount” (default).
Tip: To mark an order as “unfulfilled”, manually type in the value “null” in the order preset for fulfillment status.