Order Fields & Definitions

These are the fields to map on the presets screen.

preset-1

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.

orderimp-presets-addresses

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.

/col_half]

orderimp-presets-line items

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

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).

NEW – Import Live Orders!

  • Import orders as unfulfilled, partial, and more!
  • Import Live Orders from Any Platform!

import-live-orders

User selectable options:

  • Email customers order receipt – Determines whether an order confirmation will be sent to the customer
  • Send Tracking Email – Determines whether a fulfillment confirmation will be sent to the customer
  • Reduce Inventory QOH for Line Items Imported – Determines which inventory updating behavior is used. Will reduce your shopify inventory during imports (assuming merchant is using shopify inventory tracking)
Tip: To mark an order as “unfulfilled”, manually type in the value “null” in the order preset for fulfillment status.

 

fullfillment-null

Leave A Comment?