Listed below are the available field mappings for export webhooks:
Field | Description |
|---|---|
achAccountNumber | Customer’s banking account number (If paySource = CHECK) |
achAccountType | Checking account type (‘Checking’ or ’Savings’) (If paySource = CHECK) |
achRoutingNumber | Customer’s banking routing number (If paySource = CHECK) |
acquisitionDate | The date the partial record was created |
address1 | Line 1 of the customer’s billing address |
address2 | Line 2 of the customer’s billing address |
agentName | Name of the agent that completed the sale |
agentNote | The most recent agent note |
added to the customer’s profile. If the customer type is New Sale, Upsell, Partial, or Decline, it is the agent note at time of order instead. | |
ani | The phone number that the sales call originated from |
basePrice | The base price of the product |
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 |
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 |
cancelReason | Reason the order was cancelled |
cardExpiryDate | The customer’s card expiration date (MM/YY) |
cardLast4 | Last 4 digits of the card number |
cardMonth | The month the customer’s card expires |
cardNumber
If PCI compliance docs are provided - Will send first 6, censored middle 6, last 4
cardType | The brand of the card (Visa, MasterCard, American Express, Discover, etc) |
cardYear | The year the customer’s card expires |
chargebackAmount | The amount chargebacked |
chargebackDate | The date of the chargeback |
chargebackNote | Notes assigned to the chargeback |
chargebackReasonCode | Reason code assigned to the chargeback |
city | The customer’s billing city |
clientOrderId | The unique id assigned to an order |
clientProductId | The Client ID value assigned to a base product. First item on the order. |
clientPurchaseId | The unique id assigned to a subscription |
clientTxnId | The unique id assigned to a transaction For a refund or void this is the id of the original sale. If the actual id of the refund or void is needed then use refundClientTxnId. |
clubDisplayName | Display name of the membership club product |
clubName | The title of the Membership Club plugins |
clubPassword | Value specific to Membership Club plugins |
clubProductName | Base product name of the membership club product |
clubUsername | Value specific to Membership Club plugins |
contactOptIn | Boolean (‘1’ or ‘0’), represents if the customer has agreed to be contacted via |
SMS | |
country | The customer’s billing country |
couponCode | The coupon code the customer used on the order |
currencyCode | Currency the customer used to pay for 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 API |
custom5 | The custom5 value passed in on Import Lead API or Import Order API |
customerId | The unique customerId assigned to a customer |
customerType | The customer type that triggered the Export Profile. This is configured in the Export Routing Section. |
customFields | The data passed in via a campaign’s custom field. Will list all custom field values separated by commas |
dateCreated | The date the order was created |
dateRefunded | The date the refund was issued |
declineReason | Decline reason returned by the processor |
dnis | The phone number that was dialed |
dob | The customer’s date of birth |
doNotSellName | Boolean (‘1’ or ‘0’), represents if the customer is on your Do Not Sell list |
emailAddress | The customer’s email address |
firstName | The first name of the customer |
fulfillmentStatus | Will send the fulfillment status for the fulfillment record (Hold, Pending, Pending Shipment, Shipped, Delivered, Cancelled, RMA Pending, Returned) |
fullName | The full name of the customer |
gatewayTitle | The title of the gateway |
gender | The customer’s gender (Male or Female) |
hasUpsells | Boolean (‘1’ or ‘0’), represents if the customer purchased any upsells on the order |
ipAddress | The customer’s IP Address that was passed in for the order |
lastName | The last name of the customer |
marketingOptIn | |
memberId | Value specific to Membership Club plugins |
nextBillDate | The next bill date of the subscription |
offerSku | The SKU assigned to the product |
orderCustomFields | Custom fields assigned to an order |
orderId | The numeric id assigned to an order |
orderStatus | Status of the order (Partial, Complete, Pending, Declined, Refunded) |
orderTotal | The total price of the order, without upsells |
originalClientOrderId | The initial unique id assigned to a subscription |
originalOrderId | The initial numeric id assigned to a subscription |
paySource | The pay source the customer used ('CREDITCARD','CHECK','ACCTONFILE','COD','PREPAID','APPLEPAY','GOOGLEPAY') |
paySourceId | Pay Source ID used on the transaction |
phoneNumber | The customer’s phone number |
postalCode | The customer’s billing postal code |
product1_billingCycleNumber | The current billing cycle the product1 purchase is on |
product1_campaignProductId | The numerical value of the product1 offer listed inside the campaign |
product1_crmId | The base product ID of the first item in the order |
product1_description | Product Description set on the base product |
product1_externalId | The external id of the product (Shopify, BigCommerce, etc…) |
product1_id | The external or 3rd party Client ID of the base product of the first item in the order |
product1_name | The assigned name of the product1 base product |
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_productCategoryName | The name of the product category of the product1 offer |
product1_qty | The quantity of the product1 offer that the customer purchased |
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_sku | The SKU for the product1 base product |
product2_billingCycleNumber | The current billing cycle the product2 purchase is on |
product2_campaignProductId | The numerical value of the product2 offer listed inside the campaign |
product2_crmId | The base product ID of the second item in the order |
product2_description | Product Description set on the base product |
product2_externalId | The external id of the product (Shopify, BigCommerce, etc…) |
product2_id | The external or 3rd party Client ID of the base product of the second item in the order |
product2_name | The assigned name of the product2 base product |
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_productCategoryName | The name of the product category of the product2 offer |
product2_qty | The quantity of the product2 offer that the customer purchased |
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_sku | The SKU for the product2 base product |
product3_billingCycleNumber | The current billing cycle the product3 purchase is on |
product3_campaignProductId | The numerical value of the product3 offer listed inside the campaign |
product3_crmId | The base product ID of the third item in the order |
product3_description | Product Description set on the base product |
product3_externalId | The external id of the product (Shopify, BigCommerce, etc…) |
product3_id | The external or 3rd party Client ID of the base product of the third item in the order |
product3_name | The assigned name of the product3 base product |
product3_price | The quantity of the product3 offer that the customer purchased |
product3_productCategoryId | The numerical value of the product category of the product3 offer |
product3_productCategoryName | The name of the product category of the product3 offer |
product3_qty | The quantity of the product3 offer that the customer purchased |
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_sku | The SKU for the product3 base product |
product4_billingCycleNumber | The current billing cycle the product4 purchase is on |
product4_campaignProductId | The numerical value of the product4 offer listed inside the campaign |
product4_crmId | The base product ID of the forth item in the order |
product4_description | Product Description set on the base product |
product4_externalId | The external id of the product (Shopify, BigCommerce, etc…) |
product4_id | The external or 3rd party Client ID of the base product of the forth item in the order |
product4_name | The assigned name of the product4 base product |
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_productCategoryName | The name of the product category of the product4 offer |
product4_qty | The quantity of the product4 offer that the customer purchased |
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_sku | The SKU for the product4 base product |
product5_billingCycleNumber | The current billing cycle the product5 purchase is on |
product5_campaignProductId | The numerical value of the product5 offer listed inside the campaign |
product5_crmId | The base product ID of the fifth item in the order |
product5_description | Product Description set on the base product |
product5_externalId | The external id of the product (Shopify, BigCommerce, etc…) |
product5_id | The external or 3rd party Client ID of the base product of the fifth item in the order |
product5_name | The assigned name of the product5 base product |
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_productCategoryName | The name of the product category of the product5 offer |
product5_qty | The quantity of the product5 offer that the customer purchased |
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_sku | The SKU for the product5 base product |
productCost | Advertiser’s cost to manufacture/acquire the product (Expense Value) |
productId | The numerical value assigned to product on the CRM>Products page. First item on the order. |
productRotationIds | List of rotations on the base product |
pubId | The affiliate passed value that is marked as the “Is Publisher” value |
purchaseId | The numeric id assigned to a subscription |
refundReason | The stated reason the customer requested a refund |
recurringPrice | The recurring price the customer will pay for the product |
refundTxnId | The numeric id assigned to a refund or void |
refundClientTxnId | The unique id assigned to a refund or void |
responseType | Response ('SUCCESS','HARD_DECLINE','SOFT_DECLINE','PENDING','COD_PENDING') |
rmaNumber | The RMA number assigned to a specific fulfillment record |
salesTax | The sales tax the customer paid on the order |
salesUrl | The Url of your landing page. |
shipAddress1 | Line 1 of the shipping recipient’s address |
shipAddress2 | Line 2 of the shipping recipient’s address |
shipCity | The shipping recipient’s city |
shipCountry | The shipping recipient’s country |
shipFirstName | The first name of the shipping recipient |
shipFullName | The full name of the shipping recipient |
shipLastName | The last name of the shipping recipient |
shippingCost | Advertiser’s cost to ship the product (Expense value) |
shipPostalCode | The shipping recipient’s postal code |
shipProfileId | The value that represents a specific shipping profile within a campaign |
shipState | The shipping recipient’s state |
sourceId | The affiliate Id value that represents the affiliate profile |
sourceValue1 | The source value 1 passed in on Import Lead API or Import Order API |
sourceValue2 | The source value 2 passed in on Import Lead API or Import Order API |
sourceValue3 | The source value 3 passed in on Import Lead API or Import Order API |
sourceValue4 | The source value 4 passed in on Import Lead API or Import Order API |
sourceValue5 | The source value 5 passed in on Import Lead API or Import Order API |
state | The customer’s billing state |
subAffId | The affiliate passed value that is marked as the “Is Sub Affiliate” value |
timeCreated | The time the order was created |
totalDiscount | The total discount applied to the order |
totalPrice | Represents orderTotal + upsells + totalShipping |
totalShipping | The total price the customer paid for shipping on the order |
trackingNumber | The tracking number assigned to a specific fulfillment record |
transactionId | The numeric id assigned to the transaction. For a refund or void this is the id of the original sale. If the actual id of the refund or void is needed then use refundTxnId. |
voiceLogNumber | Value that is passed in from a Phone Switch plugin |