Listed below are the available field mappings for export webhooks:
Field | Description | ||
|---|---|---|---|
clientOrderId | The unique id assigned to an order | ||
orderId | The numeric id assigned to an order | ||
clientPurchaseId | The unique id assigned to a subscription | ||
purchaseId | The numeric id assigned to a subscription | ||
fulfillmentStatus | Will send the fulfillment status for the fulfillment record (Hold, Pending, Pending Shipment, Shipped, Delivered, Cancelled, RMA Pending, Returned) | ||
rmaNumber | The RMA number assigned to a specific fulfillment record | ||
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 | ||
orderCustomFields | Custom fields assigned to an order | ||
customerType | The customer type that triggered the Export Profile. This is configured in the Export Routing Section. | ||
originalOrderId | The initial numeric id assigned to a subscription | ||
fullName | The full name of the customer | ||
firstName | The first name of the customer | ||
lastName | The last name of the customer | ||
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 | ||
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 | ||
totalDiscount | The total discount applied to the order | ||
basePrice | The base price of the product | ||
salesTax | The sales tax the customer paid on the order | ||
paySource | The pay source the customer used ('CREDITCARD','CHECK','ACCTONFILE','COD','PREPAID','APPLEPAY','GOOGLEPAY')agentName | Name of the agent that completed the sale | |
agentNote | The note an agent added to the customer’s profile | ||
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 | ||
cardExpiryDate | The customer’s card expiration date (MM/YY) | ||
cardMonth | The month the customer’s card expires | ||
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 | ||
cardSecurityCode | The customers card security code | ||
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)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. | ||
offerSkuclientPurchaseId | The SKU unique id assigned to the producta subscription | ||
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 listclientTxnId | The unique id assigned to a transaction | |
clubDisplayName | Value specific to Membership Club plugins | ||
clubName | The title of the Membership Club plugins | ||
clubPassword | Value specific to Membership Club plugins | ||
clubProductName | Value specific to Membership Club plugins | ||
clubUsername | Value specific to Membership Club plugins | ||
contactOptIn | Boolean (‘1’ or ‘0’), represents if the customer has agreed to be contacted via Email and SMS | ||
gendercountry | 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 | ||
gatewayTitle | The title of the gateway | ||
transactionId | The numeric id assigned to the transaction | ||
clientTxnId | The unique id assigned to a transaction | ||
hasUpsells | Boolean (‘1’ or ‘0’), represents if the customer purchased any upsells on 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 | ||
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 | ||
clubUsernamecustomerId | 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 | ||
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 | ||
memberId | Value specific to Membership Club plugins | ||
clubPassword | Value specific to Membership Club plugins | ||
memberId | Value specific to Membership Club plugins | ||
clubName | The title of the Membership Club plugins | ||
clubProductName | Value specific to Membership Club plugins | ||
clubDisplayName | Value specific to Membership Club plugins | ||
productRotationIds | List of rotations on the base product | ||
product1_id | The Client ID of the base product of the first item in the orderofferSku | 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 | ||
originalOrderId | The initial numeric id assigned to a subscription | ||
paySource | The pay source the customer used ('CREDITCARD','CHECK','ACCTONFILE','COD','PREPAID','APPLEPAY','GOOGLEPAY') | ||
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_campaignProductIdexternalId | The numerical value of the product1 offer listed inside the campaignexternal id of the product (Shopify, BigCommerce, etc…) | ||
product1_nameid | The assigned name Client ID of the product1 base product of the first item in the order | ||
product1_skuname | The SKU for assigned name of 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_productCategoryName | The name of the product category of the product1 offer | ||
product1_billingCycleNumberqty | The current billing cycle quantity of the product1 purchase is onoffer 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_productCategoryNamesku | The name of SKU for the product1 base product category of the product1 offer | ||
product1product2_externalIdbillingCycleNumber | The external id of the product (Shopify, BigCommerce, etc…)current billing cycle the product2 purchase is on | ||
product2_idcampaignProductId | The Client ID numerical value of the base product of the second item in the orderproduct2 offer listed inside the campaign | ||
product2_crmId | The base product ID of the second item in the order | ||
product2_campaignProductIdexternalId | The numerical value of the product2 offer listed inside the campaignexternal id of the product (Shopify, BigCommerce, etc…) | ||
product2_nameid | The assigned name Client ID of the product2 base product of the second item in the order | ||
product2_skuname | The SKU for assigned name of 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_productCategoryName | The name of the product category of the product2 offer | ||
product2_billingCycleNumberqty | The current billing cycle quantity of the product2 purchase is onoffer 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_productCategoryNamesku | The name of SKU for the product2 base product category of the product2 offer | ||
product2product3_externalIdbillingCycleNumber | The external id of the product (Shopify, BigCommerce, etc…)current billing cycle the product3 purchase is on | ||
product3_idcampaignProductId | The Client ID numerical value of the base product of the third item in the orderproduct3 offer listed inside the campaign | ||
product3_crmId | The base product ID of the third item in the order | ||
product3_campaignProductIdexternalId | The numerical value of the product3 offer listed inside the campaignexternal id of the product (Shopify, BigCommerce, etc…) | ||
product3_nameid | The assigned name Client ID of the product3 base product of the third item in the order | ||
product3_skuname | The SKU for assigned name of the product3 base product | ||
product3_qtyprice | The quantity of the product3 offer that the customer purchased | ||
product3_priceproductCategoryId | The quantity numerical value of the product category of the product3 offer that the customer purchased | ||
product3_productCategoryIdproductCategoryName | The numerical value name of the product category of the product3 offer | ||
product3_billingCycleNumberqty | The current billing cycle quantity of the product3 purchase is onoffer 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_productCategoryNamesku | The name of SKU for the product3 base product category of the product3 offer | ||
product3product4_externalIdbillingCycleNumber | The external id of the product (Shopify, BigCommerce, etc…)current billing cycle the product4 purchase is on | ||
product4_idcampaignProductId | The Client ID numerical value of the base product of the forth item in the orderproduct4 offer listed inside the campaign | ||
product4_crmId | The base product ID of the forth item in the order | ||
product4_campaignProductIdexternalId | The numerical value of the product4 offer listed inside the campaignexternal id of the product (Shopify, BigCommerce, etc…) | ||
product4_nameid | The assigned name Client ID of the product4 base product of the forth item in the order | ||
product4_skuname | The SKU for assigned name of 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_billingCycleNumberThe current billing cycle the product4 purchase is onproductCategoryName | 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_productCategoryNamesku | The name of SKU for the product4 base product category of the product4 offer | ||
product4product5_externalIdbillingCycleNumber | The external id of the product (Shopify, BigCommerce, etc…)current billing cycle the product5 purchase is on | ||
product5_idcampaignProductId | The Client ID numerical value of the base product of the fifth item in the orderproduct5 offer listed inside the campaign | ||
product5_crmId | The base product ID of the fifth item in the order | ||
product5_campaignProductIdexternalId | The numerical value of the product5 offer listed inside the campaignexternal id of the product (Shopify, BigCommerce, etc…) | ||
product5_nameid | The assigned name Client ID of the product5 base product of the fifth item in the order | ||
product5_skuname | The SKU for assigned name of 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_productCategoryName | The name of the product category of the product5 offer | ||
product5_billingCycleNumberqty | The current billing cycle quantity of the product5 purchase is onoffer 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_productCategoryNamesku | The name of SKU for the product5 base product category of the product5 offer | ||
product5_externalId | The external id of the product (Shopify, BigCommerce, etc…) | ||
chargebackAmount | The amount chargebacked | ||
chargebackDate | The date of the chargeback | ||
chargebackReasonCode | Reason code assigned to the chargeback | ||
chargebackNote | Notes assigned to the chargeback | ||
declineReason | Decline reason returned by the processor | ||
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 | ||
recurringPrice | The recurring price the customer will pay for the product | ||
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 + 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 | ||
voiceLogNumber | Value that is passed in from a Phone Switch plugin |