Skip to main content

Amazon Seller - Data mapping & synchronisation

Learn how Optiply integrates with Amazon's Selling Partner API, including AWS regional endpoints, synchronisation modes (Full vs. Secondary), and detailed data mapping for products and orders.

Carla Domingos avatar
Written by Carla Domingos
Updated over 2 weeks ago

πŸ”— Amazon Selling Partner API Integration

This article details the integration between Optiply and Amazon's Selling Partner API (SP-API). It covers the different synchronisation modes available and how data is mapped between the two systems.


⏱️ Synchronisation Overview

There are two distinct "Versions" or modes for this integration: Secondary and Full.

1. SECONDARY Mode (Sell Orders Only)

This mode is used when your Products are already synced to Optiply from another source (e.g., WooCommerce, Shopify). Amazon is added purely to import sales data.

Entity

Direction

Frequency

Sell Orders

Amazon β†’ Optiply

Every 30 minutes

2. FULL Mode (Products + Sell Orders)

This mode is used when Amazon is a primary source of product data.

Entity

Direction

Frequency

Products

Amazon β†’ Optiply

Every 30 minutes

Sell Orders

Amazon β†’ Optiply

Every 30 minutes


πŸ—ΊοΈ Data Mapping Details

1. Products

Data is retrieved via the /catalog/2022-04-01/items endpoint.

Optiply Field

Amazon Field

Notes

Name

products_inventory.item-name

-

SKU Code

identifiers

Maps where identifierType = SKU

EAN Code

identifiers

Maps where identifierType = EAN

Price

products_inventory.price

-

Unlimited Stock

-

Always set to False

Stock Level

warehouse_inventory.totalQuantity

-

Remote ID

items.asin

The ASIN is used as the unique ID.

2. Sell Orders

Data is retrieved via the /orders/v0/orders endpoint.

Optiply Field

Amazon Field

Notes

Total Value

Orders.OrderTotal.Amount

-

Placed Date

Orders.PurchaseDate

-

Sell Order ID

Orders.AmazonOrderId

-

3. Sell Order Lines

Data is retrieved via the /orders/v0/orders/{orderId}/orderItems endpoint.

Optiply Field

Amazon Field

Product ID

OrderItems.ASIN

Quantity

OrderItems.QuantityOrdered

Subtotal Value

OrderItems.ItemPrice.Amount

⚠️ Important Limitation: We do not sync order changes. Once an order is imported, any subsequent line changes, deletions, or new lines added to that existing order on Amazon will not be updated in Optiply.


❓ Frequently Asked Questions (FAQs)

Which AWS Region should I select?

Use the table at the top of this article. If you sell in Germany, use the Europe endpoint (eu-west-1). If you sell in Japan, use the Far East endpoint (us-west-2).

Can I use Amazon just for sales data?

Yes. Select the Secondary integration mode. This is perfect if your "master" product data comes from Shopify or WooCommerce, but you also sell on Amazon and want those sales counted in your forecast.

Why aren't my order modifications syncing?

Optiply's Amazon integration fetches the order snapshot at the time of creation/import. It does not "listen" for updates. If you modify an order in Amazon after it has been placed, that change will not reflect in Optiply.

How do I match products in Secondary mode?

You need to tell Optiply which field to compare. If your Shopify product SKU is "ABC-123" and your Amazon product has "ABC-123" stored in its EAN field, set the mapping key to eanCode.

Did this answer your question?