VM Import Issues

  • Posts: 106
  • Thank you received: 5
  • Hikaserial Standard Hikashop Business
9 years 6 months ago #201565

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.4.39

I did the import for Virtuemart and it completed without an error. Though, I did have a couple of issues.

1) No order history got imported.

2) The Virtuemart Order# did not get imported into the HikaShop order# field. I see the VM order# saved in the HikaShop order table, but not as the order#. Instead there is some weird entry (e.g. 17850_bda5b5d65c0a5ed4212f90ed0f) that has nothing to do with the VM order#. This is going to make it difficult for us to look up old orders.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 6 months ago #201671

Hi,

1. The order history import is not supported by the import system.
If you need it, you would have to import the data manually with either a custom script.

2. Looking at the code of the import, the order_number from the VM order table is used for the order_number column of the HikaShop order table.
So I don't see why the order number wouldn't be correct. Are you sure you're not talking about something else like the order_id or another column of the order table of VirtueMart ? Which VirtueMart version were you using ?

Please Log in or Create an account to join the conversation.

  • Posts: 106
  • Thank you received: 5
  • Hikaserial Standard Hikashop Business
9 years 6 months ago #201676

1) It seems rather odd that importing the order history is not supported. That should be added to the script.

2) Well, that may be technically true. However, what VM shows on the backend and the frontend is the order_id not order_number. Maybe 2.x is different, but this is the behavior of 1.1.x I'm not sure why VM does it that way, but the HikaShop import should import the order_id as the order number, as that is what is displayed to the admin and customer. Then old orders could be looked up.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 6 months ago #201681

Hi,

1/ I'm sorry but that's just a fact ; the import of the virtuemart order history is not supported by HikaShop 2.4.0
But it does not means that Nicolas didn't create a feature request ticket in our system for that :)
After that, even if we have a feature request ticket in our side, the feature could not be added in a short delay ; we are currently finishing the next HikaShop release and performing the tests.

2/ The Virtuemart "order number" is stored in the HikaShop "order number" and the Virtuemart "order id" is stored in the HikaShop "order_vm_id".
We can't set the "order_id" of HikaShop with the virtuemart "order_id".
The system plugin "vm_redirect" read the parameter "order_number" and will look at the corresponding order thanks to the "order_vm_id" ; so the fallback should work correctly and no information (order id / order number) is lost during the import.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 106
  • Thank you received: 5
  • Hikaserial Standard Hikashop Business
9 years 6 months ago #201776

1) Thanks for putting in a ticket to add that feature. I'll import that data myself, but that feature will help others in the future.

2) I understand that no data is being lost. That is not the issue. The issue is not being able to look up an order by the order number that is shown in VM. If VM shows an order to be "24560", I can try to enter that into the HikaShop search, but it will not find the order because the order number got imported as "17850_bda5b5d65c0a5ed4212f90ed0f". That long number is useless, as it does not correspond in any way to what VM displays as the order number in the front and back ends.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 6 months ago #201784

Hi,

2) I see what you means. The HikaShop search in the backend can't look into the VM field..
I don't know if the order number has an importance or not for you ; but you can see to copy the order_vm_id into the order_number if you want to use that id instead.

You can use a mass-action to perform the copy or you can use a query like that :

UPDATE #__hikashop_order SET order_number = order_vm_id WHERE order_vm_id IS NOT NULL AND order_vm_id != '';
But using the query will remove the imported order_number.

Otherwise, you can see to use some overrides (or modify a little the order listing) to add the "order_vm_id" in the search filters.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.068 seconds
Powered by Kunena Forum