Transfer of orders..

  • Posts: 35
  • Thank you received: 1
12 years 4 months ago #57272

Salut Nicolas,

I have an old site with Hikashop v1.5.5 [Joomla 1.5.26] on it with approx. 1012 orders
and I have a new site with Hikashop v.1.5.8 [Joomla v2.5.6] on it with 0 orders.

I need to get the orders from the old site to the new one.

This is something I have to do! :(

Thanks,
Cheers,

Emmanuel.

P.S.: If this is something where you need access to both platforms - no problem [and I don't have a problem paying for this transfer if need be]

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

  • Posts: 13201
  • Thank you received: 2322
12 years 4 months ago #57319

Hi tedstrauss,

To do the transfer, the both version of HikaShop must be the same.
Update HikaShop on your old site, and then you can export all your SQL Base, and import it in the new site.

You can too just transfer the tables: order - order-product - address - user.
Be careful, if the users are not the sames between the two sites, one user will have the orders of another one.

The best way is to export/inmport all the SQL base.

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

  • Posts: 35
  • Thank you received: 1
12 years 4 months ago #57325

Salut Xavier,

Unfortunately, it's a bit more complicated then that - due to quite a bit of custom code that was written by Jérome/Nicolas and a 3rd person - the site journeypipe.com has been frozen at Hikashop v1.5.5 and can't really be upgraded [and is Joomla 1.5.26]

the new site journey2.com is Hikashop v1.5.8 [and is Joomla 2.5.6]

So now what would you recommend / how would you recommend that I proceed.

Also when you say "Be careful, if the users are not the sames between the two sites, one user will have the orders of another one." I'm assuming you mean the Joomla user table - but if so, those 2 I'm assuming will be quite a bit different as the older site is running Joomla v1.5.26 and the new site is running Joomla v2.5.6

Thoughts...

Sincerely,

Emmanuel.

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

  • Posts: 82820
  • Thank you received: 13366
  • MODERATOR
12 years 4 months ago #57327

Then you need to do it the other way around.
Install HikaShop 1.5.5 on your new website, do the transfer of the tables and then update to the latest version.
The point is that when you transfer the tables of the database, the version of HikaShop needs to be the same on the two websites or it won't work properly.

For the users, the point is that in the user table of HikaShop, there is he column user_cms_id where the id of the user in the jos_users table is.
If the ids of the users in the jos_users table of your old and new website are not the same, the orders/addresses of the users won't be attributed to the correct user.
There is not a lot of solutions for that... The best is to make sure that the ids are the same or update the ids in the hikashop user table after the import with a query based on the email of the user:
UPDATE #__hikashop_user as a,#__users as b SET a.user_cms_id=b.id WHERE a.user_email=b.email

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

Time to create page: 0.071 seconds
Powered by Kunena Forum