Which ReportType should I use for getting daily and weekly sales data?

[Hippo_Sak]

Is it a report or do I have to create new pivot table to get the numbers?

[Buildcom]

You should probably leverage _GET_FLAT_FILE_ORDERS_DATA_. You can provide a start and end date.

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

[Hippo_Sak]

Are you sure? I got no data returned.

<HasNext>false</HasNext>
<ReportRequestInfo>
  <ReportType>_GET_FLAT_FILE_ORDERS_DATA_</ReportType>
  <ReportProcessingStatus>_DONE_NO_DATA_</ReportProcessingStatus>
  <EndDate>2018-06-17T07:00:00+00:00</EndDate>
  <Scheduled>false</Scheduled>
  <ReportRequestId> ************** </ReportRequestId>
  <StartedProcessingDate>2018-07-03T20:44:39+00:00</StartedProcessingDate>
  <SubmittedDate>2018-07-03T20:44:35+00:00</SubmittedDate>
  <StartDate>2018-06-10T07:00:00+00:00</StartDate>
  <CompletedDate>2018-07-03T20:44:44+00:00</CompletedDate>
</ReportRequestInfo>

[Buildcom]

Not sure why you are getting no data.
RequestReport

<?xml version="1.0"?>
<RequestReportResponse xmlns="http://mws.amazonaws.com/doc/2009-01-01/">
  <RequestReportResult>
    <ReportRequestInfo>
      <ReportType>_GET_FLAT_FILE_ORDERS_DATA_</ReportType>
      <ReportProcessingStatus>_SUBMITTED_</ReportProcessingStatus>
      <EndDate>2018-06-17T07:00:00+00:00</EndDate>
      <Scheduled>false</Scheduled>
      <ReportRequestId>xxxxxxxxxx</ReportRequestId>
      <SubmittedDate>2018-07-03T20:56:06+00:00</SubmittedDate>
      <StartDate>2018-06-10T07:00:00+00:00</StartDate>
    </ReportRequestInfo>
  </RequestReportResult>
  <ResponseMetadata>
    <RequestId>xxxxxxxxxxxx</RequestId>
  </ResponseMetadata>
</RequestReportResponse>

GetReportList

<?xml version="1.0"?>
<GetReportListResponse xmlns="http://mws.amazonaws.com/doc/2009-01-01/">
  <GetReportListResult>
    <HasNext>false</HasNext>
    <ReportInfo>
      <ReportType>_GET_FLAT_FILE_ORDERS_DATA_</ReportType>
      <Acknowledged>false</Acknowledged>
      <ReportId>xxxxxxxxxx</ReportId>
      <ReportRequestId>xxxxxxxxxxxx</ReportRequestId>
      <AvailableDate>2018-07-03T21:00:16+00:00</AvailableDate>
    </ReportInfo>
  </GetReportListResult>
  <ResponseMetadata>
    <RequestId>xxxxxxxxxxxx</RequestId>
  </ResponseMetadata>
</GetReportListResponse>