Is it possible to disable buying only in one category?

Hi All!

Is it possible to disable , in admin , the order of one category?
For example :

pendants - costumer can buy every product in this category/subcategory
packaging - this is only for showcase, so that costumer can see the packaging types.

thanks in advance

Nandor

Let's say you wanted all Products that have master_categories_id 12 to be Call for Price (or change to what ever you want it to read/link to) ...

Edit the file:
/includes/functions/functions_general.php

and add the code in RED around line 1101:

[B]// bof: show room only for master_categories_id 12
//echo 'Products ID: ' . $product_id . ' Master Cat: ' . zen_get_products_category_id($product_id) . '<br>';
  if (zen_get_products_category_id($product_id) == 12) {
    return '<a href="' . zen_href_link(FILENAME_CONTACT_US) . '">' . TEXT_CALL_FOR_PRICE . '</a>';
  }
// eof: show room only for master_categories_id 12

[/B]    $button_check = $db->Execute("select product_is_call, products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");

NOTE: you could also use a Product Type for this to change the behavior from a Product General to a Document Product and turn off the ability to Add to Cart on those ...

Ajeh:

NOTE: you could also use a Product Type for this to change the behavior from a Product General to a Document Product and turn off the ability to Add to Cart on those ...

Hello!

The second one seems easier! i changed it to document product, but how/where , in admin, can i turn off the ability to add to cart, just for this category?

thanks in advance

N.

Nandor:

Hello!

The second one seems easier! i changed it to document product, but how/where , in admin, can i turn off the ability to add to cart, just for this category?

thanks in advance

N.

catalog->Product Types.... edit

Cheers
Rod

I may be thinking of something else, but i don't believe it's possible to change the Product Type of an existing product. I think you'll have to recreate the products using the new Product Type.

stevesh:

I may be thinking of something else, but i don't believe it's possible to change the Product Type of an existing product. I think you'll have to recreate the products using the new Product Type.

Doesnt work either way. Recreated category. When i create a new category "Restrict to product type" is not given. When i enter this category again (after having created) there is the choice "Restrict to product type" , i set it to Document-general instead of Product-general. till now its ok. But when i reenter edit this category it is automatically set back to Product-general. (before this i changed the product types setting of document -general to No (cant be added to cart)

thanks

Nandor

Ajeh:

Let's say you wanted all Products that have master_categories_id 12 to be Call for Price (or change to what ever you want it to read/link to) ...

Edit the file:
/includes/functions/functions_general.php

and add the code in RED around line 1101:

[B]// bof: show room only for master_categories_id 12
//echo 'Products ID: ' . $product_id . ' Master Cat: ' . zen_get_products_category_id($product_id) . '<br>';
if (zen_get_products_category_id($product_id) == 12) {
return '<a href="' . zen_href_link(FILENAME_CONTACT_US) . '">' . TEXT_CALL_FOR_PRICE . '</a>';
}
// eof: show room only for master_categories_id 12

[/B] $button_check = $db->Execute("select product_is_call, products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");

i tried this solution. Master cat. id is 58, i rewrote it but the add this to my cart is still there.
So you can buy from this category.

thanks

Nandor

Check and make sure that in the table:
products

58 is the actual master_categories_id of the Product(s) in the table ...

Also, look at the upgrades for v1.3.9e to v1.3.9h ... I cannot recall what version the master_categories_id look up issues were all cleaned up ...
http://www.zen-cart.com/showthread.php?153143-Known-Bugs-%28and-fixes%29-with-v1-3-9

Another check is to look in the functions_lookups.php and make sure the function zen_get_products_category_id reads:

  function zen_get_products_category_id($products_id) {
    global $db;

    $the_products_category_query = "select products_id, master_categories_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'";
    $the_products_category = $db->Execute($the_products_category_query);

    return $the_products_category->fields['master_categories_id'];
  }

Ajeh:

Check and make sure that in the table:
products

58 is the actual master_categories_id of the Product(s) in the table ...

Also, look at the upgrades for v1.3.9e to v1.3.9h ... I cannot recall what version the master_categories_id look up issues were all cleaned up ...
http://www.zen-cart.com/showthread.php?153143-Known-Bugs-%28and-fixes%29-with-v1-3-9

Another check is to look in the functions_lookups.php and make sure the function zen_get_products_category_id reads:

function zen_get_products_category_id($products_id) {
global $db;

$the_products_category_query = "select products_id, master_categories_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'";
$the_products_category = $db->Execute($the_products_category_query);

return $the_products_category->fields['master_categories_id'];

}

**Is this the master cat. id:**




i found this in functions lookups php :

function zen_get_products_category_id($products_id) {
    global $db;

    $the_products_category_query = "select products_id, master_categories_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'";
    $the_products_category = $db->Execute($the_products_category_query);

    return $the_products_category->fields['master_categories_id'];
  }

thanks

Nandor

Now go into Category 58 (Packaging) and edit the Product ... Does it show:

Product Master Category: ID# 58 Packaging

Ajeh:

Now go into Category 58 (Packaging) and edit the Product ... Does it show:

yes it does :

Product Master Category: ID# 58 Packaging

For giggles and grins ... can you change the code to show uncomment the echo:

// bof: show room only for master_categories_id 12
[B]echo 'Products ID: ' . $product_id . ' Master Cat: ' . zen_get_products_category_id($product_id) . '<br>';
[/B]  if (zen_get_products_category_id($product_id) == 12) {
    return '<a href="' . zen_href_link(FILENAME_CONTACT_US) . '">' . TEXT_CALL_FOR_PRICE . '</a>';
  }
// eof: show room only for master_categories_id 12

and go to that Category/Product and what do you see?

Ajeh:

For giggles and grins ... can you change the code to show uncomment the echo:

// bof: show room only for master_categories_id 12
[B]echo 'Products ID: ' . $product_id . ' Master Cat: ' . zen_get_products_category_id($product_id) . '<br>';
[/B] if (zen_get_products_category_id($product_id) == 12) {
return '<a href="' . zen_href_link(FILENAME_CONTACT_US) . '">' . TEXT_CALL_FOR_PRICE . '</a>';
}
// eof: show room only for master_categories_id 12

> 
> and go to that Category/Product and what do you see?


**I deleted this before echo : //  (hope you meant this by changing the code to show uncomment the echo)

saw category/product and see the same in admin :
Product Master Category: 	ID# 58 Packaging

and you can see the add this to my cart button.

Nandor**

And the line:

  if (zen_get_products_category_id($product_id) == 12) {

you changed to:

  if (zen_get_products_category_id($product_id) == [B]58[/B]) {

If you switch to the Classic Template ... does this work correctly?

Ajeh:

If you switch to the Classic Template ... does this work correctly?

switched to classic template in admin/tools/template selection. It is the same as previously , you can buy from this category.

Could you Zip and post as an attachment your file, from the server, for:
/includes/functions/functions_general.php

Ajeh:

Could you Zip and post as an attachment your file, from the server, for:
/includes/functions/functions_general.php

Attachment #12314

thanks

You have the code in the wrong place ... :eek:

Remove the new code that I gave you:

// bof: show room only for master_categories_id 58
echo 'Products ID: ' . $product_id . ' Master Cat: ' . zen_get_products_category_id($product_id) . '<br>';
  if (zen_get_products_category_id($product_id) == 58) {
    return '<a href="' . zen_href_link(FILENAME_CONTACT_US) . '">' . TEXT_CALL_FOR_PRICE . '</a>';
  }
// eof: show room only for master_categories_id 58

and go lower in the code and find the code that starts with:

    }

    $button_check = $db->Execute("select product_is_call, products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");
    switch (true) {
// cannot be added to the cart

Put it just below the } and above the line starting with $button_check so it reads:

    }

// bof: show room only for master_categories_id 58
echo 'Products ID: ' . $product_id . ' Master Cat: ' . zen_get_products_category_id($product_id) . '<br>';
  if (zen_get_products_category_id($product_id) == 58) {
    return '<a href="' . zen_href_link(FILENAME_CONTACT_US) . '">' . TEXT_CALL_FOR_PRICE . '</a>';
  }
// eof: show room only for master_categories_id 58


    $button_check = $db->Execute("select product_is_call, products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");
    switch (true) {
// cannot be added to the cart