[Skip to main content](#vessel-content) # Mass delete products ## - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86540 - Thank you received: 14299 - - 12 years 2 weeks ago [\#176965](#176965) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass delete products](/forum/44-mass-actions/870038-mass-delete-products?start=20#176965 "-- 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, We tried with several FTP clients and it didn't work: [ take.ms/TFiHn](http://take.ms/TFiHn) If you can install a file manager extension on your website we could do it with a backend access. [ extensions.joomla.org/extensions/core-en...ents/file-management](http://extensions.joomla.org/extensions/core-enhancements/file-management) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 2 weeks ago [\#177024](#177024) 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=20#177024 "-- 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!")* Hello, Yes, during the weekend there was a snow storm - broken fibers. I installed eXtplorer - seems to work just fine. Please try. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 2 weeks ago [\#177213](#177213) 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=20#177213 "-- 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!")* Guys, any news? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 2 weeks ago [\#177381](#177381) 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=20#177381 "-- 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!")* It's been 2 days. Any kind of news or developments? Any attempts at fixing my issue? Please, some kind of reply.. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177451](#177451) 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=20#177451 "-- 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, Sorry, I am currently on holidays and I don't had time until now. As I have developed this part, I am in charge of that. I will try to find the source of the issue and correct that thanks to the access provided. I keep you informed. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177454](#177454) 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=20#177454 "-- 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!")* Ok. Thank you. Be aware, there are down-times on my server, maybe once a day or once every 2 days, but they are very short, in case you try to connect and it doesn't work, please try again a little later - it will work. Thank you and waiting news from you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177461](#177461) 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=20#177461 "-- 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, you now have access to the mass actions. I just removed the following actions for the products in the hikashopmassaction plugin php file: - Add a product - Update related - Update options - Update characteristics These actions are not very optimized and do some MySQL request too heavy when there is a lot of products in the database. I will look how to improve that for a future release of HikaShop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177489](#177489) 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=20#177489 "-- 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!")* Ok, thank you. I will give it a try as per previous instructions - I will come back and tell you what happened. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177607](#177607) 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=20#177607 "-- 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!")* Hello, Indeed, now the speed is not an issue - everything works fast. I created a new mass action and you can see the settings - printscreen. [ ![settings.png](/forum/attachment/20420) ](/forum/attachment/20420 "settings.png") Also you can see the result in the error.png attachement. [ ![error.png](/forum/attachment/20421) ](/forum/attachment/20421 "error.png") I changed the mass action filter to not delete but to show the results. It gives the same error but it also gives me a table below. I attached for this display-products.png [ ![display-products.png](/forum/attachment/20422) ](/forum/attachment/20422 "...y-products.png") in this image you can see how the app shows the product_parent_id - as a long string, not just the codes in blue above (which are in my csv). I created another mass-action, to check the correct product_parent_id. You can see the filter attached: export-products.png [ ![export-products.png](/forum/attachment/20423) ](/forum/attachment/20423 "...t-products.png") This created the csv attached: export.csv *This attachment is hidden for guests. Please log in or register to see it.* In this export you will see that product_parent_id is the same as in my filter csv - the format ABS00024 for example. Not as it appears in display-products.png Please help me sort this out - it is really getting on my nerves, it should be something easy to do and I just can't get passed it. I left the actions there, the one set up to delete the products is named ID-to-delete. - [ ![settings.png](/forum/attachment/20420) ](/forum/attachment/20420 "settings.png") [ ](/forum/attachment/20420?download=1 "settings.png") - [ ![error.png](/forum/attachment/20421) ](/forum/attachment/20421 "error.png") [ ](/forum/attachment/20421?download=1 "error.png") - [ ![display-products.png](/forum/attachment/20422) ](/forum/attachment/20422 "...y-products.png") [ ](/forum/attachment/20422?download=1 "...y-products.png") - [ ![export-products.png](/forum/attachment/20423) ](/forum/attachment/20423 "...t-products.png") [ ](/forum/attachment/20423?download=1 "...t-products.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177736](#177736) 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=20#177736 "-- 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 uncheck the option "Save the products on Mass Action CSV import". This option allow to add the products in your shop, but in your case the products are already in, and needs to be deleted. Having the full name in display-products.png is normal, to be more understandable we display the product full name, but we check only it's code. If unchecking the option is not enough, please tell me and on Monday I will go back on your extplorer in order to debug that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177737](#177737) 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=20#177737 "-- 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!")* There's no difference upon checking or unchecking that option. The error is the same. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177912](#177912) 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=20#177912 "-- 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 just wanted to debug your mass action, but I have timeout when reaching your server. Are there snow storms again ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177916](#177916) 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=20#177916 "-- 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'm sorry. It's ok now. Port 80 was being blocked. It's ok now. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177920](#177920) 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=20#177920 "-- 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!")* That should be ok now, there was a missing line in the delete products mass action function. Please keep me informed if it's ok in order to correct the code on our end too. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177932](#177932) 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=20#177932 "-- 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!")* It doesn't work. But please - i mentioned - the action is already there, it is called IDs-to-delete. Just click it and click Process. You can see yourself if it works or not. I mean I know everytime I write here I get to the back of the line of people waiting for answers. The error is the same - no difference. Also, if you want to import the csv again yourself, as mentioned before , you can find the csv file at ip/ID-TO-DELETE.csv - the ip being the IP you're using to access the website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177941](#177941) 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=20#177941 "-- 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 checked your csv file and it's indeed not correct, the first column must contain the column name so in your case "product_code" as you are managing product codes in the csv file. If it still doesn't work so you will have to use the column name "product_id" and use the ids instead of the product codes. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177945](#177945) 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=20#177945 "-- 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!")* "product_parent_id" "ABS00005" "ABS00006" "ABS00007" This is how my csv starts now. And it's not product code it's product_parent_id. I exported using mass action and it is exactly the same as my imported file now. Are you sure all settings are correct in the mass action? Because the error is all mentioning "could not be imported Product not found". I mean if it doesn't work - it means it's a bug. Using product_id instead of my field is not a solution is a workaround. I have almost 150.000 products, each has multiple variants, total is aroudn 3.2 million variants. each variant has a product_id - that means 3.2 million product ids. I will simply not be able to delete a few hundred thousand ids from 3.2 million ids. The mysql will crash, the server will crash and hikashop will crash. I had to split the import of products in almost 100 sepparate csv's to be able to do it without crashing and at each import i had to wait almost 40 minutes. When I tried to do this on a hosting service they kicked me out and closed my account because of the resources I was consuming. Now it's a quad-core i7 with 8 gigs of ram and a 15.000 scsi just for this website and still it barely works. So please don't tell me "use product ids if product_parent_id" doesn't work. It's not possible. So i need the mass action to work. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177955](#177955) 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=20#177955 "-- 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!")* In HikaShop, when using the delete function in the product class you just have to delete the main product and the variants will be deleted too. So setting "product_code" as column title should do the trick, it will delete the main product and its variants. "ABS00005", etc are not ids but codes. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177965](#177965) 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=20#177965 "-- 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 set in the file the first line to "product_code". I selected in the mass action, first filter Product Columns - product_code = csv (the new csv, the one with "product_code" in the first line). Same error. I selected in the mass action, first filter Product Columns - product_parent_id = csv (the new csv, the one with "product_code" in the first line). Same error. I tried different settings besides "=", Begins width, Ends with, etc. wihtout click on process but to see how many "results" it says. No matter what you choose it says 2868086 results. This is a product parent id: ABS00005. Try to delete it using mass action ![:)](/media/kunena/emoticons/3.png ":)"). I think it would be easier and a lot faster for you to try directly than for me. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#177995](#177995) 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=20#177995 "-- 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 have done some tests and the issue seems to be coming from the massaction class, a function is not handling a specific case. So tomorrow morning I will debug that class on your website directly. Can I set the error reporting level to "maximum" while debugging ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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.117 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)