We are planning on using Multi Store on a website along with shoppica2 and using Multistore Product Text which enables us to create a custom description for each product for each site.

We would also like to use the product slideshow functionality as frankly its brilliant.

That’s where I need a little help – we want to pull the descriptions for the products for the slideshow, but it is also pulling the descriptions for the other stores – which means we have the same product show up multiple times but with different descriptions.

I think that what it is doing is is pulling the description form the oc_product_descriptions table where productid= what ever the product is.

This then pulls down multiple descriptions for the product as our table has been modified with a store_id column as well so we can have multiple descriptions for different sites

So my request for help – could you tell me where I can edit the sql so that we tell it to pull down the description for where productid- the product and storeid= current store.

Thanks in advance!