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