View Full Version : Best Customers Upgraded Report

02-28-2010, 11:00 AM
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.

More... (http://addons.oscommerce.com/info/5417)