Admin Report "Products Viewed" RESET?

General Support for technical Issues relating to AlegroCart
Post Reply
fruitbat
Posts: 23
Joined: Mon Oct 07, 2013 11:21 pm
Location: Australia

Admin Report "Products Viewed" RESET?

Post by fruitbat » Wed Nov 06, 2013 3:36 am

Hi. Just wondering if it's possible to reset the report in Admin called "Products Viewed" so that it starts from zero again, thanks. :?:

User avatar
leo
admin
Posts: 4251
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Admin Report "Products Viewed" RESET?

Post by leo » Wed Nov 06, 2013 5:17 am

The easiest was is to run this query on your database:

Code: Select all

UPDATE `product` SET `viewed` = '0';
You will get errors in the admin. To get rid of it simple visit/view at least one product in the catalog.

fruitbat
Posts: 23
Joined: Mon Oct 07, 2013 11:21 pm
Location: Australia

Re: Admin Report "Products Viewed" RESET?

Post by fruitbat » Wed Nov 06, 2013 5:50 am

Thanks Leo, perfect! Off to do it right now...Cheers.

fruitbat
Posts: 23
Joined: Mon Oct 07, 2013 11:21 pm
Location: Australia

Re: Admin Report "Products Viewed" RESET?

Post by fruitbat » Wed Nov 06, 2013 5:57 am

Beautiful! Worked like a charm, got the error you mentioned, viewed one product, all good! Thanks again for a great cart.

SoftBird
Posts: 1
Joined: Thu Oct 02, 2014 1:45 pm

Re: Admin Report "Products Viewed" RESET?

Post by SoftBird » Thu Oct 02, 2014 1:46 pm

In the template manager, I have Center Content set to Content. What file controls "Content"?
Last edited by SoftBird on Tue Mar 17, 2015 10:59 pm, edited 2 times in total.

User avatar
leo
admin
Posts: 4251
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Admin Report "Products Viewed" RESET?

Post by leo » Thu Oct 02, 2014 11:31 pm

The template files are:
/catalog/template/default/shared/multiple_columns.tpl and single_column.tpl.
The controllers are in the /catalog/extension/module dir.

Abraham12li
Posts: 1
Joined: Tue Mar 03, 2015 10:29 am

Re: Admin Report "Products Viewed" RESET?

Post by Abraham12li » Tue Mar 03, 2015 10:31 am

heck out and ticket logs show price and charges for shipping correct but the statements from merchant account show each charge to customer less the shipping amount. My records in the admin show everything is okay and correct with my shipping cost as well, but this log does not match the merchant account actual charges to customer.














______________________________________________________

http://www.test-king.com/cert-CCNA-Rout ... tching.htm
http://test-king.com/learning/Cloud-Certifications.htm
http://www.stanford.edu/
Last edited by Abraham12li on Tue Mar 17, 2015 10:58 pm, edited 1 time in total.

User avatar
Brent
Site Admin
Posts: 4401
Joined: Sat Dec 12, 2009 3:35 pm
Location: Canada eh

Re: Admin Report "Products Viewed" RESET?

Post by Brent » Tue Mar 03, 2015 11:02 am

What payment method are you using.

Post Reply