Product in menu with multistore

[Skayfer]

Hi,

 

I create shop with multistore. There is 5 shops for different languages with little different products.

 

I display product in menu with script

{assign var="idpro" value=0}
				{foreach from=$products item=product}
					
					{if $product.id_category == $catid && $product.active == 1 && $product.id_product != $idpro}
						{assign var="idpro" value=$product.id_product}
						<li>
							<span class="arrow">></span><a href="{$link->getProductLink($product.id_product, $product.link_rewrite)|escape:'htmlall':'UTF-8'}">
							{$product.name|escape:'htmlall':'UTF-8'|truncate:50:'...'}
							</a> {if isset($product.on_sale) && $product.on_sale == 1}<span class="sale">SALE</span>{/if}
						</li>
					{/if}
				{/foreach}

, but this script display all products, too products not avalaible from choiced shop.

I want add to

{if $product.id_category == $catid && $product.active == 1 && $product.id_product != $idpro} 

condition that check if product is avalaible for this shop version.

 

 

Now half of products in menu are non avalaible because is assign for  other shops.

[Skayfer]

I look to database in ps_product, but i don't find something like shop id, or multistore id.

[Skayfer]

Or someone have idea how merge products to different table for different shops ? Maybe this resolve my problem.