Is "Payments Transactions View" in SP-API, or is it missing?

[johnkw]

As previously mentioned in bug #378 there isn't much documentation on reports currently. But one I'm urgently looking for is "Payments Transactions View" which is documented here in general: https://sellercentral.amazon.com/gp/help/200141650?language=en_US&ref=ag_200141650_cont_201074420

Is there a corresponding SP-API report, and if so, what is it?

Nothing on https://github.com/amzn/selling-partner-api-docs/blob/main/references/reports-api/reportType_string_array_values.md stands out as obviously it to me.

[johnkw]

According to Seller Support the answer was no that report doesn't exist in the API. I suspect they're correct.

However, much of that data does eventually go into the Settlement report (GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2), although you have to wait for the settlement period to end in order to see it.

[JungleBooks]

Any update on this? or is the transaction report still missing?

[MyRealProfit]

Any updates guys? My clients desperately need Date Range Transactions report on every day basis. Does anyone know when Transactions will be implemented in SP-API?
Thank you!!!

[github-actions[bot]]

This is a very old issue that is probably not getting as much attention as it deserves. We encourage you to check if this is still an issue after the latest release and if you find that this is still a problem, please feel free to open a new issue and make a reference to this one.

[johnkw]

This should not be closed without an answer.

The report list is now at https://developer-docs.amazon.com/sp-api/docs/report-type-values

If it's really the case that Seller Central has access to transaction reports, and SP-API does not, that's weird, and should be EXPLICITLY documented as such in the https://developer-docs.amazon.com/sp-api/docs/report-type-values list.

[vinodbhoj]

This is crazy. How are we supposed to use SP-API to get the response? Instead of downloading the report to the FTP location, do all 10,000 operations on the downloaded file. Which is a data violation to have these data on an FTP location?

Shopify is so much better. NO help from Amazon on this.

[johnkw]

We just do everything using the Settlement reports. It works fine, but it's just weird that you have to wait for these arbitrary bi-weekly time periods to happen. It should be documented.

[vinodbhoj]

@johnkw Thank you for the update.
Can you please provide the API / Summary steps you use?
I want to avoid downloading the report due to data policy. I can get Sales, discounts, and taxes. using API listFinancialEvents from SP-API

I am trying to find which elements to add/subtract from listFinancialEvents API to get a Refund. Attaching the sample request/response snippet for this API
listFinancialEvents.txt

[johnkw]

GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2

[vinodbhoj]

GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 I can download the reports. But how do I request a report for a specific date?
What should I pass in a request so that it will download report for a specific date?

[B3lg4r4th]

I'd love to bump this issue to maybe a get new information from the team about whether they're planning to introduce the SELLER_TRANSACTION_DATE_RANGE to SP-API.

[rt3722]

Please add "Payments Transactions View" to SP-API.

[napter]

If the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE report is archived, is the only option to go into the UI and click "generate report" for every single one? Is there no way to re-request the report via the API so it can be downloaded?

[johnkw]

Amazon moved the report documentation again. It's now at: https://developer-docs.amazon.com/sp-api/docs/report-type-values

Still no documentation mention of "Transaction View" (which also got renamed to that on the https://sellercentral.amazon.com/payments/event/view page).

GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE should be mentioned here since it is the only workaround to get this data, but any questions/issues on it should be deleted here and moved to a new ticket. This ticket is about "Transaction View".

[wolendranh]

@sungolivia @chrisskhoury
HI!

Any updates on "Payments Transactions View" report/API added into SP-API? This issues was created in 2021 and there is no communication from Amazon on this one.

Thank you in advance

[Philomath88]

I would also like an update

[Ridgewood1]

Any update on this one?

[shreeharsh-a]

Thank you for bringing this up. We have noted & forwarded this to the relevant team for review & action.

Note: SP API or docs related issues / troubleshooting support is managed by a different team. We can help if the issue is related to the content published on this repo.

[napter]

Thank you for bringing this up. We have noted & forwarded this to the relevant team for review & action.

Note: SP API or docs related issues / troubleshooting support is managed by a different team. We can help if the issue is related to the content published on this repo.

Is there another repo where we can communicate with that team and track this?

[johnkw]

It's great that the SPAPI team has been informed of this bug report. However it would be helpful to leave the bug open until it's fixed, so people know where to look for information on this bug.

[ronen-taktook]

I definitely agree with @johnkw
Open the issue until you fix it
Or give us a link so we can see the status

[shreeharsh-a]

@ronen-taktook Please be advised that only issues related to the content published on this repo will be tracked to closure here.

[johnkw]

Ok but keep in mind that no one cares about "selling-partner-api-models" or whatever this repo is about now. Everyone only cares about the API being functional. Can this open bug report be moved/transformed to a "discussion"?

[froilangrepo2go]

ANY UPDATES?

[stefnats]

This has been resolved with the Finances API v2024-06-19

The listTransactions operation (GET /finances/2024-06-19/transactions) provides date-range-based transaction data via postedAfter/postedBefore parameters which is essentially the programmatic equivalent of the Seller Central "Transaction View".

Docs: https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-use-case-guide
API Reference: https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-reference

You can also filter by transactionStatus (RELEASED, DEFERRED, DEFERRED_RELEASED).

Hope that helps!