AbleCommerce Shopping Cart Software

In Able Commerce 5.5 there was a very nice Sales Summary Report as shown below. This report is missing in 7.0. Is there a simple way to produce it?

Sales Summary for xxxxxxxx

Report Period: from to (mm/dd/yyyy)


--------------------------------------------------------------------------------

Results from 06/23/2009 to present:
Product Sales: .................. 15,052.45
Product Discounts: .................. 0.00
Product Sales Less Discounts: .................. 15,052.45
GiftWrap Charges: .................. 27.65
Coupons Redeemed: .................. -436.73
Taxes Collected: .................. 0.00
Shipping Charges: .................. 878.75
Total Receivables: .................. 15,522.12

Total Number of Orders: .................. 185
Total Items Sold: .................. 322
Number of Customers: .................. 180
Average Order Amount: .................. 83.90

You can try to create your own report for AbleCommerce7. All you need is to place two calendar controls on your report, for this you can take help from existing reports. Then you need to write a query that loads order by comparing order date within defined range. Once order are loaded then you can process those orders to extract your desired information.

We have created some custom reports including one we are working on now to emulate the sales breakdown by variant (Product Breakdown in 5.5) but my clients are complaining about charges to implement ones that were standard in 5.5. I have to charge them whatever it costs for my or one of my staff's time to recreate these reports. Programmers don't work for free.

I thought maybe Able had a quick way to reproduce this report since it was a standard report in 5.5. It seems like there are a lot of reports that were standard in 5.5 that are not available in 7.0. Some of these are ones my customers depend upon to do business and they are of the opinion that they should have been ported in some format to 7.0.

You can see what I mean from the following list of reports available from the 5.5 admin. I know some of them have been replaced or are accessed from different areas but some are just not there. The two I receive the most complaints about are the sales summary and the product breakdown (which showed variations) but I never know when a customer converting from 5.5 is going to tell me they need one of the other missing ones.

Available Reports For Serene Comfort


Summary Reports
Sales Summary
Product Breakdown
Shipping Breakdown
Taxes Breakdown
Affiliates Sales
Vendor Sales
Inventory Report
Coupon Summary Report
Coupon Detail Report
Abandoned Baskets Report
Gift Certificates Summary
Custom Reports

Statistics Reports
Abandoned Products
Popular Products
Biggest Customers
Sales History

Activity Reports
Activity Summary
Browser Types
Referring Pages
Download Logs