I have a heavily modded osCommerce store with a custom report script for Monthly Stats.
I need only the Monthly Stats updated.
Custom script for catalog/admin/[url removed, login to view] is attached.
Right now for totals by Customer Group it sorts by ALL CUSTOMERS, RETAIL ONLY, or NON-RETAIL only.
It currently gets this information by reading the database for the "orders" table, then it references the "customers" table to determine the Customer Group.
THE PROBLEM: Some customer records have been deleted so the report is no longer accurate because it does not include any orders where there is no customer record in the database.
THE REPORT NEEDS TO CHANGE TO HAVE IT DETERMINE THE CUSTOMER GROUP FROM THE ORDERS TABLE DIRECTLY USING THE CUSTOM FIELD ALREADY IN PLACE CALLED "group_letter"
So for RETAIL orders it would select all with group_letter R and for NON-RETAIL it would be all other orders where group_letter != R.
This is not a very complex project so please keep the bids reasonable.