Table of Contents
Your eCommerce business is incomplete without an Amazon Seller Account. However managing Amazon Sales can be a really challenging task. To tackle this challenge, we have developed a perfect solution - Amazon Odoo Connector. If you use Odoo to manage your backend operations and also sell on Amazon, this connector is just what you need. With this connector, you can easily manage all the important operations of Amazon FBM (Fulfillment by Merchant) from Odoo. Take your online business to a new level with the help of Amazon Odoo Integration.
Let’s discuss the one-time configuration and the salient features of Amazon Odoo Connector.
After successfully downloading the Amazon Odoo Connector App from Odoo store or Emipro shop, place it on the Odoo Add-ons path or at any other desired path. Now, restart the Odoo instance and navigate to Apps in the dashboard. Click on Update Apps List from the menu. Once it completes loading successfully, Amazon Odoo Connector App will be visible in Apps.
Click on the Install button. Success! Now, you are ready to use the Amazon Odoo Connector App in your Odoo.
1. User Access Rights
System will set Amazon Manager rights to admin and bot user once the connector is installed.
2. Create Amazon Seller In Odoo
After installing Amazon Odoo Connector in your Odoo, you can see it in Odoo dashboard. Now, to Create an Amazon Seller, the Current user in Odoo should have same rights as ‘Amazon Manager’ group.
You can change rights of Current user under Settings / User & Companies / Users menu. Also, configure Amazon Seller under menu Amazon / Configuration / Amazon Settings. Here you need to click on link 'Create More Seller' in order to create new one. You can configure Amazon account using two different method.
Method 1: Is Own Developer Account ?
If the seller has own developer account then seller will have credentials too (select key, access key, merchant key) given by Amazon.
2.1 How to Get Credentials from Amazon Seller account
As per the Amazon’s new policy, any seller can not generate own credentials and must authorize App developer id to integrate with connector.
If seller already have a developer account then it can get credentials from seller account.
Go to Settings / User Permissions. If you have professional selling plan then you can see User permissions menu item.
Go to Visit Developer Credentials and click on view MWS Credentials.
Click on view and you can find Access key and secret key.
Click on Settings >> Account info.
Click on Your Merchant Token.
After get Secret, Access key and merchant Id seller can configure Amazon Seller.
Method 2: Is Not Own Developer Account ?
If seller don’t own developer account, then it can use emipro developer id and authorize in the seller central account.
2.2 How to authorize Developer Id In Seller account
When you open a wizard to create seller account, it will ask to select option of own developer account or not. You need to sellect, we have not own developer account and system will ask to select country. Based on country selection, system will show developer id and developer name. Seller must authorize developer id in seller central account.
Go to Settings / User Permissions. If you have professional selling plan then you can see User permissions menu item.
Click on visit Manage your apps >> Authorise new Developer.
Enter Developer Id and Developer Name.
After that Amazon will generate auth token and you can see it under settings >> User Permissions >> Manage your apps.
Click on view and get MWS Auth token.
Click on Settings >> Account info.
Click on your Merchant Token.
3. Load Marketplaces
After the amazon seller account is created, next process is to create marketplaces for seller. For that, go to Menu Amazon / Configuration / Amazon Settings and select one seller. Now, click on ‘Add More Marketplace to Integrate’ and automatically you get the list of all the marketplace for selected seller.
Once all Marketplace are loaded, you can select as many marketplaces as required. System will configure all required fields automatically.
If you want to add more marketplace then click on link Create More Marketplace and a pop up will open. In that pop up, set Instance name, select particular Seller and select New Marketplace, by clicking on Create system. It will create a new Marketplace for selected Seller.
3.1 Seller Configuration
Auto Update FBM Order Status
This field is used to Auto Update Delivery Order status and Tracking number reference of Delivery Orders to Amazon. You can create a Scheduler for this field that can automatically update the order status.
Allow to Create New Product if not found in Odoo ?
If you tick this field, when Orders are imported from Amazon and if they don’t find a Product in ERP, then it will automatically create a new Odoo Product and Amazon Product also. It will also make mapping between Odoo Product and Amazon Product.
Request For Settlement Report
This field is to create automatic request for Settlement report in Amazon. You can create a Scheduler for this field that automatically request for Settlement Report.
Download and Process Settlement Report
By using this field, it will automatically download Settlement report and process that settlement report in ERP. Also, you can create a Scheduler for this field. By default system will process only one settlement report of each execution.
Stock Auto Export
This field will automatically update Product Stock from Odoo to Amazon for all Marketplaces. It is also used for Creating a Scheduler.
Auto Send Invoice Via Email
You can configure a scheduler that can send Invoices to Customer via email and this email is also visible in seller central backend.
Auto Send Refund Via Email
This field will automatic send refund Invoices to customer via email. This field is also used for creating a scheduler.
Connector will automatic create one shipment charge service type of product, that is used for shipment fee in order line in an order.
System will automatic create one promotion discount product used for promotion discount in order line in an order.
Gift Wrapper Fee
It is automatically created by Connector, used for gift wrapper fee in order line in an order.
You can also set shipment discount in order line, that is created by System in an order.
Is default Odoo Sequence in Sales Orders (FBM) ?
If you tick this field, by default odoo sequence numbers is set in sales orders.
You can configure a particular Prefix, for Amazon Orders. You can configure this field with unique values per each seller. When you have multiple sellers at that time, you can set field value like Seller Code to identify that Order is belong to which Seller.
Auto Import FBM Orders
By ticking this field, System will create a scheduler that can import FBM orders automatically. By default system will import only unshipped orders of last 30 days.
Import FBM Shipped Orders
If this field is true then system will import shipped orders from Amazon to Odoo and process delivery orders as well.
Import Shipped FBM Order Time
When you tick ‘Import FBM Shipped Orders’ field, at that time you will see a this new configuration field.
If you import shipped order then system will ask to select start date of import of shipped order and based on this configuration, system will start importing orders.
Last Import FBM Order Days
As per Amazon documentation, it does not guarantee that all the orders will be returned between a given Date range. Sometimes it will miss some Orders to be returned, so to resolve this mistake you can check last Order import time - days (given in this field). By doing this, you will get exact total Orders.
Auto Create Return Picking
When you refund order from ERP to Amazon, system will create return picking based on configuration.
Auto Create Refund
When you refund order from ERP to Amazon, system will create refund based on configuration.
Odoo provides different Payment Terms that you can configure in Orders. By default System set ‘Immediate Payment’ in Payment Term.
This field is used when you use feature ‘Export Products’. You can define that Exported Products are in which Conditions like New, Refurbished etc. By default System set ‘New’ in condition.
You can set work-flow for Imported FBM Orders, like automatic validate Order, create its Invoice and validate that Invoice. You can configure different Workflow for different Seller.
Connector will create a default sales workflow for seller. For configuring workflow, go to menu Amazon / Configuration / Auto Sales Workflow and open that workflow.
You must configure shipping policy under order configuration in auto sales workflow. This shipping policy is set in FBM orders.
You must configure sales journal that is also set in FBM sale orders for invoice.
By default Invoice policy is based on product configuration and you can configure policy based on delivery order or sales order.
If you configure then Odoo will not follow default policy for Amazon orders and follow policy based on auto workflow configuration.
4. Marketplace Configuration
System will export product stock from ERP to Amazon based on stock field configuration. Like quantity on hand, forecast quantity.
Settlement Report Journal
System will create Journal for each Marketplace when Marketplace is created in Odoo. When we process settlement report then system will create bank statement and use journal based on configuration.
Ending Balance Account
You can configure Ending balance account and if you create ending balance account then system will create ending balance line in bank statement.
Ending Balance Description
By default, this field value is ‘Transfer to Bank’ and set by Connector and system will set ending balance description based on configuration.
By default system will set seller company warehouse as default merchant warehouse, user can change it manually.
All merchant order will be delivered from configured warehouse and also system will update stock from configured warehouse.
Connector will set default ‘English’ language to each Marketplace. This Language is set to an Amazon Customer in Odoo and When Invoices or refunds documents are send to customer in this configured language.
By default, connector will create different Price-list for each instance. When system will create Amazon orders then set price-list based on marketplace configuration. Also when you update price of product in Amazon at that time price will be considered based on marketplace price list.
You can configure different Sales team for each instance. This Sales team is set in FBM Orders when orders are imported.
5. Configure Automation Schedulers
For Creating a Scheduler, Tick that automation scheduler field and configure below fields.
List Of Schedulers Provide By Connector
Amazon Features list
6. Sync Active Products
Using this process, you can synchronize the products from Amazon to Odoo.
However, Odoo will not create any new product, but it'll sync the Amazon products with existing ones which are in Odoo.
In order to do this process, go to Amazon / Products / Sync Active Products. Create a new record by selecting any of Amazon Instance.
By clicking on Request Report button, Amazon will respond back to flat product file with the details like Item Name, Item Description, Listing ID, Seller SKU, Price, Qty, ASIN numbers etc.
Clicking on the Sync Products button on that screen, the system will try to find out seller SKU in amazon product list and if it gets found, then the system will update that product with the latest data received from Amazon in that file.
Now in case if seller SKU is not found, then the system will try to find out. In the Odoo product list (The products which are not prepared to be exported at Amazon yet at the menu Sales / Products / Variants).
If from there SKU gets found, the system will add that product to the amazon product list at Amazon / Products / Products menu.
Now in case if that SKU is not found at Odoo Product list too, system create skip line log in the log book and that can be seen at Amazon / Log / Amazon Process Job Log menu.
Basically, this feature is very useful when you have already running Odoo database with heavy number of products and at that time you are starting Amazon-Odoo Integration. In that case, with this feature, you don't need to create products separately again to export them at Amazon, the system will create and prepare product for Amazon automatically with the matching SKUs between Amazon and Odoo.
7. Import Products
For Fresh Installation, there is no any Amazon Products under menu Amazon / Products / All Variants. So at that time you can use this feature at Amazon / Products / Import Products.
By Clicking on Import Products, you can see a wizard with some fields like Amazon Seller, Upload File, Separator etc. Also you can download a Sample for Import Products that contains details Internal Reference, Seller SKU, ASIN, Product Title, Fulfillment By and Marketplace.
You can export products from Amazon in flat file and manually prepare a file same as sample format for import products. In import product wizard, select Amazon seller, upload preparable File and click on IMPORT PRODUCT button and system will create new Amazon products with file details at Menu Amazon / Products / All Variants. If those products are not available in Odoo products then system will create new Odoo products.
If seller have multiple Amazon product and same Odoo product then also it is manageable in the connector.
8. Export / Update Product
From Odoo Amazon Connector, user can export product which already exists in Amazon Catalog. If product are not in Amazon catalog then user can export csv file and import csv in Amazon.
To export product from Odoo to Amazon, first you must prepare for export.
8.1 Prepare Product For Export
You can see prepared products for Amazon under Amazon / Products / Products menu.
You can't create Amazon products directly from here.
In order to create products for Amazon, You need to go to menu Sales / Products / Products and in list view of product, select one or more products which you want to export to Amazon.
At the top side, under the 'More' section, you will find an option Prepare Product for Export. Clicking on that option, you will be asked to select Amazon Instance. After those products successfully prepared for Amazon, you can see all of them over here in this menu.
After prepare for export user must configure below required fields.
By default system will take product name as title, if you have different title then you can set in Amazon product.
By default system will set product description in Amazon product, user can change as per requirement.
3. Standard Product Type
This is main field based on that system will export product from ERP to Amazon. Like ASIN, EAN, UPC number.
4. Seller SKU
By default system will set product internal reference as seller SKU, user can change as per requirement.
5. Features & Search terms
Those fields are not required but user can configure it, if seller want to use different features and search terms.
System will not export price, stock, images with product, system will first create inactive listing in Amazon.
8.2 Update products
User can update all product information from Odoo to Amazon. Like title, description, search terms & features for all products which are exist in Amazon seller account.
After configure products user can got to tree view of Amazon products, select product and perform operation export product, update product.
8.3 Import products in seller central account
For new catalog products which are not exist in Amazon seller account, either user can directly create in Amazon or user can use import product features.
User can go to Amazon products / More / Export file in CSV and upload file in seller account.
After importing the file, Amazon Seller central will ask you to select category and based on that the listing will be created.
In the file if you specify color and size attribute then Amazon import product algorithm consider as Variation product.
If you are exporting product variants in Amazon then in one file you need to specify all variants of same template, because Amazon will consider all variants of same template.
Using file format it is not possible to export multi variants products in same file.
9. Export / Update Price
Based on Price List selected on each marketplace, your product's price can be updated directly at Amazon.
We can update price using two methods.
1.You can select specific products from list and click on Update Price in Amazon option or go to Amazon Operations pop up, select one or more instances and select Update product price option to set price for all your Amazon products in single click.
2. Goto Amazon / Amazon <=> Odoo / Amazon Operations. This option is basically for bulk operations.
10. Export / Update Stock
Based on stock field configuration on each marketplace, product stock will update from ERP to Amazon.
System will select stock based on merchant warehouse stock location and seller stock field configuration.
You can configure this field under menu Amazon / Configuration / Amazon Settings. Select ‘Amazon Marketplace’ from left hand side. In Odoo Products there are fields like ‘Quantity On Hand’ or ‘Forecast Quantity’ that describes Product Stock Quantity available in specific Marketplace Warehouse. You can set Stock field as per your requirement.
Update fix stock from ERP to Amazon:
If you are selling in multiple marketplaces or store then some of the time will be required to fix stock or some percentage of stock from Odoo to Amazon. In Amazon product, you can see ‘Fix Stock Type’ and ‘Fix Stock Value’ field.
Fix Stock Type & value:
It has two values Fix and Percentage. If you set ‘Fix’ then whenever you update the Product stock, at that time some value that is given in ‘Fix Stock value’ field will be updated at Amazon for Specific Instance. If you set percentage then system will always update percentage stock in Amazon. In both type system will not update more stock then actual available stock. If stock is 10 and user set fix 5 then it will update 5 quantity to Amazon. If stock is 4 and update set fix 5 then system will update 4 quantity in Amazon. We can update stock using three methods. 1.You can select specific products from list and click on Update Stock in Amazon option or go to Amazon Operations pop up, select one or more instances and select Update product Stock option to set price for all your Amazon products in single click. 2. Go to Amazon / Amazon <=> Odoo / Amazon Operations. This option is basically for bulk operations. 3. Configure scheduler to export stock from ERP to Amazon.
10.1 Export/Update Product Images
For Export / Update Product Image, you need to add Product Images info at menu Sales / Products / Product Variants. In Product, you will see a tab named ‘Images’.
Under that tab, you need to add Image Name, Image Type and Image URL. All Image Type are given from Amazon.
You can Export / Update Product Image by Selecting One or More Product from menu Amazon / Products / All Variants and click on ‘Action’ to perform operations.
Notes: When user will export product from ERP to Amazon, first system will create listing as incomplete
After export images, price and stock, listing will active in the Amazon.
11. Import Sales Orders(Unshipped/Shipped)
You can see Amazon Sale orders at the menu Amazon / Sales / Sales Orders (FBM). You can't create Sale Order manually and push it to Amazon. Through only import Sale Order from any of your Amazon Instance, you can see your Orders here. Import Sale Order can be performed by 2 ways.
For Import Sales Orders, you must take care of some configurations.
1. To import Sale Orders via automatic jobs at frequent amount of time
Go to Amazon / Config. At there, activate automatic Job for Import Order from Amazon. However from Amazon settings you can set your preferred timings for auto import Sale Order from Amazon.
If user have configured import shipped orders then system will also import shipped orders and process delivery orders.
2. Manually Import the Sale Orders at any time
Go to menu Amazon / Amazon <=> Odoo / Amazon Operations and select your instances and option Sale Order under the Import Operations (FBM) section. Clicking on Execute button will import all Unshipped/Partial Shipped orders from Amazon to Odoo.
System will ask to select date range, if user will not select date range then system will import order last import date-configure days.
In import order process system will apply a workflow based on configuration and confirm order, create & validate invoice based on workflow.
In above screen-shot you can see import amazon orders.
You will see a different sign if orders is not yet updated at Amazon. Once you ship order successfully from your warehouse and complete delivery order at Odoo. Shipment will be automatically updated at amazon via scheduler or also user can update it manually.
11.1 Export Shipping details with package tracking number to Amazon
For update shipment details user must transfer delivery order in Odoo.
If you have one tracking number then you can configure in carrier tracking ref field which is provided by default in Odoo.
If you have multi tracking number then you can use Odoo packaging features. Do put in pack and set additional reference in package.
Note: If product type is BOM(KIT) then system will also manage in Update order status process.
Connector is allow you to Update Tracking number in 2 ways.
1. Automatic Scheduler
Go to Amazon Seller configuration page under at menu Amazon / Configuration / Amazon Settings. There is one field for Scheduler : Auto Update FBM Order Status. Set preferred timings for auto update tracking information of Order to amazon.
2. Manually Update Order Status at any time
Go to the menu Amazon / Amazon <=> Odoo / Amazon Operations. Select your Instances and tick Update Order Status under Export Operations (FBM). Click on Execute button will Update tracking information of Orders to Amazon.
If you update manually order status then process will pause in two minutes because Amazon is giving response in two minutes and based on response, system will update status in ERP.
When tracking status is updated in Amazon then delivery order has a flag (boolean ‘Updated in Amazon’) will be true and next time it will not consider for process.
In Update order status first system will request in Amazon how many orders have already shipped in Amazon, if already shipped then system will not repeat again.
In update order status system will select delivery date as shipment done date.
12. Process Amazon Settlement Reports
Amazon provides the Settlement/Payment Reports to view information about your payments related to sales and operational activity for your Amazon account.
Settlement reports can provide a detailed breakdown of your account activity for a given settlement period.
This Connector provide two ways to Process Settlement / Payment Reports.
1. Manually Download & Reconcile report
Settlement reports are generated regularly by amazon, and you can download them in Odoo from manually at menu Amazon / Amazon <==> Odoo / List settlement reports. Clicking on Get Report List button, Odoo will download your settlement reports from Amazon for given date period. You can see all of your settlement reports from the menu Amazon / Reports / Settlement Statements.
Those all reports you can see per seller wise.
Odoo will download your reports and after that status of those reports will be in Done state. It means, report has been processed from Amazon side but it has not yet updated in Odoo.
By clicking on button Process Statement, any unprocessed statement will automatically create the Amazon/Bank statement in Odoo, all lines will be imported from the report file and report state will be set to Imported.
In Imported state Reconcile Button will be visible, when user click on Reconcile button, system will Reconcile statement lines, here, the important thing to note down is till all the statement lines are not reconciled with proper accounts, your Amazon bank statement user will not be able closed. Odoo will take default Journal for your bank statement which is configured in your particular Amazon Instance screen inside Settlement Report Journal field.
Automatic Scheduler :
Go to menu Amazon / Configuration / Amazon Settings, select ‘Amazon Seller’ and see field configuration under ‘Payment Report’. There are two fields that need to be configure for automatic Process Settlement Report.
Settlement report transaction configuration
In your Odoo bank statement, all of your Amazon subscription, commission fees or other transaction type will be reconcile automatically with the accounts you have configured over Settlement Report Settings Tab inside Seller screen and on the menu 'Amazon / Configuration / Sellers'.
Once all your statement lines will be properly reconciled, all of your related Amazon invoices will automatically marked as Paid.
13. Cancel Order at Amazon
You can cancel any order at Amazon directly from Odoo.
For Cancel Order go to Menu Amazon / Sales / Sales Orders (FBM). To cancel order, first you need to cancel Shipment (Delivery Order) for specific Sale Order and there will be option Cancel in Amazon visible in Sale Order.
By clicking on that, one pop up will be open and you will be asked to select a specific return reason. For example, if stock is not available. Selecting any option and clicking on Cancel Order button will directly update at Amazon and your order will be canceled straight away at Amazon.
14. Create Refund at Amazon
You can get Refund of FBM Orders at Amazon from Odoo. Go to menu Amazon / Sales / Refund and create a new record.
Select any Order that is Done / (Cancel Order) and it’s order lines will be automatically created as Refund Lines. Here, you can remove product lines for which you don’t want to make refund.
You can open each refund product lines and set refund amount by calculating different kinds of fees and set the appropriate refund messages at Amazon.
Connector is providing many types of refund configuration for each Amazon Seller. Go to menu Amazon / Configuration / Amazon Settings and select Amazon Seller. Go to bottom area and you will see Orders and Returns settings.
System will create auto return and refund in ERP based on configuration.
14.1 Track feed submission history to Amazon requests from Odoo
Our module submits feeds to Amazon during exporting stock, products, shipment status and price from Odoo.
Sometimes due to technical reasons or missing required informations in feed then you will not get desired results at your Amazon account.
In those cases, you can track submitted feed history by clicking on feed history box on Amazon dashboard. This information may be useful to technical persons rather then end users.
15. Amazon Log book & Mismatch Log
System will create log for mismatch details and also informative log for import orders, update tracking number, export/update product, stock, price, refund.
16. Send Invoice / Credit Notes
You can configure scheduler to send invoice / credit notes from ERP to Amazon.
In Seller / Configurations / Auto Send Invoice Via Email ? and Seller / Configurations / Auto Send Refund Via Email ?
System will select default email template for invoice /credit notes.
All send invoices will be visible in Seller central backend.