Suggestions - Correct inaccurate Sales Report Totals

Print Page | Close Window

Correct inaccurate Sales Report Totals

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Suggestions
Forum Description: ProductCart Suggestions
URL: https://forum.productcart.com/forum_posts.asp?TID=4391
Printed Date: 09-May-2024 at 6:59pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Correct inaccurate Sales Report Totals

Posted By: mattprice
Subject: Correct inaccurate Sales Report Totals
Date Posted: 26-March-2011 at 6:45am

The Sales Reports in Productcart, whilst very extensive in their variety, do not reflect the final sales price accurately.

We make extensive use of Quantity Discounts throughout nearly all of our products but all of the sales reports in Productcart base their totals on the base price of a product. This means that the Sales Reports are always overinflated.

I also note the reports do not take into account when a customer uses a discount code. This too makes for an innacurate Sales Report.

Thanks

Matt

Replies:

Posted By: ProductCart
Date Posted: 27-March-2011 at 4:38am

We are aware of the issue with quantity discounts and we will try to address it in the next release.

Different is the issue with discount codes. That a much trickier one. If there were 10 products purchased and a $10 coupon, do you subtract $1 from each of the 10 products purchased? That would not be accurate. We believe that with discount codes it is more accurate to leave product sales "as is", and only adjust overall sales.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: mattprice
Date Posted: 29-March-2011 at 2:59am

I agree with the discount code problem but would welcome a change to the reports that factors in quantity discounts.

Many thanks

Matt

Posted By: mattprice
Date Posted: 30-July-2011 at 6:59am

I know I probably should be able to figure this out myself but please can you let me know whether the Monthly Sales total on the admin home page are correctly calculated for quantity discounts ?

Matt

Posted By: Dayv3
Date Posted: 12-August-2011 at 12:41am

If you want to take this a step further, the sales total also includes the
shipping fees which are a pass thru expense.

Dave

Posted By: Hamish
Date Posted: 12-August-2011 at 10:50am

Hi Dave, this may well be true on your store, but other stores operate differently, making a profit, or a loss on shipping.

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code