Delete products

[buzltyr]

I have deleted all the products, but under the admin/Product types it shows I have 8 products. this is probably why I can't add categories as the add shows add product only, I have searched all through the menus in the catalog but I can't find anymore products to delete. Nor does the site show any, where do I find those products?

[fairestcape]

You've probably got dribs and drabs of corrupt data lurking in the product tables in the database.

Try this:-

ADMIN>>>TOOLS>>>STORE MANAGER...

... right at the the bottom is a button to optimise the database.

Click it.

[buzltyr]

I tried that and I still do not have the add category. I have 8 products in the Product Types/ Products General. I did see on a thread somewhere there is an sql patch that is run through the admin that fixes this but cannot find it as yet. Will keep looking and thanks for your help.

[fairestcape]

There is still some residual (perhaps corrupted) data in your dbase tables.

If you are familiar with phpMyAdmin, it's possible to remove this stuff using that interface (phpMyAdmin).

It's quite handy (phpMyAdmin) for those of us who know a smattering of SQL, but are too terrified of running a detailed SQL query!

A SQL query query to remove data would include the truncate command, so search the forum for other examples of SQL where truncate features in the syntax.

[buzltyr]

There is still some residual (perhaps corrupted) data in your dbase tables.

If you are familiar with phpMyAdmin, it's possible to remove this stuff using that interface (phpMyAdmin).

It's quite handy (phpMyAdmin) for those of us who know a smattering of SQL, but are too terrified of running a detailed SQL query!

A SQL query query to remove data would include the truncate command, so search the forum for other examples of SQL where truncate features in the syntax.

Yeah I don't know how to do that...

[DontBlink7]

You've probably got dribs and drabs of corrupt data lurking in the product tables in the database.

Try this:-

ADMIN>>>TOOLS>>>STORE MANAGER...

... right at the the bottom is a button to optimise the database.

Click it.

ok i clicked the optimize database button, and it redirects me to a blank page, is that right? isn't it supposed to redirect me back or something,could that be a problem with my sql database?

[DrByte]

No, you should not get a blank page. A blank page suggests that an error occurred.
Ref: https://www.zen-cart.com/tutorials/index.php?article=82

[DontBlink7]

No, you should not get a blank page. A blank page suggests that an error occurred.
Ref: https://www.zen-cart.com/tutorials/index.php?article=82

thanks for the advice but im still not getting any where, blank page are all over my admin, i can make a new product, but when i try to add an image, it gives me a blank page, same with multiple different things, somebody help please!