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 you can do that.
If you want to do a copy of one website somewhere else, I recommend you that you use Akeeba Backup.

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?

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.

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.

It's not possible that nothing happened when you imported. Did you get an error message ? Something ? The categories ?

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

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.

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.