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.

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 order status database designation. To view this, go to order status and look at the URL in your browser.)

• referer
  The referrer information that leads to the creation of the order. In other words, where the shopper arrived at your store from.

• salesperson
  The salesperson 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 commission 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 approved 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 Shift4Shop 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 recurrent 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 Screening Rules, this column will record the FraudWatch Status Rule recorded for the order

  • 0 = No rules triggered/applied

  • 1 = Order moved to Approved Status

  • 2 = Order Rejected

  • 3 = Order placed into Review Status