Use of ReportRequest for multiple report

[Oceanicasa]

Hi all,

After many attempts, i managed to work with seller fulfilled orders using mws api, but now i want to get all fba orders also.

for seller fulfilled orders I am using, RequestReportSample.php , GetReportRequest & GetReport successfully. My system is working proper.

After studying about FBA order reports, I came to know RequestReport operation call is being used. Today when i was trying with RequestReport for FBA orders, my cron missed generated Report ID for Non FBA to be pulled for GetReport & my system missed fetching orders.

So basically i want to know how can I use RequestReportSample.php for multiple reports.

I also read i can use ManageReportSchedule but i am confused using it.

Please help me the best way out to get all orders. FBA+Non FBA using mws.

I have just started using MWS and getting non FBA is my first step. Need to get the knowledge of it more.

Thanks & Regards,
Oceanicasa.

[Buildcom]

So basically i want to know how can I use RequestReportSample.php for multiple reports.

Just make multiple request one per report.

I also read i can use ManageReportSchedule but i am confused using it.

This is so that you can schedule a specific report to run at specific time(s). Then you won’t need to request the report. You can then just search for the report type and look for any that haven’t been acknowledged. (This assumes you acknowledge a report once you have processed it)

Please help me the best way out to get all orders. FBA+Non FBA using mws.

You didn’t provide which reports you are using right now to retrieve this information. So I’m not sure as I am not familiar with FBA. But we pull Non FBA orders by leveraging a scheduled GET_ORDERS_DATA report.

[Oceanicasa]

Hi,

Just make multiple request one per report.
: I did it , In request i set GET_AMAZON_FULFILLED_SHIPMENTS_DATA but when when i tested it with amazon scratchpad, I saw that it gets cancelled.
In testing i make the request for : GET_AMAZON_FULFILLED_SHIPMENTS_DATA
in next step when I run GetReportRequestListSample.php to check the processing status of request, it shows

    <ReportType>_GET_AMAZON_FULFILLED_SHIPMENTS_DATA_</ReportType>
    <ReportProcessingStatus>_CANCELLED_</ReportProcessingStatus> 

and

 <ReportType>_GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_</ReportType>
<ReportProcessingStatus>_DONE_</ReportProcessingStatus>

I also noticed that the element in response is also set to true. I checked in ManageReportScheduleSample.php for scheduled information, but it is not set. I am confused from where it is getting called.

Thanks,
Oceanicasa

[Buildcom]

So the specific report you are trying to request has special requirements.

A near real-time FBA report is generated no more than once every 30 minutes. This means that after a near real-time FBA report is generated following your report request, a 30-minute waiting period must pass before Amazon will generate an updated version of that report. Note that the four “All Orders” reports are not subject to this limitation.

Content updated near real-time in Europe (EU), Japan, and North America (NA). In China, content updated daily. For FBA sellers only. For Marketplace and Seller Central sellers.
Note: In Japan, EU, and NA, in most cases, there will be a delay of approximately one to three hours from the time a fulfillment order ships and the time the items in the fulfillment order appear in the report. In some rare cases there could be a delay of up to 24 hours.

http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html

[Oceanicasa]

Yes,

But i could check that FBA reports are getting generated every 15 minutes and all those reports are giving “cancelled” & “No Data Available”.

I am unable to locate from where it is being called. I checked in ManageReportScheduleSample.php also it is not set there even. I guess because of this recurring generated request only my script request is getting cancelled.

[Buildcom]

These I believe are generate by Amazon so you have no control over them.

[Oceanicasa]

Then how would I pull the orders. have you implemented this? Any other suggestion ?

[Buildcom]

Wait did you use the ManageReportSchedule or the GetReportScheduleList to check for the schedule? Because the former is to modify the schedule and the latter actually shows you the schedule.

[Oceanicasa]

GetReportScheduleList

I run this and got that the two reports are getting generated at every 15 minutes.
Please see the below response on : GetReportScheduleList

<GetReportScheduleListResponse xmlns="http://mws.amazonaws.com/doc/2009-01-01/">
  <GetReportScheduleListResult>
    <HasNext>false</HasNext>
    <ReportSchedule>
      <ReportType>_GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_</ReportType>
      <Schedule>_15_MINUTES_</Schedule>
      <ScheduledDate>2018-12-01T04:38:06+00:00</ScheduledDate>
    </ReportSchedule>
    <ReportSchedule>
      <ReportType>_GET_AMAZON_FULFILLED_SHIPMENTS_DATA_</ReportType>
      <Schedule>_15_MINUTES_</Schedule>
      <ScheduledDate>2018-12-01T04:51:37+00:00</ScheduledDate>
    </ReportSchedule>
  </GetReportScheduleListResult>
  <ResponseMetadata>
    <RequestId>4e7862e3-d00e-45c4-ba38-e6222ef6d34f</RequestId>
  </ResponseMetadata>
</GetReportScheduleListResponse> 

I don’t know from where to stop this. Please guide.

Thanks,
Oceanicasa.

[Buildcom]

You would modify it by using the ManageReportSchedule. However if its there someone must have scheduled it and I would check with them before making any modifications.

http://docs.developer.amazonservices.com/en_US/reports/Reports_ManageReportSchedule.html

[Oceanicasa]

Yes… After checking with all, i could manage it to stop. And now it is giving me proper report response. Thank you so much for guiding.