Featured products in admin shows items not in stock

[jagge]

Hi,
we have a store which have about 50% of the products inactive from time to time.
But when adding a featured product from admin all products shows in the selectbox even though its inactive or not in stock?
Is it possible to change this to only show products that are actually active?
Ive searched around here but couldnt find anything.

Thanks,
Jagge

[Ajeh]

You could customize it to change this section of code so that the SQL statement has additional conditions for what to exclude:

// do not include things that cannot go in the cart
      $not_for_cart = $db->Execute("select p.products_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCT_TYPES . " pt on p.products_type= pt.type_id where pt.allow_add_to_cart = 'N'");

[Tech-E]

Hi Ajeh

Do we need to change that in all the scripts that use the $not_for_cart variable? I found it in 4 administrative files, but not in any catalog files. I thought it would be filtered in a catalog script when a product is out of stock.

[jagge]

Thanks Ajeh for the quick answer.
Not sure what to do though. Im quite a newbie on this. Shall I change something in that codesnippet or add something?

/Ola

[Ajeh]

Currently, that SELECT is picking Products that are set to:
where pt.allow_add_to_cart = 'N'");

So add on to that ...

you don't want Products that have the status turned off:
p.products_status = 0

or have nothing 0 or less for the quantity:
p.products_quantity <= 0

So adding something to the WHERE statement to:

where pt.allow_add_to_cart = 'N' or p.products_quantity <= 0 or products_status =0

might do the trick ...

[jagge]

Thanks Ajeh!
That did the trick for sure!

/Jagge

[Ajeh]

Thanks for the update that this was able to work for you ...