Link Search Menu Expand Document
Amazon Odoo Connector
User Guide
Odoo Version Contact Us

FBA Shipment Report


  • Amazon Shipment Report provides comprehensive details of Orders which are Shipped by Amazon FBA (Fulfilment 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:(refer FBA Selller configuration)

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 product 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 from Amazon ↣ Configurations ↣ Settings ↣ Amazon Seller. 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 ↣ Orders​.


How the Shipment Report is Processed in the System


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 during 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.


Request and Process Shipment Report


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

1. Manually through Operations:

  • Go to ​Amazon ↣ Operations​.
  • Select the respective Amazon Seller
  • Select FBA Operation
  • Select Operation for Import FBA shipped orders
  • 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.
  • Click on the Excute button


You can view all the generated Shipment reports from ​Amazon ↣ FBA ↣ Orders & Returns ↣ Shipment Reports.

Process to be followed:

  • When you click on Execute button you can see the Check Status button will be visible on screen.
  • It will take a few seconds to process your request at Amazon server
  • 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 and Process File.
  • You can download that report by clicking on the Download Report but report data is encrypted.
  • Just click on Process File 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 Odoo.
  • Top right side you can see the Two smart button as Sales Orders and Stock moves with help of those buttons you can redirect on the FBA sales orders.


Tip

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.


Note

*Sometimes seller may receive Fatal or cancel status of this reports.

Fatal status: Seller can get Fatal status for two reasons.

  1. Seller has made the same exact request too many times in a row.
  2. There is no data available for the date range specified.

Cancel status: When Seller already have data in your Odoo environment, the connector will cancel any duplicate reports.

Table of contents