Amazon Field Mappings
Follow
George Sutton
Updated : Created :
Page contents
When an Amazon Store's integrated to Unleashed via the eCommerce Hub Sales Orders will import and Products will sync from Amazon to Unleashed. Based on your Amazon Store's Amazon Integration Setup, the details synced from Amazon to Unleashed as detailed in the below tables.
Sales Order
When a Sales Order reaches the appropriate Order Status in Amazon, based on your store's configuration settings, it will import to Unleashed. Any updates made to the Amazon Order after it's imported to Unleashed will not sync to update and the imported order cannot be manually edited in Unleashed.
Sales Order details
Due to Amazon's Data Protection Policy Unleashed will not receive any Personally Identifiable Information (PII) via the eCommerce Hub's Amazon integration for Sales Orders, which means only part of the order's delivery address will import from Amazon. For more details, see Amazon Integration PII Changes.
| Unleashed Order | Amazon Order |
|---|---|
| Order Number |
AmazonOrderId |
| Order Date |
PurchaseDate |
| Required Date |
LatestShipDate |
| Currency |
OrderCurrency |
| City |
ShippingAddress.City |
| State/Region |
ShippingAddress.District |
| Country |
ShippingAdrress.Country |
| Post Code |
ShippingAddress.PostalCode |
Sales Order Line
| Unleashed Order Line | Amazon Order Line |
|---|---|
| Order Quantity |
QuantityOrdered |
| Unit Price |
ItemPrice |
| Discounted Unit Price |
ItemPrice - PromotionDiscount |
| Discount Rate |
PromotionDiscount / ItemPrice |
| LineTax |
ItemTax, see Amazon: Configuration |
| TaxRate |
ItemTax/(ItemPrice * QuantityOrdered) |
Sales Order Charge
| Unleashed Order Charge | Amazon Order charge |
|---|---|
| Description | ShipServiceLevel:
|
| Sub Total |
|
| Tax Rate |
|
Product
If Product Synchronization is enabled within the Amazon Store's configuration settings, updates made to a synced product will automatically sync to update the product in Unleashed for the following details.
| Unleashed Product | Amazon Product |
|---|---|
| ProductDescription |
item-name |
| ProductNotes |
item-note, under the Offer tab |
|
ProductCode |
seller-sku or ASIN, based on Product Field Mapping selected in the configuration. |
| Selected Sell Price, based on the selected Sell Price Tier for the Shop |
price |
| Default Image |
image-url |
| Base Unit Height |
Height, converted to measurement units of Unleashed |
| Base Unit Depth |
Length, converted to measurement units of Unleashed |
| Base Unit Width |
Width, converted to measurement units of Unleashed |
| Base Unit Weight |
Weight, converted to measurement units of Unleashed |
Managing synced Amazon products
When a product is deleted in Amazon, the synced product in Unleashed remains unchanged. Similarly, if a product is deleted, obsoleted or is no longer sellable in Unleashed, the synced product in Amazon remains unchanged.
If a product is no longer in use on Amazon or Unleashed and has no open transactions or stock on hand, you must update the product on both platforms individually, making the product unavailable in Amazon and obsoleting it in Unleashed.
For more details, see Obsolete Products, Customers and Suppliers.
Customer
Due to Amazon's Data Protection Policy Unleashed will not receive any Personally Identifiable Information (PII) via the eCommerce Hub's Amazon integration for Customers or Sales Orders, which means unique Customers will no longer be created by the Amazon integration. For more details, see Amazon Integration PII Changes.