Amazon - Unleashed Field Mapping
Follow
George Sutton
Updated : Created :
Find Amazon in the Unleashed menu under eCommerce Hub
The following field mappings are used for the Amazon - Unleashed integration.
Sales Order
| Unleashed | Amazon |
|---|---|
| OrderNumber |
AmazonOrderId |
| OrderDate |
PurchaseDate |
| RequiredDate |
LatestShipDate |
| Currency |
OrderCurrency |
| DeliveryName |
ShippingAddress.Name |
| DeliveryStreetAddress |
ShippingAddress.AddressLine1 |
| DeliveryStreetAddress2 |
ShippingAddress.AddressLine2 + "" + ShippingAddress.AddressLine3 |
| DeliveryCity |
ShippingAddress.City |
| DeliveryRegion |
ShippingAddress.District |
| DeliveryCountry |
ShippingAdrress.Country |
| DeliveryPostCode |
ShippingAddress.PostalCode |
Sales Order Line
| Unleashed | Amazon |
|---|---|
| OrderQuantity |
QuantityOrdered |
| UnitPrice |
ItemPrice |
| DiscountedUnitPrice |
ItemPrice - PromotionDiscount |
| DiscountRate |
PromotionDiscount / ItemPrice |
| LineTax |
ItemTax |
| TaxRate |
ItemTax/(ItemPrice * QuantityOrdered) |
Customer
| Unleashed | Amazon |
|---|---|
| CustomerCode |
BuyerEmail.Split('@')[0] |
| CustomerName |
BuyerName |
|
Contact.FirstName |
BuyerName.Split(' ').First() |
| Contact.LastName |
BuyerName.Split(' ').Last() |
| Contact.EmailAddress |
BuyerEmail |
| Contact.PhoneNumber |
ShippingAddress.Phone |
| Address.AddressName |
ShippingAddress.Name |
| Address.StreetAddress |
ShippingAddress.AddressLine1 |
| Address.StreetAddress2 |
ShippingAddress.AddressLine2 + "" + ShippingAddress.AddressLine3 |
| Address.City |
ShippingAddress.City |
| Address.Region |
ShippingAddress.District |
| Address.Country |
ShippingAddress.Country |
| Address.PostalCode |
ShippingAddress.PostalCode |
Sales Order Charge
| Unleashed | Amazon | Note |
|---|---|---|
| Description | ShipServiceLevel |
Shipping: "Standard","Expedited","Scheduled","NextDay","SecondDay","Next","Second" GiftWrap: "Gift Wrap" |
| SubTotal |
Sum of (ShippingPrice - ShippingDiscount) Sum of GiftWrapPrice |
|
| Tax Rate |
Sum of ShippingTax / Sum of ShippingPrice Sum of GiftWrapTax/ Sum of GiftWrapPrice |
Product
| Unleashed | Amazon |
|---|---|
| ProductDescription |
item-name |
| ProductNotes |
item-note (under the Offer tab) |
|
ProductCode |
seller-sku (based on integration configuration) |
| Default Sell Price |
price |
| Quantity |
NA |
| Default Image |
image-url |
| Product Code |
product-id (ASIN) (based on integration configuration) |
| Package Dimensions | |
| Height |
Height (converted to measurement units of Unleashed account) |
| Depth |
Length (converted to measurement units of Unleashed account) |
| Width |
Width (converted to measurement units of Unleashed account) |
| Weight |
Weight (converted to measurement units of Unleashed account) |