mobgro LiteCart Fan From United States Member since Dec 2016 mobgro May 10 2022 12:29 PM Hi all, How would I reset the product views and product sold quantities to 0? Thanks Grant
vilaiporn LiteCart Fan From Thailand Member since Aug 2017 vilaiporn May 10 2022 02:50 PM 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?
mobgro LiteCart Fan From United States Member since Dec 2016 mobgro May 10 2022 02:59 PM 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 May 10 2022 04:49 PM 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".
mobgro LiteCart Fan From United States Member since Dec 2016 mobgro May 10 2022 05:00 PM Thanks Tim, Grant