Retrieving list of Amazon Payments taken for orders within date range

Question

I need to write a program that imports payments taken via amazon for items we sell on the Amazon website into our system.

According to the Amazon Marketplace Web Service site i can get this information:

Amazon Marketplace Web Service (Amazon MWS) is an integrated Web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.

However, i can't find anything about this at all. None of the client libraries appear to have anything about retrieving a list of payments.

How can i get a list of payments made via amazon, preferably using the Amazon Marketplace Web Service?

Answer 1

Based on your comment to the answer provided by fmr, I would suggest that you use the MWS Orders API to get "current/live" data.

Using the ListOrders request with the OrderStatus parameter set to Shipped will give you a list of orders that have, for all intents and purposes, been paid for (not exactly, but read on).

When an OrderStatus is set to Pending the buyer's payment instrument (ie. credit card) has not yet been approved by Amazon and the order cannot be shipped. When the status moves to Unshipped the payment instrument has been approved and the order can be shipped. When the order is shipped and the seller (you) have confirmed the shipment, the buyer's payment instrument is "charged", the OrderStatus is set to Shipped and the funds are available in Seller Central for you to disperse. The dispersing of funds is when you actually get the money (well, in 3-5 business days).

Settlement Reports are generated every 14 days by Amazon and can't be scheduled. So, to get around this you could use the above technique to see the account activity based on the items you've sold.

Answer 2

Using MWS, you can programmatically retrieve the settlement report which is produced monthly by Amazon. This is the same settlement report that you would download from Seller Central. The report type you're looking for is: _GET_FLAT_FILE_PAYMENT_SETTLEMENT_DATA_ (for the CSV format).