[Skip to main content](#vessel-content) # Quick/easy way to add possible values for product variant caracteristics? ## - **[Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile")** - [![Foxworks's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7379.png)](/forum/user/7379-foxworks "View Foxworks's Profile") Topic Author - [ Offline](/forum/user/7379-foxworks) Less More - Posts: 92 - Thank you received: 5 - - - 2 years 5 months ago [\#361332](#361332) by [Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile") *[Quick/easy way to add possible values for product variant caracteristics?](/forum/37-import-export-csv-xls/908232-quick-easy-way-to-add-possible-values-for-product-variant-caracteristics#361332 "-- url of the page with the problem -- : kiteoutlet.eu -- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.5 For the webshop I manage I have done a few large CSV imports of new products with variants to update the product range of the supplier. This works fine following the documentation for importing products with variants found here: www.hikashop.com/support/documentation/7...-import.html#variant As per the instructions, to be able to do a successful CSV import, you first need to create the characteristic and the possible values via the menu Products>Characteristics. For my previous imports creating the characteristics and their values manually was a tedious task but not impossible. However for the latest import of products from one of the website's suppliers I will need to create a handful of new characteristics with a total of over 450 possible values. This is an enormous task to do manually, so I was hoping that there is a way to do this more easily. If it is at all possible to create the large amount of values in a more user friendly/less labor-intensive way (for example by also uploading a CSV with all possible values, running a batch command somewhere, or editing the database using a bulk action or sql-script), please let me know!")* was created by *[Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile")* -- url of the page with the problem -- : kiteoutlet.eu -- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.5 For the webshop I manage I have done a few large CSV imports of new products with variants to update the product range of the supplier. This works fine following the documentation for importing products with variants found here: [ www.hikashop.com/support/documentation/7...-import.html#variant](https://www.hikashop.com/support/documentation/73-hikashop-import.html#variant) As per the instructions, to be able to do a successful CSV import, you first need to create the characteristic and the possible values via the menu Products>Characteristics. For my previous imports creating the characteristics and their values manually was a tedious task but not impossible. However for the latest import of products from one of the website's suppliers I will need to create a handful of new characteristics with a total of over 450 possible values. This is an enormous task to do manually, so I was hoping that there is a way to do this more easily. If it is at all possible to create the large amount of values in a more user friendly/less labor-intensive way (for example by also uploading a CSV with all possible values, running a batch command somewhere, or editing the database using a bulk action or sql-script), please let me know! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDgyMzItcXVpY2stZWFzeS13YXktdG8tYWRkLXBvc3NpYmxlLXZhbHVlcy1mb3ItcHJvZHVjdC12YXJpYW50LWNhcmFjdGVyaXN0aWNzP3RtcGw9bWFya2Rvd24=) 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: 86326 - Thank you received: 14288 - - 2 years 5 months ago [\#361333](#361333) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Quick/easy way to add possible values for product variant caracteristics?](/forum/37-import-export-csv-xls/908232-quick-easy-way-to-add-possible-values-for-product-variant-caracteristics#361333 "-- url of the page with the problem -- : kiteoutlet.eu -- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.5 For the webshop I manage I have done a few large CSV imports of new products with variants to update the product range of the supplier. This works fine following the documentation for importing products with variants found here: www.hikashop.com/support/documentation/7...-import.html#variant As per the instructions, to be able to do a successful CSV import, you first need to create the characteristic and the possible values via the menu Products>Characteristics. For my previous imports creating the characteristics and their values manually was a tedious task but not impossible. However for the latest import of products from one of the website's suppliers I will need to create a handful of new characteristics with a total of over 450 possible values. This is an enormous task to do manually, so I was hoping that there is a way to do this more easily. If it is at all possible to create the large amount of values in a more user friendly/less labor-intensive way (for example by also uploading a CSV with all possible values, running a batch command somewhere, or editing the database using a bulk action or sql-script), please let me know!")* Hi, You can use the CSV export and import features of PHPMyAdmin to import your characteristics and their values to the hikashop_characteristic table in your database. The following user(s) said Thank You: [Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDgyMzItcXVpY2stZWFzeS13YXktdG8tYWRkLXBvc3NpYmxlLXZhbHVlcy1mb3ItcHJvZHVjdC12YXJpYW50LWNhcmFjdGVyaXN0aWNzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile")** - [![Foxworks's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7379.png)](/forum/user/7379-foxworks "View Foxworks's Profile") Topic Author - [ Offline](/forum/user/7379-foxworks) Less More - Posts: 92 - Thank you received: 5 - - - 2 years 5 months ago [\#361335](#361335) by [Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile") Replied by *[Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile")* on topic *[Quick/easy way to add possible values for product variant caracteristics?](/forum/37-import-export-csv-xls/908232-quick-easy-way-to-add-possible-values-for-product-variant-caracteristics#361335 "-- url of the page with the problem -- : kiteoutlet.eu -- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.5 For the webshop I manage I have done a few large CSV imports of new products with variants to update the product range of the supplier. This works fine following the documentation for importing products with variants found here: www.hikashop.com/support/documentation/7...-import.html#variant As per the instructions, to be able to do a successful CSV import, you first need to create the characteristic and the possible values via the menu Products>Characteristics. For my previous imports creating the characteristics and their values manually was a tedious task but not impossible. However for the latest import of products from one of the website's suppliers I will need to create a handful of new characteristics with a total of over 450 possible values. This is an enormous task to do manually, so I was hoping that there is a way to do this more easily. If it is at all possible to create the large amount of values in a more user friendly/less labor-intensive way (for example by also uploading a CSV with all possible values, running a batch command somewhere, or editing the database using a bulk action or sql-script), please let me know!")* Thank you. I will give that a try! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDgyMzItcXVpY2stZWFzeS13YXktdG8tYWRkLXBvc3NpYmxlLXZhbHVlcy1mb3ItcHJvZHVjdC12YXJpYW50LWNhcmFjdGVyaXN0aWNzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile")** - [![Foxworks's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7379.png)](/forum/user/7379-foxworks "View Foxworks's Profile") Topic Author - [ Offline](/forum/user/7379-foxworks) Less More - Posts: 92 - Thank you received: 5 - - - 2 years 5 months ago - 2 years 5 months ago [\#361387](#361387) by [Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile") Replied by *[Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile")* on topic *[Quick/easy way to add possible values for product variant caracteristics?](/forum/37-import-export-csv-xls/908232-quick-easy-way-to-add-possible-values-for-product-variant-caracteristics#361387 "-- url of the page with the problem -- : kiteoutlet.eu -- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.5 For the webshop I manage I have done a few large CSV imports of new products with variants to update the product range of the supplier. This works fine following the documentation for importing products with variants found here: www.hikashop.com/support/documentation/7...-import.html#variant As per the instructions, to be able to do a successful CSV import, you first need to create the characteristic and the possible values via the menu Products>Characteristics. For my previous imports creating the characteristics and their values manually was a tedious task but not impossible. However for the latest import of products from one of the website's suppliers I will need to create a handful of new characteristics with a total of over 450 possible values. This is an enormous task to do manually, so I was hoping that there is a way to do this more easily. If it is at all possible to create the large amount of values in a more user friendly/less labor-intensive way (for example by also uploading a CSV with all possible values, running a batch command somewhere, or editing the database using a bulk action or sql-script), please let me know!")* Thanks again Nicholas for your answer. Exporting the hikashop_characteristic table from the MySQL database to see how the file should be formatted and then uploading the new rows to be added with the info for all the characteristics values I needed to add worked like a charm! The only issue I ran into was that MySQL automatically escaped all " in the names for the values (used to indicate dimensions in inches) by adding an extra set of double quotation marks ("") around them. There probably is an option somewhere that I could have checked on import to prevent this but I only found out after importing. Luckily I didn't have too many values that were formatted like that, so I could easily change them back in HikShop. Last edit: 2 years 5 months ago by [Foxworks](/forum/user/7379-foxworks "View Foxworks's Profile"). The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDgyMzItcXVpY2stZWFzeS13YXktdG8tYWRkLXBvc3NpYmxlLXZhbHVlcy1mb3ItcHJvZHVjdC12YXJpYW50LWNhcmFjdGVyaXN0aWNzP3RtcGw9bWFya2Rvd24=) 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.063 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)