Products Purchased Reset

Open to all! Ask other shopowners for help.
Post Reply
KenSO
Member
Posts: 44
Joined: Fri Mar 05, 2021 12:01 pm
Phoenix Version:
Has thanked: 37 times
Been thanked: 4 times

Products Purchased Reset

Post by KenSO »

Hello,

Please can someone tell me how to flush/reset the products purchased count in admin or in the database?
products_purchased.jpg
Thanks ....
You do not have the required permissions to view the files attached to this post.

Tags:


Join The Code Co-op to get access to your library in the Code Co-op Forum
User avatar
burt
Core Team
Posts: 4546
Joined: Tue Oct 29, 2019 9:37 am
Phoenix Version: v1.1.0.8
Has thanked: 252 times
Been thanked: 412 times

Re: Products Purchased Reset

Post by burt »

Be sure you want to do this, as this will not be easily un-doable.
Make a DB backup.

Then in PHPMyAdmin or via your hosting control panel.

Code: Select all

UPDATE products SET products_ordered = 0
I am not here to build for you.
I am here to build with you. Let's help each other.
KenSO
Member
Posts: 44
Joined: Fri Mar 05, 2021 12:01 pm
Phoenix Version:
Has thanked: 37 times
Been thanked: 4 times

Re: Products Purchased Reset

Post by KenSO »

That worked like a charm. I'm setting up a new store using backup data from another store. Thank you Sir @burt


Join The Code Co-op to get access to your library in the Code Co-op Forum
Post Reply