[Skip to main content](#vessel-content) # Profile for tuva ## [![tuva's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/28511-tuva "View tuva's Profile") **[ Offline](/forum/user/28511-tuva)** - **User Type:** User - **Register Date:** 07 Oct 2013 - **Last login:** 12 years 10 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 15:07 - **Posts:** 5 - **Profile views:** 39 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # tuva's recent posts (5 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/37-import-export-csv-xls/864185-import-variants-problem#135759) | [Import variants problem](/forum/37-import-export-csv-xls/864185-import-variants-problem#135759 "-- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.1.5 Using Open Office Calc I'm getting very close, but having problems with getting variants to import. I have about 260 products with 2 variants for each - an original painting and a print. I set up two products correctly in Hikashop with the variants as an example. Those are product IDs 108 and 209. I exported the file, then edited it in Open Office Calc to match the same structure. When I import, it gets all of the products but not the variants. In Open Office, I think I see the problem - the last two columns are "related" and "options". The next column has no header and that is where Calc thinks the variants should go. I have included the two files: workfile from hikashopexport4.csv - the file I'm editing test.txt - exported from Hikashop after the import I think all I need to do is get the correct heading name for the variants, but I can't find that documentation. Any help would be appreciated.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 10 months ago, by [tuva](/forum/user/28511-tuva "View tuva's Profile") [Last Post](/forum/37-import-export-csv-xls/864185-import-variants-problem#135759 "Never mind. My dev team says they know how to do that. Thanks") 12 years 10 months ago by [tuva](/forum/user/28511-tuva "View tuva's Profile") | Replies:3 Views:925 | [Last Post](/forum/37-import-export-csv-xls/864185-import-variants-problem#135759 "Never mind. My dev team says they know how to do that. Thanks") by [tuva](/forum/user/28511-tuva "View tuva's Profile") 12 years 10 months ago | | [](/forum/37-import-export-csv-xls/864185-import-variants-problem#135751) | [Import variants problem](/forum/37-import-export-csv-xls/864185-import-variants-problem#135751 "-- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.1.5 Using Open Office Calc I'm getting very close, but having problems with getting variants to import. I have about 260 products with 2 variants for each - an original painting and a print. I set up two products correctly in Hikashop with the variants as an example. Those are product IDs 108 and 209. I exported the file, then edited it in Open Office Calc to match the same structure. When I import, it gets all of the products but not the variants. In Open Office, I think I see the problem - the last two columns are "related" and "options". The next column has no header and that is where Calc thinks the variants should go. I have included the two files: workfile from hikashopexport4.csv - the file I'm editing test.txt - exported from Hikashop after the import I think all I need to do is get the correct heading name for the variants, but I can't find that documentation. Any help would be appreciated.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 10 months ago, by [tuva](/forum/user/28511-tuva "View tuva's Profile") [Last Post](/forum/37-import-export-csv-xls/864185-import-variants-problem#135759 "Never mind. My dev team says they know how to do that. Thanks") 12 years 10 months ago by [tuva](/forum/user/28511-tuva "View tuva's Profile") | Replies:3 Views:925 | [Last Post](/forum/37-import-export-csv-xls/864185-import-variants-problem#135759 "Never mind. My dev team says they know how to do that. Thanks") by [tuva](/forum/user/28511-tuva "View tuva's Profile") 12 years 10 months ago | | [](/forum/37-import-export-csv-xls/864185-import-variants-problem#135658) | [Import variants problem](/forum/37-import-export-csv-xls/864185-import-variants-problem#135658 "-- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.1.5 Using Open Office Calc I'm getting very close, but having problems with getting variants to import. I have about 260 products with 2 variants for each - an original painting and a print. I set up two products correctly in Hikashop with the variants as an example. Those are product IDs 108 and 209. I exported the file, then edited it in Open Office Calc to match the same structure. When I import, it gets all of the products but not the variants. In Open Office, I think I see the problem - the last two columns are "related" and "options". The next column has no header and that is where Calc thinks the variants should go. I have included the two files: workfile from hikashopexport4.csv - the file I'm editing test.txt - exported from Hikashop after the import I think all I need to do is get the correct heading name for the variants, but I can't find that documentation. Any help would be appreciated.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 10 months ago, by [tuva](/forum/user/28511-tuva "View tuva's Profile") [Last Post](/forum/37-import-export-csv-xls/864185-import-variants-problem#135759 "Never mind. My dev team says they know how to do that. Thanks") 12 years 10 months ago by [tuva](/forum/user/28511-tuva "View tuva's Profile") | Replies:3 Views:925 | [Last Post](/forum/37-import-export-csv-xls/864185-import-variants-problem#135759 "Never mind. My dev team says they know how to do that. Thanks") by [tuva](/forum/user/28511-tuva "View tuva's Profile") 12 years 10 months ago | | [](/forum/37-import-export-csv-xls/864131-export-error#135497) | [Export error](/forum/37-import-export-csv-xls/864131-export-error#135497 "-- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.1.5 I have HikaShop Essential: 2.2.2 I'm working on getting about 250 products set up for an artist. Each has an "Original" and a variant for a "Print". I can do that just fine. I want to set up all the product through an import and am doing this in stages. I got all of the original products imported with no problems. I then went through the admin tools and set up a few of them in Hikashop with the variants so I could see the data structure and then duplicate it for all the other products. When I export my sample file to a text file and import it into Excel, it appears that the fields for the products I edited don't line up. For example, the product ID field has text from the description. All of the original imported products are OK, only the ones I edited in Hikashop are broken. Any ideas? I've attached the file. Thanks") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 10 months ago, by [tuva](/forum/user/28511-tuva "View tuva's Profile") [Last Post](/forum/37-import-export-csv-xls/864131-export-error#135497 "Yes, Open Office Calc worked much better. Excel 2010 choked on it though. But that will work great. thanks") 12 years 10 months ago by [tuva](/forum/user/28511-tuva "View tuva's Profile") | Replies:2 Views:858 | [Last Post](/forum/37-import-export-csv-xls/864131-export-error#135497 "Yes, Open Office Calc worked much better. Excel 2010 choked on it though. But that will work great. thanks") by [tuva](/forum/user/28511-tuva "View tuva's Profile") 12 years 10 months ago | | [](/forum/37-import-export-csv-xls/864131-export-error#135391) | [Export error](/forum/37-import-export-csv-xls/864131-export-error#135391 "-- HikaShop version -- : 2.2.2 -- Joomla version -- : 3.1.5 I have HikaShop Essential: 2.2.2 I'm working on getting about 250 products set up for an artist. Each has an "Original" and a variant for a "Print". I can do that just fine. I want to set up all the product through an import and am doing this in stages. I got all of the original products imported with no problems. I then went through the admin tools and set up a few of them in Hikashop with the variants so I could see the data structure and then duplicate it for all the other products. When I export my sample file to a text file and import it into Excel, it appears that the fields for the products I edited don't line up. For example, the product ID field has text from the description. All of the original imported products are OK, only the ones I edited in Hikashop are broken. Any ideas? I've attached the file. Thanks") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 10 months ago, by [tuva](/forum/user/28511-tuva "View tuva's Profile") [Last Post](/forum/37-import-export-csv-xls/864131-export-error#135497 "Yes, Open Office Calc worked much better. Excel 2010 choked on it though. But that will work great. thanks") 12 years 10 months ago by [tuva](/forum/user/28511-tuva "View tuva's Profile") | Replies:2 Views:858 | [Last Post](/forum/37-import-export-csv-xls/864131-export-error#135497 "Yes, Open Office Calc worked much better. Excel 2010 choked on it though. But that will work great. thanks") by [tuva](/forum/user/28511-tuva "View tuva's Profile") 12 years 10 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.099 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)