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

  1. Choose the applicable mode: sales-orders-only uses existing Optiply products; full mode also imports products from Amazon Seller.
  2. In full mode, compare product identifiers with the product table. Keep the ASIN-based article code separate from the marketplace-specific remote identifier.
  3. Compare Amazon's SellerSKU with the selected Optiply matching key. A familiar field name is not enough: the values must match your products.
  4. 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 fieldAmazon Seller valueRule
nameproducts_inventory.item_nameProduct name.
articleCodeproducts_inventory.asin1ASIN.
remoteIdASIN + _ + marketplace codeIdentifies the product in its main marketplace, not ASIN alone.
skuCodeCatalog identifier with type SKUSeparate from the EAN identifier.
eanCodeCatalog identifier with type EANSeparate from the SKU identifier.
priceproducts_inventory.priceProduct price.
stockLevelSelected warehouse_inventory.totalQuantity valuesCombined across the selected stock marketplaces; a zero result can fall back to nonempty product-inventory quantity.
statusInventory statusIn the warehouse-inventory mapping, Inactive becomes disabled; other statuses become enabled. Incomplete inventory records are excluded.
unlimitedStockfalse when a product is createdNot 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 fieldAmazon Seller value
remoteIdorders.AmazonOrderId
placedorders.PurchaseDate
totalValueNumeric 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 fieldAmazon Seller valueRule
productIdOrderItems.SellerSKUMatches the selected Optiply product key, such as skuCode or eanCode, then uses that product's Optiply ID. It is not an ASIN join.
quantityOrderItems.QuantityOrderedWhole-number quantity.
subtotalValueOrderItems.ItemPrice.AmountLine 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.