[Skip to main content](#vessel-content) # parent\_category in import/export ## - **[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")** - [![plumbingdeals's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Topic Author - [ Offline](/forum/user/3607-plumbingdeals) Less More - Posts: 223 - Thank you received: 1 - - 14 years 10 months ago [\#32271](#32271) by [plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") *[parent\_category in import/export](/forum/4-how-to/32271-parent-category-in-import-export#32271 "having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks")* was created by *[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")* having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMyMjcxLXBhcmVudC1jYXRlZ29yeS1pbi1pbXBvcnQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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: 86289 - Thank you received: 14265 - - 14 years 10 months ago [\#32294](#32294) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: parent\_category in import/export](/forum/4-how-to/32271-parent-category-in-import-export#32294 "having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks")* This column is for specifying the parent category of the categories of the product. But that column is optional. It's useful when you have two categories with the same name so that the system knows which one you're talking about. Do you want to remove the products ? Or do you want to remove the link of these products to that category ? If you want to remove the products of a category, it's easy, you can do that on the listing products with the delete button after selecting all the products of a category. If you want to remove the link between them the easiest is to use phpmyadmin and run a query like that: DELETE FROM jos_hikashop_product_category WHERE category_id=XX Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMyMjcxLXBhcmVudC1jYXRlZ29yeS1pbi1pbXBvcnQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")** - [![plumbingdeals's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Topic Author - [ Offline](/forum/user/3607-plumbingdeals) Less More - Posts: 223 - Thank you received: 1 - - 14 years 10 months ago [\#32602](#32602) by [plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Replied by *[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")* on topic *[Re: parent\_category in import/export](/forum/4-how-to/32271-parent-category-in-import-export#32602 "having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks")* that is the problem i am running into.... example....i have a main category 181 whose parent is 2 181 has a sub of 182, which has a sub of 187 which one would go in the parent_category column? thanks... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMyMjcxLXBhcmVudC1jYXRlZ29yeS1pbi1pbXBvcnQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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: 86289 - Thank you received: 14265 - - 14 years 10 months ago [\#32632](#32632) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: parent\_category in import/export](/forum/4-how-to/32271-parent-category-in-import-export#32632 "having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks")* If your categories are already created, do not use the parent_category column and directly put the id of the category you want in the "categories" column. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMyMjcxLXBhcmVudC1jYXRlZ29yeS1pbi1pbXBvcnQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")** - [![plumbingdeals's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Topic Author - [ Offline](/forum/user/3607-plumbingdeals) Less More - Posts: 223 - Thank you received: 1 - - 14 years 10 months ago - 14 years 10 months ago [\#32635](#32635) by [plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Replied by *[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")* on topic *[Re: parent\_category in import/export](/forum/4-how-to/32271-parent-category-in-import-export#32635 "having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks")* yeah, i figured that out. unfortunately i have made a mess of my categories! question... if i upload a csv with corrected categories, will that overwrite the existing categories? second question... is it better to use category name or number when uploading products? thanks! oh...one more question... i deleted some products due to this mess, can i upload them using the old product id number, or should i leave this column blank for these products when adding them back? Last edit: 14 years 10 months ago by [plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMyMjcxLXBhcmVudC1jYXRlZ29yeS1pbi1pbXBvcnQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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: 86289 - Thank you received: 14265 - - 14 years 10 months ago [\#32659](#32659) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: parent\_category in import/export](/forum/4-how-to/32271-parent-category-in-import-export#32659 "having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks")* No categories cannot be overwritten with the CSV import. It's better to use the id, especially if you have several categories with the same name ![:)](/media/kunena/emoticons/8.png ":)") The product_id will be ignored. However, if you set the product_code of your products in your CSV, the information of the products will be updated. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMyMjcxLXBhcmVudC1jYXRlZ29yeS1pbi1pbXBvcnQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")** - [![plumbingdeals's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Topic Author - [ Offline](/forum/user/3607-plumbingdeals) Less More - Posts: 223 - Thank you received: 1 - - 14 years 10 months ago [\#32661](#32661) by [plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile") Replied by *[plumbingdeals](/forum/user/3607-plumbingdeals "View plumbingdeals's Profile")* on topic *[Re: parent\_category in import/export](/forum/4-how-to/32271-parent-category-in-import-export#32661 "having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks")* i apologize, but now i'm a bit confused... what then is the best way to recategorize a large number of products? should i just delete them completely and start over, or is there a better way? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMyMjcxLXBhcmVudC1jYXRlZ29yeS1pbi1pbXBvcnQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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: 86289 - Thank you received: 14265 - - 14 years 10 months ago [\#32683](#32683) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: parent\_category in import/export](/forum/4-how-to/32271-parent-category-in-import-export#32683 "having a problem with categories... i notice that when i export a list of products, the csv has a column named "parent_category" which is empty for all products. what is this column for/do? also, is there a way to remove products from a single category in bulk? thanks")* You can just create such CSV: product_code,categories my_prod1,18 my_prod2,20 That will reassign my_prod1 to the category 18 and the my_prod2 to the category 20 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMyMjcxLXBhcmVudC1jYXRlZ29yeS1pbi1pbXBvcnQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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.217 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)