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?
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?
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
4 14.1
Posted 16 September 2015 - 06:22 PM #3
I wouldn't advise deleting products via phpmyadmin. There are other tables related to products.
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 1210 Multi-Vendor USD 1250 Multi-Vendor PLUS USD 3100 (2775)
CS-Cart Ultimate USD 4025 CS-Cart + YOUPI USD 1459 Multi-Vendor Ultimate USD 7500 (6000)
Posted 17 September 2015 - 10:06 AM #5
Hello,
thank you eComLabs, this sounds like the right solution.
Thanks
Luca
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 1210 Multi-Vendor USD 1250 Multi-Vendor PLUS USD 3100 (2775)
CS-Cart Ultimate USD 4025 CS-Cart + YOUPI USD 1459 Multi-Vendor Ultimate USD 7500 (6000)