Amazon SP-API Integration

The Amazon Connector pulls Products and Sales Orders from the Amazon marketplace.

How to Setup Amazon SP-API Connector?

Amazon Connector is moved out from ERPNext and is available through a Frappe App on Frappe Cloud Marketplace

App Installation

  • If you are hosting your ERPNext site on Frappe Cloud, you can quickly install the app by going to your site Dashboard. The app is available in Frappe Cloud Marketplace

  • If your site is hosted by Frappe, please raise a support ticket to get the app installed on your site.

  • If you are self-hosting ERPNext you can install the app using Frappe bench. Refer to bench documentation for installing Frappe Apps. bench get-app ecommerce_integrations --branch main

The repository for the app is hosted on GitHub: http://github.com/frappe/ecommerce_integrations/

Setting Up Credentials in ERPNext

You can request the developer credentials from Amazon Seller Central once you are a registered seller on their website. For more details on the same, click here.

1. Setup SP-API Credentials

Enter the IAM ARN, Refresh Token, Client ID, Client Secret, AWS Access Key, AWS Secret Key and Country. Credentials

2. Set up Order Details

Set up Company, Warehouse, Parent Item Group, Price List, Customer Group, Territory, Customer Type and Account Group. The Account Group is used to hold commissions, taxes etc. that Amazon charges. setup

3. Setup Sync Configurations

Using the After Date, you can sync orders created after a particular date. In case you are importing a lot of historic data, it is suggested to start in the reverse chronological order of the After Date and import data in small chunks. SyncingAfter setting up all the configurations, click on Is Active and save the settings. You are now ready to use the integration.

4. Amazon - ERPNext Item Mapping

Both ASIN and SellerSKU can be utilized to map Amazon items with corresponding ERPNext items. For instance, if you have pre-existing items in your system, created through other integrations, you can establish a custom field within the Item Master by using the Customize Form feature and setting the ASIN/SellerSKU as the value.

During the process of syncing orders from Amazon, the system will attempt to find the Item Code using the field configured to find the Item Code in the Amazon - ERPNext Item Mapping table. If the item is not found in the mapping table, you have the option to create a new item by checking the Create Item If Not Exists box.

Screenshot from 2023-07-31 13-52-50

5. Sync Orders

Click on this button to sync sales orders. Once this is successful you should see your Amazon Orders as Sales Orders in ERPNext. You can also set up a scheduler to sync orders automatically.

In case your developer account does not have access to personally identifiable information. The customer name would be stored as a combination of the BuyerName + <Order ID> or Marketplace email ID.

Sales Order

Note

The connector won't handle Order cancellation. If you cancel any order in Amazon then manually you have to cancel the respective Sales Order and other documents in ERPNext.

Was this article helpful?