removing all product data from an new dev site

[brick]

I am in the process of populating a new site with products and i want to be able to try different upload templates in the Dataport. if i don't like what i upload i want to clear the DB and do it again.
How do i do that.

it would be "delete from productTable" if i had access to the sql dB but i dont.

thanks

Brick

[mazhar]

Try bulk delete products from merchant panel. Login to the system and then from catalog there is an option to drop multiple products and categories. You can use this section to drop the desired records.

[brick]

Mazar I needed to remove all the products so i figured out how to use the the DB. Here is the problem. I have re-uploaded 6500 products to a new dev site but they are not visible in any category. They are visible as orphaned products under catalog but how do i get them to show up in a category.