Timeline for How to Delete All Products Within a Category
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 26, 2015 at 14:03 | comment | added | hakre | For the script you've found you've forgotten to report how it did the job for you. Otherwise there is little information by only saying you found something when you don't have any practical experience with it - while you could have especially, as you're talking about your problem. All it would have required would be that you backup your devbox and give it a test-run there. | |
| Jul 26, 2015 at 13:54 | answer | added | hakre | timeline score: 1 | |
| Jun 23, 2015 at 5:48 | history | edited | Ademos | CC BY-SA 3.0 |
deleted 15 characters in body
|
| Jun 23, 2015 at 5:21 | comment | added | Ademos | @andrewkett: Thanks for the response. My goal is to remove the products and product images completely from my store inventory. I edited my question to clarify this | |
| Jun 23, 2015 at 5:16 | history | edited | Ademos | CC BY-SA 3.0 |
added 65 characters in body
|
| Jun 23, 2015 at 4:35 | history | edited | Ademos | CC BY-SA 3.0 |
I added a specific goal to the question, to clarify that I wanted to remove the products from the inventory, rather than removing them from them from a category.
|
| Jun 23, 2015 at 4:30 | history | edited | Ademos | CC BY-SA 3.0 |
I added a specific goal to the question, to clarify that I wanted to remove the products from the inventory, rather than removing them from them from a category.
|
| Jun 22, 2015 at 9:00 | comment | added | Andrew Kett | To clarify, do you want to only remove the products from the category or actually delete the products completely from your catalog? | |
| Jun 22, 2015 at 8:25 | answer | added | Stefkay | timeline score: 0 | |
| Jun 22, 2015 at 7:44 | answer | added | Neklo.com | timeline score: 1 | |
| Jun 22, 2015 at 2:45 | comment | added | Ademos | @TimHallman: Thank you for the clarification. It's true that there are multiple methods of executing MySQL queries, but it's my understanding that some MySQL query methods are better suited for certain contexts. For example, when removing products from a category on a shared server, PHPMyAdmin would be be limited in execution time, compared to using MySQL terminal commands. Perhaps you could offer advice on that in your answer. === Also, after the products were removed, would the related product images be removed too? If not, does a method exist to remove both database entries and images? | |
| Jun 22, 2015 at 1:05 | comment | added | Tim Hallman | There are multiple ways to execute a query, but you could simply use phpmyadmin. The question is perhaps too broad. | |
| Jun 22, 2015 at 0:53 | comment | added | Ademos | mbalparda: Thanks the backup advice, I'll keep it in mind. === @TimHallman: Thanks for the idea. If you could elaborate on where that query would be used (a terminal command for MySQL?) and clarify if the command will also remove product images, it would make a great answer to add below. | |
| Jun 22, 2015 at 0:15 | comment | added | Tim Hallman |
A simple database query will do the trick DELETE FROM catalog_category_product WHERE category _id = yourCatId;
|
|
| Jun 21, 2015 at 22:32 | comment | added | mbalparda | In any case I advise you to do a backup first. You can start by doing a database backup and trying the script you posted which seems usable at a first glance from my phone and if it does not work you can restore the backup you made first. | |
| Jun 21, 2015 at 21:02 | review | First posts | |||
| Jun 22, 2015 at 0:16 | |||||
| Jun 21, 2015 at 21:00 | history | asked | Ademos | CC BY-SA 3.0 |