[Skip to main content](#vessel-content) # Import from Virtuemart - Imported Orders: -1 ## - **[IP3](/forum/user/6885-ip3 "View IP3's Profile")** - [![IP3's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6885-ip3 "View IP3's Profile") Topic Author - [ Offline](/forum/user/6885-ip3) Less More - Posts: 30 - Thank you received: 0 - - 14 years 6 months ago [\#45186](#45186) by [IP3](/forum/user/6885-ip3 "View IP3's Profile") *[Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#45186 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* was created by *[IP3](/forum/user/6885-ip3 "View IP3's Profile")* Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/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: 86290 - Thank you received: 14268 - - 14 years 6 months ago [\#45380](#45380) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#45380 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* Try to do it again with the debug mode of joomla activated(configuration of joomla). That might throw up an error during the import. You're importing from VM 1.x ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[erickb](/forum/user/4069-erickb "View erickb's Profile")** - [![erickb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4069-erickb "View erickb's Profile") - [ Offline](/forum/user/4069-erickb) Less More - Posts: 2697 - Thank you received: 74 - - 14 years 6 months ago [\#45458](#45458) by [erickb](/forum/user/4069-erickb "View erickb's Profile") Replied by *[erickb](/forum/user/4069-erickb "View erickb's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#45458 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* I have done my own SQL import from VM 1.1 to Hikashop Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IP3](/forum/user/6885-ip3 "View IP3's Profile")** - [![IP3's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6885-ip3 "View IP3's Profile") Topic Author - [ Offline](/forum/user/6885-ip3) Less More - Posts: 30 - Thank you received: 0 - - 14 years 6 months ago [\#45600](#45600) by [IP3](/forum/user/6885-ip3 "View IP3's Profile") Replied by *[IP3](/forum/user/6885-ip3 "View IP3's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#45600 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* Thanks for the input. I am importing from VM 1.1.9 I turned on Joomla debug and the import stops at the first step with 500 Error: JDatabaseMySQL::query: 1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=INSERT IGNORE INTO `jos_hikashop_category` (`category_type`,`category_name`,`category_published`,`category_parent_id`,`category_namekey`) SELECT 'tax',CONCAT('Tax imported (', vmtr.tax_country,')'),1,3,CONCAT('VM_TAX_', vmtr.tax_rate_id,'_',hkz.zone_id) FROM `jos_vm_tax_rate` vmtr INNER JOIN `jos_hikashop_zone` hkz ON vmtr.tax_country = hkz.zone_code_3 AND hkz.zone_type = 'country' WHERE vmtr.tax_rate_id > 2 With Joomla debug off, it will progress through the import and Orders are reported: [Orders] Imported orders: -1 Imported orders' addresses: 98 Updating billing addresses: 0 Updating shipping addresses: 0 Updating order payments: 0 Updating orders: 85/43/98 Elasped time: 79.58ms Any manual import suggestions? Field maps to use? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/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: 86290 - Thank you received: 14268 - - 14 years 6 months ago [\#45606](#45606) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#45606 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* You need to edit all the virtuemart tables in your database and change their collation to utf8_general_ci Then, you won't get these collation mixes and the import will work properly. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IP3](/forum/user/6885-ip3 "View IP3's Profile")** - [![IP3's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6885-ip3 "View IP3's Profile") Topic Author - [ Offline](/forum/user/6885-ip3) Less More - Posts: 30 - Thank you received: 0 - - 14 years 6 months ago [\#45777](#45777) by [IP3](/forum/user/6885-ip3 "View IP3's Profile") Replied by *[IP3](/forum/user/6885-ip3 "View IP3's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#45777 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* Changed the collation and still same result. Using Joomla 1.5 not sure if that is a handicap or not. Regardless, is there a method to import only orders? Is there a field map for a CSV import from VM to Hika? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[erickb](/forum/user/4069-erickb "View erickb's Profile")** - [![erickb's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4069-erickb "View erickb's Profile") - [ Offline](/forum/user/4069-erickb) Less More - Posts: 2697 - Thank you received: 74 - - 14 years 6 months ago [\#45806](#45806) by [erickb](/forum/user/4069-erickb "View erickb's Profile") Replied by *[erickb](/forum/user/4069-erickb "View erickb's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#45806 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* to change the collation you can use akeeba admin tools to import anything INSERT INTO db1.table1(field1,field2,...) SELECT field1,field2,... FROM dbx.tablex Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IP3](/forum/user/6885-ip3 "View IP3's Profile")** - [![IP3's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6885-ip3 "View IP3's Profile") Topic Author - [ Offline](/forum/user/6885-ip3) Less More - Posts: 30 - Thank you received: 0 - - 14 years 4 months ago - 14 years 4 months ago [\#53775](#53775) by [IP3](/forum/user/6885-ip3 "View IP3's Profile") Replied by *[IP3](/forum/user/6885-ip3 "View IP3's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#53775 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* Nikolas, I have imported order information to the jos_hikashop_order, jos_hikashop_address, and jos_hikashop_order_product tables, but I don't see the orders in Hikashop Sales screen. If I search by customer, then edit the customer, I can see the order listed, in what I assume is a history. I can open the order and edit it. When I list 'Sales' the order is not listed. What am I missing? Last edit: 14 years 4 months ago by [IP3](/forum/user/6885-ip3 "View IP3's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/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: 86290 - Thank you received: 14268 - - 14 years 4 months ago [\#53856](#53856) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#53856 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* Please make sure that the order_type is set to "sale" in the entries of the hikashop_order table. The following user(s) said Thank You: [IP3](/forum/user/6885-ip3 "View IP3's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IP3](/forum/user/6885-ip3 "View IP3's Profile")** - [![IP3's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6885-ip3 "View IP3's Profile") Topic Author - [ Offline](/forum/user/6885-ip3) Less More - Posts: 30 - Thank you received: 0 - - 14 years 4 months ago [\#53920](#53920) by [IP3](/forum/user/6885-ip3 "View IP3's Profile") Replied by *[IP3](/forum/user/6885-ip3 "View IP3's Profile")* on topic *[Re: Import from Virtuemart - Imported Orders: -1](/forum/2-general-talk-about-hikashop/45186-import-from-virtuemart-imported-orders-1#53920 "Just imported from Virtuemart. Got products, customer address, but no orders? Checked the jos_hikashop_config vm_import_last_vm_order and the value was 0. Ran import again, same result. vm_import_last_vm_order still at 0. Any thoughts?")* Ah, that did it! Like a key in a lock. Thanks Nicolas. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ1MTg2LWltcG9ydC1mcm9tLXZpcnR1ZW1hcnQtaW1wb3J0ZWQtb3JkZXJzLTE/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.375 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)