[Skip to main content](#vessel-content) # Removal of Products when importing CSV ## - **[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")** - [![Prodessa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29619-prodessa "View Prodessa's Profile") Topic Author - [ Offline](/forum/user/29619-prodessa) Less More - Posts: 11 - Thank you received: 0 - - 12 years 11 months ago [\#133709](#133709) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#133709 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* was created by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful? - [ ![h9a8917e.png](/forum/attachment/13896) ](/forum/attachment/13896 "h9a8917e.png") [ ](/forum/attachment/13896?download=1 "h9a8917e.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 12 years 11 months ago [\#133753](#133753) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#133753 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* Hi, Which version of HikaShop are you using ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")** - [![Prodessa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29619-prodessa "View Prodessa's Profile") Topic Author - [ Offline](/forum/user/29619-prodessa) Less More - Posts: 11 - Thank you received: 0 - - 12 years 11 months ago [\#133767](#133767) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") Replied by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#133767 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* Versie HikaShop [1310121420] Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 12 years 11 months ago [\#133853](#133853) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#133853 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* Can you try to change the line: $query ='SELECT product_id FROM '.hikashop_table('product').' WHERE product_id IN ('.implode(',',$ids).') AND product_type=\'main\';'; to: $query ='SELECT product_id FROM '.hikashop_table('product').' WHERE product_id NOT IN ('.implode(',',$ids).') AND product_type=\'main\';'; in the file plugins/hikashop/datafeed/datafeed.php and try again ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")** - [![Prodessa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29619-prodessa "View Prodessa's Profile") Topic Author - [ Offline](/forum/user/29619-prodessa) Less More - Posts: 11 - Thank you received: 0 - - 12 years 11 months ago - 12 years 11 months ago [\#134036](#134036) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") Replied by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#134036 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* Hi Nicolas, I'm sorry but that doesn't remove the articles that are not in the CSV? The function uses product_id to check but that is not in my csv file, I have change it to product_code. What can we check more? The image attached in first message shows configuration is that correct? Does the PIPE separator/delimiter influence the behavior? Last edit: 12 years 11 months ago by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")** - [![Prodessa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29619-prodessa "View Prodessa's Profile") Topic Author - [ Offline](/forum/user/29619-prodessa) Less More - Posts: 11 - Thank you received: 0 - - 12 years 11 months ago - 12 years 11 months ago [\#134046](#134046) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") Replied by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#134046 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* I have check the code step by step and he never access the highlighted part. Somehow the contentfile is treated as object but is not. Should the helper convert it? Code: $contentFile = file_get_contents($path); if(empty($contentFile)){ $messages[] = 'Could not retrieve the CSV file '. $path; }else{ if(!$helper->handleContent($contentFile)){ return false; } if(!empty($plugin->params['delete']) && [u]!empty($contentFile->products)){[/u] $ids = array(); foreach($contentFile->products as $product){ var_dump($product); $ids[$product->product_id] = $product->product_id; } $query ='SELECT product_id FROM '.hikashop_table('product').' WHERE product_id NOT IN ('.implode(',',$ids).') AND product_type=\'main\';'; $db = JFactory::getDBO(); $db->query($query); $prods = $db->loadObjectlist('product_id'); $todelete = array_keys($prods); $class = hikashop_get('class.product'); $class->delete($todelete); Last edit: 12 years 11 months ago by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")** - [![Prodessa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29619-prodessa "View Prodessa's Profile") Topic Author - [ Offline](/forum/user/29619-prodessa) Less More - Posts: 11 - Thank you received: 0 - - 12 years 10 months ago [\#134674](#134674) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") Replied by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#134674 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* Nicolas? Any help? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) 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 10 months ago [\#134760](#134760) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#134760 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* Hi, Can you try to do this thing thanks to the hikashop mass actions ? In System > Mass Actions, configure a mass action like on this screenshot: [ ![h16e1866.png](/forum/attachment/14053) ](/forum/attachment/14053 "h16e1866.png") - [ ![h16e1866.png](/forum/attachment/14053) ](/forum/attachment/14053 "h16e1866.png") [ ](/forum/attachment/14053?download=1 "h16e1866.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")** - [![Prodessa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29619-prodessa "View Prodessa's Profile") Topic Author - [ Offline](/forum/user/29619-prodessa) Less More - Posts: 11 - Thank you received: 0 - - 12 years 10 months ago [\#134772](#134772) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") Replied by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#134772 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* I've get a timeout of the browser, should I change something? [ ![h0ff6533.PNG](/forum/attachment/14055) ](/forum/attachment/14055 "h0ff6533.PNG") - [ ![h0ff6533.PNG](/forum/attachment/14055) ](/forum/attachment/14055 "h0ff6533.PNG") [ ](/forum/attachment/14055?download=1 "h0ff6533.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) 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 10 months ago [\#134818](#134818) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#134818 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* Hi, Have you set a limit in the filters ? like on the example start:0 and limit:500 ? Then execute again the mass action with start:500 and limit:500. Else if there is too many data, the servers can't process the action. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")** - [![Prodessa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29619-prodessa "View Prodessa's Profile") Topic Author - [ Offline](/forum/user/29619-prodessa) Less More - Posts: 11 - Thank you received: 0 - - 12 years 10 months ago [\#134843](#134843) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") Replied by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#134843 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* The file is about 380KB The server responds with limit 500:500 = Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 251396073 bytes) in C:\domains\website.nl\wwwroot\administrator\components\com_hikashop\classes\massaction.php on line 1555 Warning: mysqli_ping() [function.mysqli-ping]: MySQL server has gone away in C:\domains\website.nl\wwwroot\libraries\joomla\database\database\mysqli.php on line 190 Is there still a option? Is it also posible to point to a URL in the massaction? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) 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 9 months ago [\#138262](#138262) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#138262 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* Hi, Sorry for the late reply, have you solved your problem ? Do you have the latest version (2.2.3) ? Thanks to reduce the limit, could you give me the concerned lines regarding the Fatal Error ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")** - [![Prodessa's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29619-prodessa "View Prodessa's Profile") Topic Author - [ Offline](/forum/user/29619-prodessa) Less More - Posts: 11 - Thank you received: 0 - - 12 years 9 months ago [\#138263](#138263) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") Replied by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#138263 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* I found a way arround it by removing the products directly from the database by a seperate routine. Did you have a look at the code what I mentioned in my earlier response? Currently I'm not able to provide but i will try this week. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) 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 9 months ago [\#138294](#138294) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Removal of Products when importing CSV](/forum/37-import-export-csv-xls/863831-removal-of-products-when-importing-csv#138294 "Hi, Currently we are using Hikashop Products Cron Update Plugin to process our articles/products. As we enabled the option delete products not in CSV you would expect that products will be removed/deleted from our shop. The current format of the CSV is: product_code|price_value|categories|categories_namekey|images|product_quantity|product_description|cxp_merknaam|product_name|product_sale_end|cxp_toepassing|cxp_materiaal|product_published|cxp_levertijd|cxp_normale_prijs The importing is working as it should be! The removal is however not working despite the configuration of the column names configurations: Configuration of column names: product_code:product_code|price_value:price_value|categories:categories|categories_namekey:categories_namekey|images:images|product_quantity:product_quantity|product_description:product_description|cxp_merknaam:cxp_merknaam|product_name:product_name|product_sale_end:product_sale_end|cxp_toepassing:cxp_toepassing|cxp_materiaal:cxp_materiaal|product_published:product_published|cxp_levertijd:cxp_levertijd|cxp_normale_prijs:cxp_normale_prijs It's rather difficult to troubleshoot or find documentation/examples. What are the criteria to get is working successful?")* We had made few changes on the mass actions. But not sure that they fix this problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjM4MzEtcmVtb3ZhbC1vZi1wcm9kdWN0cy13aGVuLWltcG9ydGluZy1jc3Y/dG1wbD1tYXJrZG93bg==) 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.228 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)