Amazon FBM Order Report
Retrieving shipping information from Amazon manually.
If you are unable to obtain a Restricted Data Token from Amazon to retrieve shipping address information automatically via CSM, it is necessary to download an order report containing this information from your Amazon Seller Central account, then import this report into Business Central:
- Log into your Amazon Seller Central
- Choose the Orders menu item located along the top of your dashboard, then choose the Order Reports option
- On the Order Reports page, choose the Unshipped Orders tab
- In the Request Report area, choose the Request button. This will create a new report line in the Download Report area. It may take up to 45 minutes for Amazon to generate the new report.
- Choose the Refresh button in the Download Report area to refresh the report line.
- When the report has been generated, a new Download button will be added in the Download column. Choose this button to download the report to your machine.
Now that you have an order report, you must import it into Business Central:
- Open your Amazon FBM sales channel
- Choose the Actions ribbon, then choose Import Order Report
- In the Import Buyer Address window, enable the Release Orders field if you want to instruct CSM to release each CSM order’s related sales order as part of the import process.
- In the File field, use the AssistButton to open a file directory
- Navigate to the location of the order you downloaded above, select it, and then choose Open
- In the Import Buyer Address window, choose OK
CSM imports the selected file and updates the address information on the relevant CSM orders accordingly. In turn, the related Business Central sales orders are also updated.
Note: the order report file you import must include order IDs for each Amazon order; if the order ID is not present in this file, the import process will fail. While the order ID is the only mandatory value, other values such as the buyer name and address are recommended; if these values are not present in the order report file, CSM will alert you to these missing values and give you an option as to whether you wish to continue with the import process.
For more information on how to configure and download order reports in the Amazon Seller Central interface, see here.