rhand Posted November 3, 2008 Posted November 3, 2008 Hello there everyone, I have been doing a lot of test buys in my OSC shop and now I would like to reset report. Is that possible some way? I really likes to keep track of the real sales and dump the test/former sales. Thanks for your support. Rhand
FIMBLE Posted November 3, 2008 Posted November 3, 2008 You can set the order number in your phpmyadmin Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
rhand Posted November 3, 2008 Author Posted November 3, 2008 You can set the order number in your phpmyadmin Nic So could I just empty that table if I would like to start from scratch Fimble?
FIMBLE Posted November 3, 2008 Posted November 3, 2008 So could I just empty that table if I would like to start from scratch Fimble? There order number you can reset to 0 yes Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
rhand Posted November 3, 2008 Author Posted November 3, 2008 There are a few tables with order in them. Do you mean order_status_history, orders, order_products, order_products_attributes, order_product_downloads or another one Nic?
rhand Posted November 4, 2008 Author Posted November 4, 2008 Well, I still don't know if I can really empty a table to get rid of the past test orders and which table it should be. Nic when you have time or someone else please help me out here!
rhand Posted November 4, 2008 Author Posted November 4, 2008 Does anybody have a suggestion yet? Do I need to empty any or all of the earlier mentioned tables to get rid of the old test orders or is there another way? I think I have to empty order_status_history. But as this is a life site I need to be certain that that is the table to empty to get rid of the old reports on all the test buys...
dusty108 Posted November 4, 2008 Posted November 4, 2008 I found this in tips, it will solve part of your problem: How to Reset the Products Viewed Report Open the application you use to run SQL queries on your database. I use PHPMyAdmin. Run the following SQL command. Remember to backup your database before doing this, just in case UPDATE products_description SET products_viewed = 0
rhand Posted November 5, 2008 Author Posted November 5, 2008 I am going to give this a try O'Neil. Thank you very much for your suggestion! For other order remains in reports I will need other queries I guess. Will try some myself. Will let you know the outcome. Hopefully I will be able to have a whole shop with a clean order slate!
rhand Posted November 5, 2008 Author Posted November 5, 2008 to reset Reports in OSC I maybe should reset products_quantity to zero in orders_product to remove the most bought products, reset products_viewed in products_description to remove most viewed products and then I still need a way to empty customer order-total: UPDATE products_description SET products_viewed = 0 (Thanks to O'Neil) UPDATE orders_products SET products_quantity = 0 (Not sure about this one) customer order-total?
Guest Posted November 5, 2008 Posted November 5, 2008 Does anybody have a suggestion yet? Do I need to empty any or all of the earlier mentioned tables to get rid of the old test orders or is there another way? Why not jist gp tp Admin-->Customers-->Orders. Select the order you want to remove and click delete?
rhand Posted November 7, 2008 Author Posted November 7, 2008 Hello Brian, thanks for your input. Yes that seems to be a lot easier. That should remove all orders or the orders you want and remove them from reports as well. Will let you know if it works out!
dusty108 Posted November 11, 2008 Posted November 11, 2008 Any suggestions how to reset "bestsellers"
rhand Posted November 24, 2008 Author Posted November 24, 2008 No, I do not know and neither do I know of a way to reset reports or part of it as I still have some open questions in this thread..
Recommended Posts
Archived
This topic is now archived and is closed to further replies.