Import Orders from VM - to Different Site

  • Posts: 152
  • Thank you received: 1
9 years 5 months ago #205694

Hi Guys,

Okay so a while ago I fixed up a clients site from VM to Hika - much better, but they delayed somewhat and now the old VM site they kept running while we sat with the Hika version in a sub folder... Well now.. We want to make the Hika one primary and can the VM one.. But the VM one has new orders & customers.

Is there a way I can export the VM orders & customers to CSV or something and then Import that to Hika?

Any ideas?

Its not simply a case of just install Hika on the VM site and run the migration as that VM is outdated and there have been some major changes to the Hika version that I dont want to have to rebuild.... So Ideally it must be an import...

Believe in Better

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 5 months ago #205756

Hi,

Mmm. If it were on the same website, just running the import again would just pick the new data and leave alone the data already migrated.

For the users, you have Joomla tools to export/import them, so that should not be a problem.
For the user's addresses and orders, if you still have the old HikaShop you used for the first migration, you can run the import again. That will get the new orders/users/addresses in HikaShop. Then, you can simply delete the tables of these (order, order_product, user, address) on the new website and get them from the old website. Hopefully it should work.
Otherwise, the best solution is to run some custom and complex MySQL queries to port the new data from the old website to the new one. If you know pretty well MySQL, that might be the best. Otherwise, I wouldn't recommend it.

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

Time to create page: 0.045 seconds
Powered by Kunena Forum