How to Find All Zen-Cart Deactivated Products?

Is there some easy way we can find all products that have been set to deactivated?  Without going through all of them one by one in admin? We can use the powerful mysql command to achieve this. Go to phpMyAdmin, if you only use the following sql command, you will only get all deactivated products […]

Read More

How to show 6 latest product reviews from Zen-Cart?

If you like to show 6 random product reviews, you can do like this: Configuration –> Maximum Values –> Random Product Reviews for SideBox and set “How many products do you want to display in this sidebox?” to 6. If you need to show 6 latest product reviews from all of your product,how to do […]

Read More

How to Calculate Certain Period Net Sale for Zen-Cart

At the end of every month we need to know how much we have earned, or how much we have sold every day, in a year for our Zen-Cart based shop cart. Usually we have to login our admin panel, and check the total orders we have sold at the certain time. We have to […]

Read More

How to reset zen-cart admin password?

If you lost your zen-cart admin password, and you can not reset the new passwords via email either, how to do then? We can reset the admin passwords via phpmyadmin. If your zen-cart is v1.3.9.h or older, open your phpMyAdmin (supplied by your hosting company), select your store’s database, then click the “SQL” tab and […]

Read More

How to delete Zen-Cart un-approved Product Reviews in Bulk?

If there are so many spam products reviews, we can not delete them one by one. We will spend a lot of time if we do so. We can using mysql command to delet the spam or un-approved zen-cart reviews in bulk. The product review id is save at 2 tables: reviews and reviews_description, the […]

Read More