Best Practices and Protocol for setting up Custom Fields
  1. Knowledge Base
  2. Revenue Conduit Account Management
  3. Best Practices and Protocol for setting up Custom Fields

Magento Field to Field Sync -Field Types Protocol and Best Practices

If you are using our field to field sync feature to map properties, it is critical that you follow the field type protocol in order for the information to map correctly.

Revenue Conduit has some additional fields outside of the default fields that we sync automatically, that are made available via Magento API. We have created a field to field sync feature that will allow you to map custom fields to your marketing platform. It is imperative that you use the appropriate field types when creating custom fields in your marketing platform if you want the data to sync up properly.
Below you will see the naming convention used in Revenue Conduit for the available fields. Next to that name, we have included the field type you will need to use to create the matching field type in your marketing platform.

Contact Fields


Confirmation Flag - Single-line text field
Customer Date of Birth - Date field
Customer Group ID - Single-line text field
Customer ID - Single-line text field
Customer Prefix - Single-line text field
Customer Suffix - Single-line text field
Store Created In - Single-line text field
Tax/VAT Text - Single-line text field
Website ID - Single-line text field

Order Fields


Applied  Rule IDs - Single-line text field
Base Currency Code - Number field
Base To Global Rate - Number field
Base To Order Rate - Number field
Billing Name - Single-line text field
Carrier Code - Single-line text field
Customer Group ID - Single-line text field
Customer notification - Single-line text field
Gift Message - Single-line text field
Gift Message ID - Single-line text field
Global Currency Code - Number field
Increment ID - Single-line text field
Is Email Sent -Single-line text field
Order Currency Code - Number field
Order Is Active - Single-line text field
Order State - Single-line text field
Parent IDs - Single-line text field
Payment Amount Ordered - Number field
Payment Base Amount Ordered - Number field
Payment Base Shipping Amount - Number field
Payment Creation Date - Date field
Payment ID - Single-line text field
Payment is Active - Single-line text field
Payment Method - Single-line text field
Payment Shipping Amount - Number field
Payment Updation Date - Date field
Product is Virtual - Single-line text field
Purchase order number - Number field
Quote ID - Single-line text field
Remote IP - Single-line text field
Shipment Comments - Single-line text field
Shipment ID - Single-line text field
Shipping Description - Single-line text field
Shipping Method - Single-line text field
Shipping Name - Single-line text field
Store Currency Code - Number field
Store ID - Single-line text field
Store Name - Single-line text field
Store To Base Rate - Number field
Store To Order Rate - Number field
Total Canceled - Number field
Total Invoiced - Number field
Total Offline Refunded - Number field
Total Online Refunded - Number field
Total Paid - Number field
Total Quantity Ordered - Number field
Total Refunded - Number field
Track ID - Single-line text field
Track Title - Single-line text field
Tracking Number - Number field
Weight - Number field

****For more information on our Field to Field Sync Feature, please see one of the following articles below:

Infusionsoft


Hubspot


ActiveCampaign