[Skip to main content](#vessel-content) # \[solved\] children products from VM1, how to import ## - **[mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile")** - [![mmleoni's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31790-mmleoni "View mmleoni's Profile") Topic Author - [ Offline](/forum/user/31790-mmleoni) - Just another \*nix coder/sysadmin... Less More - Posts: 3 - Thank you received: 1 - - - [](http://www.mmleoni.net) - 12 years 7 months ago - 12 years 7 months ago [\#148947](#148947) by [mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile") *[\[solved\] children products from VM1, how to import](/forum/37-import-export-csv-xls/866782-solved-children-products-from-vm1-how-to-import#148947 "-- HikaShop version -- : HikaShop Business 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : 5.4 / 5.3 Hi guys! import from DB tables ( VM 1.1.8 ). in the #__hikashop_product table I have all children product from VM, but I can not view or edit them. If I add a 'charateristic' in the father product I can view as charateristics all children, but only in back office. If I try to edit a child, a new product is created on save. what have I to do with these children? I can recover them or I have to create again all 300+ children? thank you, marco")* was created by *[mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile")* -- HikaShop version -- : HikaShop Business 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : 5.4 / 5.3 Hi guys! import from DB tables ( VM 1.1.8 ). in the #__hikashop_product table I have all children product from VM, but I can not view or edit them. If I add a 'charateristic' in the father product I can view as charateristics all children, but only in back office. If I try to edit a child, a new product is created on save. what have I to do with these children? I can recover them or I have to create again all 300+ children? thank you, marco Last edit: 12 years 7 months ago by [mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjY3ODItc29sdmVkLWNoaWxkcmVuLXByb2R1Y3RzLWZyb20tdm0xLWhvdy10by1pbXBvcnQ/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 12 years 7 months ago [\#148950](#148950) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[child product from VM1](/forum/37-import-export-csv-xls/866782-solved-children-products-from-vm1-how-to-import#148950 "-- HikaShop version -- : HikaShop Business 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : 5.4 / 5.3 Hi guys! import from DB tables ( VM 1.1.8 ). in the #__hikashop_product table I have all children product from VM, but I can not view or edit them. If I add a 'charateristic' in the father product I can view as charateristics all children, but only in back office. If I try to edit a child, a new product is created on save. what have I to do with these children? I can recover them or I have to create again all 300+ children? thank you, marco")* Hi, The import system from VM doesn't support child products. You'll have to create again the variants/characteristics via the interface as explained here: [ www.hikashop.com/support/support/documen...html#characteristics](http://www.hikashop.com/support/support/documentation/integrated-documentation/19-hikashop-product-form.html#characteristics) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjY3ODItc29sdmVkLWNoaWxkcmVuLXByb2R1Y3RzLWZyb20tdm0xLWhvdy10by1pbXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile")** - [![mmleoni's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31790-mmleoni "View mmleoni's Profile") Topic Author - [ Offline](/forum/user/31790-mmleoni) - Just another \*nix coder/sysadmin... Less More - Posts: 3 - Thank you received: 1 - - - [](http://www.mmleoni.net) - 12 years 7 months ago - 12 years 7 months ago [\#149054](#149054) by [mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile") Replied by *[mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile")* on topic *[child product from VM1](/forum/37-import-export-csv-xls/866782-solved-children-products-from-vm1-how-to-import#149054 "-- HikaShop version -- : HikaShop Business 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : 5.4 / 5.3 Hi guys! import from DB tables ( VM 1.1.8 ). in the #__hikashop_product table I have all children product from VM, but I can not view or edit them. If I add a 'charateristic' in the father product I can view as charateristics all children, but only in back office. If I try to edit a child, a new product is created on save. what have I to do with these children? I can recover them or I have to create again all 300+ children? thank you, marco")* Hi nicolas, thank you for your reply. I read in other post that children are not imported, but children have been imported! They are not usable, but they are all present in the table '#__hikashop_product' (they reference to the father by the product_parent_id field and a suffix has been added to product_code.). When I try to add a charateristic (I have already read the documentation and the link you posted) and I click on 'manage variants', all the imported children appear. As said, they are not visible in front end and they are not editable. My question is: what should I do with these little children? Can I save them, or have I to act like Herod? :evil: (delete from #__hikashop_product where product_parent_id != 0) note: I'm not asking if I can import children product, I would like to know what I have to do with imported ones. ciao, marco --- edit: syntax error! Last edit: 12 years 7 months ago by [mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjY3ODItc29sdmVkLWNoaWxkcmVuLXByb2R1Y3RzLWZyb20tdm0xLWhvdy10by1pbXBvcnQ/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 12 years 7 months ago [\#149097](#149097) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[child product from VM1](/forum/37-import-export-csv-xls/866782-solved-children-products-from-vm1-how-to-import#149097 "-- HikaShop version -- : HikaShop Business 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : 5.4 / 5.3 Hi guys! import from DB tables ( VM 1.1.8 ). in the #__hikashop_product table I have all children product from VM, but I can not view or edit them. If I add a 'charateristic' in the father product I can view as charateristics all children, but only in back office. If I try to edit a child, a new product is created on save. what have I to do with these children? I can recover them or I have to create again all 300+ children? thank you, marco")* You can delete them. child products require more than just an entry in the hikashop_product table. They also need: first, a characteristic with its values in the hikashop_characteristic table then, for each characteristic of the product, a link between the product and the characteristic and a link between the product and the default value of the characteristic in the hikashop_variant table and also, for each variant, a link between the variant in the hikashop_product table and its corresponding value for each characteristic in the table hikashop_variant. It will be either to delete them and create all the links manually via the interface than doing it via phpmyadmin. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjY3ODItc29sdmVkLWNoaWxkcmVuLXByb2R1Y3RzLWZyb20tdm0xLWhvdy10by1pbXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile")** - [![mmleoni's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31790-mmleoni "View mmleoni's Profile") Topic Author - [ Offline](/forum/user/31790-mmleoni) - Just another \*nix coder/sysadmin... Less More - Posts: 3 - Thank you received: 1 - - - [](http://www.mmleoni.net) - 12 years 7 months ago [\#149201](#149201) by [mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile") Replied by *[mmleoni](/forum/user/31790-mmleoni "View mmleoni's Profile")* on topic *[child product from VM1, how to import!](/forum/37-import-export-csv-xls/866782-solved-children-products-from-vm1-how-to-import#149201 "-- HikaShop version -- : HikaShop Business 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : 5.4 / 5.3 Hi guys! import from DB tables ( VM 1.1.8 ). in the #__hikashop_product table I have all children product from VM, but I can not view or edit them. If I add a 'charateristic' in the father product I can view as charateristics all children, but only in back office. If I try to edit a child, a new product is created on save. what have I to do with these children? I can recover them or I have to create again all 300+ children? thank you, marco")* ok, thanks nicolas. You confirmed my analysis about tables involved into the operation. In the attachment a '70 lines script' to transform imported orphans into active hikashop variants... Too many children to do the work by hand! ![:P](/media/kunena/emoticons/15.png ":P") Source is comment, read it carefully. this script solved my situation, but there is no warranty it will be useful to you too. back db, put script into the root of joomla site and run it. now I have, also, to write code for virtuemart variant.... have a nice day, marco The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjY3ODItc29sdmVkLWNoaWxkcmVuLXByb2R1Y3RzLWZyb20tdm0xLWhvdy10by1pbXBvcnQ/dG1wbD1tYXJrZG93bg==) 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.201 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)