We charge a minimal annual fee to register on our site forum. To manage subscription payments (mostly for individuals who don't consistently sign up year over year), I need to get a listing of past, historical invoices and associated data. I wnat to look at whether they were paid or not and look at payment trends year over year.

1. Is there a widget available that I could use to get invoice history (member ID, invoice ID, invoice date, invoice amount, payment status, payment date) onto a custom page

2. Or, is there a way to get this historical invoice data exported

3. Or, is there an API call I can make to retrieve this information?

4. Or, other ideas without having to scan the invoice history page by page?

Thanks for your input.

There isnt really a way you are going to be able to get this directly from the admin CP, other than from the invoice page, as you are not just looking for sales, but rather missed sales. Getting a list of sales you can do from Statistics>Sales in the admin CP, just click to show it in table view, and you can export to CSV.

In terms of being able to get data via API, you could use the rest API to get information from commerce

https://invisioncommunity.com/developers/rest-api/index/

Thanks for the suggestion Marc; however, the Statistics/Sales/Sales and the Statistics/Sales/Income reports only provide the date and # of subscriptions on that date and have no reference to the member/customer.

1. Would it be difficult to add a Download feature to the Commerce/Payments/Invoices and take advantage of the "Download Member List" feature code.

2. On the Commerce/Payments/Invoices view, could you add the member/customer ID to the view so that the invoice can be associated to the member ID when copied/pasted from the view itself. The member can change their Display Name over time.

Hi Marc, any update?

As mentioned above, there isnt a way in which to do this currently. I would suggest adding a suggestion to the feedback forum. Im not one of the devs myself here, so how hard it is to do, isnt something I can really comment on