Jump to content

Pronux

Members
  • Content count

    98
  • Joined

  • Last visited

Everything posted by Pronux

  1. Pronux

    Simply Hide Products (SHP)

    I've received the following question via mail: --------------------------------------------------------------- Hi here! I would like to know how it would be possible to hide products without an assigned category. I want to hide products from the main store but make them available to those that link directly to them. This would be used for google advertising. Thank you --------------------------------------------------------------- Answer: Yes, you can hide products without an assigned category. BUT: you must define the customer(s) who can see the products (you have to select this customres in the admin for each product) So I'm not sure if this is the right contribution for your scenario.
  2. Pronux

    Simply Hide Products (SHP)

    Sorry, but I can't see the ".....describe categories status where categories_id not in(924, 240,...." in you code snippet. Please go through each file of your shop and find the query -> use an editor which scans all files for the word "describe".
  3. Pronux

    Simply Hide Products (SHP)

    I mean the the sql query you mentioned in your post on 4 january: http://forums.oscommerce.com/topic/349008-simply-hide-products-shp/page__view__findpost__p__1471287 I don't know where this query is in your shop, you have to search for it. Note: In a clean osCommerce installation this contribution works without a problem, so it must be a query which has been modified.
  4. Pronux

    Simply Hide Products (SHP)

    You have to find the sql query which causes the error. If you copy it here into this thread I will fix it.
  5. Pronux

    Simply Hide Products (SHP)

    That's possible, if I have time I will change it into an ajax field. Can you tell me in which box (catalog/includes/boxes/) the error occur ?
  6. Pronux

    Simply Hide Products (SHP)

    Hi, Did you remove the correct code, it's just above the following lines: $_SESSION['hidden_products'] = $hidden_products; $_SESSION['hidden_categories'] = $hidden_categories; $_SESSION['hidden_products_timestamp'] = $hidden_products_timestamp; If you installed it correctly, it will hide the category name. Have you installed some other contributions which may cause this error ?
  7. Pronux

    Simply Hide Products (SHP)

    hope it works for you :thumbsup: happy new year from switzerland
  8. Pronux

    Simply Hide Products (SHP)

    Yes, this should be easy. Open the file catalog/includes/functions/general.php, go to function tep_set_hidden_products and delete the following section: $check_query = tep_db_query("SELECT DISTINCT shp.products_id FROM ".TABLE_PRODUCTS." shp WHERE shp.products_id NOT IN (".$hidden_products.") AND shp.products_status = '1' AND shp.products_id IN (SELECT products_id FROM ".TABLE_PRODUCTS_TO_CATEGORIES." WHERE categories_id IN (".$all_categories_temp."))"); if (tep_db_num_rows($check_query) > 0) { if($hidden_products != "0") { $hidden_products .= ", "; } else { $hidden_products = ""; } while($h_prods = tep_db_fetch_array($check_query)) { $hidden_products .= $h_prods['products_id'].", "; } $hidden_products = substr($hidden_products, 0, -2); }
  9. Pronux

    Simply Hide Products (SHP)

    Hi, If you copy a product it will work as you want, if you link a product it will not work.
  10. Pronux

    Simply Hide Products (SHP)

    Hi, This seems to be a bug which occurs only if you hide categories but no products. Please try the following fix: Open file catalog/includes/functions/general.php, go to function tep_set_hidden_products and add near line 1400 the code: else { $has_hidden_categories = true; } before: //find hidden categories and also all products in there if($has_hidden_categories) { after it should look like: else { $has_hidden_categories = true; } //find hidden categories and also all products in there if($has_hidden_categories) { Does this fix your problem ?
  11. Pronux

    Simply Hide Products (SHP)

    I have received the following question via E-Mail: "Any thoughts of making SHP available for v3 of osC? Thanks." Answer: I will probably make it available for v3 as soon as v3 final is released, but at the moment I have no time….sorry
  12. Pronux

    Simply Hide Products (SHP)

    It would be possible, but you have to code it yourself (I would probably write it, but I have no time at the moment......) Here a short description of how you can make it: 1. Add a new field "postcode" to the table hidden_products 2. Extend the function tep_print_shp_menu() (file: catalog/admin/includes/functions/general.php) so that it can also display a dropdown menu with postcodes which a user can then select. 3.Extend the function tep_set_hidden_products() (file: catalog/admin/includes/functions/general.php) so that it gets also the hidden categories from the table hidden_products, based on the customers postcode. hope it helps.
  13. Pronux

    Simply Hide Products (SHP)

    Hi Jamez Thanks for the hint about php4. I will add your code to the next release of SHP. Yes, that's the part of the code which creates the menu as you can see in the first screenshot above. Can you upload categories.php from the SHP zip to your shop and see if it works ?
×