[Skip to main content](#vessel-content) # Importing without category columns ## - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Offline](/forum/user/8351-verzevoul) Less More - Posts: 1189 - Thank you received: 13 - - 5 years 6 months ago [\#331498](#331498) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") *[Importing without category columns](/forum/37-import-export-csv-xls/902325-importing-without-category-columns#331498 "Hi there! I m strungling importing a csv with some columns (product_id product_parent_id product_name product_quantity product_code product_published product_type product_msrp price_value price_access) Import finishes well but products almost the half lost their categories ids. And went to the parent category. Can I import without category columns? Thank you")* was created by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* Hi there! I m strungling importing a csv with some columns (product_id product_parent_id product_name product_quantity product_code product_published product_type product_msrp price_value price_access) Import finishes well but products almost the half lost their categories ids. And went to the parent category. Can I import without category columns? Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDIzMjUtaW1wb3J0aW5nLXdpdGhvdXQtY2F0ZWdvcnktY29sdW1ucz90bXBsPW1hcmtkb3du) 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: 14272 - - 5 years 6 months ago [\#331499](#331499) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing without category columns](/forum/37-import-export-csv-xls/902325-importing-without-category-columns#331499 "Hi there! I m strungling importing a csv with some columns (product_id product_parent_id product_name product_quantity product_code product_published product_type product_msrp price_value price_access) Import finishes well but products almost the half lost their categories ids. And went to the parent category. Can I import without category columns? Thank you")* Hi, First please note that there are two import systems in HikaShop: - The import in the Products>Import menu, which is meant to import new products primarily. - The import filter of mass actions in System>Mass actions, which is meant to update products information. I'll suppose that you're using the first one here. So first, I would rather recommend you use the second one for what you want to do, it's much more suitable. Then, if you use the first import, if you set the "product_type" to "variant" and you have the id of a main product in product_id (or the code of a main product in product_code), it will actually remove the categories of that product as the system will suppose that you're importing variant. So it could be linked to that. Also, with the first import, if you have the option "Update products information if the product_code already exists" activated, it will delete the link between the categories and the products if no category is provided in the CSV and the product is found. So make sure that is option is turned off if you don't want that to happen. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDIzMjUtaW1wb3J0aW5nLXdpdGhvdXQtY2F0ZWdvcnktY29sdW1ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Offline](/forum/user/8351-verzevoul) Less More - Posts: 1189 - Thank you received: 13 - - 5 years 6 months ago [\#331607](#331607) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Importing without category columns](/forum/37-import-export-csv-xls/902325-importing-without-category-columns#331607 "Hi there! I m strungling importing a csv with some columns (product_id product_parent_id product_name product_quantity product_code product_published product_type product_msrp price_value price_access) Import finishes well but products almost the half lost their categories ids. And went to the parent category. Can I import without category columns? Thank you")* Ok, nice! I imported a csv in mass actions succesfully with 3 prices but only the last price is written in the db. Please check - [ ![massactionsettings.png](/forum/attachment/52463) ](/forum/attachment/52463 "...onsettings.png") [ ](/forum/attachment/52463?download=1 "...onsettings.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDIzMjUtaW1wb3J0aW5nLXdpdGhvdXQtY2F0ZWdvcnktY29sdW1ucz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Offline](/forum/user/8351-verzevoul) Less More - Posts: 1189 - Thank you received: 13 - - 5 years 6 months ago - 5 years 6 months ago [\#331608](#331608) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Importing without category columns](/forum/37-import-export-csv-xls/902325-importing-without-category-columns#331608 "Hi there! I m strungling importing a csv with some columns (product_id product_parent_id product_name product_quantity product_code product_published product_type product_msrp price_value price_access) Import finishes well but products almost the half lost their categories ids. And went to the parent category. Can I import without category columns? Thank you")* I belive its easier to have the product prices in three rows thant 1 row with |. But is it possibe? Also I just noticed that category link are also deleted from mass action too Last edit: 5 years 6 months ago by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDIzMjUtaW1wb3J0aW5nLXdpdGhvdXQtY2F0ZWdvcnktY29sdW1ucz90bXBsPW1hcmtkb3du) 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: 14272 - - 5 years 6 months ago [\#331621](#331621) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing without category columns](/forum/37-import-export-csv-xls/902325-importing-without-category-columns#331621 "Hi there! I m strungling importing a csv with some columns (product_id product_parent_id product_name product_quantity product_code product_published product_type product_msrp price_value price_access) Import finishes well but products almost the half lost their categories ids. And went to the parent category. Can I import without category columns? Thank you")* Hi, You can't have several rows for the same product in a CSV. It's one row = one product. That's why you only got one price imported. Also, in your CSV you've entered "9" in the price_access column for the first price. But you need to have instead ",9," or it won't work properly. The user group ids needs to be surrounded by commas in CSV files. Regarding the category, I don't see how that could happen.... unless you have another mass action which delete the category for some reason during the import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDIzMjUtaW1wb3J0aW5nLXdpdGhvdXQtY2F0ZWdvcnktY29sdW1ucz90bXBsPW1hcmtkb3du) 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.098 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)