[Skip to main content](#vessel-content) # 1 store used for multiple Joomla sites. Possible? ## - **[PLHC](/forum/user/6918-plhc "View PLHC's Profile")** - [![PLHC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6918-plhc "View PLHC's Profile") Topic Author - [ Offline](/forum/user/6918-plhc) Less More - Posts: 9 - Thank you received: 0 - - 14 years 6 months ago [\#47987](#47987) by [PLHC](/forum/user/6918-plhc "View PLHC's Profile") *[1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#47987 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* was created by *[PLHC](/forum/user/6918-plhc "View PLHC's Profile")* Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd website and just change the pricing and coupons. Thanks for your help! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14264 - - 14 years 6 months ago [\#48036](#48036) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48036 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Yes you can do that. If you want to do a copy of one website somewhere else, I recommend you that you use Akeeba Backup. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PLHC](/forum/user/6918-plhc "View PLHC's Profile")** - [![PLHC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6918-plhc "View PLHC's Profile") Topic Author - [ Offline](/forum/user/6918-plhc) Less More - Posts: 9 - Thank you received: 0 - - 14 years 6 months ago [\#48046](#48046) by [PLHC](/forum/user/6918-plhc "View PLHC's Profile") Replied by *[PLHC](/forum/user/6918-plhc "View PLHC's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48046 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Yes, I've already backed up the 1st site. But as stated, I don't want to upload the ENTIRE backup to the 2nd site just the Hikashop part. How do I do that? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14264 - - 14 years 6 months ago [\#48071](#48071) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48071 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Then you'll have to export the hikashop tables from the database via phpmyadmin on your old website, install HikaShop on your new website, import the hikashop tables to the database via phpmyadmin on your new website and copy the files from the folder media/com_hikashop/ from the old to the new website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PLHC](/forum/user/6918-plhc "View PLHC's Profile")** - [![PLHC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6918-plhc "View PLHC's Profile") Topic Author - [ Offline](/forum/user/6918-plhc) Less More - Posts: 9 - Thank you received: 0 - - 14 years 5 months ago [\#48426](#48426) by [PLHC](/forum/user/6918-plhc "View PLHC's Profile") Replied by *[PLHC](/forum/user/6918-plhc "View PLHC's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48426 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Hi! I tried exactly what you suggested (export and import) and absolutely NOTHING changed. I already had the Hikashop extension on the 2nd site so all I want to do is move the meat of the store (products, descriptions, prices, etc) to the other site. I'm not sure what I'm doing wrong, but all that is on the 2nd site backend for Hikashop, is the bare shop extension. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14264 - - 14 years 5 months ago [\#48427](#48427) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48427 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* It's not possible that nothing happened when you imported. Did you get an error message ? Something ? The categories ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PLHC](/forum/user/6918-plhc "View PLHC's Profile")** - [![PLHC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6918-plhc "View PLHC's Profile") Topic Author - [ Offline](/forum/user/6918-plhc) Less More - Posts: 9 - Thank you received: 0 - - 14 years 5 months ago [\#48429](#48429) by [PLHC](/forum/user/6918-plhc "View PLHC's Profile") Replied by *[PLHC](/forum/user/6918-plhc "View PLHC's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48429 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Hmm...Ok. The error I got after importing was that the hikashop....address already existed. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PLHC](/forum/user/6918-plhc "View PLHC's Profile")** - [![PLHC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6918-plhc "View PLHC's Profile") Topic Author - [ Offline](/forum/user/6918-plhc) Less More - Posts: 9 - Thank you received: 0 - - 14 years 5 months ago - 14 years 5 months ago [\#48432](#48432) by [PLHC](/forum/user/6918-plhc "View PLHC's Profile") Replied by *[PLHC](/forum/user/6918-plhc "View PLHC's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48432 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Just did it again. Here you go Error SQL query: -- phpMyAdmin SQL Dump -- version 2.8.0.1 -- [ www.phpmyadmin.net](http://www.phpmyadmin.net) -- -- Host: -- Generation Time: Apr 27, 2012 at 05:11 AM -- Server version: 5.0.91 -- PHP Version: 4.4.9 -- -- Database: `jml_` -- -- --- -- -- Table structure for table `yvbwn_hikashop_address` -- CREATE TABLE `yvbwn_hikashop_address` ( `address_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT , `address_user_id` int( 10 ) unsigned NOT NULL default '0', `address_title` varchar( 255 ) default NULL , `address_firstname` varchar( 255 ) default NULL , `address_middle_name` varchar( 255 ) default NULL , `address_lastname` varchar( 255 ) default NULL , `address_company` varchar( 255 ) default NULL , `address_street` varchar( 255 ) default NULL , `address_post_code` varchar( 255 ) default NULL , `address_city` varchar( 255 ) default NULL , `address_telephone` varchar( 255 ) default NULL , `address_telephone2` varchar( 255 ) default NULL , `address_fax` varchar( 255 ) default NULL , `address_state` varchar( 255 ) default NULL , `address_country` varchar( 255 ) default NULL , `address_published` tinyint( 4 ) NOT NULL default '1', `address_vat` varchar( 255 ) default NULL , `address_default` tinyint( 4 ) NOT NULL default '0', PRIMARY KEY ( `address_id` ) , KEY `address_user_id` ( `address_user_id` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1; MySQL said: Documentation \#1050 - Table 'yvbwn_hikashop_address' already exists Last edit: 14 years 5 months ago by [PLHC](/forum/user/6918-plhc "View PLHC's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14264 - - 14 years 5 months ago [\#48485](#48485) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48485 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Tick the option "IF NOT EXISTS" when you do the export and that will avoid that error when you import. That option is ticked by default in recent versions of phpmyadmin. You're using an old version. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PLHC](/forum/user/6918-plhc "View PLHC's Profile")** - [![PLHC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6918-plhc "View PLHC's Profile") Topic Author - [ Offline](/forum/user/6918-plhc) Less More - Posts: 9 - Thank you received: 0 - - 14 years 5 months ago [\#48486](#48486) by [PLHC](/forum/user/6918-plhc "View PLHC's Profile") Replied by *[PLHC](/forum/user/6918-plhc "View PLHC's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48486 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Okay, but will ticking the option fix my original issue of nothing changing? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PLHC](/forum/user/6918-plhc "View PLHC's Profile")** - [![PLHC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6918-plhc "View PLHC's Profile") Topic Author - [ Offline](/forum/user/6918-plhc) Less More - Posts: 9 - Thank you received: 0 - - 14 years 5 months ago [\#48505](#48505) by [PLHC](/forum/user/6918-plhc "View PLHC's Profile") Replied by *[PLHC](/forum/user/6918-plhc "View PLHC's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48505 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* After using your suggestion this is what I got: Error SQL query: SELECT * FROM WHERE CONCAT_WS( "-", 1, 0, 'root', 'ROOT', '', 0, 0, 1, 58, 0, 'root', 0, 0, 'all', 0, '', '', '' ) = "1" ORDER BY 1 , 0, 'root', 'ROOT', '', 0, 0, 1, 58, 0, 'root', 0, 0, 'all', 0, '', '', '' MySQL said: \#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE CONCAT_WS("-", 1, 0, 'root', 'ROOT', '', 0, 0, 1, 58, 0, 'root',' at line 3 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[PLHC](/forum/user/6918-plhc "View PLHC's Profile")** - [![PLHC's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6918-plhc "View PLHC's Profile") Topic Author - [ Offline](/forum/user/6918-plhc) Less More - Posts: 9 - Thank you received: 0 - - 14 years 5 months ago [\#48508](#48508) by [PLHC](/forum/user/6918-plhc "View PLHC's Profile") Replied by *[PLHC](/forum/user/6918-plhc "View PLHC's Profile")* on topic *[Re: 1 store used for multiple Joomla sites. Possible?](/forum/4-how-to/47987-1-store-used-for-multiple-joomla-sites-possible#48508 "Hi! I wanted to know how (if possible) I can upload my store onto my second Joomla account? I have 2 sites retail and wholesale and to save time I want to upload the already finished store to the 2nd...")* Nevermind. What I needed to do was delete the tables on site 2 and replace them with site 1's tables. It's done. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQ3OTg3LTEtc3RvcmUtdXNlZC1mb3ItbXVsdGlwbGUtam9vbWxhLXNpdGVzLXBvc3NpYmxlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.320 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)