Amazon Odoo Connector

Amazon Seller account management is so easy now in Odoo

Our Amazing navigation dashboard is an overview of all of Amazon operations at a glance. From the dashboard itself, you will be able to easily execute any operation for Amazon or navigate to any useful data directly. By clicking on main menu 'Amazon', you will able to see beautiful dashboard containing all Amazon navigation menus in one screen. You will able to see no of records at each box in red fonts. Clicking on each box will navigate you to respective screens.


It's time to set up Amazon Seller account and Instances!

After installation of this module, you will able to see the option for Amazon Seller configuration under 'Settings >> Configuration >> Amazon' menu. Be sure that user is under 'Amazon Manager' group. Here you can select preconfigured Amazon sellers from list or if no any seller configured, then you can click on link 'Create more Seller' in order to create new one. While defining a Seller account, Access Key, Secret Key and Merchant Id is must necessary. Upon successfully defining your seller account, it's time to load marketplace per each seller wise. To do so, you need to go to menu 'Amazon >> Configuration >> Sellers' and open particular seller. Clicking on 'Load Marketplace' button, will automatically get all your marketplaces for that seller. Once all marketplaces are loaded, you can start to configure Amazon Instances per each seller. In order to start Amazon integration into Odoo, Seller and Instance must need to configured properly. You can check your Amazon Connection and change the Amazon Credentials into Amazon Instance screen when needed.




Configure necessary parameters per each Amazon Instance wise

After you define & create your Amazon Sellers and Instances successfully, you can configure other necessary Amazon parameters in Amazon configuration screen. By selecting any Seller, you will see list of necessary parameters to be set for that Instance. Some of the options are mandatory and some of them are optional. We recommend you to properly set options like Warehouse, Default Customer, Auto Workflow, Pricelist, Order Prefix & Stock prior to sync Amazon with Odoo.


Configure auto Invoice & Payment workflow setting per each Amazon Instance

Per each Amazon Instance, you can configure Auto Workflow settings. We recommend you to configure Auto Invoice & Payment workflow properly before sync with Amazon. Improper configuration of Auto Invoice & Payment workflow setting, may lead to runtime problems while integration of sale orders from Amazon to Odoo. With Auto workflow setting, user can decide whether to create automatic Invoice and register payment when Amazon Orders are synchronised with Odoo. We suggest to configure Journal, Shipping & Invoice policy in Auto Workflow setting under menu 'Amazon >> Configuration >> Auto Sales Workflow' menu and set it per Instance under Auto Workflow field.

Execute all Amazon operations from one pop up screen

By clicking on Perform Operation box in dashboard, a pop up will open with all Amazon Import / Export operations. You can select one or more Amazon Instances and execute one or more operations in single click. As per number options selected in pop up, time to execute operation will be increased at Odoo. So if you select multi instances or more operations, system may take more time for bi-directional data exchange between Amazon Marketplace and Odoo.

View last Amazon sync. history and modify Amazon credentials

Once you configure your Amazon Instance under 'Settings >> Configuration >> Amazon' menu, those instances will be available over under 'Amazon >> Configuration >> Instances' menu. You can open each Instance and in details view, you will able to see Last sync history for Catelog, Inventory, Product Images operations. Here in this screen you can also check your Amazon credentials or modify them by clicking on Amazon Credential button.

Amazon Browse Nodes

Amazon uses a hierarchy of nodes to organise its items for sale. Each node represents a collection of items for sale. Browse node IDs are positive numbers that uniquely identify product collections, for example, Literature & Fiction: (17), Medicine: (13996), Mystery & Thrillers: (18), Nonfiction: (53), Outdoors & Nature: (290060). Per each Amazon Instance, you can Import browse nodes in Odoo. We have given some of the base browse nodes in our module. You can import more browse nodes by "Perform Operation" box in dashboard. In each browse node, you can assign Odoo product category and select that browse node in each product. While exporting product to Amazon from Odoo, if browse node is assigned to products, then those products will be automatically listed under those categories in Amazon.

Prepare products for Export & update Images, Price at Amazon

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. Here you can see three menu items.

1.Variation Products:

Here user can see all variation product (Parent Product of variation product) & inside product form view, user can see Variants tab. In which you can find all variants of selective parent product (You can perform Variation related any operation from this menu item). In list of products, you can select them and export them with Details, Images or Update price to Amazon. If you select product and perform operation with amazon (Export/update) then system will automatically perform with all variations items. Ex:- if you export one product from list view then system will automatically export all variants in Amazon.

2.Non-Variation Products:

Here user can see all non-variation product, and can not see any variation product variants. In list of products, you can select them and export them with Details, Images or Update price to Amazon.

3.All Variations:

User can find any variants for Variation-Non-Variation Product.(User must not perform operation from this menu item) However here you can open those products and add more Amazon specific attribute values to products. Once all products are well configured with proper values, you can export them to Amazon.

In Amazon Product you can configure All amazon attributes & catalog attributes. In odoo products, if you have select Variation theme then system will set two attrbibutes automatically in Amazon product (Variation Theme/Parentage)

In Amazon Product by default system will set relation type as Variation, but later-on, user can change in In Amazon product ! In Amazon Product, you can configure Catalog Attribute as well. If you have select product category in Odoo product then user can select all category attributes & set value as well.

Most important feature of this module is you can export product in Any category & no need to create attributes manually, user can select it & use it.

If You have register Brand in Amazon then you no need to select product ASIN/UPC/EAN13 number then you should do following configuration.

1.You just select brand in Odoo template & set Manufacturer inside Brand.

2.You must select Standard Product ID as GCID.

If You are selling product in USA, then Item Type Keyword must be required by Amazon for sale product in selective category. For US Sellers, you can't allow to set Browse Node, If you set Browse Node then amazon will ignore it. Amazon is not providing any API to get Item-Type Keyword, you can find from amazon seller central Account.

You Can configure Other Amazon attributes like.

1.Features & Search Terms.

2.Other Attributes like(Used For, Target Audience, Subject Content, Other Attributes, Platinum Keywords)

3.Promotion & Discount


5.CPSIAWarning, TSDWarning, TSDLanguage, TSDAgeWarning

6.Description & Disclaimer

7.General Product Listing Elements Like(Browse Node ,Item Type,Product Tax Code,Condition,etc..) If product is not existing in Amazon then also You can export new product in Amazon but you must configure All catalog attribute/value properly.

In list of products(Varation/Non-Variation), you can select them and export them with Details, Images or Update price to Amazon. In order to export product images to Amazon, you need to go to menu 'Sales >> Products >> Product Variants' and open any product for which you want to set Images for Amazon account. Under 'Images' Tab, you can set images and that will be exported in Amazon from Odoo.

Sync Sale Orders from Amazon to Odoo

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.

1. To import Sale Orders via automatic jobs at frequent amount of time

Go to amazon cron jobs from Dashboard and click on Amazon Cron box. 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.

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.

At the list of Amazon Sale Orders, you will see a sign if Order is not updated at Amazon. Once you ship full order from your warehouse and complete the delivery order at Odoo, Shipment will be automatic updated at Amazon and here in list view of Sale Orders, sign will be changed in order to indicate you that order is marked as completed to Amazon.

Cancel Order at Amazon with specific reason

You can cancel any order at Amazon directly from Odoo. Once you cancel the shipment, your Order will be in Shipping Exception stage and there will be an option Cancel in Amazon will be visible in Sale Order. By clikcing on it, one pop up will be open and you will be asked to select a specific return reason. Selecting any option and clikcing on Cancel Order button will make direct update at Amazon and your order will be canceled straight away at Amazon too.

Refund the Order at Amazon from Odoo

You can refund at Amazon from Odoo. Go to menu 'Amazon >> Refund Orders >> Refund' and create new record. Select and of your Done / Shipping Exception sale 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 lines and set the refund amount by distribute it to different kind of fees and set the refund message at Amazon. In our module, we have provided 2 types of refund configuration per each Amazon Instance. Go to menu 'Settings >> Configuration >> Amazon' and select any instance from Dropdown for particular Seller. Go to bottom area and you will see Refund/Return Information setting. You can set those options as per need.

1.Auto Create Return Picking?

Once you validate your refund order, system will make auto update at Amazon and create automatic return picking in Odoo. For product to be added in Return Picking from refund order validation, it is must required that you select option either NoInventory or CustomerCancel for field Message in refund order line.

2.Auto Create Refund?

Once you validate your refund order, system will make auto update at Amazon and create a refund invoice in Odoo.

Export Shipping details with package tracking number to Amazon

For update your shipment tracking no. to Amazon from Odoo, go to delivery order and click on Validate button. There will be pop up will open with list of products to be shipped to customers. Create new destination package and select it. In that package set your parcel tracking number in Additional Reference field. Once the auto scheduled job for update shipment status will run, parcel number will automatically updated at Amazon.

Note If product type is BOM(KIT) then system will also manage in Update order status process.

Export Shipping details with package tracking number to Amazon

There is one option given in the Amazon seller settings screen: One order can have multiple tracking numbers?. In case if you are needed to manage multiple tracking numbers for the single delivery order, you can set that option at seller settings so that system will get the tracking no from Destination Package >> Additional Reference field for the particular package. However, if you don't set that option, the system will get the tracking number of particular delivery order from its Carrier Tracking Ref field.

Update Product price to Amazon

Based on Pricelist selected on each Instance, your product's price can be updated directly at Amazon. 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.

Sync Active Products

Using this process, you can synchronize the products from Amazon into 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 >> Reports >> 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 >> Sales >> Products'). 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 for to export them at Amazon, the system will create and prepare product for Amazon automatically with the matching SKUs between Amazon and Odoo.

Live (On the fly) stock update at Amazon

With this feature, once you update your delivery order, stock will be updated at Amazon instantly. You can configure this option per instance wise. In order to do this setting, you need to go to menu 'Settings >> Configuration >> Amazon' and at each instance, that option will be visible under stock information section. You can enable/disable this option at any time upon requirement.

Set automatic jobs per Instance wise

Per each Amazon Seller, you can set automatic jobs for export Stock, Order Status, Import and Process Amazon settlement reports and Import FBM Sales Orders to Odoo. In order to do this setting, you need to go to menu 'Settings >> Configuration >> Amazon' and at each seller you can see this options under Amazon Seller option. Once you set and click on Apply, you can see those schedule jobs by clicking on Amazon Cron box at Amazon dashboard. At there you can modify timings of automatic jobs upon your requirement.

Make better Sales decisions, faster.

With our amazing and advanced data visualization & discovery for your Amazon Sales, you can wow your executive team with visual representations of your FBM Sales results, create a culture of daily accountability, visualize your entire FBM sale`s health in one screen as well as save your valuable time by eliminating the need to aggregate and communicate raw data.

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 feeds history by clicking on Feed History box on Amazon dashboard. This information may useful to technical persons rather then end users.

Copy products from one Instance to other Amazon Instance

With this feature, you can direct copy all or selected products from one instance to another. So there will be no double entry to same products for another instance. In order to do this, go to menu 'Amazon >> Configuration >> Instances' and open any instance. At top side under the Action section, you will find an option Copy Products by Instance. Clicking on it, one pop up will be open to select source and destination Instances. You can select specific products to be copied by unselecting Copy All Products option.

Amazon Settlement/Payment 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. 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, in any unprocessed statement will automatically create the Amazon/Bank statement in Odoo and import all lines from the report file and set report state to Imported. In Imported state Reconcile Button will be visible, When user will click on Reconcile button system will Reconcile statement lines, Here, 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.

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.

Amazon Invoices

Amazon Invoices

Amazon Credit Notes / Refunds

Amazon Credit Notes / Refunds