Tradebox Finance Manager imports Amazon sales that are contained within the Amazon Order Report. This needs to be downloaded into a local folder on the user's PC or network prior to importing the sales into Tradebox. Tradebox can request and download a report automatically on your behalf using Amazon Marketplace Web Services (MWS) credentials; this automatic report request always contains the last 7 days worth of sales information. Our guide to setting up and using MWS is available here.
It was previously possible to manually request reports on Amazon to use with Tradebox, however due to changes Amazon have made to both merchant and FBA order reports, manually requested reports can no longer be processed by Tradebox as of July 2018.
Known Issue July 2018
Historically, the format of the two report types (automatic via MWS and manual via a user logging in to Amazon Seller Central) have followed the same format. On 27/03/2018, users began reporting a change in manually requested merchant reports (see our full article on that issue here) and this was followed by users beginning to report a similar problem with Amazon FBA reports on 26/07/2018.
If you manually request FBA reports by logging into your Amazon account and going to Reports -> Fulfillment by Amazon -> Amazon Fulfilled Shipments then you will be affected by this change.
To our best knowledge, Amazon reports requested via MWS are unaffected by the change.
What to do if you're affected?
We encourage any affected users to start using MWS to request their reports rather than downloading them manually, or alternatively, upgrade to our new software, Tradebox One, which uses a different mechanism to connect to Amazon and is therefore completely unaffected by any changes they may make to their reports.
Our guide to using MWS credentials in Tradebox Finance Manager is available here. Setting this up may require some changes to your Tradebox set up and how often you process:
- If you are using Tradebox to download both Amazon FBA and Amazon merchant orders, you will now need two channels for each Amazon marketplace you sell on with both merchant and FBA, e.g. Amazon merchant UK, Amazon FBA UK, Amazon merchant DE, Amazon FBA DE, etc. This may impact on your licence with us if adding these channels will take you over your current channel limit for Tradebox. If that's the case, please call Tradebox Support on 0191 257 4707.
- Each Amazon report contains orders for the last 7 days. This means you will need to run Tradebox at least once per week to avoid missing sales.
- Because there's an inherent delay in the requests via MWS, Tradebox will need to be open on your PC for about 40 minutes prior to download.
If you choose instead to upgrade to Tradebox One, this also requires a separate merchant and FBA channel to be set up for each Amazon marketplace you sell on. Our guide to upgrading from Finance Manager to Tradebox One is available here.