Duplicate shop?

Dear forum members,

I set up a shop with everything needed. The shop "project" covers several almost identical shop. Almost. So I tried to duplicate the first version of the shop. This included all shop files and the database tables. The tables and files are located on the same web and database server. I just had to change the path names (/www/shop1 to /www/shop2) and the table prefix.

Everything looked fine, the shop seemed to work properly. I was able to browse products and place orders and everything connected with that. But - problem! - the orders are not visible in the administration frontend although it seems as they were stored in the database correctly.

What could be the problem here? My approach was that there is something missing in the database. I dumped the source database and removed some rows from it (like statistics, counters, orders, order item and customer data). I also removed the auto increment parameters as they were not needed in some cases. In the order table I set the auto increment parameter to 20000 as I wanted to start the oder and invoice numer from that value.

If I chose the wrong forum I kindly ask you to move my issue.

Thank you.

Peter

Sounds like the dreaded "both configure.php files need to be changed to reflect the new site" bug. Make sure bothe the admin/includes/configure.php and the includes/configure.php are correct for each shop.

dbltoe:

Sounds like the dreaded "both configure.php files need to be changed to reflect the new site" bug. Make sure bothe the admin/includes/configure.php and the includes/configure.php are correct for each shop.Thanks for the suggestion. As the catalog and other settings can be modified via the administration frontend I am pretty sure both configuration files are correct. Any ideas?

Thanks.

Peter

If I have site A and site B with both having identical items BUT different databases, I could have the admin configure.php set to upload A for both. Hence, I could change something in B but not find it in B's catalogue because it loaded to A's database.

If both configures are correct in their settings, I'm at a loss. Sorry:cry:

Yeah, that's the strange thing. I can see orders and order items in the database but not in the frontend although I can see products both in the database, in the shop and in the frontend.

That means there must be something wrong with the data rows in the database. But there is not much I changed. I just set the auto increment parameter. Perhaps I should not have done that. I will export the data schema from shop A again and import it without removing anything. After that I will remove items step by step.

If what you are wanting to do is to have a 'master template site' that can be quickly installed, all that is necessary is to restore the site files to the new folders, create a database and restore the copy, and adjust the configure.php files to the new settings.

It is not necessary to fiddle with any database settings, particularly auto_increments, as that is guaranteed to break things. The only time this is necessary is when using something like SQLyog for the database export/restore, as it does not carry over the params like auto_increment, and they need to be manually reset.

Some database exports made with some of the mySQL admin packages include a USE DATABASE line that needs to be edited to the new values before the import, or deleted.

If however, you are trying to have 2 shopfronts sharing one database, you need the Multisite Module.

And if you are sharing a single database between 2 sites with differentiating table prefixes, I suspect that could get very confusing for the site admin.