Log onto phpMyAdmin, and run this query:
Remember to change op_product to whatever your product table is called.
Code: Select all
UPDATE op_product SET viewed=0Request Reviews v1.0 released.
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…
You probably also got a mail from your hosting provider containing info about phpmyadmin…
Request Reviews v1.0 released.
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.
Code: Select all
UPDATE `product` SET `viewed` = 0;3. upload the "reset_viewed.sql" file you just made
Do this everytime you want to reset the view list.
Who is online
Users browsing this forum: Bing [Bot], Google [Bot], Majestic-12 [Bot] and 102 guests
