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

  • Posts: 170
  • Thank you received: 8
  • Hikashop Essential
7 years 8 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: 7 years 8 months ago by ianspeed.

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 7 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.063 seconds
Powered by Kunena Forum