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 automatically canceled in Odoo.
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 pickings by clicking on 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.
Amazon requires to provide a tracking reference with each delivery. You’ll need to assign a carrier. If the carrier doesn’t automatically provide a tracking reference, you’ll need to set one manually. This concerns all marketplaces.
If your chosen carrier isn’t one supported by Odoo, you can still create a carrier bearing its name (e.g. create a carrier named
Colissimo). This name is case insensitive, but be careful about typos, as Amazon won’t recognize them.
Create a delivery carrier named
Self Deliveryto inform Amazon that you make your own deliveries. You still have to enter a tracking reference.
Keep in mind that the customer is notified by email about the delivery, and the carrier and tracking reference are displayed in the email to the customer.
Manage errors when synchronizing deliveries¶
Sometimes, Amazon can fail to correctly process all the information sent by Odoo. In this case, Odoo sends an email listing all the shipments that failed and the errors Amazon sent with them. In addition, these shipments are flagged with a Synchronization with Amazon failed tag.
Usually, the error can be corrected directly in the Amazon backend or in Odoo. If the problem is corrected in Odoo, synchronize the shipment again using the Retry Amazon Sync button.
It might happen that Odoo receives a notification from Amazon saying that some delivery information was not processed, but without specifying which shipments were affected. In that case, all the shipments in an unknown state will be treated as if they failed to synchronize. Once Odoo receives a notification from Amazon saying that a shipment was processed, its tag will change to Synchronized with Amazon. To speed up this process, on your Amazon account, click on Sync Orders to manually synchronize these orders, or click on Recover Order and enter the relevant Amazon Order Reference.
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¶
Sending invoices to Amazon customers directly from Odoo is not feasible due to Amazon’s policy of not sharing customer email addresses. Instead, it is possible to manually upload the invoices generated on Odoo to the Amazon backend.
In addition, for your B2B clients, it is currently required to manually retrieve VAT numbers from the Amazon backend before creating the invoice in Odoo.
For TaxCloud users: invoices created from Amazon sales orders are not synchronized with TaxCloud, since Amazon already includes them in its own tax report to TaxCloud.
As customers pay Amazon as an intermediary, creating a dedicated Bank journal (for example, named
Amazon payments) with a dedicated Bank and Cash intermediary account is recommended.
In addition, as Amazon makes a single monthly payment, selecting all the invoices linked to a single
payment is necessary when registering payments. Use the dedicated
Journal and select Batch Deposit as the Payment Method. Then,
select all the payments generated and click .
The same can be done with vendor bills from Amazon dedicated to commissions. When the balance is received in the bank account at the end of the month and the banks statements are recorded, 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.