Importing Magento Stock on Hand
The following table shows the field mapping in Unleashed and Magento.
| Unleashed | Magento |
|---|---|
| Product Code | SKU |
| Product Description | Name |
| Default Sell Price | Price |
| Average Landed Cost | Cost (if enabled) |
| Unleashed | Magento |
|---|---|
| Invoice Number | Invoice Number |
| Customer Reference | Customer Reference |
| Customer Reference | PO # - customer ref |
| Delivery Address | Delivery Address |
| Order Date | Invoice Date |
| Required Date | Invoice Date |
| Line Tax Rate | Item Tax Rate |
| Line Discount | Item Discount / Coupon |
| Price | Item Price |
| Unleashed | Magento |
|---|---|
| Customer Code | ID |
| Customer Name | Company Name - if entered or first and last name. |
| Currency (these must be set up) | Currency |
| Customer Type | Customer Category |