Which tables do I need to copy for orders and customers in to second site?

  • Posts: 173
  • Thank you received: 8
  • Hikashop Essential
8 years 11 months ago #266004

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.6.30
-- Browser(s) name and version -- : N/A
-- Error-message(debug-mod must be tuned on) -- : None

Hi, I'm upgrading an old 1.5.2 site to 3.6.5.
I have had to do this in parallel, I need to convert all of the orders and users from the 1.5 site over to the new 3.6.5 site which is also running Hikashop 2.6.4. After the conversion I can then update the Hikashop to the latest version 3.0.1 I can not just copy all the files as there are slight differences in the urls for products etc. We just need the old order data and user database bringing across.
Which tables do I need to copy across?

Many Thanks

Ian

Last edit: 8 years 11 months ago by ianspeed.

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

  • Posts: 26325
  • Thank you received: 4064
  • MODERATOR
8 years 11 months ago #266036

Hello,

Order are mostly in "hikashop_order" and "hikashop_order_product".
But the order needs a link with "hikashop_user" which are related to the joomla table "users"
Afterwards, there is also the "hikashop_address" for the addresses (and also related to "hikashop_user").
The orders will also have links to other tables, like products and so on.
www.hikashop.com/support/documentation/6...ocumentation.html#db

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.060 seconds
Powered by Kunena Forum