Mass deleting products and catagories,.. and other questions

[taos]

In the test fase I have installed a lot of products and I want to delete them all.

All the products with a manufacturer are deleted by deleting the manufacturer. How can I delete the products without a manufacturer ?

To populate the database...
Easypopulate works but not on a 5 MB CVS file with >17500 lines

Someone in the forum wrote about a pdf of the complete DB structure. Where can I find this pdf file?

Thanks in advance,
Maurice Lucas

[kirk6677]

you can go to a dos or unix promt and type the folowing and press enter after each line.

mysql

use database (database being the name of the database you are using)

delete from customers;

this will delete everything in the customers table and leave the structure untouched.

[taos]

Originally Posted by kirk6677

you can go to a dos or unix promt and type the folowing and press enter after each line.

mysql

use database (database being the name of the database you are using)

delete from customers;

this will delete everything in the customers table and leave the structure untouched.

I don't have a ssh account so no unix prompt but phpmyadmin will do the trick.

Thanks,
Maurice Lucas

[doug]

The pdf is called tep_database-pr2.2-CVS.pdf and is in the root where you installed OSC.