Manage Amazon orders in Odoo¶
Synchronization of orders¶
Orders are automatically fetched from Amazon and synchronized in Odoo at regular intervals. The synchronization is based on the Amazon status: only orders whose status has changed since the last synchronization are fetched from Amazon. For FBA (Fulfilled by Amazon), only Shipped and Canceled orders are fetched. For FBM (Fulfilled by Merchant), the same is done for Unshipped and Canceled orders. For each synchronized order, a sales order and a customer are created in Odoo if they are not yet registered.
When an order is canceled in Amazon and was already synchronized in Odoo, the corresponding sales order is canceled in Odoo. When an order is canceled in Odoo, a notification is sent to Amazon who will mark it as such in Seller Central and notify the customer.
To force the synchronization of an order whose status has not changed since the last synchronization, activate the developer mode, navigate to your Amazon account and modify the date under . Pick a date anterior to the last status change of the order that you wish to synchronize and save.
To synchronize immediately the orders of your Amazon account switch to developer mode, head to your Amazon account and click on SYNC ORDERS. The same can be done with order cancellations and pickings by clicking on SYNC CANCELLATIONS and SYNC PICKINGS.
Manage deliveries in FBM¶
When a FBM (Fulfilled by Merchant) order is synchronized in Odoo, a picking is created along with the sales order and the customer. You can either ship all the ordered products to your customer at once or ship products partially by using backorders.
When a picking related to the order is confirmed, a notification is sent to Amazon who will, in turn, notify the customer that the order (or a part of it) is on its way.
Starting from July 2021, Amazon requires that deliveries be provided with a tracking reference. This concerns all marketplaces.
If this is not already done, you need to install the Delivery Costs module in order to provide the tracking reference. There is unfortunately no workaround to comply with this new Amazon policy.
Follow deliveries in FBA¶
When a FBA (Fulfilled by Amazon) order is synchronized in Odoo, a stock move is recorded for each sales order item so that it is saved in your system. Inventory managers can find such moves in. They pick up products in a specific inventory location called Amazon. This location represents your stock in Amazon’s warehouses and allows you to manage the stock of your products under the FBA program.
To follow your Amazon (FBA) stock in Odoo, you can make an inventory adjustment after replenishing it. You can also trigger an automated replenishment from reordering rules on the Amazon location.
The Amazon location is configurable by Amazon account managed in Odoo. All accounts of the same company use the same location by default. It is however possible to follow the stock by marketplace. First, remove the marketplace for which you want to follow the stock separately from the list of synchronized marketplaces. Then, create another registration for this account and remove all marketplaces, except the one to isolate from the others. Finally, assign another stock location to the second registration of your account.
Issue invoices and register payments¶
You can issue invoices for Amazon orders in Odoo. Click Create Invoice in the sales order to do so. You can also do it in batch from the list view of orders. Then, confirm and send the invoices to your customers.
To display only Amazon-related orders on the list view, you can filter orders based on the sales team.
As the customer has paid Amazon as an intermediary, you should register invoice payments in a payment journal dedicated to Amazon (e.g. Amazon Payments, with a dedicated intermediary account). You can do the same with the vendor bill received from Amazon and dedicated to commissions. When you receive the balance on your bank account at the end of the month and record your bank statements in Odoo, you simply credit the Amazon intermediary account by the amount received.
Follow your Amazon sales in sales reporting¶
As a sales team is set on your account under the tab Order Follow-up, this helps you give quick glances at the figures in just a few clicks in Sales reporting. By default, your account’s sales team is shared between all of your company’s accounts.
If you wish, you can change the sales team on your account for another to perform a separate reporting for the sales of this account.
It is also possible to perform reporting on a per-marketplace basis in a similar fashion. First, remove the marketplace you wish to track separately from the list of synchronized marketplaces. Then, create another registration for this account and remove all marketplaces, except the one to isolate from the others. Finally, assign another sales team to one of the two registrations of your account.