X-Cart forums

[deffe]

Currently any product that is flagged as wholesale only is hidden from customers not logged in. I'm trying to find the script that sets the template to hide the wholesale only products. I would like all products shown regardless how it is flagged.

Any ideas?

[deffe]

Found the category listing code. In /include/search.php, ~line 398, comment if else statement and replace with:

$where[] = "($sql_tbl[category_memberships].membershipid IS NULL OR $sql_tbl[category_memberships].membershipid = '2')";
$where[] = "($sql_tbl[product_memberships].membershipid IS NULL OR $sql_tbl[product_memberships].membershipid = '2')";

This is obviously only for the default wholesale membership but you get the idea.

[deffe]

And here is the allowed product listing. In /include/func/func.product.php, ~line 668, comment all three SQL condition variables and replace with:

$membershipid_condition = " AND ($sql_tbl[category_memberships].membershipid = '2' OR $sql_tbl[category_memberships].membershipid IS NULL) ";
$p_membershipid_condition = " AND ($sql_tbl[product_memberships].membershipid = '2' OR $sql_tbl[product_memberships].membershipid IS NULL) ";
$price_condition = " AND $sql_tbl[quick_prices].membershipid ".((empty($membershipid) || empty($active_modules['Wholesale_Trading'])) ? "= '0'" : "IN ('$membershipid', '0')")." AND $sql_tbl[quick_prices].priceid = $sql_tbl[pricing].priceid";

Love it when I answer my own questions.

[MACWIllo]

Hi there,

Does this mod make it so that a customer not logged in will see all products, but when they are logged in they see their membership specific products? Or does it make all products and categories available to all membership levels at all times...

I want my not-logged-in customers to see everything, and also when they log in (as a "Retail" membership). However I want the wholesale memberships to only see the wholesale specific products and categories.

Cheers, Pete.

[deffe]

It will show products flagged as wholesale only to all customers.

[MACWIllo]

great! thats exactly what i am looking for, thanks a bunch!

[MACWIllo]

Hmm. Can't seem to get it to work. My "Retail" membership is membershipid '9', and so I replaced your default wholesale value of '2' to my '9' in the hope that this would display any products available to "Retail" memberships to anyone not logged in.

This is my search.php code:

if ($current_area == 'C') {
		/*if ($user_account['membershipid'] == 0) {
		
			$where[] = "$sql_tbl[category_memberships].membershipid IS NULL AND $sql_tbl[product_memberships].membershipid IS NULL";
		} else {
			$where[] = "($sql_tbl[category_memberships].membershipid IS NULL OR $sql_tbl[category_memberships].membershipid = '$user_account[membershipid]')";
			$where[] = "($sql_tbl[product_memberships].membershipid IS NULL OR $sql_tbl[product_memberships].membershipid = '$user_account[membershipid]')";
		}*/
		
		$where[] = "($sql_tbl[category_memberships].membershipid IS NULL OR $sql_tbl[category_memberships].membershipid = '9')";
		$where[] = "($sql_tbl[product_memberships].membershipid IS NULL OR $sql_tbl[product_memberships].membershipid = '9')";

		
		$where[] = "$sql_tbl[categories].avail = 'Y'";
	}

I've also done the changes to the func.product.php:

if ($current_area == "C") {

		/*$membershipid_condition = " AND ($sql_tbl[category_memberships].membershipid = '$membershipid' OR $sql_tbl[category_memberships].membershipid IS NULL) ";
		$p_membershipid_condition = " AND ($sql_tbl[product_memberships].membershipid = '$membershipid' OR $sql_tbl[product_memberships].membershipid IS NULL) ";
		$price_condition = " AND $sql_tbl[quick_prices].membershipid ".((empty($membershipid) || empty($active_modules['Wholesale_Trading'])) ? "= 0" : "IN ('$membershipid', 0)")." AND $sql_tbl[quick_prices].priceid = $sql_tbl[pricing].priceid";*/
		
		$membershipid_condition = " AND ($sql_tbl[category_memberships].membershipid = '9' OR $sql_tbl[category_memberships].membershipid IS NULL) ";
		$p_membershipid_condition = " AND ($sql_tbl[product_memberships].membershipid = '9' OR $sql_tbl[product_memberships].membershipid IS NULL) ";
		$price_condition = " AND $sql_tbl[quick_prices].membershipid ".((empty($membershipid) || empty($active_modules['Wholesale_Trading'])) ? "= '0'" : "IN ('$membershipid', '0')")." AND $sql_tbl[quick_prices].priceid = $sql_tbl[pricing].priceid";

	} else {

Any ideas why it wouldn't be working?

[deffe]

Did you add wholesale pricing to the product? Only selecting the wholesale option in the product details will not set the membershipid in the xcart_pricing table.

[MACWIllo]

ok i've got the product working now, but how do you apply that to the category showing?