/
Export Webhook Field Mapping Options

Export Webhook Field Mapping Options

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

Related content

Generic Webforce Webhook configuration
Generic Webforce Webhook configuration
More like this
Export subscriptions
Export subscriptions
More like this
Konnektive integration - Inbound Data
Konnektive integration - Inbound Data
More like this
Webforce generic webhook
Webforce generic webhook
More like this
Automated Reports
Automated Reports
More like this
Clickfunnels 2.0
Clickfunnels 2.0
More like this