teglet Posted August 13, 2006 Share Posted August 13, 2006 Hi All, I am sure this is a very simple thing to do but I cant for the life of me think of the simple way to do it... I have an OSC site that I have been running very sucessfully now for 2+ years. As you all know you add contributions and make changes to code throughout the store life and what you end up with is what you are happy with - generally. Now my problem is that I want to have four or five seperate shops that are run by regional managers. I therefore need to set one shop up that is configured for the UK, ie, uk counties, uk tax, uk credit cards etc etc, - That should be easy enough I know there are UK specific contributions for that. But how do I do the following two things: 1. When I have created the 1 clean perfect UK install that meets my needs, and put it on www.site1.co.uk how can I duplicate that and the database and make a totally new install with it's own separate database and install it on www.site2.co.uk? etc etc. 2. Over the 2+ years I have added products to the existing site database that I no longer sell but there are several hundred that I do still sell. Now each of these has a lengthy description and various product attributes associated with them. How can I do a selective back up of just the products that I want to sell in the new shops and create a database of these without importing all of the products that I no longer sell. In essence what I am looking for is five completely separate shops that have five separate databases, that come pre-loaded with a common set of core products which have been copied from the main (old) site. This allows each manager to add their own regional products not available nationally. Any help here would be gratelly appreciated as I am tearing my hair out :( Link to comment Share on other sites More sharing options...
jhsands Posted August 13, 2006 Share Posted August 13, 2006 1. When I have created the 1 clean perfect UK install that meets my needs, and put it on www.site1.co.ukhow can I duplicate that and the database and make a totally new install with it's own separate database and install it on www.site2.co.uk? etc etc. tarball [at *nix shell: man tar] the /catalog/ directory (or whatever dir you use) and save a copy of the database through your backup system. Upload the database and tarball to the new site and untar it. If you do not have shell access and cannot tar, then simply FTP download the entire /catalog directory from site 1 and then reupload it to site 2. After you get it uploaded, you'll have to change /includes/configure.php and admin/includes/configure.php for site2. Then go to the admin site and make changes to the store name, email address, and etc. Now each of these has a lengthy description and various product attributes associated with them. How can I do a selective back up of just the products that I want to sell in the new shops and create a database of these without importing all of the products that I no longer sell. Using admin - copy, move and delete multiple products may be easier than selective exporting. You can delete a bunch at a time. ;) BACKUP your current files before editing. Did I mention to BACKUP your current files, first? "I'm not a hero, I'm a firefighter; it is my job to save lives. I'm a Jesus Christ Firefighter saving souls from the flames!" Installed contribs: Almost XP Buttons *** Attribute Sort *** Auto Thumbnail Change *** Column Product Listing (for SPPC v4.0) *** Contact Us Registered *** Country-State Selector 1.3.3J *** CC# Db Mask 1.3 *** Email Order Clickable Link *** Extra Images *** Linkpoint API CVM *** Loginbox Best *** New Spiders *** New Attrib Mgr v.5.0 w/ New Attrib Include *** Multi Product Update *** MySQL Cron *** Pricing per Category *** Product Listing in Columns v2.2 [later upgraded to CPL(SPPC)] *** Product Sort v1.6 *** Seperate Pricing Per Customer v4.15 *** Simple Down for Maintenance [Gokou] *** Ultimate_SEO_URLs_v2.2.2 *** UPS Worldship Export 1.3 *** Welcome Email username & password Link to comment Share on other sites More sharing options...
teglet Posted August 18, 2006 Author Share Posted August 18, 2006 tarball [at *nix shell: man tar] the /catalog/ directory (or whatever dir you use) and save a copy of the database through your backup system. Upload the database and tarball to the new site and untar it. If you do not have shell access and cannot tar, then simply FTP download the entire /catalog directory from site 1 and then reupload it to site 2. After you get it uploaded, you'll have to change /includes/configure.php and admin/includes/configure.php for site2. Then go to the admin site and make changes to the store name, email address, and etc. Using admin - copy, move and delete multiple products may be easier than selective exporting. You can delete a bunch at a time. ;) I tried that but I have too many DB mods and when I do the back up it crashes the site. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.