Reset Product Views Count

LiteCart Fan
From United States
Member since Dec 2016

Hi all,
   How would I reset the product views and product sold quantities to 0?
Thanks Grant

LiteCart Fan
From Thailand
Member since Aug 2017

Hello,
I would go for delete all the orders.
But maybe I did not well understand what you want to do.
What do you mean for product views?

LiteCart Fan
From United States
Member since Dec 2016

In the admin section there is product views list "Most Visited Products", reset the product count views to "0". Deleting order does not subtract inventory. Also tried deleting individual items in each order and does not adjust inventory. Just need to reset those to zero starting point..
Thank for replying, Grant

tim
Founder
From Sweden
Member since May 2013
tim

The views and purchases counter is in the mysql lc_products table.

Here is a query you can run in phpMyAdmin:
UPDATE lc_products SET views = 0, purchases = 0;

To restock quantities you must delete the orders or give them an order status that doesn't have the property "is sale".

LiteCart Fan
From United States
Member since Dec 2016

Thanks Tim, Grant

This thread has been closed due to long inactivity. Posting to it is not possible.
This website uses no cookies and no third party tracking technology. We think we can do better than others and really think about your privacy.