Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

How To Delete Products Listed In Excel File Rate Topic   - - - - -

 
  • lparodi
  • Member
  • Trial users
  • Join Date: 08-Dec 14
  • 46 posts

Posted 16 September 2015 - 04:51 PM #1

Hello,

I have an excel list of about 500 products that should be deleted. Is there a way to do that massively form the excel itself or in some other way?



 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4636 posts

Posted 16 September 2015 - 05:40 PM #2

Deleted from the website?

if so I import the "Product code" and also the  "Status" column with entry in status column set to "D" (for disabled

 

I then go to products list on website admin>view 100 products and "sort by status" till disabled products group together, then select all and delete, should only take 10 mins or so.

 

You will also be able to do via phpmyadmin by an sql query to delete all products with status of "D" but I feel admin is safer

 

John


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3828 posts

Posted 16 September 2015 - 06:22 PM #3

I wouldn't advise deleting products via phpmyadmin.  There are other tables related to products.



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19685 posts

Posted 17 September 2015 - 09:05 AM #4

Put them to ToDelete category via the csv file, make an import and delete this category


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • lparodi
  • Member
  • Trial users
  • Join Date: 08-Dec 14
  • 46 posts

Posted 17 September 2015 - 10:06 AM #5

Hello,

thank you eComLabs, this sounds like the right solution.

 

Thanks

Luca



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19685 posts

Posted 17 September 2015 - 01:41 PM #6

You are welcome! 


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.