Amazon SP API Integration
Connecting ERPNext v16 to the Amazon Marketplace is easy with the Amazon SP API Integration. You can connect your Amazon products and sales orders to ERPNext, which enables you keep track of all your Amazon stock, sales orders, and accounting in one spot.
How do you get the Amazon SP-API Connector to work?
The primary ERPNext app no longer has the Amazon Connector. It’s just a Frappe app now. The Frappe Cloud Marketplace offers this software for download. It receives frequent updates to stay in line with Amazon’s most recent SP-API regulations and standards.
Preparing the app
- You may quickly add the Amazon Connector to your ERPNext site if you host it on Frappe Cloud. Just go to your Site Dashboard and choose the app from the Frappe Cloud Marketplace.
- You can obtain help installing the Amazon SP-API Connector app by opening a support issue if Frappe hosts your site.
- If you host ERPNext yourself, you may utilise Frappe Bench to deploy the app. The Bench documentation shows you how to put programs on your computer. The command bench get-app ecommerce_integrations –branch main is the most popular.
You can get the app’s source code at http://github.com/frappe/ecommerce_integrations/.
How to Make Your ERPNext Account
You can only use the Amazon SP-API Connector if you are an Amazon seller. You can acquire developer credentials when you sign up for Amazon Seller Central. These credentials make it secure for ERPNext to connect to Amazon’s SP-API.
1. Sign up for an SP-API account
Enter the information you acquired from Amazon Seller Central and AWS into ERPNext:
- The IAM ARN tells you what AWS IAM role you need to utilise to get to the API.
- Refresh Token: This is what makes access tokens work on their own.
- When you sign up for the Amazon Developer Console, you get a Client ID and a Client Secret.
- To check API requests, you need an AWS Access Key and an AWS Secret Key.
- Country: This tells you what country you’re in on Amazon, like the US, UK, IN, and so on.
Amazon and ERPNext need these credentials to be able to talk to each other safely and without any complications.
2. Enter the order details
You need to set up the default master and accounting settings for ERPNext that will be utilised when you get orders from Amazon.
- The company that manufactures ERPNext, which will keep track of sales on Amazon.
- The warehouse is where the inventory is updated and where merchandise is housed.
- This is how to bring together Amazon items that were made in ERPNext: Parent Item Group.
- Price List: This tells Amazon how much to charge for products.
- We sort and report consumers based on their type, area, and group.
- Account Group: This is where Amazon takes off fees like shipping costs, taxes, and commissions.
These options let Amazon keep track of sales, money, and inventory.
3. Make the rules for synchronizing
You can utilize the After Date option to pick which Amazon orders to bring in. You can only sync orders that were placed after the date you select.
- If you have a lot of historical data, it’s better to sync orders in small groupings, starting with the most recent ones and going back in time.
- Click “Is Active” and then save your options after you’ve made them all.
You can get data from Amazon and send it to ERPNext when you turn it on.
4. Linking Amazon products to ERPNext
You can use either ASIN or SellerSKU to connect things in ERPNext:
- If the items are already in ERPNext (for example, if they were made through another integration), you can add a custom field to the Item Master and put the ASIN or SellerSKU there.
- Please tell us which field in the Amazon – ERPNext Item Mapping database we should look at to find the Item Code.
When you sync orders, ERPNext uses the mapping field you set up to find what you need. If you set on “Create Item If Not Exists,” the program will automatically make an item if it doesn’t already exist. This stops mistakes from happening when objects are missing during order sync.
5. Sync orders
To acquire sales orders from Amazon by manually, click “Sync Orders.” If you do it right, ERPNext will present Amazon orders as sales orders.
You can also choose a time for when orders will sync by themselves. This will help you get your task done on time and save you time.
If your Amazon developer account can’t see personally identifiable information (PII), ERPNext will save the customer’s name as either the Buyer’s Name or the Marketplace email ID, depending on what data is available.
Note:
- The Amazon SP-API Connector does not cancel orders by itself.
- If you cancel a purchase on Amazon, you have to cancel the Sales transaction and any additional papers that go with it, like Delivery Notes or Invoices.
This integration’s purpose is to make sure that ERPNext v16 can still follow Amazon’s SP-API standards while keeping track of orders and money correctly.
