Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Mass Delete Products  (Read 2763 times)

Offline lindsey80

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Mass Delete Products
« 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

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4986
  • Karma: +257/-2
    • View Profile
Re: Mass Delete Products
« Reply #1 on: January 29, 2018, 12:27:19 AM »
Hello.
Go to Admin > Catalog > Product select all and click Delete Selected in bottom right  ;)

Offline lindsey80

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Mass Delete Products
« Reply #2 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

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4986
  • Karma: +257/-2
    • View Profile
Re: Mass Delete Products
« Reply #3 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

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4321
  • Karma: +291/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Mass Delete Products
« Reply #4 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
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline Tishbyte

  • Newbie
  • *
  • Posts: 38
  • Karma: +7/-0
  • Still Learning
    • View Profile
    • Tishbyte Studios
Re: Mass Delete Products
« Reply #5 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

Offline cchko

  • Newbie
  • *
  • Posts: 1
  • Karma: +1/-0
    • View Profile
Re: Mass Delete Products
« Reply #6 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

 

Powered by SMFPacks Social Login Mod