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
Sales Summary Report in 5.5 missing in 7.0
- mfreeze
- 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
Mary E Freeze
Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development
http://www.ffgraphics.com
Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development
http://www.ffgraphics.com
Re: Sales Summary Report in 5.5 missing in 7.0
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.
- mfreeze
- 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
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
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
Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development
http://www.ffgraphics.com