osCommerce Community Support Forums > Hide Products Contribution Available?

kozen

May 19 2008, 05:35 AM

Hi,

I was searching this forum, Google and the contribution base already and didn't find the answer

I am looking for a contribution which allows me to set a product "invisible" to the catalog which is means it is not accessible through out the front catalog browsing and category listing at all. However, it should still be accessible via a direct URL so the customers who know the URL can purchase the product like any other. ("Out of Stock" sets the product completely invisible which is not what I actually want)

Is something like this available?

Thanks a lot in advance.

dmnalven

May 20 2008, 05:11 PM

Try changing the query in product_info.php, around line #17, to:

CODE

$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

and the query around line #72 to:

CODE

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

This has NOT been tested extensively but will show those products marked "Out of Stock" (and hence not visible) when directly accessed with their product id in the url.

For any refinements, please PM me.

kozen

May 21 2008, 04:25 AM

QUOTE (dmnalven @ May 21 2008, 01:11 AM)

Try changing the query in product_info.php, around line #17, to:

CODE

$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

and the query around line #72 to:

CODE

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

This has NOT been tested extensively but will show those products marked "Out of Stock" (and hence not visible) when directly accessed with their product id in the url.

For any refinements, please PM me.

Thanks a lot for the reply. The problem is: I find the normal "Out of Stock" setting useful. However, I need the "invisibility" somehow additionally, do you know what I mean?

dmnalven

May 21 2008, 04:15 PM

Yes.

OSCOMMERCE SUPPORT CALL 702-453-3332