Seller Central
Seller Forums

Amazon Seller Forums » Amazon Marketplace Web Service (MWS) » Marketplace Web Service (Amazon MWS) Questions

Thread: Unable to filter Removal Orders Report by marketplace
This question is not answered.


Permlink Replies: 8 - Pages: 1 - Last Post: 14 Jan, 2018 11:47 AM by: SellerLegend Threads: [ Previous | Next ]
SellerLegend

Posts: 7
Registered: 06 Jan, 16 11:37 AM
Posted on: 10 Jan, 2018 2:27 AM  
Click to report abuse...   Click to reply to this thread Reply
Trying to filter _GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA_ by marketplace, however, the report we get is the same for any EU marketplace we request.

For example, we requested a report for the UK marketplace, followed by a request for the ES marketplace. Both reports had same from and to dates. But their outcome is same. UK/GBP removal orders are also present in Spain report.

Anyone else having the same issue?
Is this a helpful question? Yes 0   No
8 Replies
Sort replies by:
SellerLegend

Posts: 7
Registered: 06 Jan, 16 11:37 AM
Posted on: 10 Jan, 2018 3:10 AM   in response to: SellerLegend in response to: SellerLegend  
Click to report abuse...   Click to reply to this thread Reply
Here's the invocation code for ES marketplace, (with credentials nullified of course)

$access_key = "";
$secret_key = "";
$auth_token = "";
$merchant_id = "";

$APPLICATION_NAME = "";
$APPLICATION_VERSION = "";

$service = new MarketplaceWebService_Client(
$access_key,
$secret_key,
[
'ServiceURL' => "https://mws-eu.amazonservices.com/",
'ProxyHost' => null,
'ProxyPort' => -1,
'ProxyUsername' => null,
'ProxyPassword' => null,
'MaxErrorRetry' => 10,
],
$APPLICATION_NAME,
$APPLICATION_VERSION
);

$request = new MarketplaceWebService_Model_RequestReportRequest();

$request->setMWSAuthToken($auth_token);
$request->setMerchant($merchant_id);

$marketplaceIdArray = array("Id" => array("A1RKKUPIHCS9HS"));
$request->setMarketplaceIdList($marketplaceIdArray);
$request->setReportType("_GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA_");

$request->setStartDate("2017-01-01 00:00:00");
$request->setEndDate("2017-01-31 23:59:59");
$response = $service->requestReport($request);

We have also tried on scratch pad with the same results.
Was this reply helpful? Yes 0   No 0
Buildcom

Posts: 257
Registered: 24 Jan, 13 8:32 PM
Posted on: 10 Jan, 2018 10:30 AM   in response to: SellerLegend in response to: SellerLegend  
Click to report abuse...   Click to reply to this thread Reply
Whats the markeplace id you are using for the UK?
Was this reply helpful? Yes 0   No 0
Oneida Books

Posts: 23,177
Registered: 04 Mar, 12 10:55 PM
Posted on: 10 Jan, 2018 11:31 AM   in response to: SellerLegend in response to: SellerLegend  
Click to report abuse...   Click to reply to this thread Reply
This has the Marketplace set to = A1RKKUPIHCS9HS or ES
$marketplaceIdArray = array("Id" => array("A1RKKUPIHCS9HS"));
So are you changing it ?
Was this reply helpful? Yes 0   No 0
SellerLegend

Posts: 7
Registered: 06 Jan, 16 11:37 AM
Posted on: 10 Jan, 2018 12:35 PM   in response to: Oneida Books in response to: Oneida Books  
Click to report abuse...   Click to reply to this thread Reply
Thanks for your interest, Oneida and BuildCom.

Yes, we do change the Marketplace to A1F83G8C2ARO7P for the UK. And also, we use the proper marketplace ids for DE, FR, IT, like so:

France
A13V1IB3VIYZZH

Germany
A1PA6795UKMFR9

Italy
APJ6JRA9NG5V4
Was this reply helpful? Yes 0   No 0
Buildcom

Posts: 257
Registered: 24 Jan, 13 8:32 PM
Posted on: 10 Jan, 2018 4:34 PM   in response to: SellerLegend in response to: SellerLegend  
Click to report abuse...   Click to reply to this thread Reply
How are you retrieving the report? Maybe the retrieve request has the same report id and its not being updated?
Was this reply helpful? Yes 0   No 0
SellerLegend

Posts: 7
Registered: 06 Jan, 16 11:37 AM
Posted on: 10 Jan, 2018 10:08 PM   in response to: Buildcom in response to: Buildcom  
Click to report abuse...   Click to reply to this thread Reply
We actually save the request id to database, then another script gets the status of the request and gets report id when the status is DONE, and then we retrieve the report. We had checked, we are passing correct report id.
Was this reply helpful? Yes 0   No 0
Buildcom

Posts: 257
Registered: 24 Jan, 13 8:32 PM
Posted on: 12 Jan, 2018 10:23 AM   in response to: SellerLegend in response to: SellerLegend  
Click to report abuse...   Click to reply to this thread Reply
I would try using scratchpad to see if the result is the same. If it is you will need to open a support ticket within seller central.

https://mws.amazonservices.com/scratchpad/index.html

Was this reply helpful? Yes 0   No 0
SellerLegend

Posts: 7
Registered: 06 Jan, 16 11:37 AM
Posted on: 14 Jan, 2018 11:47 AM   in response to: SellerLegend in response to: SellerLegend  
Click to report abuse...   Click to reply to this thread Reply
Thanks, Buildcom. As explained in the previous post, we had already tried scratchpad and got the same result.

We had opened a case with MWS support already, and here's the response we received yesterday:

"Hello,

In the EU, specifying marketplace will not affect the outcome of some reports. This is one where all marketplaces will be returned regardless of specified marketplace. This is not an issue with the API, as it was designed to do this."

To which we respectfully inquired:

"Thanks Yusuf.

How do the MWS API designers then suggest we distinguish which removal orders belong to which marketplace. Furthermore, as you said, this is not the only report where that behaviour is displayed. For example, inventory reports have the same issue. So then, how are we to distinguish what inventory belongs to which EU marketplace?"

We are awaiting a response.
Was this reply helpful? Yes 1   No 0