List Only Products That Are In Stock

[lawnwrangler]

Does anyone know of an easy way to list only the products that have a stock level of > 0?

 

I'm assuming I'll have to modify index.php, but I'm not sure where.

 

 

-M

[♥Monika in Germany]

Does anyone know of an easy way to list only the products that have a stock level of > 0?

 

I'm assuming I'll have to modify index.php, but I'm not sure where.

-M

<{POST_SNAPBACK}>

 

I use these settings in admin-->mystore-->stock, and items not in stock are not shown:

Check stock level true

Subtract stock true

Allow Checkout false

[lawnwrangler]

thanks, that worked! the thing that confused me was that those settings only work after new products have been added. They didin't seem to apply to the products that already existed in my store.

 

matt

 

I use these settings in admin-->mystore-->stock, and items not in stock are not shown:

Check stock level true 

Subtract stock true 

Allow Checkout false

<{POST_SNAPBACK}>

[wheeloftime]

thanks, that worked! the thing that confused me was that those settings only work after new products have been added. They didin't seem to apply to the products that already existed in my store.

 

matt

<{POST_SNAPBACK}>

 

Those products which already had a quantity of 0 before you made this change will stay visible because the check on zero stock level only happens when a product is ordered.

You'll have to manually make these products 'invisible' by clicking the red dot for each to make them unavailable.

[Rob123]

Those products which already had a quantity of 0 before you made this change will stay visible because the check on zero stock level only happens when a product is ordered.

You'll have to manually make these products 'invisible' by clicking the red dot for each to make them unavailable.

<{POST_SNAPBACK}>

 

An alternative method is to write a php or mySQL script that makes the changes en masse.

 

HTH,

Robert

[♥Monika in Germany]

An alternative method is to write a php or mySQL script that makes the changes en masse.

 

HTH,

Robert

<{POST_SNAPBACK}>

 

 

yup, one update statement in phpmyadmin will take care of it and make them all status=0 if quantity=0