VM import orders non-registered customers

-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : 2.3.0 Business
-- Joomla version -- : 1.5.26
-- PHP version -- : 5.3.21

Hi,

I have a question about imported orders from Virtuemart 1.1.9 in the event of non-registered customers. About 4 weeks ago I've imported those VM orders into Hikashop 2.3.0 .

The problem is that in the order details of those orders the fields for customer e-mail and customer id are empty.
So I can't use the E-mail button on this page to send a mail, because the e-mail address of the customer is unknown.

This is not like it should be, I suppose.
In the Hikashop demo site I''ve placed a test order by a non-registered customer. Then the customer e-mailadress and customer id are given in the order details.
And this customer information also showed up some months ago after importing the same VM orders into a test version of my website using Hikashop Essential 2.2.1.

So it looks like something has gone wrong with the VM order import into Hikashop 2.3.0

Please advise how to repair this.

Thanks,
Udo
.

Hi Nicolas,

Thanks for your help!

Maybe this is a way to repair ALL orders:
- first clean the order, product_order and user tables in the dbase.
- then reimport these data from VM.
Is it wise to do it that way?

A complication might be that a month ago Jerome patched my website to fix a problem of the import of order/user. He expected the patch to be included in Hikashop 2.3.0. Is this hot fix integrated in the new file importvm.php?

regards,
Udo

Hi,

My dbase doesn't have a table hikashop_vm_orders....

There is for instance hikashop_order, hikashop_order_product, hikashop_vm_cat and hikashop_vm_prod.

regards,
Udo

Hi,

Alas the VM import still is not properly.
* I've uploaded the new importvm-file.
* Cleaned the tables hikashop_order, hikashop_order_product and hikashop_user (like I said there's no table hikashop_vm_orders.)
* Then a query in the dbase to display the right order_number (instruction Jerome a month ago): UPDATE `#__hikashop_order` SET order_number = LPAD(order_vm_id, 8, '0');

The results of a new VM import:
- All order information of registered customers seems to be correct. In the customers listing the registered customers are linked to the correct orders.
- In the customers listing many registered customers are linked to a wrong address. Some customers are not linked to any address.
- The order information of guest customers has no link to a customer. So in the order details the email address is missing.
- In the customers listing many guest customers are linked to a wrong address. Some guest customers are not linked to any address.

The main problem is the missing email address in the orders of guest customers.

Is there a way to get the VM import correct?

Regards,
Udo

Hi,

Sorry for the very late reply, do you have solved your issue ?
As I can see in our logs, some fixes have been made about the vm import, could you try our newest version available from our website ?

Hi Xavier,

Hikashop is live since May 1 and I'm very glad with the new shop.
Alas, I never really solved the VM import problems. Apparently import from Virtuemart is quite complicated.
It was disappointing that the imported user information is incomplete and sometimes wrong.

It stroke me that there was a logic in the errors:
* in all recently imported customer accounts (last 2 months) only street and house number were missing
* in all customer accounts from 2 months ago untill 16 months ago the entire address is missing
* in all customer accounts older then 16 months ago a wrong address is shown. It's the address of another customer.

Meanwhile I have made some manual corrections and the result is workable. Sometimes we take a look at the old Virtuemart information, especially for guest customers. And some registered customers have to add their address once more.

Importing VM once more using a the newest HS version seems risky since my manual corrections may get lost.

I read that in version 2.3.1 the name of the user on the orders listing is displayed, even for guests. That's a fine improvement.
However I'm hesitating to update my 2.3.0 version since I've done quite a lot adjustments. And sometimes I'm not happy with the changing of pictures or layout in the new version.
Is there a way to have the user name displayed by manualy editing a few files?

Thanks for the support.
Udo