Sold product still showing as new

[fonzie]

We're selling postage stamps, and sometimes we sell rare stamps of which we have only 1 item in stock, when we add such an item to our shop, it shows up as a new product, but when we sell this item very quickly, say after 2 or 3 days, it still shows up in the 'new products' although it's already sold, (new products are set to 30 days)

is there a way of avoiding this ?

regards,
Fons

[Ajeh]

You would need to customize the SELECT statements where ever you do not want to see the Sold Out Products to have on them:
and products_quantity > 0

[fonzie]

thanks for your quick reply,

how do I go about it ? I'm afraid I'm not a programmer

thanks

[Ajeh]

Let's say you want to customize the New Products centerbox ...

The code:

  $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and   p.products_status = 1 " . $display_limit;

would change to read:

  $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and p.products_quantity > 0
                           and   p.products_status = 1 " . $display_limit;

and change the code:

    $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                  p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and p.products_status = 1
                           and p.products_id in (" . $list_of_products . ")";

to read:

    $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                  p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and p.products_status = 1
                           and p.products_quantity > 0
                           and p.products_id in (" . $list_of_products . ")";

[fonzie]

thanks a lot, it works perfect,

regards,
Fons