[Skip to main content](#vessel-content) # Import CSV with products and manual variants ## - **[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 2 months ago - 12 years 2 months ago [\#167904](#167904) by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile") *[Import CSV with products and manual variants](/forum/37-import-export-csv-xls/870442-import-csv-with-products-and-manual-variants#167904 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 2.5.22 -- PHP version -- : 5 Ls, Currently we are using csv import to insert our products in to hikashop, however we need to put some variants manually together. The source system that compiles the csv is not able to do it automatically. However when we put the variants together by hand and run the next update of the product all variants are again main products. We know the product id or product code that does not change during import why are the variants removed to the main category? Is there a option to change the behavior of the CSV import and that it leaves the variants the way they are?")* was created by *[Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile")* -- HikaShop version -- : 2.3.2 -- Joomla version -- : 2.5.22 -- PHP version -- : 5 Ls, Currently we are using csv import to insert our products in to hikashop, however we need to put some variants manually together. The source system that compiles the csv is not able to do it automatically. However when we put the variants together by hand and run the next update of the product all variants are again main products. We know the product id or product code that does not change during import why are the variants removed to the main category? Is there a option to change the behavior of the CSV import and that it leaves the variants the way they are? Last edit: 12 years 2 months ago by [Prodessa](/forum/user/29619-prodessa "View Prodessa's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA0NDItaW1wb3J0LWNzdi13aXRoLXByb2R1Y3RzLWFuZC1tYW51YWwtdmFyaWFudHM/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 2 months ago [\#167951](#167951) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import CSV with products and manual variants](/forum/37-import-export-csv-xls/870442-import-csv-with-products-and-manual-variants#167951 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 2.5.22 -- PHP version -- : 5 Ls, Currently we are using csv import to insert our products in to hikashop, however we need to put some variants manually together. The source system that compiles the csv is not able to do it automatically. However when we put the variants together by hand and run the next update of the product all variants are again main products. We know the product id or product code that does not change during import why are the variants removed to the main category? Is there a option to change the behavior of the CSV import and that it leaves the variants the way they are?")* Hi, It's probably that you're missing some data in the CSV file preventing HikaShop from knowing that the elements that you're adding are variants and not main products and thus when it updates their information, it removes the link between the variant and the main product and the variant becomes itself a main product. So I would first recommend to check the product_type and product_parent_id columns of your CSV, the characteristic column of your CSV and fact that you have the main product entry on your CSV before the variants. Remember that the import system is to import new data, not to update the existing data. If for example you just want to update the quantities of the products/variants with just the product_id and the product_quantity columns in your CSV, then I would recommend instead to create a mass action with a filter "CSV products". This wil really update the products/variants data without other alteration. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA0NDItaW1wb3J0LWNzdi13aXRoLXByb2R1Y3RzLWFuZC1tYW51YWwtdmFyaWFudHM/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.081 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)