Listed below are the available field mappings for export webhooks:
‘clientOrderId' – The unique orderId assigned to a specific order
'fulfillmentStatus' – Will send the fulfillment status for the fulfillment record (Hold, Pending, Pending Shipment, Shipped, Delivered, Cancelled, RMA Pending, Returned)
'trackingNumber – The tracking number assigned to a specific fulfillment record
'dateCreated' – The date the order was created
'timeCreated – The time the order was created
'customerId' – The unique customerId assigned to a customer
‘customFields' – The data passed in via a campaign’s custom field. Will list all custom field values separated by commas
‘customerType’ - The customer type that triggered the Export Profile. This is configured in the Export Routing Section.
'fullName' – The full name of the customer
'firstName' – The first name of the customer
'lastName' – The last name of the customer
'address1' – Line 1 of the customer’s billing address
'address2' – Line 2 of the customer’s billing address
'city' – The customer’s billing city
'state' – The customer’s billing state
'country' – The customer’s billing country
'postalCode' – The customer’s billing postal code
'emailAddress' – The customer’s email address
'phoneNumber' – The customer’s phone number
'shipFullName' – The full name of the shipping recipient
'shipFirstName' – The first name of the shipping recipient
'shipLastName' – The last name of the shipping recipient
'shipAddress1' – Line 1 of the shipping recipient’s address
'shipAddress2' – Line 2 of the shipping recipient’s address
'shipCity' – The shipping recipient’s city
'shipState' – The shipping recipient’s state
'shipCountry' – The shipping recipient’s country
'shipPostalCode' – The shipping recipient’s postal code
'acquisitionDate' – The date the partial record was created
'orderStatus' – Status of the order (Partial, Complete, Pending, Declined, Refunded)
'orderTotal' – The total price of the order
'totalShipping' – The total price the customer paid for shipping on the order
'totalPrice' – Represents orderTotal + totalShipping
'salesTax' – The sales tax the customer paid on the order
'paySource' – The pay source the customer used ('CREDITCARD','CHECK','ACCTONFILE','COD','PREPAID','APPLEPAY','GOOGLEPAY')
'cardNumber' – If PCI compliance docs are provided - Will send first 6, censored middle 6, last 4
'cardExpiryDate' – The customer’s card expiration date (MM/YY)
'cardMonth' – The month the customer’s card expires
'cardYear' – The year the customer’s card expires
'cardType' – The brand of the card (Visa, MasterCard, American Express, Discover, etc)
'achAccountNumber' – Customer’s banking account number (If paySource = CHECK)
'achRoutingNumber' – Customer’s banking routing number (If paySource = CHECK)
'achAccountType' – Checking account type (‘Checking’ or ’Savings’) (If paySource = CHECK)
'campaignId' – The numerical value assigned to the campaign the order came through on
'campaignName' – The assigned name of the campaign the order came through on
'productId' – The numerical value assigned to product on the CRM>Products page. First item on the order.
'productCost' – Advertiser’s cost to manufacture/acquire the product (Expense Value)
'shippingCost' – Advertiser’s cost to ship the product (Expense value)
'clientProductId' – The Client ID value assigned to a base product. First item on the order.
'offerSku' – The SKU assigned to the product
'recurringPrice' – The recurring price the customer will pay for the product
'currencyCode' – Currency the customer used to pay for the order
'shipProfileId' – The value that represents a specific shipping profile within a campaign
'couponCode' – The coupon code the customer used on the order
'ipAddress' – The customer’s IP Address that was passed in for the order
'sourceId' – The affiliate Id value that represents the affiliate profile
'pubId' – The affiliate passed value that is marked as the “Is Publisher” value
'subAffId' – The affiliate passed value that is marked as the “Is Sub Affiliate” value
'voiceLogNumber' – Value that is passed in from a Phone Switch plugin
'agentNote' – The note an agent added to the customer’s profile
'agentName' – Name of the agent that completed the sale
'callTime' – If the order was place via Order Entry, this will be the time the agent spent with the customer before the Sale or Disposition
'doNotSellName' - Boolean (‘1’ or ‘0’), represents if the customer is on your Do Not Sell list
'contactOptIn' - Boolean (‘1’ or ‘0’), represents if the customer has agreed to be contacted via Email and SMS
'gender' – The customer’s gender (Male or Female)
'dob' – The customer’s date of birth
‘dnis' – The phone number that was dialed
'ani' – The phone number that the sales call originated from
'hasUpsells' – Boolean (‘1’ or ‘0’), represents if the customer purchased any upsells on the order
'custom1' – The custom1 value passed in on Import Lead API or Import Order API
'custom2' – The custom2 value passed in on Import Lead API or Import Order API
'custom3' – The custom3 value passed in on Import Lead API or Import Order API
'custom4' – The custom4 value passed in on Import Lead API or Import Order AP
'custom5' – The custom5 value passed in on Import Lead API or Import Order API
'clubUsername' – Value specific to Membership Club plugins
'clubPassword' – Value specific to Membership Club plugins
'product1_id' – The Client ID of the base product of the first item in the order
'product1_crmId' – The base product ID of the first item in the order
'product1_campaignProductId' – The numerical value of the product1 offer listed inside the campaign
'product1_name' – The assigned name of the product1 base product
'product1_sku' – The SKU for the product1 base product
'product1_qty' – The quantity of the product1 offer that the customer purchased
'product1_price' – The price the customer paid for the current billing cycle for product1
'product1_productCategoryId' – The numerical value of the product category of the product1 offer
'product1_billingCycleNumber' – The current billing cycle the product1 purchase is on
'product1_recurringstatus' – If the offer is a recurring order, will send the purchase status for the product1 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)
'product1_productCategoryName' – The name of the product category of the product1 offer
'product2_id' – The Client ID of the base product of the second item in the order
'product2_crmId' – The base product ID of the second item in the order
'product2_campaignProductId' – The numerical value of the product2 offer listed inside the campaign
'product2_name' – The assigned name of the product2 base product
'product2_sku' – The SKU for the product2 base product
'product2_qty' – The quantity of the product2 offer that the customer purchased
'product2_price' – The price the customer paid for the current billing cycle for product2
'product2_productCategoryId' – The numerical value of the product category of the product2 offer
'product2_billingCycleNumber' – The current billing cycle the product2 purchase is on
'product2_recurringstatus' – If the offer is a recurring order, will send the purchase status for the product2 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)
'product2_productCategoryName' – The name of the product category of the product2 offer
'product3_id' – The Client ID of the base product of the third item in the order
'product3_crmId' – The base product ID of the third item in the order
'product3_campaignProductId' – The numerical value of the product3 offer listed inside the campaign
'product3_name' – The assigned name of the product3 base product
'product3_sku' – The SKU for the product3 base product
'product3_qty' – The quantity of the product3 offer that the customer purchased
'product3_price' – The price the customer paid for the current billing cycle for product3
'product3_productCategoryId' – The numerical value of the product category of the product3 offer
'product3_billingCycleNumber' – The current billing cycle the product3 purchase is on
'product3_recurringstatus' – If the offer is a recurring order, will send the purchase status for the product3 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)
'product3_productCategoryName' - The name of the product category of the product3 offer
'product4_id' – The Client ID of the base product of the forth item in the order
‘product4_crmId' – The base product ID of the forth item in the order
'product4_campaignProductId' – The numerical value of the product4 offer listed inside the campaign
'product4_name' – The assigned name of the product4 base product
'product4_sku' – The SKU for the product4 base product
'product4_qty' – The quantity of the product4 offer that the customer purchased
'product4_price' – The price the customer paid for the current billing cycle for product4
'product4_productCategoryId' – The numerical value of the product category of the product4 offer
'product4_billingCycleNumber' – The current billing cycle the product4 purchase is on
'product4_recurringstatus' – If the offer is a recurring order, will send the purchase status for the product4 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)
'product4_productCategoryName' - The name of the product category of the product4 offer
'product5_id' – The Client ID of the base product of the fifth item in the order
'product5_crmId' – The base product ID of the fifth item in the order
'product5_campaignProductId' – The numerical value of the product5 offer listed inside the campaign
'product5_name' – The assigned name of the product5 base product
'product5_sku' – The SKU for the product5 base product
'product5_qty' – The quantity of the product5 offer that the customer purchased
'product5_price' – The price the customer paid for the current billing cycle for product5
'product5_productCategoryId' – The numerical value of the product category of the product5 offer
'product5_billingCycleNumber' – The current billing cycle the product5 purchase is on
'product5_recurringstatus' – If the offer is a recurring order, will send the purchase status for the product5 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)
'product5_productCategoryName' – The name of the product category of the product5 offer