Export Webhook Field Mapping Options

Owned by Diana Castillo Arroyo (Unlicensed)
Mar 06, 2023
6 min read

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