Removing products from catalog when sold out

[viper00713]

does anyone know if i can make it to where when an item sells out, that it would no longer show up in the online catalog, untill i have more available stock.

thanks

[Jack_mcs]

There are sold out contributions that will still allow the product to be seen by your customers. If you remove it until there is stock again the product won't appear on your site. If someone comes to your site looking for it during the time that it is not there, they will assume you don't carry it and may not come back. With the sold out, they may come back. Installing the wish list contribution as well would enhance the chances of making a sale on such a product even more.

 

Jack

[viper00713]

i had just downloaded os commerce the other day, the copy which i have must already do this, for when a item sells out, it does not deactivate. I want the item to deactivate and to no longer show up in the catalog. I sell DVD's and when i reorder them, there is no guantee that i would recieve the same title as before, there for i would like it to deactivate until i get more copies of that movie.

[andytc]

take a look at your file - catalog/checkout_process.php:

 

find this code -

 

CODE

if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) {

// tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");

}

 

 

The example above would keep the item shown and NOT de-activate it.

 

If that bit of code in your file looks like the above with the 2 comment marks // on the second line , just remove the 2 // to put it back to standard OSC.

[viper00713]

no, my file doesn't have the 2 comment marks, it looks like this

 

 

if ( ($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false') ) {

tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");

}

[satish]

steps:

Set a cron that will set the products status to 0 mif inventory 0 or less then 0.

In code that display products list modify query to chek for product with greate then zero and place those in list.

 

On product in page again chek for stock.Then decide whether to show add to cart or not.

 

Satish

[viper00713]

im sorry, i do not understand, i am still new to all this

[kewldude_3001]

If 'subtract stock' is set to true under configuration/stock, doesnt that automatically set the product to out of stock once it hits 0 and remove the product from displaying till there is more stock?

[viper00713]

yes, i have it subtract stock set to true, and it displays the item as out of stock, and they can't purchase it anymore, but it remains in the catalog. I want it to remove it from the catalog, until i get more stock. I don't want alot of items that will show up as out of stock

[kewldude_3001]

lol mine does that by itself, i cant seem to remember what i did which is why i want to say i didnt do anything