[Plugin: WP E-Commerce Dashboard] WP E-Commerce Reporting – What would you like to see?

Hi Lee. Must say, like your work!!

Your contributions to the WP e-Commerce Plugin are exceptional. And thus your contributions to the greater WordPress community as a whole are therefore also exceptional.

I support WP e-Commerce because I genuinely believe the Plugin is the best. On top of that though I like the team (I met Dan at WCNYC) and I believe in the open source community growing behind them. I have seen really ugly behavior from other e-Commerce plugin developers (false posts / name calling / flame wars) and this just makes me want to support WP e-Commerce even more.

Blimey I don’t know where that came from. You inspired me! Anyway I’ve looked at your most recent release and I am therefore 99% the issue below is fixed. But just in case here goes.

When you have a really really big sales log (say two years or more of transactions) then your dashboard page grinds to a halt. I’m not a database expert myself but I suspect there is a way to optimize this from happening.

Nice work! Oh and in terms of a killer feature for the Dashboard please add “Most popular products sold”. If this was advanced enough to show trends on a month by month basis that would be amazing.

Hi @razrgeezer

Thanks for your comments. I’m really interested in taking a look at the performance issue you had.

When you have a really really big sales log (say two years or more of transactions) then your dashboard page grinds to a halt. I’m not a database expert myself but I suspect there is a way to optimize this from happening.

Unfortunately I don’t have a site with a big sales log, so I’m wondering if you could run some debug for me to help pin down the issue?

Could you do the following:

First, put this in wp-config.php:
define('SAVEQUERIES', true);

Then, paste the following onto the end of wp-admin/index.php

<?php
if (current_user_can('administrator')){
    global $wpdb;
    echo "<pre>";
    print_r($wpdb->queries);
    echo "</pre>";
}
?>

Next time you view your wordpress dashboard it should spit out an array of the queries it ran, and how long they took at the bottom of the page. If you can send me this that’d be fantastic. NOTE: I wouldn’t recommend posting it here, but if you can drop me a line through my blog you can attach it there:

https://www.leewillis.co.uk/contact/

Once you’ve done that you can (& should!) back out the changes you made.

Nice work! Oh and in terms of a killer feature for the Dashboard please add “Most popular products sold”.

That’s be neat – I’ll look into it.

If this was advanced enough to show trends on a month by month basis that would be amazing.

That might be beyond me, but we’ll see ??

Thanks again.
Lee

Hey @razrgeezer,

I’ve just pushed some database suggestions up to the Instinct guys that will hopefully improve performance (Particularly of my plugin – but probably some other bits and bobs as well).

Can you apply the following changes against your WP database and see if it helps?

alter table wp_wpsc_purchase_logs add index (date);
alter table wp_wpsc_purchase_logs add index (processed,date);
alter table wp_wpsc_cart_contents add unique index (purchaseid);
alter table wp_wpsc_product_rating add index (time);

Cheers
Lee