Reset counter and product accesses into database

[ZeroCool]

Hi!

Just finished my webshop. But while configuring the shop I accessed my site more than 2000 times. And the visited products already have lots of hits!

How can I delete these counter stats from database?

Michael

[Working-Overtime]

I can't believe no-one has answered this post by now. And you may have already figured itout, so this reply is for those that haven't been down this path......

To reset your counter and Date, login to your Domain's Control Panel (not the catalog Admin CP), then (hopefully you have phpmyadmin) log in to your database and find the "counter" table. Click "Browse"

There you will be able to "edit" the entries

OR, if you have a hard time locating that section, use the text below (cut & Paste) to run an SQL query

#Modifying the VALUES with your preferences will reset the counter.
#I used today's date and reset the counter to zero

INSERT INTO counter (startdate, counter) VALUES ('20031104', 0);