[Skip to main content](#vessel-content) # Importing Products and Product Variants at the same time ## - **[jtquinto](/forum/user/31780-jtquinto "View jtquinto's Profile")** - [![jtquinto's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31780-jtquinto "View jtquinto's Profile") Topic Author - [ Offline](/forum/user/31780-jtquinto) Less More - Posts: 30 - Thank you received: 2 - - 8 years 8 months ago [\#288283](#288283) by [jtquinto](/forum/user/31780-jtquinto "View jtquinto's Profile") *[Importing Products and Product Variants at the same time](/forum/37-import-export-csv-xls/893867-importing-products-and-product-variants-at-the-same-time#288283 "-- HikaShop version -- : 3.3.0 -- Joomla version -- : 3.8.5 I'm trying to populate a shop catalog with some sample products and their corresponding variants thru a CSV file. The results seem ok, at first; I imported 2 products with 2 and 3 variants, respectively, and 7 items have been created. When I check the Product List in the back-end, the 2 main items and 5 variants are listed and published, as expected. However, the product variants do not show up in the front-end and are not accessible in the back-end (only the parent product page opens, and there is no Variants tab) until I actually add and save the Characteristics to the main product page. After that, the Variants tab would show with the proper number of Imported variant items, but the list would show them having the selected default values in the Characteristics section of the main product page. ... but the variants would have the proper values saved when you open their detail page. I've attached the sample CSV file I'm using: Also...how to set the default Product Variant when importing from CSV? I'm getting a "No Default Variant" warning message when the selected Characteristics default values are not in the imported Variants listings.")* was created by *[jtquinto](/forum/user/31780-jtquinto "View jtquinto's Profile")* -- HikaShop version -- : 3.3.0 -- Joomla version -- : 3.8.5 I'm trying to populate a shop catalog with some sample products and their corresponding variants thru a CSV file. The results seem ok, at first; I imported 2 products with 2 and 3 variants, respectively, and 7 items have been created. When I check the Product List in the back-end, the 2 main items and 5 variants are listed and published, as expected. However, the product variants do not show up in the front-end and are not accessible in the back-end (only the parent product page opens, and there is no Variants tab) until I actually add and save the Characteristics to the main product page. [ ![hika-import-variants-tab-01.jpg](/forum/attachment/42716) ](/forum/attachment/42716 "...nts-tab-01.jpg") [ ![hika-import-characteristics-01.jpg](/forum/attachment/42715) ](/forum/attachment/42715 "...ristics-01.jpg") After that, the Variants tab would show with the proper number of Imported variant items, but the list would show them having the selected default values in the Characteristics section of the main product page. ... but the variants would have the proper values saved when you open their detail page. [ ![hika-import-variant-page.jpg](/forum/attachment/42718) ](/forum/attachment/42718 "...riant-page.jpg") I've attached the sample CSV file I'm using: *This attachment is hidden for guests. Please log in or register to see it.* Also...how to set the default Product Variant when importing from CSV? I'm getting a "No Default Variant" warning message when the selected Characteristics default values are not in the imported Variants listings. - [ ![hika-import-characteristics-01.jpg](/forum/attachment/42715) ](/forum/attachment/42715 "...ristics-01.jpg") [ ](/forum/attachment/42715?download=1 "...ristics-01.jpg") - [ ![hika-import-variants-tab-01.jpg](/forum/attachment/42716) ](/forum/attachment/42716 "...nts-tab-01.jpg") [ ](/forum/attachment/42716?download=1 "...nts-tab-01.jpg") - [ ![hika-import-variant-page.jpg](/forum/attachment/42718) ](/forum/attachment/42718 "...riant-page.jpg") [ ](/forum/attachment/42718?download=1 "...riant-page.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTM4NjctaW1wb3J0aW5nLXByb2R1Y3RzLWFuZC1wcm9kdWN0LXZhcmlhbnRzLWF0LXRoZS1zYW1lLXRpbWU/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 8 years 8 months ago [\#288289](#288289) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing Products and Product Variants at the same time](/forum/37-import-export-csv-xls/893867-importing-products-and-product-variants-at-the-same-time#288289 "-- HikaShop version -- : 3.3.0 -- Joomla version -- : 3.8.5 I'm trying to populate a shop catalog with some sample products and their corresponding variants thru a CSV file. The results seem ok, at first; I imported 2 products with 2 and 3 variants, respectively, and 7 items have been created. When I check the Product List in the back-end, the 2 main items and 5 variants are listed and published, as expected. However, the product variants do not show up in the front-end and are not accessible in the back-end (only the parent product page opens, and there is no Variants tab) until I actually add and save the Characteristics to the main product page. After that, the Variants tab would show with the proper number of Imported variant items, but the list would show them having the selected default values in the Characteristics section of the main product page. ... but the variants would have the proper values saved when you open their detail page. I've attached the sample CSV file I'm using: Also...how to set the default Product Variant when importing from CSV? I'm getting a "No Default Variant" warning message when the selected Characteristics default values are not in the imported Variants listings.")* Hi, As you guessed, you're missing something in your CSV. You need to set the default value in the cell of the characteristic for the main product in your CSV: [ monosnap.com/file/9Wadhr1ccOmm2hDXAQ2WK06QaUjR2f](https://monosnap.com/file/9Wadhr1ccOmm2hDXAQ2WK06QaUjR2f) The following user(s) said Thank You: [jtquinto](/forum/user/31780-jtquinto "View jtquinto's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTM4NjctaW1wb3J0aW5nLXByb2R1Y3RzLWFuZC1wcm9kdWN0LXZhcmlhbnRzLWF0LXRoZS1zYW1lLXRpbWU/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.047 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)