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.
Expand All / Collapse All
You can find this file in a French version with the addition of customer email address can send mail from this page.
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.
Small upgrade from v1.0. This version allows you to click on customer name and go directly to customer screen or click anywhere else and go directly to their orders.
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.
Note: Contributions are used at own risk.