AbleCommerce Shopping Cart Software

Hello,

Is there a way to download the reports from the admin, for example Monthly sales, or Product Sales Breakdown, etc. from the backend into a CSV/excel format?

Thanks

Out of the box there is no way of downloading the reports. I think this could be accomplished with some custom code. I have posted a sample which provides order feeds to vendors here viewtopic.php?f=47&t=12877

So you can write something similar to expose your reports. The trick would be to have a protected feed for reports which on back end query AbleCommerce reports with supplied dates. You can have a look at the code of these reports to get an idea how these reports are querying back end code. Then all you need is to put some code to do reporting work through code instead of UI and publish RSS for returned results. RSS feeds are the XML documents so you can save them locally .

A more appropriate solution is to use some code to output a CSV file and stream it to your browser so that it will automatically downloaded. This CSV creation/Save work I guess is being done on Email List page so you can use that as sample. So have a look at desired reporting code in report it self and then query back end code in same way and create CSV for outputted results and stream it to browser.

TTMedia,

I don't know if you found a solution to your sales download issue. We had some customers with similar download needs as yours. We've built a few new and enhanced reports that can let you view sales across any time period and download that information in CSV or Excel format. There are also some other reports to let you view and download your customer and sales data. You can see some screen shots and sample downloads on our website at:

http://www.ecombuildertoday.com/ablecommerce-reports

Full source code is included if you need to make any modifications or we can help you with that, too.