Amazon Odoo Connector
Integrate & Manage your Amazon seller account operations from Odoo
It is being very much essential to integrate your Amazon seller account with Odoo, if you are a seller on Amazon Marketplace and using Odoo for all other business operations. Amazon Marketplace is Amazon.com's fixed-price online Marketplace which enables sellers to offer their new and used items alongside Amazon's regular offerings. Emipro offers an easy connector module for Amazon to manage all necessary operations from Odoo for Merchant fulfilment Network of Amazon. Our Odoo-Amazon connector module automates your vital business processes and eliminates the need for manual data entry in Odoo by enabling bi-directional data exchange between Amazon Marketplace and Odoo. Also, this module saves your time by instantly entering items and inventory data from your Odoo instance into Amazon and automatically importing Amazon orders and customer data into Odoo. After installation of our module, there is no need to log in to your Amazon account to make updates to your data.
Amazon Seller account management is so easy now in Odoo
A clean & beautiful dashboard with everything in one screen
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.
Variation Product Attribute Configuration
If you want to create Variation product in ERP, then you must first create product attributes like size,color,memory,etc. This is default feature provided by odoo. If you want to export variation products in Amazon, then you must map amazon attribute with odoo attribute. When you install Amazon module at that time system will automatically create all amazon categories & attributes, you just need to select proper category & child category (if child category is available). When you select category than after system will show you all attributes of selective category. Here you must select correct amazon attribute, otherwise when you export product in amazon then system will map wrong attribute for export in Amazon. Here we are selecting category & child category just to find an correct attribute. And if many attributes are same then user can easily find which attiribute is use for which category.
Variation Product Configuration
After configuring attributes, you need to do configuration in product. In variant tab, you must select amazon category/variationtheme. If you select Variation Theme, it means that this product will export in Amazon as Variation Product. After selecting Variation theme, you must select Parent SKU. Parent SKU is required because if one product have 6 variants then amazon will create 6 variants in amazon & create 1 product as virtual product & set Parent SKU in virtual product, Customer can not purchase virtual product from Amazon. If You not select Variation Theme then system will export as individual item in Amazon. After That In Product Attributes, you can select product Attributes, and it will load all attributes of selective category.
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 manu items.
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.
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.
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 !
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.
There is one option we have given in the Seller configuration: Allow To create a new product if not found in Odoo? In case if that option is not set and at the time of Odoo imports the sale orders from Amazon and if a particular product from that order is not available Odoo, the system will skip that order and create the mismatch log. If that option is set to true, the system will automatically create products in Odoo while inputting the sales orders from 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.
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
Odoo will do it for you. So you don't have to!
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.
Amaze Sales Analysis Reports
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 Credit Notes / Refunds
They loved this App and increased their revenue too!
For every seller in Amazon, one of the main things to take care of, is Seller Rating, and we dare to say that after implementing Emipro's module to manage Amazon related stuffs in Odoo, it boosted our seller rating to new high ! System atomization is 'key' of this module. With no fuss, we were able to use this module, and due to that, we were able to deliver goods to our customer within given timeline, and update it's status to Odoo in no time! Next great think which impressed us, are many different types of reporting, which system generates based on Amazone data. It helped us a lot to take certain decisions, and due to that, we were able to achieve our sales target, and that really huge thing for sales team. We also had many other things to manage for our ERP, and Emipro Delivered that, with conventional. As we are managing our products with third party warehouse (TPW), with the solution of Emipro, we are now managing it with ease in Odoo, and our manual work (as well as ratio of error) came down to almost 0 ! Main USP of Emipro is what we figured out, is the knowledge of ERP, and the way they handle our project, is commendable. Nothing more to say for Emipro. They are simply 'The Best' !"
-- Andreas Uhlig, +49421595740, CEO, Andreas Uhlig GmbH & Co KG, Germany
We are working with Emipro since month of August 2015 and I am really impressed by their professionalism and commitment to our Odoo project. Specially they helped me to move my whole Amazon Sales including Amazon FBA to Odoo sucessfully. I have worked with quite some companies from abroad already, but Emipro is definitely one of the most professional companies I have ever worked with. They have got very good knowledge of all e-commerce related business processes and always know a solution for each and every problem we are facing in our current business process. But what I like most about them is that they are really thinking from our business perspective. They are looking with a critical eye at each customization we are requesting and are trying to understand the purpose behind it. Often they come up with a very easy solution which did not even require any customization at all. They know Odoo very well and that helps a lot! Emipro is a young committed team with an awesome attitude! They already became a very valuable source for our business and I can recommend them to everyone who wants to integrate Odoo for their Amazon business."
-- Jonas Tank, CEO, Ecom Brands GmbH, Germany
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.