This is a discussion on Customer Order Totals Report within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; Okay, I loath this report. It's totally useless, expecially when you have been running a store for a while. So, ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| Okay, I loath this report. It's totally useless, expecially when you have been running a store for a while. So, I have been rethinking how to make this useful (remember, I wrote the recover cart sales initially, so I am a big believer that people that run stores really know what they want, since I run one). Now the way I see it, this can be a useful report. But the way it works now it provides no useful information that I can get from it. So, I was looking in the database and decided to take a stab at making it useful, but before I start to code the sucker, I want to make sure that I have thought of everything. So, here are the changes. It will still list the columns it has but... 1) add new columns. A) Total number of orders B) Average order size C) Average items per order (possible addition in v2) - may add some intense processing time as it will require a different table to be open and opperated on D) Date of Last Order 2) Make each column sortable 3) Set a date range (ie: last 120 days) 4) Number of items per page I would like to also be able to add some "action" to this. Maybe the ability to create a "customer list" from this by select box and be able to "import" that list to the coupon system so I can send my best customers as I define them a coupon. Or be able to use a drilldown that will show the most common items purchased between the selected customers to see if they are selecting featured or special items, etc. Like I said, the current report really doesn't tell me what is happening in the store, but I think that basic idea of knowing who your "best customers are" is important. So, here you have a chace to add your $0.02 before I start to hack at the report and add some meat to its bones.
__________________ so endith the lesson<think>sometimes I just sit's and thinks</think> "Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB |
| Sponsored Links | ||
| ||
|
#2
| |||
| |||
| Your report idea sounds great! A question. When you say you want to >>"import" that list to the coupon system>> do you mean import the e-mail addresses so that you can e-mail them a code? I think that would be very useful. Other ideas might be: 1. Column that shows last order date for each customer (unless that was what you meant by D). 2. An action might be a button that shows breakdown of products purchased (with separate attributes) of each customer and of all products sold. It could be similiar to the products purchased link (which is pretty useless when you have attributes). 3. Action option to print or export list based on total sales. Thanks Mike |
|
#3
| |||
| |||
| Quote:
Quote:
2) Hmmm, maybe an ajax loaded div on mouseover for each customer... I'll think about that. 3) export might be a nice feature... I'll consider that as well. Thanks for the input... Keep it coming....
__________________ so endith the lesson<think>sometimes I just sit's and thinks</think> "Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Order Totals: Total $ and Total Sales Count | michael_s | New osCommerce Contributions | 0 | 04-18-2007 09:30 AM |
| Order Totals: Total $ and Total Sales Count | michael_s | New osCommerce Contributions | 0 | 04-17-2007 05:54 PM |
| Order Totals: Total $ and Total Sales Count | michael_s | New osCommerce Contributions | 0 | 04-17-2007 11:15 AM |
| Customer Registration Report | michael_s | New osCommerce Contributions | 0 | 04-07-2007 02:02 AM |