OpenCart Community

How can I reset my Product Viewed number so I my start at zero? Thanks

Log onto phpMyAdmin, and run this query:
Remember to change op_product to whatever your product table is called.

Sorry, I don't understand where to go to zero products viewed.

run that above command via phpmyadmin

Thanks for showing how to do that.

Sorry, I'm new to this. How do I get to phpMyAdmin?

Good question. Did you install opencart yourself? The database info you entered during installation is most likely your friend in ths case.

You probably also got a mail from your hosting provider containing info about phpmyadmin…

Thanks for the reply. I am not the one that setup my cart. I can get into the cart through ADMIN and make changes to my pricing, shipping, etc. But I don't know how to get to what your saying about loggin into phpMyAdmin. Or is that where I am already at? I don't know where to find or put in the code: select all . I'll try to get ahold of the person that setup my cart for me. All I really need to do is set my Product Viewed numbers to zero. Thank You for your help.

1. save this text to a notepad file named "reset_viewed.sql" 2. Goto OpenCart admin area under Configuration->Setting->Backup/Restore
3. upload the "reset_viewed.sql" file you just made

Do this everytime you want to reset the view list.

Thank You. Hope you have a good day.

this seems like a feature that would be simple to create as a "reset" button on that page in admin. I'm have a fear of blowing away my database my mistake.

Do I type on CODE: SELECT ALL or just that line of code?

just the line

Hi,

Can I zero the products viewed data in the same way mentioned here for OC 1.4.9 or is there a different procedure?