[N00dles]

I want to be able to see if the product has stock available in the part I view in admin/categories.php where you add the featured items.

I am in the /skin/myskin/common/admin/featured_products.tpl
I have added a new colm in the part I want but when I try to use the smarty code for the query it wants to be a Y instead of the number available.
The Y/N has been subsituted for the available stock count VAR so now it is featured product = active true false, so will I need to do another query just for the avaiblity of stock itself ?

Is there another var / query / php I need to add for the available amount to show on the admin featured_products.tpl ?

How I think the var query is : table [field_productid]. field_valueneeded
v4.4.3

I have tried a few none work

{$products[prod_num].avail}

or

{$products[productid].avail}

But this does not work I have tried others to

{if $products[product].avail gt 0}{$lng.txt_items_available|substitute:"items":$products[product].avail}{else}{$lng.lbl_no_items_available}{/if}

{if $product.avail gt 0}IN STOCK{else}BACKORDERED{/if}