[Skip to main content](#vessel-content) # Importing products - variants import problem ## - **[rikatos](/forum/user/1634-rikatos "View rikatos's Profile")** - [![rikatos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1634-rikatos "View rikatos's Profile") Topic Author - [ Offline](/forum/user/1634-rikatos) Less More - Posts: 179 - Thank you received: 17 - - - [](http://oceansafety.com) - 13 years 6 months ago - 13 years 6 months ago [\#98225](#98225) by [rikatos](/forum/user/1634-rikatos "View rikatos's Profile") *[Importing products - variants import problem](/forum/3-bug-report/80165-importing-products-variants-import-problem#98225 "I exported my products from my current hikashop on joomla 2.5.9, to reimport them in my new build joomla 3. Products imported with no problems. Variants claim to have imported with errors but do not show up #in the characteristics. One line from the errors is listed below :) I include the variants from one product as an attachment below. You will notice it makes a lot of extra columns which are what gives the error below : The column 'sport pro options' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored It says it ignores the extra columns and imports, but the part codes cannot be found anywhere. Joomla 3, latest hikashop business, oceans17.co.uk")* was created by *[rikatos](/forum/user/1634-rikatos "View rikatos's Profile")* I exported my products from my current hikashop on joomla 2.5.9, to reimport them in my new build joomla 3. Products imported with no problems. Variants claim to have imported with errors but do not show up #in the characteristics. One line from the errors is listed below ![:)](/media/kunena/emoticons/3.png ":)") I include the variants from one product as an attachment below. You will notice it makes a lot of extra columns which are what gives the error below : The column 'sport pro options' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored It says it ignores the extra columns and imports, but the part codes cannot be found anywhere. Joomla 3, latest hikashop business, [ oceans17.co.uk](http://oceans17.co.uk) Last edit: 13 years 6 months ago by [rikatos](/forum/user/1634-rikatos "View rikatos's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDE2NS1pbXBvcnRpbmctcHJvZHVjdHMtdmFyaWFudHMtaW1wb3J0LXByb2JsZW0/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86321 - Thank you received: 14279 - - 13 years 6 months ago [\#98443](#98443) 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 - variants import problem](/forum/3-bug-report/80165-importing-products-variants-import-problem#98443 "I exported my products from my current hikashop on joomla 2.5.9, to reimport them in my new build joomla 3. Products imported with no problems. Variants claim to have imported with errors but do not show up #in the characteristics. One line from the errors is listed below :) I include the variants from one product as an attachment below. You will notice it makes a lot of extra columns which are what gives the error below : The column 'sport pro options' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored It says it ignores the extra columns and imports, but the part codes cannot be found anywhere. Joomla 3, latest hikashop business, oceans17.co.uk")* Hi, Before importing the CSV, you need to create the characteristics via the menu Products->Characteristics. Otherwise, the system won't be able to import properly the variants. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDE2NS1pbXBvcnRpbmctcHJvZHVjdHMtdmFyaWFudHMtaW1wb3J0LXByb2JsZW0/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[rikatos](/forum/user/1634-rikatos "View rikatos's Profile")** - [![rikatos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1634-rikatos "View rikatos's Profile") Topic Author - [ Offline](/forum/user/1634-rikatos) Less More - Posts: 179 - Thank you received: 17 - - - [](http://oceansafety.com) - 13 years 6 months ago [\#98488](#98488) by [rikatos](/forum/user/1634-rikatos "View rikatos's Profile") Replied by *[rikatos](/forum/user/1634-rikatos "View rikatos's Profile")* on topic *[Importing products - variants import problem](/forum/3-bug-report/80165-importing-products-variants-import-problem#98488 "I exported my products from my current hikashop on joomla 2.5.9, to reimport them in my new build joomla 3. Products imported with no problems. Variants claim to have imported with errors but do not show up #in the characteristics. One line from the errors is listed below :) I include the variants from one product as an attachment below. You will notice it makes a lot of extra columns which are what gives the error below : The column 'sport pro options' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored It says it ignores the extra columns and imports, but the part codes cannot be found anywhere. Joomla 3, latest hikashop business, oceans17.co.uk")* Are you telling me that I need to re-create every single variant ? I have over 400 variants, and these variants have their own characteristics x 4 each minimum ! If so I think I may cry ! That would be totally crazy. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDE2NS1pbXBvcnRpbmctcHJvZHVjdHMtdmFyaWFudHMtaW1wb3J0LXByb2JsZW0/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86321 - Thank you received: 14279 - - 13 years 6 months ago [\#98686](#98686) 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 - variants import problem](/forum/3-bug-report/80165-importing-products-variants-import-problem#98686 "I exported my products from my current hikashop on joomla 2.5.9, to reimport them in my new build joomla 3. Products imported with no problems. Variants claim to have imported with errors but do not show up #in the characteristics. One line from the errors is listed below :) I include the variants from one product as an attachment below. You will notice it makes a lot of extra columns which are what gives the error below : The column 'sport pro options' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored It says it ignores the extra columns and imports, but the part codes cannot be found anywhere. Joomla 3, latest hikashop business, oceans17.co.uk")* Hi, That's not what I'm saying. I'm saying that you need to create the characteristics, not the variants of the products. You can ind your characteristics via the menu Products->Characteristics. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDE2NS1pbXBvcnRpbmctcHJvZHVjdHMtdmFyaWFudHMtaW1wb3J0LXByb2JsZW0/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[rikatos](/forum/user/1634-rikatos "View rikatos's Profile")** - [![rikatos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1634-rikatos "View rikatos's Profile") Topic Author - [ Offline](/forum/user/1634-rikatos) Less More - Posts: 179 - Thank you received: 17 - - - [](http://oceansafety.com) - 13 years 6 months ago [\#99173](#99173) by [rikatos](/forum/user/1634-rikatos "View rikatos's Profile") Replied by *[rikatos](/forum/user/1634-rikatos "View rikatos's Profile")* on topic *[Importing products - variants import problem](/forum/3-bug-report/80165-importing-products-variants-import-problem#99173 "I exported my products from my current hikashop on joomla 2.5.9, to reimport them in my new build joomla 3. Products imported with no problems. Variants claim to have imported with errors but do not show up #in the characteristics. One line from the errors is listed below :) I include the variants from one product as an attachment below. You will notice it makes a lot of extra columns which are what gives the error below : The column 'sport pro options' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored It says it ignores the extra columns and imports, but the part codes cannot be found anywhere. Joomla 3, latest hikashop business, oceans17.co.uk")* Ahh ok, but still, that means in my case about 400 characteristics to be made, and its not a big store, but at least I dont have to re-create the 1600 or so variants. Its a hollow yayy but a yayy none the less. I guess Im off to do the painful excercise of creating those 400 characteristics manually then...ouchy still ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDE2NS1pbXBvcnRpbmctcHJvZHVjdHMtdmFyaWFudHMtaW1wb3J0LXByb2JsZW0/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86321 - Thank you received: 14279 - - 13 years 6 months ago [\#99181](#99181) 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 - variants import problem](/forum/3-bug-report/80165-importing-products-variants-import-problem#99181 "I exported my products from my current hikashop on joomla 2.5.9, to reimport them in my new build joomla 3. Products imported with no problems. Variants claim to have imported with errors but do not show up #in the characteristics. One line from the errors is listed below :) I include the variants from one product as an attachment below. You will notice it makes a lot of extra columns which are what gives the error below : The column 'sport pro options' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored It says it ignores the extra columns and imports, but the part codes cannot be found anywhere. Joomla 3, latest hikashop business, oceans17.co.uk")* To do that more easily, you could simply export the table hikashop_characteristic and import it on your new website via phpmyadmin. That will take 2 minutes. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDE2NS1pbXBvcnRpbmctcHJvZHVjdHMtdmFyaWFudHMtaW1wb3J0LXByb2JsZW0/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[rikatos](/forum/user/1634-rikatos "View rikatos's Profile")** - [![rikatos's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1634-rikatos "View rikatos's Profile") Topic Author - [ Offline](/forum/user/1634-rikatos) Less More - Posts: 179 - Thank you received: 17 - - - [](http://oceansafety.com) - 13 years 6 months ago - 13 years 6 months ago [\#99309](#99309) by [rikatos](/forum/user/1634-rikatos "View rikatos's Profile") Replied by *[rikatos](/forum/user/1634-rikatos "View rikatos's Profile")* on topic *[Importing products - variants import problem](/forum/3-bug-report/80165-importing-products-variants-import-problem#99309 "I exported my products from my current hikashop on joomla 2.5.9, to reimport them in my new build joomla 3. Products imported with no problems. Variants claim to have imported with errors but do not show up #in the characteristics. One line from the errors is listed below :) I include the variants from one product as an attachment below. You will notice it makes a lot of extra columns which are what gives the error below : The column 'sport pro options' is not in the list of possible columns : product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. The column data was ignored It says it ignores the extra columns and imports, but the part codes cannot be found anywhere. Joomla 3, latest hikashop business, oceans17.co.uk")* exported the table, changed table name prefix in export to the new one, imported. Most worked so thats great! Just a side note, the import didnt seem to bring in the same order for variants listing, so now I have variants with mixed up orders and unfortunately the variants dont seem to have a way of ordering them still apart from the way they are created , so big ouchy still as I now need to step through each product, check the ordering of the variant and delete them all and re create them if they are wrong:( Last edit: 13 years 6 months ago by [rikatos](/forum/user/1634-rikatos "View rikatos's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDE2NS1pbXBvcnRpbmctcHJvZHVjdHMtdmFyaWFudHMtaW1wb3J0LXByb2JsZW0/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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.122 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)