Seperate Pricing Per Customer v3.5

[sflraver]

I went back over everyting on the install and all seems ok. I am stumped on why the price becomes correct in the catagory listing for the customer's group only after it is added to the cart. Does anyone know the file OSC calls to pull the price on the catagory listing so maybe I can figure out where to start?

[Jan Zonjee]

I am stumped on why the price becomes correct in the catagory listing for the customer's group only after it is added to the cart.

It is not as strange as it sounds because when includes/modules/products_listing.php calls the class PriceFormatter to get the price breaks for display the code in there first looks if there is already data for that products_id stored in PriceFormatterStore.php before using data delivered by products_listing.php. Data for the products in the cart are already stored before products_listing.php is loaded and apparently those are correct, those from products_listing.php aren't.

 

Apparently you didn't use the products_listing.php from the package.

[sflraver]

my products_listing.php is the exact same as the one in the package SPPC_Price_Break_v2_0 . Here is a copy below. That was the firt thing that I checked. Any other ideas or is there something wrong in the code below from my includes/moduels/product_listing.php ?

 

<?php
/*
 $Id: product_listing.php 1739 2007-12-20 00:52:16Z hpdl $
 adapted for Separate Pricing Per Customer v4.2 2007/08/23, adapted for QPBPP for SPPC v2.0 2008/11/11

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

// BOF QPBPP for SPPC
 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_LISTING);
// EOF QPBPP for SPPC
 $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');

 if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
 </tr>
</table>
<?php
 }

 $list_box_contents = array();

 for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
switch ($column_list[$col]) {
  case 'PRODUCT_LIST_MODEL':
	$lc_text = TABLE_HEADING_MODEL;
	$lc_align = '';
	break;
  case 'PRODUCT_LIST_NAME':
	$lc_text = TABLE_HEADING_PRODUCTS;
	$lc_align = '';
	break;
  case 'PRODUCT_LIST_MANUFACTURER':
	$lc_text = TABLE_HEADING_MANUFACTURER;
	$lc_align = '';
	break;
  case 'PRODUCT_LIST_PRICE':
	$lc_text = TABLE_HEADING_PRICE;
	$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_QUANTITY':
	$lc_text = TABLE_HEADING_QUANTITY;
	$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_WEIGHT':
	$lc_text = TABLE_HEADING_WEIGHT;
	$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_IMAGE':
	$lc_text = TABLE_HEADING_IMAGE;
	$lc_align = 'center';
	break;
  case 'PRODUCT_LIST_BUY_NOW':
	$lc_text = TABLE_HEADING_BUY_NOW;
	$lc_align = 'center';
	break;
}

if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) {
  $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text);
}

$list_box_contents[0][] = array('align' => $lc_align,
								'params' => 'class="productListing-heading"',
								'text' => ' ' . $lc_text . ' ');
 }

 if ($listing_split->number_of_rows > 0) {

$rows = 0;
$listing_query = tep_db_query($listing_split->sql_query);
// BOF Separate Pricing per Customer
$no_of_listings = tep_db_num_rows($listing_query);
// global variable (session) $sppc_customer_group_id -> local variable customer_group_id

 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';
 }

while ($_listing = tep_db_fetch_array($listing_query)) {
// BOF QPBPP for SPPC
 $_listing['discount_categories_id'] = NULL;
 $listing[] = $_listing;
 $list_of_prdct_ids[] = $_listing['products_id'];
}
$list_of_prdct_ids = array_unique($list_of_prdct_ids);
// EOF QPBPP for SPPC
// next part is a debug feature, when uncommented it will print the info that this module receives
/*
  echo '<pre>';
  print_r($listing);
  echo '</pre>';
*/

// get all product prices for products with the particular customer_group_id
// however not necessary for customer_group_id = 0
if ($customer_group_id != '0') {
// BOF QPBPP for SPPC
 $pg_query = tep_db_query("select pg.products_id, customers_group_price as price from " . TABLE_PRODUCTS_GROUPS . " pg where products_id in (" . implode(',', $list_of_prdct_ids) . ") and pg.customers_group_id = '" . $customer_group_id . "' and customers_group_price != null");
// EOF QPBPP for SPPC

while ($pg_array = tep_db_fetch_array($pg_query)) {
$new_prices[] = array ('products_id' => $pg_array['products_id'], 'products_price' => $pg_array['price'], 'specials_new_products_price' => '', 'final_price' => $pg_array['price']);
}
for ($x = 0; $x < $no_of_listings; $x++) {
// replace products prices with those from customers_group table
  if(!empty($new_prices)) {
	for ($i = 0; $i < count($new_prices); $i++) {
		if( $listing[$x]['products_id'] == $new_prices[$i]['products_id'] ) {
			$listing[$x]['products_price'] = $new_prices[$i]['products_price'];
			$listing[$x]['final_price'] = $new_prices[$i]['final_price'];
		  }
	  }
	} // end if(!empty($new_prices)
$listing[$x]['specials_new_products_price'] = ''; // makes sure that a retail specials price doesn't carry over to another customer group
$listing[$x]['final_price'] = $listing[$x]['products_price']; // final price should not be the retail special price
  } // end for ($x = 0; $x < $no_of_listings; $x++)
} // end if ($customer_group_id != '0')

// an extra query is needed for all the specials

$specials_query = tep_db_query("select products_id, specials_new_products_price from " . TABLE_SPECIALS . " where products_id in (" . implode(',', $list_of_prdct_ids) . ") and status = '1' and customers_group_id = '" . $customer_group_id . "'");
while ($specials_array = tep_db_fetch_array($specials_query)) {
$new_s_prices[] = array ('products_id' => $specials_array['products_id'], 'products_price' => '', 'specials_new_products_price' => $specials_array['specials_new_products_price'] , 'final_price' => $specials_array['specials_new_products_price']);
}

// add the correct specials_new_products_price and replace final_price
for ($x = 0; $x < $no_of_listings; $x++) {
if(!empty($new_s_prices)) {
	for ($i = 0; $i < count($new_s_prices); $i++) {
		if( $listing[$x]['products_id'] == $new_s_prices[$i]['products_id'] ) {
		$listing[$x]['specials_new_products_price'] = $new_s_prices[$i]['specials_new_products_price'];
		$listing[$x]['final_price'] = $new_s_prices[$i]['final_price'];
		}
	}
  } // end if(!empty($new_s_prices)
} // end for ($x = 0; $x < $no_of_listings; $x++)

// BOF QPBPP for SPPC
$price_breaks_query = tep_db_query("select products_id, products_price, products_qty from  " . TABLE_PRODUCTS_PRICE_BREAK . " where products_id in (" . implode(',', $list_of_prdct_ids) . ") and customers_group_id = '" . $customer_group_id . "' order by products_id, products_qty");
while ($price_break = tep_db_fetch_array($price_breaks_query)) {
	  $price_breaks_array[$price_break['products_id']][] = array('products_price' => $price_break['products_price'], 'products_qty' => $price_break['products_qty']);
}
// get discount category plus quantity blocks and minimum order quantity for retail
$discount_category_query = tep_db_query("select p.products_id, p.products_qty_blocks as qtyBlocks, p.products_min_order_qty, p.products_quantity, p.manufacturers_id, p.products_weight, discount_categories_id from " . TABLE_PRODUCTS ." p left join (select products_id, discount_categories_id from " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " where products_id in (" . implode(',', $list_of_prdct_ids) . ") and customers_group_id = '" . $customer_group_id . "') as ptdc on p.products_id = ptdc.products_id where p.products_id in (" . implode(',', $list_of_prdct_ids) . ")");
  while ($dc_array = tep_db_fetch_array($discount_category_query)) {
	$discount_categories[] = array ('products_id' => $dc_array['products_id'], 'qtyBlocks' => ($customer_group_id == '0' ? $dc_array['qtyBlocks']: '1'), 'products_min_order_qty' => ($customer_group_id == '0' ? $dc_array['products_min_order_qty']: '1'), 'products_quantity' => $dc_array['products_quantity'], 'products_weight' => $dc_array['products_weight'], 'discount_categories_id' => $dc_array['discount_categories_id']);
  }
  if(!empty($discount_categories)) {
	$no_of_discount_cats = count($discount_categories);
  for ($x = 0; $x < $no_of_listings; $x++) {
// add discount categories to the listing array 
	for ($i = 0; $i < $no_of_discount_cats; $i++) {
		if ($listing[$x]['products_id'] == $discount_categories[$i]['products_id'] ) {
			$listing[$x]['discount_categories_id'] = $discount_categories[$i]['discount_categories_id'];
			$listing[$x]['qtyBlocks'] = $discount_categories[$i]['qtyBlocks'];
			$listing[$x]['products_min_order_qty'] = $discount_categories[$i]['products_min_order_qty'];
			$listing[$x]['products_quantity'] = $discount_categories[$i]['products_quantity'];
			$listing[$x]['products_weight'] = $discount_categories[$i]['products_weight'];
		  }
	  } // end for ($i = 0; $i < $no_of_discount_cats; $i++) {
	}
} // end if(!empty($discount_categories)

// if customer group id is not retail we will have to do another query to get the 
// quantity blocks and minimum order quantity
 if ($customer_group_id != '0') {
$pg_qb_moq_query = tep_db_query("select pg.products_id, pg.products_qty_blocks as qtyBlocks, pg.products_min_order_qty from " . TABLE_PRODUCTS_GROUPS . " pg where products_id in (" . implode(',', $list_of_prdct_ids) . ") and pg.customers_group_id = '" . $customer_group_id . "'");

  while ($pg_qb_moq_array = tep_db_fetch_array($pg_qb_moq_query)) {
   $new_qb_moq[] = array ('products_id' => $pg_qb_moq_array['products_id'], 'qtyBlocks' => $pg_qb_moq_array['qtyBlocks'], 'products_min_order_qty' => $pg_qb_moq_array['products_min_order_qty']);
  }
  if (!empty($new_qb_moq)) {
	$no_of_pg_qb_moq = count($new_qb_moq);
  for ($x = 0; $x < $no_of_listings; $x++) {
	for  ($i = 0; $i < $no_of_pg_qb_moq; $i++) {
	  if ($listing[$x]['products_id'] == $new_qb_moq[$i]['products_id'] ) {
			$listing[$x]['qtyBlocks'] = $new_qb_moq[$i]['qtyBlocks'];
			$listing[$x]['products_min_order_qty'] = $new_qb_moq[$i]['products_min_order_qty'];
	  }
	}
  }
} // end if (!empty($new_qb_moq))
 } // end if ($customer_group_id != '0') 
// EOF QPBPP for SPPC

//	while ($listing = tep_db_fetch_array($listing_query)) { (was original code)
for ($x = 0; $x < $no_of_listings; $x++) {
  $rows++;

  if (($rows/2) == floor($rows/2)) {
	$list_box_contents[] = array('params' => 'class="productListing-even"');
  } else {
	$list_box_contents[] = array('params' => 'class="productListing-odd"');
  }

  $cur_row = sizeof($list_box_contents) - 1;

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

	switch ($column_list[$col]) {
	  case 'PRODUCT_LIST_MODEL':
		$lc_align = '';
		$lc_text = ' ' . $listing[$x]['products_model'] . ' ';
		break;
	  case 'PRODUCT_LIST_NAME':
		$lc_align = '';
		if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		  $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a>';
		} else {
		  $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a> ';
		}
		break;
	  case 'PRODUCT_LIST_MANUFACTURER':
		$lc_align = '';
		$lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing[$x]['manufacturers_id']) . '">' . $listing[$x]['manufacturers_name'] . '</a> ';
		break;
	  case 'PRODUCT_LIST_PRICE':
		$lc_align = 'right';
// BOF QPBPP for SPPC
		$price_breaks_from_listing = array();
		if (isset($price_breaks_array[$listing[$x]['products_id']])) {
		  $price_breaks_from_listing = $price_breaks_array[$listing[$x]['products_id']];
		}
		$pf->loadProduct($listing[$x]['products_id'], $languages_id, $listing[$x], $price_breaks_from_listing);
		$lc_text = $pf->getPriceStringShort();
// EOF QPBPP for SPPC
		break;
	  case 'PRODUCT_LIST_QUANTITY':
		$lc_align = 'right';
		$lc_text = ' ' . $listing[$x]['products_quantity'] . ' ';
		break;
	  case 'PRODUCT_LIST_WEIGHT':
		$lc_align = 'right';
		$lc_text = ' ' . $listing[$x]['products_weight'] . ' ';
		break;
	  case 'PRODUCT_LIST_IMAGE':
		$lc_align = 'center';
		if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		  $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing[$x]['products_image'], $listing[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
		} else {
		  $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing[$x]['products_image'], $listing[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> ';
		}
		break;
	  case 'PRODUCT_LIST_BUY_NOW':
		$lc_align = 'center';
		$lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing[$x]['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> '; // EOF Separate Pricing per Customer
		break;
	}

	$list_box_contents[$cur_row][] = array('align' => $lc_align,
										   'params' => 'class="productListing-data"',
										   'text'  => $lc_text);
  }
}

new productListingBox($list_box_contents);
 } else {
$list_box_contents = array();

$list_box_contents[0] = array('params' => 'class="productListing-odd"');
$list_box_contents[0][] = array('params' => 'class="productListing-data"',
							   'text' => TEXT_NO_PRODUCTS);

new productListingBox($list_box_contents);
 }

 if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
 </tr>
</table>
<?php
 }
?>

[sflraver]

Ok, I uncommented the debug feature in product_listing.php. This was the output for one product in the catagory. The account I am logged into, when browsing this product, should show $19.25, and it does when I click for the full product details. The thing that might be something is that the discount_categories_id does not have a variable. Could that be causing this and if so what could cause it not to have an id?

 

 

Array

(

[0] => Array

(

[products_image] => test.jpg

[products_name] => test

[products_id] => 30

[manufacturers_id] => 0

[products_price] => 26.9500

[products_tax_class_id] => 0

[specials_new_products_price] =>

[final_price] => 26.9500

[discount_categories_id] =>

)

[mrgreg]

Hello SPPCers,

 

My eyes will no longer let me search the hundreds of pages for a design mod I would like. I did try though.

 

Perhaps someone has done something similiar...

 

Upon clicking into a catagory I would like to see all the 'click through' sub-catagory icons as normal, but below them all the products from the sub-catagories listed as in the 'product list view'.

 

Prior to enabling SPPC I had enabled this through another mod. However, upon close inspection I do not think I am to the challenge of making the required changes to bring it back.

 

Has anyone tackled a similiar display mod?

I would be more inclined to tackle it myself if time were not an issue.

 

TIA,

Greg

[sflraver]

Well... as a shot in the dark I installed something I wanted anyway which is Column Product Listing (for Separate Pricing Per Costomer v4.0). Everything shows up as it should now for the customer groups.

I still wish I knew what was wrong with the standard product_listing.php but it works now.

[Jan Zonjee]

I still wish I knew what was wrong with the standard product_listing.php but it works now.

I copied and pasted the code you posted in a file and compared, tried it and you are right: it is absolutely the same as the one in the package and in my test installation it works fine. I have no explanation why it acts so strange in your system.

 

The debug prints the information that is received from the query on index.php so it is normal to only see retail prices there.

[sflraver]

Before I changed over to the column listing cont. I added a few price break discounts and the correct "from $**.**" price showed up for each of the customer groups (only with products with a quantity price break added). I think it had something to do with the SPPC_Price_Break_v20 contribution outside of the product_listing.php file.

Never the less, I have it working with the column listing mod. If I do find out later what was causing the problem I will post back here.

 

Searching back in this and other posts you are always there helping people out. I just want to say Thank You for everything. :)

[uncommonhound]

Perhaps I am misunderstanding something... I've read thoroughly through the posts. I have my store set up to offer a 10% discount to people who have adopted their pets and a 20% discount to rescue organizations/shelters. I changed my create_account.php page to include a drop down menu for customers to choose from ("Retail Customer", "Adopter" or "Shelter") and it automatically gives them the discount on the first order. I use the fields Company and tax ID to ask for rescue/shelter name and phone number, and am alerted whenever one of the discount accounts is created... but the discount still shows up even if they leave the fields blank. I don't think that's an error.. it seems to be just the way it is.

 

I would like to require customers to have to put in either a shelter name or a shelter phone number before they get the discount. Is there a way to require one of these fields, but only IF they select "Adopter" or "Shelter"? I've searched the threads and although this is referred to.. I don't see any code that accomplishes it.

 

If I make them wait for approval I will definitely lose customers.. I want the discount to show right away but I want some protection by requiring more info, and then I can verify it before processing the order for shipment.

 

One idea was to redirect them to a separate form but that seems to be way more complicated...

 

Thanks for all the help and this fantastic contribution.

 

Leslie

[Jan Zonjee]

I would like to require customers to have to put in either a shelter name or a shelter phone number before they get the discount. Is there a way to require one of these fields, but only IF they select "Adopter" or "Shelter"? I've searched the threads and although this is referred to.. I don't see any code that accomplishes it.

That is custom coding of course. You would need to look at the POST values of the drop-down. Then if it is other than the default look for the POST shelter name or shelter phone number. If either one of those is not empty proceed with the code that sets the customer group id on creating an account.

[uncommonhound]

That is custom coding of course. You would need to look at the POST values of the drop-down. Then if it is other than the default look for the POST shelter name or shelter phone number. If either one of those is not empty proceed with the code that sets the customer group id on creating an account.

 

Thanks for making it a clearer. Between the original SPPC code, and the modified code for drop-down menus that I have now.. it seems all the elements I need are there. I just have to figure out how to patch them together. I'll give it a try and post if I'm successful (and maybe if I'm not). I'm new to php but have some co-workers that can help. I just wanted to make sure someone hadn't already written code to do this (I was hoping!)

[Jan Zonjee]

I just wanted to make sure someone hadn't already written code to do this (I was hoping!)

No, but it is not rocket science either. Couple of lines of code should suffice.

[corywiley]

I have tried adding the "show price list" addon for SPPC but it was originally designed for a lower version. Everytime I change the code into the "product_info" page, now products in the store will display their info. It is just a blank page. Has anyone gotten this addon to work with sppc version 2.2?

[Jan Zonjee]

It is just a blank page.

Which most likely points to an error that you are not being shown on a live site (could be a very minor one).

Is there no error log? Otherwise it is a guessing game...

[redrum]

A strange thing has happened regarding the shipping options;

 

A customer contacted me and asked why there was two shipping options in the checkout.

I have installed an additional shipping option that only should be used for wholesale. The other shall only be used by retail.

The customer that contacted me is set to retail customer in admin, and should only see one shipping option.

 

I also did a search in my database to check if any customer has completed a order and selected the wholesale shipping option, but I got zero in results there.

 

I cant recreate the problem myself. I have logged in on a test account and on other customers account, including the customer that contacted me.

 

The settings for shipping options is set in customer groups (admin/customers_groups.php) to apply different settings for retail and wholesale. I got two wholesale groups, the only thing that differs them are the discount. The shipping settings are the same.

 

Does anyone have any idea of what may cause this and how to avoid it?

 

Cheers,

Fredrik

[Vinotheca]

Hi

 

Installed version 4.2.2, works fine & helps me maintain prices for 5 types of customers. Many thanks to all contributors who made all those versions & improved on it.

 

Only issue I have (twice in fact, but same issue in each): both in the SPECIALS module & in the GET 1 FREE module the product dropdown box remains empty. I can no longer select any products to add a promotion to, which is kind of awkward.

 

Anyone an idea in which file I should add which section to enable my dropdown boxes to be populated again?

[Jan Zonjee]

Only issue I have (twice in fact, but same issue in each): both in the SPECIALS module & in the GET 1 FREE module the product dropdown box remains empty. I can no longer select any products to add a promotion to, which is kind of awkward.

 

Anyone an idea in which file I should add which section to enable my dropdown boxes to be populated again?

Frankly, I haven't got a clue what you are talking about. From what you say I think it is an admin issue but I'm not even sure of that.

[Vinotheca]

Frankly, I haven't got a clue what you are talking about. From what you say I think it is an admin issue but I'm not even sure of that.

 

Jan,

 

In the Admin panel indeed, when I go to "Catalog / Specials / New product" I have a screen where I can select the product that will receive the promotion, a box to select the 'customer group' that this promotion applies to, and of course the price & date.

 

It is the 'product dropdown box' that remains empty, the list seems to display no product at all.

 

I am no whiz in DB debugging, so can't seem to figure out which query it is that now no longer works, any idea ?

 

Thanks, Philippe - Vinotheca

[Teamjr]

Hello,

 

Can someone please let me know what the command line would be if I wanted to clear the customers_shipping_allowed field under customers table. If I am correct, if I clear this field, system would default to use settings from customer group, "Set shipping modules for the customer group", correct?

 

Thanks JR

[Jan Zonjee]

Can someone please let me know what the command line would be if I wanted to clear the customers_shipping_allowed field under customers table.

update customers set customers_shipment_allowed = '';

If I am correct, if I clear this field, system would default to use settings from customer group, "Set shipping modules for the customer group", correct?

Yes.

[Teamjr]

Thank you Jan,

 

Much appreciated.

 

JR

[bradybarrows]

Followed these instruction:

Separate Pricing Per Customer 4.2.0

Revised & Re-Written by JanZ & documented by Marvin Miller and JanZ

 

I am running osCommerce Online Merchant v2.2 RC2a

 

I am doing a manual installation and got to step 11 and am at loss.

 

Here are the steps:

 

Before beginning the manual install you need to:

 

Upload five included image files to your site. They are (and located in):

 

catalog/admin/includes/languages/english/images/buttons/ic_down.gif

 

catalog/admin/includes/languages/english/images/buttons/ic_up.gif

 

catalog/admin/includes/languages/english/images/buttons/button_group_prices.gif

 

catalog/admin/images/icons/tick_black.gif

 

catalog/admin/images/icons/icon_tick.gif

 

The first two are used in admin/customers.php and the last three are used in admin/attributes.php and admin/attributes_groups.php.

 

Upload four new .php files:

catalog/admin/includes/languages/english/customers_groups.php, catalog/admin/includes/languages/english/attributes_groups.php, catalog/admin/customers_groups.php, and catalog/admin/attributes_groups.php.

 

Run the spcc_v42_install.sql database installation file on your MySQL database.

 

Modify the catalog/includes/languages/english/login.php file to include the Site Administrator's email address. This email address is used for wholesale account notifications. You can find the appropriate section of that file by doing a search for the keyword root.

------------------------------------------------------------------------------------------------------------------------------

 

I was able to do everything but the last step. I opened the catalog/includes/languages/english/login.php file and can't figure out where to put the email address. I don't understand how to "find the appropriate section of that file by doing a search for the keyword root." Can someone please give me some details about this? Mahalo.

[Brollox]

Hi

 

I've been looking for a way to use easy populate to maintain different prices for different customer groups. Over in the easy populate pages it was mentioned that EP doesn't work with the newer versions of SPPC. is this right?

[Jan Zonjee]

Can someone please give me some details about this?

Just add the following to that file (before the ?> at the bottom) and you will be fine:

// BOF Separate Pricing Per Customer
// define the email address that can change customer_group_id on login
define('SPPC_TOGGLE_LOGIN_PASSWORD', 'root@localhost');
// EOF Separate Pricing Per Customer

[bradybarrows]

Just add the following to that file (before the ?> at the bottom) and you will be fine:

// BOF Separate Pricing Per Customer
// define the email address that can change customer_group_id on login
define('SPPC_TOGGLE_LOGIN_PASSWORD', 'root@localhost');
// EOF Separate Pricing Per Customer

 

Big Mahalos to you!!!