1 store used for multiple Joomla sites. Possible?

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!

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?

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.

Hmm...Ok.

The error I got after importing was that the hikashop....address already existed.

Just did it again. Here you go

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- 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

Okay, but will ticking the option fix my original issue of nothing changing?

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

Nevermind. What I needed to do was delete the tables on site 2 and replace them with site 1's tables. It's done.