OCZ Posted January 29, 2007 Share Posted January 29, 2007 Need help.. How to delete Bestsellers list?? Link to comment Share on other sites More sharing options...
Velveeta Posted January 29, 2007 Share Posted January 29, 2007 Need help..How to delete Bestsellers list?? That depends... do you want to remove the bestseller's box altogether, or just blank it out to clear out any test orders that are screwing with your #'s? If you want to remove it altogether, you'd edit the *catalog*/includes/column_left(or right).php file for the appropriate column, and just comment out the line that calls it... If you want to blank it out, then you'll need to clear out your orders_products table I believe, as I think the code for this checks that table to get the totals by products_id to figure out what the best selling products are... Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
OCZ Posted January 29, 2007 Author Share Posted January 29, 2007 That depends... do you want to remove the bestseller's box altogether, or just blank it out to clear out any test orders that are screwing with your #'s? If you want to remove it altogether, you'd edit the *catalog*/includes/column_left(or right).php file for the appropriate column, and just comment out the line that calls it... If you want to blank it out, then you'll need to clear out your orders_products table I believe, as I think the code for this checks that table to get the totals by products_id to figure out what the best selling products are... Richard. just blank it out to clear out any test orders... Link to comment Share on other sites More sharing options...
Velveeta Posted January 29, 2007 Share Posted January 29, 2007 just blank it out to clear out any test orders... Do you have any real orders in there yet, mixed up with the test orders? Or is it all test orders? If it's all test orders, you can just empty all of the orders_* tables via phpMyAdmin or something... If they're mixed up with real orders, you'll have to delete the test orders manually within the admin console to maintain the real ones... Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
OCZ Posted January 29, 2007 Author Share Posted January 29, 2007 Do you have any real orders in there yet, mixed up with the test orders? Or is it all test orders? If it's all test orders, you can just empty all of the orders_* tables via phpMyAdmin or something... If they're mixed up with real orders, you'll have to delete the test orders manually within the admin console to maintain the real ones... Richard. I will empty all orders and clear out the bestseller list Link to comment Share on other sites More sharing options...
OCZ Posted January 29, 2007 Author Share Posted January 29, 2007 I can't find orders_* tables in my phpadmin Link to comment Share on other sites More sharing options...
Velveeta Posted January 29, 2007 Share Posted January 29, 2007 I can't find orders_* tables in my phpadmin In your phpMyAdmin, you should have a dropdown to select your store database from, once in that database, you should see some orders_* tables (* = wildcard) named things like orders, orders_products, orders_total, etc... Those are the tables that need to be emptied out, although now that I think about it, there is one that comes to mind that you'll want to leave, and that's orders_status, because it holds the names of the statuses your orders can be in (pending, shipped, etc)... but clear out orders_status_history, and all of the other orders_* tables except for that one... If you tacked on a prefix to your tables, you'll need to take that into account, for example, the MS3 install defaults a prefix of osc_ onto the tables unless you change it, so in that case the tables would be called osc_orders, osc_orders_products, etc... Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.