Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Reset Reports in OSC Admin


rhand

Recommended Posts

Posted

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

Posted
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?

Posted

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?

Posted

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!

Posted

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

Posted

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

Posted

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!

Posted

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?

Posted
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?

Posted

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!

  • 2 weeks later...
Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...