Contributions
Best Customers Upgraded Report
Upgrade to the Best Selling customers in osCommerce. Adds the # of orders the customer has placed along with the $ value of those orders. Also allows you to sort by either column and takes you directly to the customers orders if you click on the name instead of to the customers list like the old osCommerce version, very helpful for stores of all sizes.
Simple to install. Just backup and then copy over admin/stats_customers with the new version included.
| 28 Feb 2010 |
This contributions shows wrong values for some costumers (more orders than done).
So I looked in the code and changed the "group by" SQL statement. After that it seems to work right for all costumers.
In line 66 you find
[...] o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by [...]
Change this to
[...] o.orders_id = op.orders_id group by c.customers_id order by [...]
There's no file included - only this text.
All credit to homewetbar the original authors.
| 13 Sep 2007 |
| 12 Sep 2007 |
Note: Contributions are used at own risk.
