[Skip to main content](#vessel-content) # Improve Bulk Import Feature ## - **[makeeasy](/forum/user/16411-makeeasy "View makeeasy's Profile")** - [![makeeasy's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-04-25.png)](/forum/user/16411-makeeasy "View makeeasy's Profile") Topic Author - [ Offline](/forum/user/16411-makeeasy) Less More - Posts: 13 - Thank you received: 1 - - 13 years 5 months ago [\#102297](#102297) by [makeeasy](/forum/user/16411-makeeasy "View makeeasy's Profile") *[Improve Bulk Import Feature](/forum/2-general-talk-about-hikashop/81378-improve-bulk-import-feature#102297 "We would like to put in a request to improve import tool/feature to allow importing of various spreadsheets that have products with multiple variants/characteristics. Apparel items or products with...")* was created by *[makeeasy](/forum/user/16411-makeeasy "View makeeasy's Profile")* We would like to put in a request to improve import tool/feature to allow importing of various spreadsheets that have products with multiple variants/characteristics. Apparel items or products with multiple colors, sizes, etc. Or be able to merge spreadsheet with tool to allow correct import into Hikashop. ![B)](/media/kunena/emoticons/9.png "B)") Thanks for a great product! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMzc4LWltcHJvdmUtYnVsay1pbXBvcnQtZmVhdHVyZT90bXBsPW1hcmtkb3du) 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 5 months ago [\#102340](#102340) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Improve Bulk Import Feature](/forum/2-general-talk-about-hikashop/81378-improve-bulk-import-feature#102340 "We would like to put in a request to improve import tool/feature to allow importing of various spreadsheets that have products with multiple variants/characteristics. Apparel items or products with...")* Hi, It is already possible to import CSVs with products with multiple variants/characteristics. Create such product on your backend, export it, and you will have an example of what the import CSV should look like for that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMzc4LWltcHJvdmUtYnVsay1pbXBvcnQtZmVhdHVyZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[makeeasy](/forum/user/16411-makeeasy "View makeeasy's Profile")** - [![makeeasy's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-04-25.png)](/forum/user/16411-makeeasy "View makeeasy's Profile") Topic Author - [ Offline](/forum/user/16411-makeeasy) Less More - Posts: 13 - Thank you received: 1 - - 13 years 5 months ago [\#102357](#102357) by [makeeasy](/forum/user/16411-makeeasy "View makeeasy's Profile") Replied by *[makeeasy](/forum/user/16411-makeeasy "View makeeasy's Profile")* on topic *[Improve Bulk Import Feature](/forum/2-general-talk-about-hikashop/81378-improve-bulk-import-feature#102357 "We would like to put in a request to improve import tool/feature to allow importing of various spreadsheets that have products with multiple variants/characteristics. Apparel items or products with...")* Hi Nicolas, maybe we are asking for the wrong thing? We have 1000+ products and they all have different variants/characteristics. We understand export of product. I think this only works for product with similiar variants. Or maybe we need a way to prepare data before import? Not sure what i am missing. I know what we are trying to do is or should be common to others. However, i have not been successful finding anyone that can load these products or has succeeded with similiar data. All our single line products load fine. Our data sheet has multiple lines with variants of same product? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMzc4LWltcHJvdmUtYnVsay1pbXBvcnQtZmVhdHVyZT90bXBsPW1hcmtkb3du) 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 5 months ago [\#102489](#102489) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Improve Bulk Import Feature](/forum/2-general-talk-about-hikashop/81378-improve-bulk-import-feature#102489 "We would like to put in a request to improve import tool/feature to allow importing of various spreadsheets that have products with multiple variants/characteristics. Apparel items or products with...")* If you want to import additional characteristics or characteristic values in HikaShop, you can import a CSV in the hikashop_characteristic table of HikaShop via your phpmyadmin. For the structure of the CSV, you can export the data of that table as a CSV and then open it in Excel and complete it with what you need before importing it back. But then, for the variants of the products, once the characteristics and their values are in the hikashop_characteristic table, you can reference them in your product CSV. Again, you can use a CSV exported in HikaShop for an example. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgxMzc4LWltcHJvdmUtYnVsay1pbXBvcnQtZmVhdHVyZT90bXBsPW1hcmtkb3du) 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.054 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)