Sales Summary Report in 5.5 missing in 7.0

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Sales Summary Report in 5.5 missing in 7.0

Post by mfreeze » Tue Jun 30, 2009 8:52 am

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
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Sales Summary Report in 5.5 missing in 7.0

Post by mazhar » Tue Jun 30, 2009 9:42 am

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.

User avatar
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Re: Sales Summary Report in 5.5 missing in 7.0

Post by mfreeze » Tue Jun 30, 2009 11:02 am

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
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

Post Reply