Finding Product Data-Entry Problems

[lloyd_borrett]

G'day,

When running a store with more than a 2000 products in it, that is being maintained by multiple people, it's easy for mistakes to creep in.

Over the years I've put together a set of MySQL select statements that help me to find common problems with product entries. I use the SELECT statements in phpMyAdmin.

The problems located are:
Products with short descriptions
Products with no manufacturer assigned
Products with no product model assigned
Products with no image
Products with URL
Products with no weight
Products with Product Qty Minimum not equal to 1
Products with Product Qty Units not equal to 1
Products with Product Qty Maximum not equal to 0
Products with Product Qty not equal to 0
Products with a weight
Products with two spaces in product name
Find a http:// url
Find a product with image in main directory
Product descriptions with links to categories cPath=
Category descriptions with links to categories cPath=
Get a customer's shopping basket
Categories with no image
Categories with no description
Stocktake Extract

See the attached text file for the details. Zen Cart Problems.zip

I hope you find them useful.

Best Regards, Lloyd Borrett.