Import from Virtuemart - Imported Orders: -1

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 ?

I have done my own SQL import from VM 1.1 to Hikashop

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?

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.

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?

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

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?

Please make sure that the order_type is set to "sale" in the entries of the hikashop_order table.

Ah, that did it! Like a key in a lock.

Thanks Nicolas.