Purpose
Use the tables below to understand the product and sales-order fields, compare your proposed mapping, and identify the matching key needed for your connection.
Prerequisites
Know whether your connection imports products or uses products already held in Optiply. Confirm the selected marketplaces and whether Amazon's SellerSKU values correspond to your Optiply SKU or EAN values. For connection setup, use Connect Amazon Seller and review product matching.
Steps
- Choose the applicable mode: sales-orders-only uses existing Optiply products; full mode also imports products from Amazon Seller.
- In full mode, compare product identifiers with the product table. Keep the ASIN-based article code separate from the marketplace-specific remote identifier.
- Compare Amazon's
SellerSKUwith the selected Optiply matching key. A familiar field name is not enough: the values must match your products. - Compare sales-order headers and lines separately. Retain the marketplace selection, unmatched-product exclusion and existing-order limitations below.
Fields and columns
Products in full mode
| Optiply field | Amazon Seller value | Rule |
|---|---|---|
name | products_inventory.item_name | Product name. |
articleCode | products_inventory.asin1 | ASIN. |
remoteId | ASIN + _ + marketplace code | Identifies the product in its main marketplace, not ASIN alone. |
skuCode | Catalog identifier with type SKU | Separate from the EAN identifier. |
eanCode | Catalog identifier with type EAN | Separate from the SKU identifier. |
price | products_inventory.price | Product price. |
stockLevel | Selected warehouse_inventory.totalQuantity values | Combined across the selected stock marketplaces; a zero result can fall back to nonempty product-inventory quantity. |
status | Inventory status | In the warehouse-inventory mapping, Inactive becomes disabled; other statuses become enabled. Incomplete inventory records are excluded. |
unlimitedStock | false when a product is created | Not included in subsequent product-update requests. |
Catalog identifiers are selected for the main marketplace and joined by ASIN. The main product marketplace and the selected marketplaces contributing warehouse stock serve different purposes. Newly created disabled products are excluded; changed existing products can be updated.
Sales-order headers
| Optiply field | Amazon Seller value |
|---|---|
remoteId | orders.AmazonOrderId |
placed | orders.PurchaseDate |
totalValue | Numeric amount extracted from orders.OrderTotal, rounded to two decimals when sent; an absent parsed total becomes zero. |
Orders are filtered to the selected marketplaces using SalesChannel. Amazon's OrderStatus controls the cancellation handling below; it is not sent as an Optiply sales-order status field.
Sales-order lines
| Optiply field | Amazon Seller value | Rule |
|---|---|---|
productId | OrderItems.SellerSKU | Matches the selected Optiply product key, such as skuCode or eanCode, then uses that product's Optiply ID. It is not an ASIN join. |
quantity | OrderItems.QuantityOrdered | Whole-number quantity. |
subtotalValue | OrderItems.ItemPrice.Amount | Line value. |
Unmatched products are excluded. Lines for the same order and resolved product are combined by adding their quantities and line values. Orders without matching lines are excluded from the import.
Expected result
You can distinguish the product's ASIN article code from its marketplace-specific identity, identify the sales-line matching key, and compare the separate order and line values. This reference does not identify your account's current configuration or schedule.
Limitations
Existing sales orders and their lines are not generally updated. Cancellation has a separate path: an already imported order marked Canceled can be removed when it still has matching product lines and passes the marketplace selection. New canceled orders are excluded. A cancellation with no matching lines is not guaranteed to remove an existing order.
This is not Amazon Vendor's sales-order mapping. The two connectors use different product matching and repeated-line rules.
Errors and recovery
If a product or sales-order line is missing, check the selected mode, marketplace and matching values before changing settings or retrying a transfer. Use the connection guide above to review those choices. Do not change an existing order in Amazon Seller expecting a general order or line update in Optiply.