osCmax v2.5 User Manual
Results 1 to 3 of 3

Customer Order Totals Report

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, ...

      
  1. #1
    osCMax Development Team met00's Avatar
    Join Date
    Oct 2005
    Location
    wherever I happen to be at the moment
    Posts
    854
    Blog Entries
    2
    Rep Power
    26


    Lightbulb Customer Order Totals Report

    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

  2. #2
    Member
    Join Date
    Mar 2007
    Posts
    36
    Rep Power
    0


    Default Re: Customer Order Totals Report

    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. #3
    osCMax Development Team met00's Avatar
    Join Date
    Oct 2005
    Location
    wherever I happen to be at the moment
    Posts
    854
    Blog Entries
    2
    Rep Power
    26


    Thumbs up Re: Customer Order Totals Report

    Quote Originally Posted by mjfontec View Post
    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.
    Yes. Create a file of e-mails that can then be sent a coupon code.

    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
    1) yes
    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

Similar Threads

  1. Order Totals: Total $ and Total Sales Count
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 04-18-2007, 09:30 AM
  2. Order Totals: Total $ and Total Sales Count
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 04-17-2007, 05:54 PM
  3. Order Totals: Total $ and Total Sales Count
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 04-17-2007, 11:15 AM
  4. Customer Registration Report
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 04-07-2007, 02:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •