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.
System will set Amazon Manager rights to admin and bot user once the connector is installed.
- There are two types of user.
- 1. Amazon Manager
- 2. Amazon User
- Amazon Manager: Amazon manager have full access rites of configuration and all processes.
- Amazon User: Amazon user can not change any configuration and not allow to delete any details of Amazon.
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.
If the seller has own developer account then seller will have credentials too (select key, access key, merchant key) given by Amazon.
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.
If seller don’t own developer account, then it can use emipro developer id and authorize in the seller central 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.
- Other Seller Create fields:
- Seller name: Enter the Name of Amazon Seller. It can be anything.
- Company: Enter the Company of seller. Make sure it is correct because all transaction will be carried out by Odoo on the basis of configuration of company.
- Short Code: When you create seller and marketplaces, system will auto create settlement report journal and in that journal system will set short code based on value you entered short code parameter in configuration. Journal short code is wizard short code + marketplace domain name. Ex : com,ca,au.
- Amazon Fee account : In Amazon connector, you can process settlement report and all charges. System will set default account in all charges taken by Amazon. Later on user, can manually change account in different charges.
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.
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.
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.
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.
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.
This field will automatically update Product Stock from Odoo to Amazon for all Marketplaces. It is also used for Creating a Scheduler.
You can configure a scheduler that can send Invoices to Customer via email and this email is also visible in seller central backend.
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.
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.
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.
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.
If this field is true then system will import shipped orders from Amazon to Odoo and process delivery orders as well.
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.
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.
When you refund order from ERP to Amazon, system will create return picking based on configuration.
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.
- There are many options that you can use when Orders are imported:
- Validate Order : Create Delivery Order (Picking)
- Create Invoice : Create Invoice in Draft State
- Validate Invoice : Change State of Invoice (from ‘Draft → Open’)
- Register Payment : Automatic Paid Invoice
- Force Invoice Date : By default when you validate invoice, then its date will be current date and the invoice number will be generated based on invoice date. If you want to generate account entry based on order date then you can use this configuration. After that invoice date becomes same as current date and journal entry date is now same as order date.
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.
System will export product stock from ERP to Amazon based on stock field configuration. Like quantity on hand, forecast quantity.
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.
You can configure Ending balance account and if you create ending balance account then system will create ending balance line in bank statement.
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 ream is set in FBM Orders when orders are imported.
For Creating a Scheduler, Tick that automation scheduler field and configure below fields.
- Interval Number
- Interval Type : Minutes, Hours
- Days, Weeks or Months
- Next Execution Time
- User : By which this Scheduler will run
List Of Schedulers Provide By Connector
- Import FBM Orders
- Auto Update FBM Order Status
- Import and process settlement report
- Update stock
- Auto Send invoice email
- Auto refund invoice email
Amazon Features list
- 1. Sync active products
- 2. Import products
- 3. Prepare product for export
- 4. Export non-variation products which are already existing in amazon catalog
- 5. Update Amazon products
- 6. Update stock,price,images
- 7. Update stock,price,images
- 8. Update tracking number
- 9. Import & Process settlement report
- 10. Refund
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.
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.
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.
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.
This is main field based on that system will export product from ERP to Amazon. Like ASIN, EAN, UPC number.
By default system will set product internal reference as seller SKU, user can change as per requirement.
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.
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.
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.
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.
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.
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.
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.
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.
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.
- Allow to Create New Product if not found in Odoo: There is one option in seller configuration. If this option is not set and at time of Import Orders from Amazon and if a particular product from that order is not available in Odoo, then system will skip that Order and create a mismatch log. If it is True then, System will automatically create a new Amazon products in Odoo while importing Orders from Amazon.
- Is default Odoo sequence in Sales Orders (FBM): You can configure this field under menu Amazon / Configuration / Amazon Settings. Select ‘Amazon Seller’ from left hand side. By default, Odoo provides Sequence number to Sales Orders (SO001). Whenever you importing Sales Orders, at that time ‘Amazon Order Reference’ will set as sequence number, if you need to use default Odoo Sequence then you can tick this field.
- Order prefix: You can configure this field at ‘Amazon Seller’ configuration. Connector will allow to set your own Order Prefix. This field is used when you have multiple sellers at that time you can set seller code for different Seller to easily identify order is belong to which seller. You can use either ‘Is default Odoo sequence in sales orders (FBM)’ or ‘Order Prefix’.
- Import FBM shipped orders: You can configure this field at ‘Amazon Seller’ configuration. If you tick this field, then connector will import unshipped orders as well as shipped orders. System will also confirm and process delivery orders if orders have already shipped in Amazon. Also, system will create invoice and validate invoice based on auto workflow configuration. After tick this field, you can see a new field ‘Import Shipped FBM Order Time’.
- Import shipped FBM order time and Last Import FBM Order Days: If you are importing first time order in Odoo then system will ask from which date we need to start import order. 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 we will check last Order import time - days (give in this field). By doing this you will get exact total Orders. User can configure last import FBM orders days. System will always import orders from last import date - last import FBM order days.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
System will create log for mismatch details and also informative log for import orders, update tracking number, export/update product, stock, price, refund.
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.