Skip to main content

Amazon SP-API Connector

The Amazon SP-API Connector imports Products and Sales Orders from the Amazon Marketplace into ERPNext. It enables businesses to synchronize Amazon orders with ERPNext while automatically mapping or creating products during the import process.

Summary

  • Imports Products and Sales Orders from Amazon Marketplace.
  • Uses Amazon Selling Partner API (SP-API) for secure integration.
  • Supports automatic item mapping using ASIN or SellerSKU.
  • Can automatically create missing Items during synchronization.
  • Allows scheduled or manual Sales Order synchronization.

Install the Amazon Connector

The Amazon Connector is available as a separate Frappe application and is no longer bundled with ERPNext.

  1. Install the ecommerce_integrations app.
  2. If using Frappe Cloud, install it directly from the Marketplace.
  3. If using a Frappe-hosted instance, request installation through Frappe Support.
  4. If self-hosting ERPNext, install the app using Frappe Bench.

Configure Amazon SP-API Credentials

Obtain your developer credentials from Amazon Seller Central after registering as a seller.

  1. Open the Amazon Connector settings in ERPNext.
  2. Enter the following credentials:
    • IAM ARN
    • Refresh Token
    • Client ID
    • Client Secret
    • AWS Access Key
    • AWS Secret Key
    • Country
  3. Save the configuration.

Configure Order Settings

Specify the default values used while creating imported Sales Orders.

  • Company
  • Warehouse
  • Parent Item Group
  • Price List
  • Customer Group
  • Territory
  • Customer Type
  • Account Group

The Account Group is used to record Amazon-related charges such as commissions, taxes, and other marketplace fees.

Configure Order Synchronization

  1. Select an After Date to import orders created after a specific date.
  2. For historical imports, synchronize orders in smaller batches using recent dates first.
  3. Enable Is Active.
  4. Save the configuration.

Note

When importing a large number of historical orders, it is recommended to synchronize them in smaller batches by selecting an appropriate After Date. This helps improve synchronization performance.

Configure Amazon Item Mapping

ERPNext can identify existing items using either the ASIN or SellerSKU.

  1. Create custom Item fields if you want to store Amazon ASIN or SellerSKU values.
  2. Configure the field that ERPNext should use for item matching.
  3. Enable Create Item If Not Exists to automatically create new Items when no matching record is found.

Synchronize Sales Orders

  1. Click Sync Orders.
  2. The connector retrieves Sales Orders from Amazon.
  3. Imported orders are automatically created as ERPNext Sales Orders.
  4. You can also configure scheduled synchronization for automatic imports.

Important

If your Amazon developer account does not have permission to access personally identifiable information (PII), ERPNext stores the customer using either the Buyer Name + Order ID or the Marketplace Email ID.

Limitations

The Amazon Connector does not automatically process order cancellations. If an order is cancelled in Amazon Marketplace, the corresponding Sales Order and related documents must be cancelled manually in ERPNext.

Rating: 0 / 5 (0 votes)