Jump to content
Sign in to follow this  
twoifbysea

Hide products from customer groups for SPPC Help

Recommended Posts

I have the All Prodcuts contribution installed and just installed Hide Products for SPPC. It works great on everything except the allprods.php page. Any ideas?

 

Here is the code:

 

<?php

 

require('includes/application_top.php');

include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ALLPRODS);

 

$breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL'));

 

$firstletter=$HTTP_GET_VARS['fl'];

if (is_numeric($firstletter)) {

$where="where pd.products_name like '!%' || pd.products_name like '0%' || pd.products_name like '1%' || pd.products_name like '2%' || pd.products_name like '3%' || pd.products_name like '4%' || pd.products_name like '5%' || pd.products_name like '6%' || pd.products_name like '7%' || pd.products_name like '8%' || pd.products_name like '9%'";

} elseif (!$HTTP_GET_VARS['page']){

$where="where pd.products_name like '$firstletter%'";

} else {

$where="where pd.products_name like '$firstletter%'";

}

 

 

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<?php

// BOF: WebMakers.com Changed: Header Tag Controller v2.55

// Replaced by header_tags.php

if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {

require(DIR_WS_INCLUDES . 'header_tags.php');

} else {

?>

<title><?php echo TITLE ?></title>

<?php

}

// EOF: WebMakers.com Changed: Header Tag Controller v1.0

?>

<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<META HTTP-EQUIV="imagetoolbar" CONTENT="no">

<script LANGUAGE="JavaScript1.1" type="text/javascript">

<!-- Begin

function right(e) {

if (navigator.appName == 'Netscape' &&

(e.which == 3 || e.which == 2))

return false;

else if (navigator.appName == 'Microsoft Internet Explorer' &&

(event.button == 2 || event.button == 3)) {

alert("Function Disabled!");

return false;

}

return true;

}

 

document.onmousedown=right;

document.onmouseup=right;

if (document.layers) window.captureEvents(Event.MOUSEDOWN);

if (document.layers) window.captureEvents(Event.MOUSEUP);

window.onmousedown=right;

window.onmouseup=right;

// End -->

</script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

 

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<?php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {?>

<td><h1><?php echo HEADING_TITLE; ?></h1></td>

<?php } else { ?>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<?php } ?>

</tr>

<tr>

<td class="main"><?php echo HEADING_SUB_TEXT; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td align="center" class="smallText"><?php $firstletter_nav=

'<a href="' . tep_href_link("allprods.php", 'fl=0', 'NONSSL') . '"> # |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=A', 'NONSSL') . '"> A |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=B', 'NONSSL') . '"> B |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=C', 'NONSSL') . '"> C |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=D', 'NONSSL') . '"> D |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=E', 'NONSSL') . '"> E |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=F', 'NONSSL') . '"> F |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=G', 'NONSSL') . '"> G |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=H', 'NONSSL') . '"> H |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=I', 'NONSSL') . '"> I |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=J', 'NONSSL') . '"> J |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=K', 'NONSSL') . '"> K |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=L', 'NONSSL') . '"> L |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=M', 'NONSSL') . '"> M |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=N', 'NONSSL') . '"> N |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=O', 'NONSSL') . '"> O |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=P', 'NONSSL') . '"> P |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Q', 'NONSSL') . '"> Q |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=R', 'NONSSL') . '"> R |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=S', 'NONSSL') . '"> S |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=T', 'NONSSL') . '"> T |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=U', 'NONSSL') . '"> U |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=V', 'NONSSL') . '"> V |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=W', 'NONSSL') . '"> W |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=X', 'NONSSL') . '"> X |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Y', 'NONSSL') . '"> Y |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Z', 'NONSSL') . '"> Z |</A>' .

'<a href="' . tep_href_link("allprods.php", '', 'NONSSL') . '"> <b>ALL</b></A>';

 

echo $firstletter_nav; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td>

<?php

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

asort($define_list);

 

$column_list = array();

reset($define_list);

while (list($column, $value) = each($define_list)) {

if ($value) $column_list[] = $column;

}

 

$select_column_list = '';

 

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {

if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_NAME') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) {

continue;

}

}

 

// listing all products

$listing_sql = "select p.products_id, p.products_model, pd.products_name, p.products_quantity, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name";

 

if (ALL_PRODUCTS_DISPLAY_MODE == 'true')

include(DIR_WS_MODULES . 'product_listing.php'); //display in standard format

else

include(DIR_WS_MODULES . 'allprods.php');

?>

</td>

</tr>

</table></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>


Sign Here

Share this post


Link to post
Share on other sites
I have the All Prodcuts contribution installed and just installed Hide Products for SPPC. It works great on everything except the allprods.php page. Any ideas?

 

Here is the code:

 

<?php

 

require('includes/application_top.php');

include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ALLPRODS);

 

$breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL'));

 

$firstletter=$HTTP_GET_VARS['fl'];

if (is_numeric($firstletter)) {

$where="where pd.products_name like '!%' || pd.products_name like '0%' || pd.products_name like '1%' || pd.products_name like '2%' || pd.products_name like '3%' || pd.products_name like '4%' || pd.products_name like '5%' || pd.products_name like '6%' || pd.products_name like '7%' || pd.products_name like '8%' || pd.products_name like '9%'";

} elseif (!$HTTP_GET_VARS['page']){

$where="where pd.products_name like '$firstletter%'";

} else {

$where="where pd.products_name like '$firstletter%'";

}

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<?php

// BOF: WebMakers.com Changed: Header Tag Controller v2.55

// Replaced by header_tags.php

if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {

require(DIR_WS_INCLUDES . 'header_tags.php');

} else {

?>

<title><?php echo TITLE ?></title>

<?php

}

// EOF: WebMakers.com Changed: Header Tag Controller v1.0

?>

<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<META HTTP-EQUIV="imagetoolbar" CONTENT="no">

<script LANGUAGE="JavaScript1.1" type="text/javascript">

<!-- Begin

function right(e) {

if (navigator.appName == 'Netscape' &&

(e.which == 3 || e.which == 2))

return false;

else if (navigator.appName == 'Microsoft Internet Explorer' &&

(event.button == 2 || event.button == 3)) {

alert("Function Disabled!");

return false;

}

return true;

}

 

document.onmousedown=right;

document.onmouseup=right;

if (document.layers) window.captureEvents(Event.MOUSEDOWN);

if (document.layers) window.captureEvents(Event.MOUSEUP);

window.onmousedown=right;

window.onmouseup=right;

// End -->

</script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

 

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<?php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {?>

<td><h1><?php echo HEADING_TITLE; ?></h1></td>

<?php } else { ?>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<?php } ?>

</tr>

<tr>

<td class="main"><?php echo HEADING_SUB_TEXT; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td align="center" class="smallText"><?php $firstletter_nav=

'<a href="' . tep_href_link("allprods.php", 'fl=0', 'NONSSL') . '"> # |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=A', 'NONSSL') . '"> A |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=B', 'NONSSL') . '"> B |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=C', 'NONSSL') . '"> C |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=D', 'NONSSL') . '"> D |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=E', 'NONSSL') . '"> E |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=F', 'NONSSL') . '"> F |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=G', 'NONSSL') . '"> G |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=H', 'NONSSL') . '"> H |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=I', 'NONSSL') . '"> I |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=J', 'NONSSL') . '"> J |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=K', 'NONSSL') . '"> K |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=L', 'NONSSL') . '"> L |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=M', 'NONSSL') . '"> M |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=N', 'NONSSL') . '"> N |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=O', 'NONSSL') . '"> O |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=P', 'NONSSL') . '"> P |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Q', 'NONSSL') . '"> Q |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=R', 'NONSSL') . '"> R |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=S', 'NONSSL') . '"> S |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=T', 'NONSSL') . '"> T |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=U', 'NONSSL') . '"> U |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=V', 'NONSSL') . '"> V |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=W', 'NONSSL') . '"> W |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=X', 'NONSSL') . '"> X |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Y', 'NONSSL') . '"> Y |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Z', 'NONSSL') . '"> Z |</A>' .

'<a href="' . tep_href_link("allprods.php", '', 'NONSSL') . '"> <b>ALL</b></A>';

 

echo $firstletter_nav; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td>

<?php

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

asort($define_list);

 

$column_list = array();

reset($define_list);

while (list($column, $value) = each($define_list)) {

if ($value) $column_list[] = $column;

}

 

$select_column_list = '';

 

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {

if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_NAME') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) {

continue;

}

}

 

// listing all products

$listing_sql = "select p.products_id, p.products_model, pd.products_name, p.products_quantity, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name";

 

if (ALL_PRODUCTS_DISPLAY_MODE == 'true')

include(DIR_WS_MODULES . 'product_listing.php'); //display in standard format

else

include(DIR_WS_MODULES . 'allprods.php');

?>

</td>

</tr>

</table></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

I m looking for the same thing.

 

I made it working when I put this code on line 30

if(!tep_session_is_registered('sppc_customer_group_id')) { 
 $customer_group_id = '0';
 } else {
  $customer_group_id = $sppc_customer_group_id;
 }

 

and I used the SQL LISTING of new_products.php :

 

  $listing_sql = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by pd.products_name";

 

The problem is that this "listing" for some reason doubles my products. HELP SOMEONE!!!

Edited by danil0

Share this post


Link to post
Share on other sites
I m looking for the same thing.

 

The problem is that this "listing" for some reason doubles my products.

This seems to work:

// BOF Separate Pricing Per Customer/Hide products and categories
 if (isset($_SESSION['sppc_customer_group_id']) && $_SESSION['sppc_customer_group_id'] != '0') {
 $customer_group_id = $_SESSION['sppc_customer_group_id'];
 } else {
  $customer_group_id = '0';
 } 

// listing all products
$listing_sql = "select distinct p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on c.categories_id = p2c.categories_id and pd.language_id = '" . $languages_id . "' $where and find_in_set('" . $customer_group_id . "', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by pd.products_name";
// EOF Separate Pricing Per Customer/Hide products and categories

Share this post


Link to post
Share on other sites
This seems to work:

// BOF Separate Pricing Per Customer/Hide products and categories
 if (isset($_SESSION['sppc_customer_group_id']) && $_SESSION['sppc_customer_group_id'] != '0') {
 $customer_group_id = $_SESSION['sppc_customer_group_id'];
 } else {
  $customer_group_id = '0';
 } 

// listing all products
$listing_sql = "select distinct p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on c.categories_id = p2c.categories_id and pd.language_id = '" . $languages_id . "' $where and find_in_set('" . $customer_group_id . "', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by pd.products_name";
// EOF Separate Pricing Per Customer/Hide products and categories

 

Thank you VERY much... its working PERFECT !!!

Share this post


Link to post
Share on other sites

hi there janz.. i have installed this and i get this error when i head over to categories/products in admin

 

1054 - Unknown column 'c.categories_hide_from_groups' in 'field list'

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_hide_from_groups from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

 

yes i do have sppc working b4 i installed this contrib..

 

is there something i am missing

 

hope to hear from you soon.. or from anyone who can lend a hand..

 

cheers

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×