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?

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?

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?

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

Thanks Nicolas.