- Posts: 173
- Thank you received: 8
Which tables do I need to copy for orders and customers in to second site?
9 years 5 months ago - 9 years 5 months ago #266004
by ianspeed
-- 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
-- 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: 9 years 5 months ago by ianspeed.
Please Log in or Create an account to join the conversation.
9 years 5 months ago #266036
by Jerome
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.
Replied by Jerome on topic Which tables do I need to copy for orders and customers in to second site?
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,
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.215 seconds