Items ordered but not on website or database

[spminis]

www.spminiatures.com

I've had a couple of instances of this recently. Customer orders an item. Item is not showing on website and I can't locate it in the database. I would like to remove these from my site but I can't find them. I'm dumbfounded

Thanks for any insight

Carol

[lat9]

Most times I've seen this issue is when a product has an invalid (i.e. non-existing) master_categories_id. Somehow (?) the storefront (or Google) finds the product, but it doesn't show in the Zen Cart admin due to its misconfiguration.

Have you searched for the product using your webhost's phpMyAdmin? If you have an order with the product you want to remove, search the orders_products table for that orders_id value. That will show you one record for each product in the order. Note the products_id of the product you want to "remove", click the SQL tab and enter/execute the following command (xx is the products_id you noted):

UPDATE products SET products_status = 0 WHERE products_id = xx LIMIT 1

Note: If your database uses a DB_PREFIX (like zen_), add the prefix at the beginning of the table name:

UPDATE zen_products SET products_status = 0 WHERE products_id = xx LIMIT 1

[swguy]

> Most times I've seen this issue is when a product has an invalid (i.e. non-existing) master_categories_id.

If this is the issue (and it might well be), you can try running the audit tool on your database.

https://www.zen-cart.com/downloads.php?do=file&id=2261

The other possible issue is that a products table entry exists but a products_description entry does not; in some versions this created issues like what you are seeing.

[spminis]

Thank you.
I had searched using the PHPadmin tool but didn't find it. I didn't know I could search by order. I found it there and was able to delete it. Thanks so much for your help/

Carol

[lat9]

Happy to have helped ... although it would have been beneficial to see what the underlying issue was!