[Skip to main content](#vessel-content) # Importing Product Options ## - **[daylily](/forum/user/36343-daylily "View daylily's Profile")** - [![daylily's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36343-daylily "View daylily's Profile") Topic Author - [ Offline](/forum/user/36343-daylily) Less More - Posts: 16 - Thank you received: 1 - - 10 years 7 months ago [\#234391](#234391) by [daylily](/forum/user/36343-daylily "View daylily's Profile") *[Importing Product Options](/forum/25-install-update/883384-importing-product-options#234391 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome latest Can you give my any advice on importing options from a text file? I made a sample and exported it to see how that looked and the only field it generated that seemed important was "related". The field contained the product_code of the option. But when I upload using a "related" field, the option is not attached. Also in the hikashop_product_related table I see a field for product_related_type with the value "options" inserted, but that is not a field that is allowable in the import file. Any ideas? If I need to I'll write a script to attach the options. If I do, is there any other tables that would be affected (besides the product and the option in the product table)? Or is it possible to override the import to do the additional processing?")* was created by *[daylily](/forum/user/36343-daylily "View daylily's Profile")* -- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome latest Can you give my any advice on importing options from a text file? I made a sample and exported it to see how that looked and the only field it generated that seemed important was "related". The field contained the product_code of the option. But when I upload using a "related" field, the option is not attached. Also in the hikashop_product_related table I see a field for product_related_type with the value "options" inserted, but that is not a field that is allowable in the import file. Any ideas? If I need to I'll write a script to attach the options. If I do, is there any other tables that would be affected (besides the product and the option in the product table)? Or is it possible to override the import to do the additional processing? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MzM4NC1pbXBvcnRpbmctcHJvZHVjdC1vcHRpb25zP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 10 years 6 months ago [\#234405](#234405) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing Product Options](/forum/25-install-update/883384-importing-product-options#234405 "-- HikaShop version -- : 2.6.1 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Chrome latest Can you give my any advice on importing options from a text file? I made a sample and exported it to see how that looked and the only field it generated that seemed important was "related". The field contained the product_code of the option. But when I upload using a "related" field, the option is not attached. Also in the hikashop_product_related table I see a field for product_related_type with the value "options" inserted, but that is not a field that is allowable in the import file. Any ideas? If I need to I'll write a script to attach the options. If I do, is there any other tables that would be affected (besides the product and the option in the product table)? Or is it possible to override the import to do the additional processing?")* Hi, Their is an 'options' column you can use to add your product options to products in your CSV. In it, you want to enter the product_code of the option product. Also, the product option row (which defines the product information for the option) needs to be placed before the product row in the CSV. The import already handles the import of options (and the export exports the options in the CSV generated as well), so there is no need to override the import system or add any additional processing. The following user(s) said Thank You: [daylily](/forum/user/36343-daylily "View daylily's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4MzM4NC1pbXBvcnRpbmctcHJvZHVjdC1vcHRpb25zP3RtcGw9bWFya2Rvd24=) 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.158 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)