Hi,
It's indeed random. There is no ordering set in the query for the export so the order of the products is whatever mysql feels.
We didn't thought that it would make any difference. And no one told us that it was a problem so far so it's still like that.
If you want to have them ordered by id, you can change the line:
$query = 'SELECT * FROM '.hikashop_table('product').$where.' ORDER BY product_parent_id ASC';
to:
$query = 'SELECT * FROM '.hikashop_table('product').$where.' ORDER BY product_parent_id ASC, product_id ASC';
in the file administrator/components/com_hikashop/classes/product.php
We'll do that change on our end as it makes sense to export the products in the order they were inserted.