Quote:
|
Originally Posted by ATKOgirl
Hi,
This may depend on how your hosting company has MySQL access set up. You might want to ask them if it is possible to have different domains access the same domain. Even if they are not set up to function in this way, they can probably grant the ability to you fairly easily.
ATKOgirl |
I have total control over how MySql is set up and can set up the correct users and priviledges to various domains either through mysql or PHPMyAdmin.
I know it is possible from a mysql point of view and I'm pretty sure that I can configure x-cart for this database. What I'd really like to do is specify which shops the products/categories appear in.
eg: category x appears in all three shops, category y appears in two etc...
I guess that an additional field could be added to the categories tables that specified which shop to show in and then put some logic in place within smarty to do the hard work - just wouldn't know where to start.
I also guess that there would need to be duplicates of various tables holding the label, text, email etc..
Another thought is to set up a cron job that backs up the sql from selected tables within the main database daily and updates a mirror (almost) database so that those product show within those shops.
any ideas/thoughts?