quick way to delete products in bulk?

hi everyone,
is there a quick way to delete products in bulk? I want to start afresh and imported thousands..
I have code to delete the categories but not the products...
Thanks in advance
David

toadman wrote:

Hi David,

You can simply Delete Products using SQL Query

DELETE FROM Product WHERE Id IN (1,2,3...) --Add your product ids on place of 1,2,3 which you want to remove.

Other wise you can delete from Admin > Catalog > Bulk edit products
And delete one by one.

Hope this helps!

Thanks !!!!

hi there
after deleteing the products from the site via the admin panel. I then re-uploaded them. But now the product urls end in 1 as if there are 2 of the produts with the same name


ie
producta deleted

product a reuploaded

url is now producta-1

im guessing somehow the system remembers the original product url and so adds a 1 to the replacement!

is there a way to wipe the database of products ?

toadman wrote:

When you add any new product to the nopCommerce, system generates SEO URL for the same (stored in [UrlRecord] table).
And with same name product it(Slug) should be ProductName-2.

For wipe it you can update UrlRecord Table

Hi there
Can you prove more details on the deletion method?
Thanks