[Skip to main content](#vessel-content) # Virtuemart import ## - **[Huski](/forum/user/3364-huski "View Huski's Profile")** - [![Huski's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3364-huski "View Huski's Profile") Topic Author - [ Offline](/forum/user/3364-huski) Less More - Posts: 301 - Thank you received: 1 - - 15 years 2 months ago [\#23212](#23212) by [Huski](/forum/user/3364-huski "View Huski's Profile") *[Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23212 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* was created by *[Huski](/forum/user/3364-huski "View Huski's Profile")* Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been copied across from VM. Why won't the products show? Do categories need to be setup first in Hika to match the VM ones? There was one message when the import was happening saying that X, Y, Z categories did not exist. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 2 months ago [\#23213](#23213) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23213 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* Everything should be imported properly without having the precreate anything. If it doesn't work please give more information. A screenshot of the different steps with the error messages, the version of VirtueMart, the version of HikaShop, etc. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Huski](/forum/user/3364-huski "View Huski's Profile")** - [![Huski's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3364-huski "View Huski's Profile") Topic Author - [ Offline](/forum/user/3364-huski) Less More - Posts: 301 - Thank you received: 1 - - 15 years 2 months ago - 15 years 2 months ago [\#23216](#23216) by [Huski](/forum/user/3364-huski "View Huski's Profile") Replied by *[Huski](/forum/user/3364-huski "View Huski's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23216 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* That was quick. It seems to have worked ok now - I had VM version 1.1.5 and updated the patch to 1.1.9 and it has now imported fine. Actually - the products are imported now but the categories are not. Have attached photo of what happened when it tried to import categories. [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/HikaCategoryError.jpg) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/HikaCategoryError.jpg "[img") - [ ![HikaCategoryError.jpg](/forum/attachment/1592) ](/forum/attachment/1592 "...egoryError.jpg") [ ](/forum/attachment/1592?download=1 "...egoryError.jpg") Last edit: 15 years 2 months ago by [Huski](/forum/user/3364-huski "View Huski's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 2 months ago [\#23218](#23218) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23218 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* Could you try to activate the debug mode of joomla in the joomla configuration and try again ? Please report any error you see during the import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Huski](/forum/user/3364-huski "View Huski's Profile")** - [![Huski's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3364-huski "View Huski's Profile") Topic Author - [ Offline](/forum/user/3364-huski) Less More - Posts: 301 - Thank you received: 1 - - 15 years 2 months ago [\#23219](#23219) by [Huski](/forum/user/3364-huski "View Huski's Profile") Replied by *[Huski](/forum/user/3364-huski "View Huski's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23219 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* No errors coming up - said nothing was imported for anything as everything was already imported. When it got to the catgories - this time it just said zero for imported. When I look at the tables, nothing has been imported into hikashop_category table but the hikashop_vm_cat table has 22 records which matches the number of categories in VM. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 2 months ago [\#23220](#23220) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23220 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* Please go in your database with phpmyadmin and in the table hikashop_config, remove all the entries starting with vm_import and delete the tables hikashop_vm_prod and hikashop_vm_cat. Make sure that the debug mode is still activated and try again to import the data from VirtueMart. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Huski](/forum/user/3364-huski "View Huski's Profile")** - [![Huski's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3364-huski "View Huski's Profile") Topic Author - [ Offline](/forum/user/3364-huski) Less More - Posts: 301 - Thank you received: 1 - - 15 years 2 months ago [\#23224](#23224) by [Huski](/forum/user/3364-huski "View Huski's Profile") Replied by *[Huski](/forum/user/3364-huski "View Huski's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23224 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* Have removed those entries and deleted the tables and when I click on import and then Next (on the screen where it says to backup first) - this is the error I get. JDatabaseMySQL::query: 1146 - Table 'XX_hikashop_vm_cat' doesn't exist SQL=SELECT max(vm_id) as 'max' FROM `XX_hikashop_vm_cat`; Call stack \# Function Location 1 JAdministrator->dispatch() XX/administrator/index.php:67 2 JComponentHelper->renderComponent() XX/public_html/administrator/includes/application.php:136 3 require_once() XX/libraries/joomla/application/component/helper.php:162 4 JController->execute() XX/public_html/administrator/components/com_hikashop/admin.hikashop.php:32 5 ImportController->import() XX/public_html/libraries/joomla/application/component/controller.php:236 6 ImportController->_vm() XX/public_html/administrator/components/com_hikashop/controllers/import.php:45 7 hikashopImportHelper->importFromVM() XX/public_html/administrator/components/com_hikashop/controllers/import.php:61 8 hikashopImportHelper->doImport() XX/public_html/administrator/components/com_hikashop/helpers/import.php:1389 9 hikashopImportHelper->loadConfiguration() XX/public_html/administrator/components/com_hikashop/helpers/import.php:1411 10 JDatabaseMySQL->loadObjectList() XX/public_html/administrator/components/com_hikashop/helpers/import.php:1544 11 JDatabaseMySQL->query() XX/public_html/libraries/joomla/database/database/mysql.php:458 12 JError->raiseError() XX/public_html/libraries/joomla/database/database/mysql.php:231 13 JError->raise() XX/public_html/libraries/joomla/error/error.php:171 14 JException->__construct() XX/public_html/libraries/joomla/error/error.php:136 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 2 months ago [\#23228](#23228) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23228 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* Please change the code: Code: $table = $this->db->loadResult(); if(empty($table)){ $this->db->setQuery("SELECT max(vm_id) as 'max' FROM `#__hikashop_vm_cat`;"); to: Code: $table = $this->db->loadResult(); if(!empty($table)){ $this->db->setQuery("SELECT max(vm_id) as 'max' FROM `#__hikashop_vm_cat`;"); in the file administrator/components/com_hikashop/helpers/import.php and try again. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Huski](/forum/user/3364-huski "View Huski's Profile")** - [![Huski's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3364-huski "View Huski's Profile") Topic Author - [ Offline](/forum/user/3364-huski) Less More - Posts: 301 - Thank you received: 1 - - 15 years 2 months ago [\#23236](#23236) by [Huski](/forum/user/3364-huski "View Huski's Profile") Replied by *[Huski](/forum/user/3364-huski "View Huski's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23236 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* hi get this error now. Did you want the extra information as I did in the previous posts or is this line enough? JDatabaseMySQL::query: 1060 - Duplicate column name 'address_vm_order_info_id' SQL=ALTER IGNORE TABLE `XX_hikashop_address` ADD `address_vm_order_info_id` INT(11) NULL I turned off debug and tried again but still no categories coming in. Also noticed there were some errors with not being able to find images. I did open up one of the products and there was multiples of the same image showing under images section of product page. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 2 months ago [\#23238](#23238) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23238 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* Mmm. That is error is because the column was already added by the first import. So that solution of testing is not good. You will have to do differently. Please do like this: Delete all the hikashop tables from the database. Then, install again hikashop. That will recreate all the tables in the database as they are by default. Then, activate the debug mode, do the modification in the file like explained in the previous post and try again an import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Huski](/forum/user/3364-huski "View Huski's Profile")** - [![Huski's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3364-huski "View Huski's Profile") Topic Author - [ Offline](/forum/user/3364-huski) Less More - Posts: 301 - Thank you received: 1 - - 15 years 2 months ago [\#23240](#23240) by [Huski](/forum/user/3364-huski "View Huski's Profile") Replied by *[Huski](/forum/user/3364-huski "View Huski's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23240 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* hi I removed hikashop tables, reinstalled hikashop and made the modification and get his error. JDatabaseMySQL::query: 1054 - Unknown column 'order_vm_id' in 'field list' SQL=SELECT max(order_vm_id) as 'max' FROM `xx_hikashop_order`; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 2 months ago [\#23253](#23253) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23253 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* It seems that you're using one of the first build of the 1.5.3 version of HikaShop which had that issue. Could you please download again the install package of HikaShop on our website and do again the procedure ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Huski](/forum/user/3364-huski "View Huski's Profile")** - [![Huski's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3364-huski "View Huski's Profile") Topic Author - [ Offline](/forum/user/3364-huski) Less More - Posts: 301 - Thank you received: 1 - - 15 years 2 months ago [\#23316](#23316) by [Huski](/forum/user/3364-huski "View Huski's Profile") Replied by *[Huski](/forum/user/3364-huski "View Huski's Profile")* on topic *[Re: Virtuemart import](/forum/3-bug-report/23212-virtuemart-import#23316 "Great funtion and tried it - seemed to work but can't see anything at all in the control panel of Hika. Thought something failed but I noticed when I look at the actual tables, that data has been...")* Thats worked now - thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzIxMi12aXJ0dWVtYXJ0LWltcG9ydD90bXBsPW1hcmtkb3du) 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.169 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)