Skip to content
Back to Site

Configure Advanced Data Mapping

Map supported source fields to compatible target fields and review the field registry directly in the configuration guide.

Advanced Data Mapping routes a supported source field to a compatible target field. Mapping changes where the value is written; it does not change the value during the mapping operation.

Each rule uses Source Field -> Target Field.

  1. Expand Advanced Data Mapping.
  2. Select an entity and click Add Mapping.
  3. Select the Source Field to route.
  4. Select the compatible Target Field that should receive the value.
  5. Add another rule inside the same Entity Mapping when another field requires routing.
  6. Repeat for other entities as needed.

When the active migration supports these Product fields, configure:

SettingValue
EntityProducts
Source FieldPrice
Target FieldSpecial Price

If the incoming Price value is 100, Advanced Data Mapping routes that value to Special Price as 100. The mapping itself does not recalculate or transform the value.

The available field list depends on the active migration and selected entity. Use the Field Label shown in the Add-on interface and confirm that the Field Type is compatible with the intended destination.

Manufacturer (11 fields)
Field LabelField Type
Nametext
Meta titletext
Meta Keywordtext
Meta Descriptiontext
Search Keywordtext
Descriptiontext
Short Descriptiontext
URLtext
Emailtext
Created Timedatetime
Updated Timedatetime
Category (10 fields)
Field LabelField Type
Nametext
Activeboolean
Descriptiontext
Short Descriptiontext
Meta Titletext
Meta Keywordtext
Meta Descriptiontext
Sort Ordernumber
Created Timedatetime
Updated Timedatetime
Product (34 fields)
Field LabelField Type
Nametext
SKUtext
Descriptiontext
Short Descriptiontext
Meta Titletext
Meta Keywordtext
Meta Descriptiontext
Pricenumber
Special Pricenumber
Special Price Start Datedate
Special Price End Datedate
Weightnumber
Weight unitnumber
Dimensions Unitnumber
Lengthnumber
Widthnumber
Heightnumber
Statusboolean
Manage Stockboolean
Quantitynumber
URL Keytext
Costnumber
MSRPtext
Barcodetext
UPCtext
EANtext
JANtext
ISBNtext
MPNtext
GTINtext
BPNtext
Google Category IDtext
Created Timedatetime
Updated Timedatetime
Customer (36 fields)
Field LabelField Type
Usernametext
Emailtext
First Nametext
Middle Nametext
Last Nametext
Gendertext
Date of Birthdate
Telephonetext
Companytext
Faxtext
Notetext
Tagstext
Statusboolean
Created Timedatetime
Updated Timedatetime
Address: First Nametext
Address: Middle Nametext
Address: Last Nametext
Address: Gendertext
Address: Address 1text
Address: Address 2text
Address: Citytext
Address: Country Codetext
Address: Countrytext
Address: State Codetext
Address: Statetext
Address: Postcodetext
Address: Telephonetext
Address: Companytext
Address: VATtext
Address: Faxtext
Address: Emailtext
Address: Prefixtext
Address: Suffixtext
Address: Created Timedatetime
Address: Updated Timedatetime
Order (101 fields)
Field LabelField Type
Statustext
Fulfillment Statustext
Tax Titletext
Tax Amountnumber
Tax Percentnumber
Discount Codetext
Discount Titletext
Discount Amountnumber
Discount Percentnumber
Discount Taxnumber
Shipping Titletext
Shipping Amountnumber
Shipping Percentnumber
Shipping Taxnumber
Shipping Methodtext
Subtotal Titletext
Subtotal Amountnumber
Subtotal Taxnumber
Total Titletext
Total Amountnumber
Payment Methodtext
Payment Titletext
Currencytext
Increment IDtext
PO Numbertext
Transaction IDtext
Tracking Numbertext
Tracking URLtext
Tracking Carriertext
Date Shippedtext
Created Timedatetime
Updated Timedatetime
Customer: Usernametext
Customer: Emailtext
Customer: First Nametext
Customer: Middle Nametext
Customer: Last Nametext
Customer: Group Idtext
Customer: Telephonetext
Customer: Faxtext
Customer Address: First Nametext
Customer Address: Middle Nametext
Customer Address: Last Nametext
Customer Address: Emailtext
Customer Address: Address 1text
Customer Address: Address 2text
Customer Address: Citytext
Customer Address: Country Codetext
Customer Address: Country Nametext
Customer Address: State Codetext
Customer Address: State Nametext
Customer Address: Postcodetext
Customer Address: Telephonetext
Customer Address: Companytext
Customer Address: Faxtext
Customer Address: Vattext
Billing Address: First Nametext
Billing Address: Middle Nametext
Billing Address: Last Nametext
Billing Address: Emailtext
Billing Address: Address 1text
Billing Address: Address 2text
Billing Address: Citytext
Billing Address: Country Codetext
Billing Address: Country Nametext
Billing Address: State Codetext
Billing Address: State Nametext
Billing Address: Postcodetext
Billing Address: Telephonetext
Billing Address: Companytext
Billing Address: Faxtext
Billing Address: Vattext
Shipping Address: First Nametext
Shipping Address: Middle Nametext
Shipping Address: Last Nametext
Shipping Address: Emailtext
Shipping Address: Address 1text
Shipping Address: Address 2text
Shipping Address: Citytext
Shipping Address: Country Codetext
Shipping Address: Country Nametext
Shipping Address: State Codetext
Shipping Address: State Nametext
Shipping Address: Postcodetext
Shipping Address: Telephonetext
Shipping Address: Companytext
Shipping Address: Faxtext
Shipping Address: Vattext
Item: Product Nametext
Item: Product Skutext
Item: Qtynumber
Item: Pricenumber
Item: Original Pricenumber
Item: Tax Amountnumber
Item: Tax Percentnumber
Item: Discount Amountnumber
Item: Discount Percentnumber
Item: Subtotalnumber
Item: Totalnumber
Item: Created Atdatetime
Item: Updated Atdatetime
Review (8 fields)
Field LabelField Type
Product Nametext
Customer Nametext
Customer Emailtext
Titletext
Contenttext
Statusboolean
Created Timedatetime
Updated Timedatetime
Page (9 fields)
Field LabelField Type
Statusboolean
Created Timedatetime
Updated Timedatetime
Nametext
Descriptiontext
Short Descriptiontext
Meta Titletext
Meta Keywordtext
Meta Descriptiontext
Post (9 fields)
Field LabelField Type
Statusboolean
Created Timedatetime
Updated Timedatetime
Nametext
Descriptiontext
Short Descriptiontext
Meta Titletext
Meta Keywordtext
Meta Descriptiontext
Coupon (17 fields)
Field LabelField Type
Coupon Codetext
Descriptiontext
Valuetext
Value Typetext
Start Datedate
End Datedate
Min Spendnumber
Max Spendnumber
Min Quantitynumber
Max Quantitynumber
Usage Countnumber
Usage Totalnumber
Usage Customernumber
Free Shippingboolean
Statusboolean
Created Timedatetime
Updated Timedatetime

Mapping rules inside an Entity Mapping run from top to bottom. Review competing destinations before execution instead of assuming an undocumented conflict-resolution behavior.

  • Click x to remove an individual mapping rule.
  • Use the remove control for the Entity Mapping to delete the entire mapping group.

If Advanced Database Mapping is included and the exact Source setup, Target Platform, and requested schema destination are eligible, configure it next. Otherwise continue to the next applicable screen shown in Add-ons.