I would like to know the answer too. Anyone here know what is the right answer to your question. I'll do some poking around and get back to you if I bump into an decent answer. You should email the people at iPage as they probably could give you help..
Yes I make a proper database for each shop, but , I have to link tose database to a shared database that contains all the products related tables no?..
I remember Linda McGrath saying something about shared databases between shops on the same server, it would seem to be difficult given that each admin can input data and stuff it! I was going to have multiple shops on one database using the different languages as a basis. Good Luck! :?..
Is there any way to have multiple stores (which I believe I have figured out by storing duplicate catalogs in different file names) that will show on select products?.
For example if the products bas is 20 is there any way to say ones store can show 10 of the 20, but the other store can show all 20?.
There may already be a discussion on thhis but I have been searching through this forum for hours :evil: with no luck...
It seems that if you duplicate the languages and change for each shop ie english is shop 1 german is shop 2 etc then you can cut and paste in admin to each store!..
The languages would be exactly the same in all the shops..
Along these lines, I would simply like to know how to export the product database only to move to another (duplicate) store to essentially keep these stores mirrored, without also overwriting the customer/order database..
I am sure I can figure out which tables to export but I thought if anyone is already doing this, it would save me from exporting tables I don't need..
Nevermind, figured it out. For my use all I need to do is export the database from PHPmyAdmin less the tables that I do not want overwritten, and then move them over to the duplicate store..
Little help here....
I'm trying to accomplish the very same thing here: Exporting my category database and importing it in a duplicate store..
So, using phpMyAdmin 2.6.0-pl2, I :.
- go to my "categories" db.
- cick the export tab.
- export (data and structure) to a sql file using the default export options.
- jump to my duplicate store db (on the same server).
- go to the "categories" db to be replaced.
- I choose my exported sql file in the "Location of the text file" section of the "Run SQL Query/queries" and click on the Go button.
And I get the following error:.
PhpMyAdmin SQL Dump.
Generation Time: Nov 01, 2004 at 11:48 PM.
Server version: 4.0.22.
PHP Version: 4.3.9.
Table structure for table `categories`.
CREATE TABLE `categories` (.
`categories_id` int( 11 ) NOT NULL AUTO_INCREMENT ,.
`categories_image` varchar( 64 ) default NULL ,.
`parent_id` int( 11 ) NOT NULL default '0',.
`sort_order` int( 3 ) default NULL ,.
`date_added` datetime default NULL ,.
`last_modified` datetime default NULL ,.
PRIMARY KEY ( `categories_id` ) ,.
KEY `idx_categories_parent_id` ( `parent_id` ).
) TYPE = MYISAM AUTO_INCREMENT =25.
#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 'categories_id` int(11) NOT NULL auto_increment,.
What am I doing wrong ? How can the syntax of dump be wrong ? .
I'm a total php/sql/phpMyAdmin newbie so please bare with me if it's an obvious one...
OSCOmmerce uses a file called: database.php. In this file is a variable called: $$LINK, this variable is set as soon as you goto the first page in your shopping cart: index.php which has a requires(application_top.php) directive, which has a requires(database.php), which creates the connection to your database from which everything is transferrred through..
Basically to put a long story short every time you want to do something with your oscommerce store it calls upon a global connection variable that is assigned to a specific database..
In order to change the behaviour of your store you would have to create another datasource that is configured to point to something else then when you want to use this datasource have your queries use this datasource..
Of course this would require changing your database.php file as well as changing your product_info.php, checkout_shipping.php, checkout_payment.php, checkout_process.php, order total, shipping basically anything that refers to the product table to point to your control table. It could be done but it would be error prone until you worked all the bugs out..
An easier way would be to setup replication between your MYSQL servers:.
This way you can have multiple databases each with their own data and each pointing to a single datasource,$$LINK, but their product tables, categories tables are controlled by a master database through your replication settings..
You could even delete rows out of your product table if you did not want the products to show in that store through the admin section of your cart, or if you wanted to get really fancy alter the select statement when it performs the replication. If you put a column in your master products table called: "store" you could filter which rows go to which slave database by altering the where clause on the replication insert..
It may sound like more work but actual it is faster, more accurate and would allow each store to operate independantly from one another allowing each one to be configured any way you would like and each to insert into their own database. The benefit would be controlling certain tables through replication and thus mirroring perhaps the product, categories table and probably the products_options table if you use that contribution..
I think it would be easier to solve these business concerns through that method than trying to change your datasources and copying and pasting data blocks through PHPMyadmin but maybe not..
Hope that gives some insight to how you may solve your data issues..
By the way I have nearly the same needs :.
I have a list of 2000 produts and 20 shops around the country that are selling some of these products , I would like them to have for each of them different shipping and payement method, and different layout , so each shop would have their own database but would share the products and manufacturers tables and image directory ..
Maybe with some more work in the code I could in a new table that would allow some configuration for each shop like payement method activated, shippind activated, categories of products activated, css choice , I could use the same directory for all the php files and the same database with some adding of merchant_id ....
Im pretty sure some people had or have the same need , so maybe you can give me advices or directions ....
I saw many post about virtual mall , but doesnt seemes to work the same way I need ...
It would seem to be relatively easy to alter your config file to show a path to a remote directory for images but the tables are in a distinct (MySQL) database and would need to be duplicated for each site...