Knowledgebase: Orders
What are the selectable Fields for the Custom Order Export?

If using Custom Export Sets for your Order Exports, you will have the following list of fields to choose from.

Note:
Several of these are dependent on different add-ons and/or specific features of the cart, or are otherwise no longer used on the system. Therefore you may have some of these fields that will not yield results.

Here's a brief description of each selectable field.

  • Distributor
    The distributor for the ordered product
  • Manufacturer
    The manufacturer of the ordered product
  • constant
    This is a wildcard * column that can be used for anything you choose
  • shipment_number
    The numerical ID of the shipping method that was selected by the customer
  • orderid
    The numerical Database ID of the order
  • ocustomerid
    The numerical Database ID of the customer on the order
  • odate
    The date on which the order was placed
  • orderamount
    The total amount recorded on the order
  • ofirstname
    The First name of the customer on the order
  • olastname
    The Last name of the customer on the order
  • oemail
    The Email Address of the customer on the order
  • oaddress
    The Billing Address used on the order
  • oaddress2
    The Billing Address, Line 2 used on the order (if any)
  • ocity
    The Billing City used on the order
  • ozip
    The Billing Zip/Postal Code used on the order
  • ostate
    The Billing State used on the order
  • ocountry
    The Billing Country used for the order
  • ophone
    The Billing Phone Number used on the order
  • ofax
    The Billing Fax number used on the order (if any)
  • ocompany
    The Billing company name used on the order (if any)
  • ocardtype
    The Card Type that was selected on the order
  • ocardno
    The Credit Card number information (Note: This is encrypted information as per PCI rules)
  • ocardname
    The name of the Card Holder
  • ocardexpiresmonth
    The expiration month of the card (if provided by the gateway)
  • ocardexpiresyear
    The expiration year of the card (if provided by the gateway)
  • ocardissuenum
    No Longer used
  • ocardstartmonth
    No Longer used
  • ocardstartyear
    No Longer used
  • ocardaddress
    No Longer used
  • ocardverification
    No Longer used
  • oprocessed
    No Longer used
  • ocomment
    Any comments recorded on the order by the customer
  • otax
    The amount of Tax charged on the order
  • otax2
    The amount of Tax 2 charged on the order (only if used)
  • otax3
    The amount of Tax 3 charged on the order (only if used)
  • ointernalcomment
    Any internal comments on the order that were entered either by your staff or the credit card gateway
  • oexternalcomment
    No Longer used
  • oshippeddate
    The date that the order was shipped
  • oshipmethod
    The shipping method that was selected by the customer
  • oshipcost
    The shipping cost calculated for the order
  • oshipfirstname
    The First name of the customer on the order for shipping
  • oshiplastname
    The Last name of the customer on the order for Shipping
  • oshipcompany
    The company name used on the order's shipping information (if any)
  • oshipemail
    The Email Address of the customer on the order
  • oshipaddress
    The Shipping Address used on the order
  • oshipaddress2
    The Shipping Address, Line 2 used on the order (if any)
  • oshipcity
    The Shipping City used on the order
  • oshipzip
    The Shipping Zip/Postal Code used on the order
  • oshipstate
    The Shipping State used on the order
  • oshipcountry
    The Shipping Country used for the order
  • oshipphone
    The Shipping Phone Number used on the order
  • opaymethod
    The payment method recorded for the order (note: this will be the numerical database number for the payment module used on the order.)
  • opaymethodinfo
    No Longer used
  • status
    No Longer used
  • other2
    No Longer used
  • otime
    The time at which the order was placed
  • oauthorization
    If supported by the gateway, this column will display the authorization code that was recorded on the order
  • oerrors
    No Longer used
  • odiscount
    Any promotional discounts that applied to the order
  • ostatus
    No Longer used
  • ohandling
    Any handling costs recorded on the order (if any)
  • coupon
    Any coupon codes or gift certificates used on the order
  • coupondiscount
    Whatever discount was applied by gift certificates or coupons.
  • coupondiscountdual
    No Longer used
  • giftcertificate
    No Longer used
  • giftamountused
    The amount of Gift Certificate total that was used on the order
  • giftamountuseddual
    No Longer used
  • trackingcode
    The shipment tracking number recorded on the order at the time of shipping
  • invoicenum_prefix
    The prefix for the order
  • invoicenum
    The actual invoice number for the order
  • order_status
    The current status in which the order resides. (Note: this is a numerical value for the irder status' database designation. To view this, go to an order status and look at the URL in your browser.)
  • referer
    The referrer information that lead to the creation of the order. In other words, where the shopper arrived at your store from.
  • salesperson
    The sales person recorded on the order (if any)
  • ip
    The IP address for the customer who placed the order
  • date_started
    The date in which the order was started
  • userid
    The user ID of the person who last edited the order
  • last_update
    The last update of the order
  • last_auto_email
    The most recent autoresponder email recorded for the order
  • oweight
    The total weight of the order
  • oboxes
    The number of boxes which were calculated for the order
  • orderkey
    Internal data for the store's Order Key
  • ostep
    The last step recorded for the order
  • shipmethodid
    No Longer used
  • insured
    If the Shopper selected Shipping Insurance, this column will display a 1. If 0, then shipping insurance was not selected
  • alt_orderid
    No Longer used
  • affiliate_id
    If the order was placed through an affiliate, this column will record the affiliate ID
  • affiliate_commission
    The amount of commision due to the affiliate if the order was recorded for their ID
  • affiliate_approved
    If the order has been approved (by you) for the affiliate
  • affiliate_approvedreason
    Any approve comments left on the order by you
  • shipping_id
    The shipping method applied to the order
  • buysafe
    If using BuySafe, this column will show if the order had BuySafe selected. A 1 will denote yes, and 0 will denote no
  • checktype
    No Longer used
  • checkacctype
    No Longer used
  • checkrouting
    No Longer used
  • checkaccount
    No Longer used
  • oshipaddresstype
    The type of address (residential or commercial) that was selected at checkout (if allowed in your settings)
  • isrecurrent
    If the order is a recurring order (Using 3dcart AutoShip) this field will show a 1. Of 0 then the order is not a recurring order
  • recurrent_frequency
    The selected frequency of the order's recurrence.
  • parent_orderid
    If using AutoShip, this will show the recurrant order's parent order ID
  • last_order
    If using AutoShip, this will show the most recent autoship order for the customer
  • next_order
    If using AutoShip, this will show the next scheduled autoship order for the customer
  • customer_pmntprofileid
    No Longer used
  • fraud_rules_result
    If using FraudWatch, this column will record the FraidWatch score recorded for the order

Help Desk Software by Kayako fusion