Set up order sync for Amazon
Import orders from Amazon and send order updates back to the marketplace using the Amazon order sync ecosystem in Productsup.
Introduction
Amazon provides sellers with access to the vast customer base on their marketplace, which helps sellers increase online visibility and drive more sales. Amazon has become a significant channel for e-commerce businesses to expand their reach and grow their online sales presence. You can use Productsup to synchronize orders between Amazon and your order management, shop, or ERP system. Productsup offers the following order-sync ecosystem to achieve this goal:
The data source Amazon Marketplace Orders (SP-API) lets Productsup import your orders from a selected Amazon Seller Central account.
The API-based export Amazon Marketplace Shipment Update (SP-API) lets you update orders on Amazon using information stored in your ERP, order management, or shop system, for example, order tracking IDs and carrier information. This way, you can notify your clients about the progress of processing and shipping their orders.
The order data that Productsup imports from Amazon includes Personally Identifiable Information (PII), such as clients' surnames, addresses, phone numbers, etc. To comply with the Amazon Data Protection Policy regarding PII, Productsup has the following measures in place:
The platform retains the order data featuring PII for 30 days.
The platform obscures the values featuring PII and displays them in Dataflow and Data View as follows:
Note
When you export order data with PII to your desired system, Productsup sends values without obscuring them. The PII order data is fully visible and readable in your target system.
Prerequisites
To use the Amazon order sync ecosystem in Productsup, you need to:
Be a partner in the Amazon Merchant Fulfilled Network, which is Amazon’s terminology for Fulfilled by Merchant.
The Amazon order sync ecosystem in Productsup is available only for the Amazon Merchant Fulfilled Network partners who manage storage, shipping, and customer support independently from Amazon.
Have the Order Sync feature activated in your organization.
The Amazon order sync ecosystem is an additional feature of the Productsup platform. Reach out to your Customer Success Manager to activate it.
Import order data from Amazon
To get your Amazon order data to your ERP, order management, or shop system, you need to first import your Amazon order data into your Productsup site:
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Search for Amazon Marketplace Orders (SP-API) and select Add. Give it a custom name as desired and select Continue.
In Authentication, choose the Amazon authentication you previously set up in your organization, project, or site. If you haven't set up Amazon authentication yet, perform the following steps:
Select Add New Authentication.
Select Amazon Authentication (BETA version by Amazon) in Type. You can optionally give your authentication a name.
Select Next.
If applicable, select Region and Country to choose your marketplace country and locale.
Select Connect to continue.
Important
Before proceeding, Productsup directs you to Amazon to finalize your authentication. After completing the authentication setup, Amazon redirects you back to Productsup.
Close the confirmation window to proceed.
Choose the market of interest in Marketplace ID.
Next, select the period you want to import the orders for in Orders Created After.
You can optionally enter a custom description for the data source in Description (optional). This changes the name of this data source.
Select Save.
Select Run in the top-right corner of your view to let the site import your order data from Amazon.
Once you set up the data source Amazon Marketplace Orders (SP-API), you can go to Exports to add and set up an export to send your order data to the needed target system, such as your ERP, order management, or shop system. When you add and set up the export, you must first map the mandatory attributes in Dataflow before running your site and sending your order data to the desired system.
Export shipment updates to Amazon
To update your orders on Amazon with information stored in your ERP, order management, or shop system, do the following:
Take the steps to import your Amazon order data into Productsup and your desired target system. See Import order data from Amazon.
Create a new site in your Productsup organization. This site has to be separate from the site that imports your order data from Amazon.
Go to Data Sources from the main menu of the newly created site and select ADD DATA SOURCE to add and set up your ERP, order management, or shop system as a data source. When done, select Run in the top-right corner of your view to run the site and let the platform import your shipment data into Productsup.
Go to Exports from your site's main menu and select ADD EXPORT.
Search for Amazon Marketplace Shipment Update (SP-API), hover over it, and select Add.
Select Add Destination, choose Amazon Selling Partner API - Shipment update from the drop-down list, give it a name as desired, and then select Save.
In Authentication, choose the Amazon authentication method you previously set up in your organization, project, or site.
Choose the market of interest in Marketplace ID.
Toggle the Feedback Import button to Off if you don't want the platform to receive feedback files from Amazon.
This feature is active by default to let Productsup receive a feedback file from the Amazon Selling Partner API in case of errors. This helps to troubleshoot the export setup.
Note
If you want the platform to receive feedback files from Amazon, leave the Feedback Import button On.
Optionally, you can change the connection attributes that let you add the export feedback to your site:
In Feedback file connection column, give a custom name to the attribute that should contain the export feedback and appear as an additional attribute in Dataflow or Data View.
By default, the attribute's name is
___amazon_item_id.In the drop-down menu Main feed connection column, choose the attribute corresponding to your unique order identifier. For example, it can be
AmazonOrderIDor any other attribute containing this data if your internal system uses a different attribute name for it.
Toggle the Active button to On to activate the destination.
Select Save.
Go to Dataflow and select Amazon Marketplace Shipment Update (SP-API) in the drop-down menu on the left to map all relevant attributes from import to export.
Once your data is ready for export, select Run in the top-right corner of your view to send shipment updates to Amazon.
The export Amazon Marketplace Shipment Update (SP-API) has the following attributes at the export stage in Dataflow and Data View:
Attribute | Mandatory or not | Meaning and expected values |
|---|---|---|
| Mandatory | Your order ID as expected by Amazon. |
| Mandatory | Your order ID as specified in your internal systems. |
| Mandatory | The shipment method used to deliver the order. |
| Mandatory | The expected shipment date for the order. |
| Mandatory | The code of the carrier company that delivers the order. For example, See Accepted CarrierCode values for more carrier codes. |
| Mandatory in some cases | The name of the carrier company that delivers the order. This field is mandatory only if your carrier company isn't on the list of carrier codes accepted by Amazon, so you provide the value |
| Optional | The ID of the shipment as specified in your internal systems. |
| Optional | The shipment tracking number that helps the buyer track the delivery progress. |
| Optional | The code of the ordered item as assigned by Amazon. |
| Optional | The ID of the ordered item as specified in your internal systems. |
| Optional | The unique identifier for the shipment of the ordered item as specified in your internal systems. |
| Optional | The number of shipped items if you send the ordered items as multiple separate deliveries. |