Amazon Shipment Report provides comprehensive details of Orders which are Shipped by Amazon FBA (Fulfillment By Amazon) including price, quantity, tracking numbers and shipping info.  

You can download a Shipment Report from Amazon either automatically or manually for specific date periods. System will request, download and process it and change the states of your FBA Orders (If any pending FBA orders) and update tracking information in Orders respectively.

Configurations to be ensured before processing shipment report: 

 

• Tax configurations of Odoo:

While importing orders, the system will apply tax based on your product and fiscal position configuration.

• Product:

At the time of processing shipment report If the product not found in Odoo and you have configured auto create true in Amazon Settings, then the system will create a new product automatically and create orders.

• Amazon FBA Order Prefix:

Before processing orders check the configuration of prefix and default sequence of Odoo in Amazon ↣ Configurations ↣ Amazon Settings. You will be able to locate it under the FBA Orders section.

Once you process the shipment report, you will be able to see your FBA orders under ​ Amazon ↣ Sales ↣ FBA ↣ Sales Orders ​.

---

Order:

While processing the report, first system will check whether any pending order is available. If it is available then the system will delete the pending order and create new order. No duplicate orders will be created while this process.

Stock Move:

After creating an order in odoo, the system will create stock moves for orders and done stock moves based on the availability of stock in the respective stock locations. The state of the stock moves will depend on odoo’s default workflow, when the stock is not available.

Warehouse:

In the shipment report we get details of the marketplace and fulfilment centre. While processing the order system will search the marketplace and warehouse in odoo based on fulfilment centre code. If it is found then the system will select warehouse or FBA warehouse (Based on marketplace configuration).

Tax calculation:

In this connector, there is a functionality to detect fiscal position based on fulfilment warehouse country. For this user needs to ensure that their fiscal positions are configured properly in Accounting ↣ Configuration ↣ Fiscal Position.  

Whenever an order is imported, the system checks if it is an Amazon order. If not, it will use the default fiscal position setting of Odoo.

Below are the steps showing how the fiscal position is applied to the Amazon orders.

• Find the fiscal position where both the origin country and country are set.
• Find the fiscal position only for the country.
• Find the fiscal position where the origin country and the country group are set.
• Find the fiscal position only for the country group.
• Find the fiscal position only for the origin country.

Note

The first fiscal position that was acquired in the above steps will be applied to the sale order.

The origin country is the country set in the warehouse.

Based on the delivery address, the country and country group is searched.

---

There are 2 ways to request and process shipment report in the system: 

 
1. Manually request and download shipment report: 

Go to Amazon ↣ Operations ↣ Select seller ↣ Select operation for FBA ↣ Shipment Report​

The system will select the start date and end date. The end date is the current date and start date is the difference between the Current Date & Default Shipment Request Report Days. By default, the user can configure Shipment Request Report days in Amazon Seller. Default days to request a report is set for 3 days in the connector.

You can view all the generated Shipment reports from ​Amazon ↣ FBA ↣ Orders and Returns ↣ FBA Shipments

 
Process to be followed: 

• When you click on Request report, Check Status button will be visible on screen.
• It will take a few seconds to process your request at Amazon. Now, click on Check Status button, if the report is still not done from Amazon side then the status will be ‘In Progress’.
• Once the report is available the status will be changed to ‘Done’ and Get Report button will be visible.
• Click on Get Report to import Report in Odoo.
• After clicking on Get Report, two buttons will be visible. Download Report & Process File.
• You can download that report by clicking on the Download Report. Just click on “Process Report” to process the file.

After Processing the report, the system will create orders, process delivery orders, create invoices and validate invoices based on auto workflow configuration.

Now, the system will show two buttons Reprocess file and Mismatch details.

• Reprocess File: ​User can reprocess file if products are missing in Odoo. After creating products just reprocess file to fetch the orders for those products. 

• Mismatch details: User can see mismatch details and correct them, like products not found in ERP. 

NOTE

If you have enabled VCS feature then the system will not create invoices while processing shipment report. Instead, Invoices will be created when you import a VCS report from Amazon.

2. Automatically through scheduler: 

You can configure a scheduler under the menu ​Amazon ↣ Configuration ↣ Sellers ↣ FBA scheduler 

---