AbanteCart Community

eCommerce construction => How-to questions => Topic started by: lindsey80 on January 28, 2018, 11:01:36 AM

Title: Mass Delete Products
Post by: lindsey80 on January 28, 2018, 11:01:36 AM
Hi, Is there any way to mass delete products as I have done an import, which it said failed.... When looking in my products page, there are now 3000 products there! Many duplicated so I don't know what has gone wrong!!  I know that I can select the Page and delete the items, but the maximum I can delete like this is 60, so it will take me forever!!

Many thanks in advance
Title: Re: Mass Delete Products
Post by: Basara on January 29, 2018, 12:27:19 AM
Hello.
Go to Admin > Catalog > Product select all and click Delete Selected in bottom right  ;)
Title: Re: Mass Delete Products
Post by: lindsey80 on January 30, 2018, 09:39:22 AM
Thanks I did have to do this but with 3000 products and only being able to delete 60 at a time, it was very tedious.  I didn't know if there was a table I could delete from?

Many thanks for your help
Title: Re: Mass Delete Products
Post by: Basara on January 31, 2018, 12:26:00 AM
Hello.

Export it to CSV format and add new column with name action type delete in cells for each product
https://abantecart.atlassian.net/wiki/spaces/AD/pages/15007876/Import#Import-ActionInsertorUpdate
Title: Re: Mass Delete Products
Post by: abantecart on January 31, 2018, 07:35:28 PM
If you have some PHP skills, you can create a quick admin controller to delete products by calling this model function deleteProduct($product_id):

https://github.com/abantecart/abantecart-src/blob/master/public_html/admin/model/catalog/product.php#L1194
Title: Re: Mass Delete Products
Post by: Tishbyte on November 30, 2018, 10:16:01 PM
This may or may not help your situation, but it may be worth a try.
http://marketplace.abantecart.com/mass_edit
Title: Re: Mass Delete Products
Post by: cchko on December 16, 2020, 03:45:52 PM
The rowNum param at the end of the URL can be used to control the number of products that appear on the page.

I had around 3000 that needed to be deleted. Trying to load them all at once froze my tab but they loaded fine 500 at a time.

/index.php?rt=catalog/product&s=user&token=token#rowNum=500