AWCOUPON with Joomla Multi Sites

I work for a company that makes custom shoes for group fundraisers. In order to keep inventory straight and for tracking reasons we use Joomla Multi Sites to clone a group site every time we make a new one.

They all live on the same domain: http://boulevardstyle.com

For example: http://boulevardstyle.com/deltagamma or http://boulevardstyle.com/tridelta

All of the clone sites are in a database called groupsites with their own prefixes. example: josdeltagamma_

The master site is in a different database called style with prefix jos_

Each site has its own administrator directory but shares the master components directory. I have found that if I just copy the folder com_awocoupon from the master install into each of the clones administrator/components directory that it shows up ok. The problem lies in the databases.

On initial install onto the master site everything is great, tables created, everything runs. The problem is that because I am only sharing the components from the master and not actually installing onto the clones themselves there are no db tables in the clone databases so when I make a coupon it errors out with no such tables.

Can I either create the tables manually, or change some file setting to point to the master db tables, which would be jos_awocoupon....

By default on the clones it is looking for the clone db prefix which in the examples case would be josdeltagamma_.

thanks for the help.

I do not have any experience with multi sites in joomla so cannot give advice from that angle. Within awocoupon, all tables are called with the prefix #_. It is then up to joomla to interpret that into the correct prefix.

I think installing the awocoupon tables in each site will work, but the coupons will be seperate. The question I have is do the sites share the same virtuemart tables or are they seperate?

They do not share the same virtuemart tables. Each clone has its own vm tables. Users are shared but I dont think that matters.

AwoCoupon should follow Virtuemart. So i believe each store should have its own set of awocoupon tables.

Adding the tables to each cloned site worked.

Thanks so much for your help.

-For anyone else doing this once the tables are created on the master, NEW, cloned sites should have them upon creation, you just need to add them for already existing sites that need to use the component.