[Skip to main content](#vessel-content) # Some variants don't get imported for some reason ## - **[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")** - [![davidvan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41992-davidvan "View davidvan's Profile") Topic Author - [ Offline](/forum/user/41992-davidvan) Less More - Posts: 10 - Thank you received: 0 - - 10 years 5 days ago [\#254877](#254877) by [davidvan](/forum/user/41992-davidvan "View davidvan's Profile") *[Some variants don't get imported for some reason](/forum/25-install-update/887399-some-variants-dont-get-imported-for-some-reason#254877 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance")* was created by *[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")* -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NzM5OS1zb21lLXZhcmlhbnRzLWRvbnQtZ2V0LWltcG9ydGVkLWZvci1zb21lLXJlYXNvbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14304 - - 10 years 4 days ago [\#254906](#254906) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Some variants don't get imported for some reason](/forum/25-install-update/887399-some-variants-dont-get-imported-for-some-reason#254906 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance")* Hi, The CSV looks quite good to me. Maybe the problem is that the values you use in the "Maat" column of your CSV aren't registered as values in the "Maat" characteristic of your website ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NzM5OS1zb21lLXZhcmlhbnRzLWRvbnQtZ2V0LWltcG9ydGVkLWZvci1zb21lLXJlYXNvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")** - [![davidvan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41992-davidvan "View davidvan's Profile") Topic Author - [ Offline](/forum/user/41992-davidvan) Less More - Posts: 10 - Thank you received: 0 - - 10 years 4 days ago - 10 years 4 days ago [\#254917](#254917) by [davidvan](/forum/user/41992-davidvan "View davidvan's Profile") Replied by *[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")* on topic *[Some variants don't get imported for some reason](/forum/25-install-update/887399-some-variants-dont-get-imported-for-some-reason#254917 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance")* That's what I thougt too, but in some products the characteristic is used and works properly. As far as I can see they're all defined. Another issue that I encouter is that when i import my csv, that none of my products with variants have no default variant selected, although in my main product line it is defined.? Could this be linked with each other or could you give me some advise on how to define a default value in my csv? Thanks in advance. Last edit: 10 years 4 days ago by [davidvan](/forum/user/41992-davidvan "View davidvan's Profile"). Reason: Extra problem Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NzM5OS1zb21lLXZhcmlhbnRzLWRvbnQtZ2V0LWltcG9ydGVkLWZvci1zb21lLXJlYXNvbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14304 - - 10 years 4 days ago [\#254923](#254923) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Some variants don't get imported for some reason](/forum/25-install-update/887399-some-variants-dont-get-imported-for-some-reason#254923 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance")* Hi, Well, I had a second look at the CSV and still don't see any problem with it. Make sure that you don't have any extra characters for the product_code, product_parent_id and Maat values for these variants in your CSV. And make sure that you don't already have variants/products with the same product_code in the database. For the images, I see that you have some extra characters after the commas and the images might not display properly because of that, but it shouldn't change anything for the variants import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NzM5OS1zb21lLXZhcmlhbnRzLWRvbnQtZ2V0LWltcG9ydGVkLWZvci1zb21lLXJlYXNvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")** - [![davidvan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41992-davidvan "View davidvan's Profile") Topic Author - [ Offline](/forum/user/41992-davidvan) Less More - Posts: 10 - Thank you received: 0 - - 10 years 4 days ago [\#254956](#254956) by [davidvan](/forum/user/41992-davidvan "View davidvan's Profile") Replied by *[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")* on topic *[Some variants don't get imported for some reason](/forum/25-install-update/887399-some-variants-dont-get-imported-for-some-reason#254956 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance")* ok I'll take a look at it. Could you give me some advice on my seond proble, how to define the default characteristic in the csv/excell. At this moment every import leads to products that after import have a list of variants, but there is no default characteristic set. it creates an error "Hika_not_default_variant. Thanks in advance Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NzM5OS1zb21lLXZhcmlhbnRzLWRvbnQtZ2V0LWltcG9ydGVkLWZvci1zb21lLXJlYXNvbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14304 - - 10 years 3 days ago [\#254984](#254984) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Some variants don't get imported for some reason](/forum/25-install-update/887399-some-variants-dont-get-imported-for-some-reason#254984 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance")* Hi, You already do that in your CSV. The default characteristic value is entered in the characteristic cell of the main product and that's how the import system knows which characteristics are necessary for a product and what the default value should be used for it. So I don't see why it would do that unless the value entered their doesn't exist in the characteristic in your backend. Again, maybe it's related to the values having extra characters on the website or in the CSV. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NzM5OS1zb21lLXZhcmlhbnRzLWRvbnQtZ2V0LWltcG9ydGVkLWZvci1zb21lLXJlYXNvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")** - [![davidvan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41992-davidvan "View davidvan's Profile") Topic Author - [ Offline](/forum/user/41992-davidvan) Less More - Posts: 10 - Thank you received: 0 - - 9 years 11 months ago [\#255339](#255339) by [davidvan](/forum/user/41992-davidvan "View davidvan's Profile") Replied by *[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")* on topic *[Some variants don't get imported for some reason](/forum/25-install-update/887399-some-variants-dont-get-imported-for-some-reason#255339 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance")* For some reason it works when i changed the name form characteristic in the csv from Kleur to Color and in hikashop. I still have one problem, from my entire csv 35 variants don't get imported. I noticed that when i delete all my products and import the csv, hikashop says that import succeeded, but that 35 products already exist. This doesn't seem to be a coincidence that this is the same amount. Could someone give me an advice on what to do? Thanks in advance. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NzM5OS1zb21lLXZhcmlhbnRzLWRvbnQtZ2V0LWltcG9ydGVkLWZvci1zb21lLXJlYXNvbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14304 - - 9 years 11 months ago [\#255365](#255365) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Some variants don't get imported for some reason](/forum/25-install-update/887399-some-variants-dont-get-imported-for-some-reason#255365 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 7 Hello, I've created an excell file with different products, with main products and variants. I have different products with multiple variants, that are set in the same way. When I import the csv of it, for some reason hikashop imports most of the variants, but doesn't import all of them. I can't figure out why he leaves out some of them. Can someone assist me to find a possible solution? I've added a file with some products where some variants don't get imported for some reason. Thanks in advance")* Hi, Maybe the problem comes from the way the products are deleted. After you deleted them, go in your phpmyadmin and edit the tables: hikashop_product hikashop_product_category hikashop_variant hikashop_price and hikashop_product_related All these tables should be empty. If not, empty them. Then try again. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NzM5OS1zb21lLXZhcmlhbnRzLWRvbnQtZ2V0LWltcG9ydGVkLWZvci1zb21lLXJlYXNvbj90bXBsPW1hcmtkb3du) 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.057 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)