[Skip to main content](#vessel-content) # Mass delete products ## - **[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 5 months ago [\#202059](#202059) 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=60#202059 "-- 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, It seems that there is an issue when setting only the product code in the csv file. I tried with: product_name,product_code testmp,testmp And it is working as expected, so please use two columns until we fix this issue in the next release. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NjAmdG1wbD1tYXJrZG93bg==) 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 [\#202077](#202077) 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=60#202077 "-- 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, I will definitely give that a go. But it is difficult to know the product name in the case of a lost product. So in that case again the client will not be able to delete the lost product. I hope this missing product thing improves in the next version. Can you tell me how I could get the 'Check Database' button in the tools bar of the products listing screen? The client doesn't have access to the configuration screen but does have access to the products listing as he manages the products. So I am thinking makes sense to have the button to 'check the database' on the products listing in case a product goes missing? Can you please explain how to? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NjAmdG1wbD1tYXJrZG93bg==) 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 5 months ago [\#202130](#202130) 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=60#202130 "-- 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, To add the "Check database" button on the product listing page, you have to: - Edit the file "administrator/components/com_hikashop/views/product/view.html.php" and replace: Code: $this->toolbar = array( array('name' => 'custom', 'icon' => $exportIcon, 'alt'=>JText::_('HIKA_EXPORT'), 'task' => 'export', 'check' => false), By: Code: $importIcon = 'upload'; if(HIKASHOP_J30) { $importIcon = 'import'; } $this->toolbar = array( array('name' => 'custom', 'icon' => $importIcon, 'alt' => JText::_('CHECK_DATABASE'), 'task' => 'checkdb', 'check' => false, 'display' => $manage), array('name' => 'custom', 'icon' => $exportIcon, 'alt'=>JText::_('HIKA_EXPORT'), 'task' => 'export', 'check' => false), - Then edit the file "administrator/components/com_hikashop/controllers/product.php" and add: Code: $this->modify[]='checkdb'; After: Code: if(JRequest::getInt('variant')){ $this->publish_return_view = 'variant'; } - Finally, in that same file (product controller) add the function: Code: function checkdb() { $databaseHelper = hikashop_get('helper.database'); $html = $databaseHelper->checkdb(); $js = ''; echo hikashop_getLayout('config', 'checkdb', $html, $js); } Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzAwMzgtbWFzcy1kZWxldGUtcHJvZHVjdHM/c3RhcnQ9NjAmdG1wbD1tYXJrZG93bg==) 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.049 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)