[Skip to main content](#vessel-content) # Mass delete products ## - **[lex131](/forum/user/12191-lex131 "View lex131's Profile")** - [![lex131's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12191-lex131 "View lex131's Profile") Topic Author - [ Offline](/forum/user/12191-lex131) Less More - Posts: 90 - Thank you received: 2 - - 12 years 1 week ago [\#178016](#178016) by [lex131](/forum/user/12191-lex131 "View lex131's Profile") Replied by *[lex131](/forum/user/12191-lex131 "View lex131's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#178016 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* You can do whatever you feel like it. If something hangs just tell me here I'll restart mysql or apache or the whole server remotely. At 9 o'clock in the morning (GMT+2) i'll be online until 17:00 and I get e-mail notifications instantly when you write anything here. Thank you and good luck ![:)](/media/kunena/emoticons/3.png ":)"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 1 week ago [\#178092](#178092) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#178092 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, I spent time on your website to debug this issue, I made a little fix for your case. So now it should work ok, just be sure to be using a csv file with no more than 100 codes else it will end in a timeout. I have not deleted all the elements, I prefer let you manage the csv files correctly. Further I will have to reproduce this issue on my end in order to make a final fix, debugging on eXtplorer is not the easiest task ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lex131](/forum/user/12191-lex131 "View lex131's Profile")** - [![lex131's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12191-lex131 "View lex131's Profile") Topic Author - [ Offline](/forum/user/12191-lex131) Less More - Posts: 90 - Thank you received: 2 - - 12 years 1 week ago [\#178097](#178097) by [lex131](/forum/user/12191-lex131 "View lex131's Profile") Replied by *[lex131](/forum/user/12191-lex131 "View lex131's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#178097 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Thank you for your time spent debugging. But what can I do to make that number (100) bigger? Because I have more than 10.000 that I need to erase - that would mean 100 csv's. Can I tweak somehow the mysql to not give a timeout? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 1 week ago [\#178117](#178117) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#178117 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* The thing is that, when you have 100 products in the csv file, if each product has variants there is a very big number of products to delete. To get the variants of the products, there is requests processed, so a lot of requests and that's why it generates a memory issue (and not a timeout as I said previously, sorry). To have a bigger number of products per csv file, you can potentially test the limit, try with 200, then 300 to see how it is handling that. And if you have a memory error displayed, you can too increase the memory limit. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lex131](/forum/user/12191-lex131 "View lex131's Profile")** - [![lex131's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12191-lex131 "View lex131's Profile") Topic Author - [ Offline](/forum/user/12191-lex131) Less More - Posts: 90 - Thank you received: 2 - - 12 years 1 week ago [\#178158](#178158) by [lex131](/forum/user/12191-lex131 "View lex131's Profile") Replied by *[lex131](/forum/user/12191-lex131 "View lex131's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#178158 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* I wasn't fast enough with the reply. I reaised all apache timeouts to 1 hour and the available memory for a request to 1GB and after 52 minutes ![:)](/media/kunena/emoticons/3.png ":)") all 9000+ products were erased. Thank you very much!!! Now one last question - if a new version of hikashop appears can I update? Or will I overwrite what you modified? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 1 week ago [\#178232](#178232) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#178232 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, The current version of HikaShop will erase what I have modified, but I will try to do the correct editions for the future release. To be sure, you can backup the current files "plugin/hikashop/massaction_product/massaction_product.php" and "administrator/components/com_hikashop/classes/massaction.php". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 7 months ago [\#197349](#197349) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#197349 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, I am using mass action to delete products but it is deleting ALL PRODUCTS. This is my CSV product_code,product_name 1148-00030,Core Cleaner and see screen grab below. [ ![[img](http://s23.postimg.org/atcoaoqsr/Screen_Shot_2015_04_05_at_12_43_00_pm.png) ](http://s23.postimg.org/atcoaoqsr/Screen_Shot_2015_04_05_at_12_43_00_pm.png "[img") In this specific case I am using it to delete products that are lost in the database. I am using hikashop 2.4.0 Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 7 months ago [\#197530](#197530) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#197530 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Is anyone looking at this post? Any news on the problem above? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 7 months ago [\#197541](#197541) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#197541 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, Yes I do, on my working time ![;)](/media/kunena/emoticons/24.png ";)") And better than looking at this post, I give a solution ![:)](/media/kunena/emoticons/3.png ":)") Please edit the file "plugins/hikashop/massaction_product/massaction_product.php" and in the function "onProcessProductMassFiltercsvImport()" add: Code: $elements = $data->elements; Before: Code: if($filter['type'] == 'out'){ Thanks for your report, I corrected it on our end too and this fix will be available in the next release. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 7 months ago [\#197738](#197738) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#197738 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi Thanks, that seems to fix the problem. Perfect. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 6 months ago [\#201104](#201104) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201104 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi Guys, The mass delete is DELETING ALL products again. I am on version 2.4. I checked and I still have the line $elements = $data->elements; there. I am sorry to say this but every time I had to use this functionality I had problem. Not very reliable/stable to my experience. Please advise, kind urgent now. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 6 months ago [\#201134](#201134) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201134 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, I don't remember that changes has been made on this part between the 2.3.5 and the 2.4.0. Please give us back backend and FTP access in order to debug that directly on your website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 6 months ago [\#201201](#201201) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201201 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* I just PM you the login details. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 6 months ago [\#201372](#201372) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201372 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, did you guys find anything? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 6 months ago [\#201377](#201377) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201377 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, Please give us a FTP access too as I asked in my previous message ![;)](/media/kunena/emoticons/24.png ";)") Without the FTP access I can't debug anything. Regarding your issue of "lost" products, it is very strange, I don't think we had other feedbacks like that. Could you give us more informations about these products ? Like if you tried to delete them, how, etc. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 6 months ago [\#201424](#201424) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201424 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Sorry about that. I just PM you the details. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 6 months ago - 11 years 6 months ago [\#201497](#201497) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201497 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, When debugging your website, I processed a massaction before my commit was done, so I lost the settings, please give me the url of the csv file to set in the path field. The issue seems to be coming from the fact that if no products are found in the database, so all the products are loaded. This will be fast to fix. Regarding the "lost products" issue you have, the listing don't see them because they don't have categories, so the system just can't list them, the mass action see them because it is only based on the product ids, no checks are done on the categories. But, to retrieve these products, you just have to click on the "Check database" button in the toolbar of the HikaShop configuration page. Last edit: 11 years 6 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 6 months ago [\#201509](#201509) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201509 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi Xavier, Thanks for that. I just PM you the address. Also is there a way for the settings not to revert back? As you experienced it is not very helpful. Regarding the lost products, I already tried the 'Check Database' Button as previously state on that other post. And that didn't fix it. Is there the possibility of that functionality being bugged and not working? Could you have a look at that as well? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 11 years 6 months ago [\#201529](#201529) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201529 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi, Problem solved for the mass actions, the issue was that when no products are found in database, the mass actions were processing a MySQL request with an empty "where" condition, so it was loading all the products. So I added a where condition to get 0 results. The settings don't revert back, it is just that due to the commit I had done, I sent an empty form which resetted the settings of the mass action, but this will not happen in normal conditions. For the check database issue, do you have the latest version of HikaShop ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")** - [![maujbigo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32468-maujbigo "View maujbigo's Profile") - [ Offline](/forum/user/32468-maujbigo) Less More - Posts: 147 - Thank you received: 6 - - 11 years 5 months ago [\#201649](#201649) by [maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile") Replied by *[maujbigo](/forum/user/32468-maujbigo "View maujbigo's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=40#201649 "-- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.3.1 Hello, On oneart.ro I have many products, and some of them must be erased. I want to know if I can do that using a csv import of some sort. And I want to erase the products including their pictures. Please help me with a solution. Thank you!")* Hi Xavier. It seems to not be deleting any product via csv now. I created a test product with code TESTMP and I uploaded this csv product_code TESTMP But nothing gets deleted. Do you mind having a look again? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NDAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.123 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)