Name: Wholesale Patch
Function: Display wholesale prices to only wholesale users.
Configuration time: 5 min
Difficulty: Medium
IMPORTANT NOTICE - INSTALLATION OF THIS PATCH MAY CAUSE UNKNOWN OR UNEXPECTED ERRORS. I AM NOT RESPONSIBLE FOR ANY PROBLEMS THIS SCRIPT MAY CAUSE ON YOUR FILES. YOU ARE INSTALLING THIS AT YOUR OWN WILL AND I MAY NOT BE HELD RESPONSIBLE FOR ANYTHING.
Earlier we had discussed making a patch that would allow you to select cutomers to get special access to prices. This patch will allow you to do that.
INSTALLATION:
IT IS STRONGLY RECOMMENDED THAT YOU HAVE BASIC PHP KNOWLEDGE AND/OR KNOWLEDGE AND ABILITY TO VIEW MYSQL DATA (EX. PHPMYADMIN)
Ftp your way here: yourstorefolder/includes/templates/template_default/templates/templates/
Find the file named: templates tpl_modules_products_quantity_discounts.php
Keep that FTP window open, but continue on. Open up notepad or your favorite editor. Paste the following code into Notepad.
***************************************************************************
Code:
<?php
/**
* Module Template
*
* @package templateSystem
* @copyright Copyright 2003-2005 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tpl_modules_products_quantity_discounts.php 3291 2006-03-28 04:03:38Z ajeh $
**
* Wholesale code by Matt
**
*
*/
?>
<?
$ididid = $_SESSION['customer_id'];
$username="";
$password="";
$database="";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query("SELECT * FROM zen_customers
WHERE customers_id='2'") or die(mysql_error());
mysql_close();
$row = mysql_fetch_array( $result );
// echo $row['customers_group_pricing'];
?>
<div id="productQuantityDiscounts">
<?php
if ($zc_hidden_discounts_on) {
?>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<td colspan="1" align="center">
<?php echo TEXT_HEADER_DISCOUNTS_OFF; ?>
</td>
</tr>
<tr>
<td colspan="1" align="center">
<?php echo $zc_hidden_discounts_text; ?>
</td>
</tr>
</table>
<?php } else {
if ($row['customers_group_pricing'] == '1') {
?>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<td colspan="<?php echo $columnCount+1; ?>" align="center">
<?php
switch ($products_discount_type) {
case '1':
echo TEXT_HEADER_DISCOUNT_PRICES_PERCENTAGE;
break;
case '2':
echo TEXT_HEADER_DISCOUNT_PRICES_ACTUAL_PRICE;
break;
case '3':
echo TEXT_HEADER_DISCOUNT_PRICES_AMOUNT_OFF;
break;
}
?>
</td>
</tr>
<tr>
<td align="center"><?php echo $show_qty . '<br />' . $currencies->display_price($show_price, zen_get_tax_rate($products_tax_class_id)); ?></td>
<?php
foreach($quantityDiscounts as $key=>$quantityDiscount) {
?>
<td align="center"><?php echo $quantityDiscount['show_qty'] . '<br />' . $currencies->display_price($quantityDiscount['discounted_price'], zen_get_tax_rate($products_tax_class_id)); ?></td>
<?php
$disc_cnt++;
if ($discount_col_cnt == $disc_cnt && !($key == sizeof($quantityDiscount))) {
$disc_cnt=0;
?>
</tr><tr>
<?php
}
}
?>
<?php
if ($disc_cnt < $columnCount) {
?>
<td align="center" colspan="<?php echo ($columnCount+1 - $disc_cnt)+1; ?>"> </td>
<?php } ?>
</tr>
<?php
if (zen_has_product_attributes($products_id_current)) {
?>
<tr>
<td colspan="<?php echo $columnCount+1; ?>" align="center">
<?php echo TEXT_FOOTER_DISCOUNT_QUANTITIES; ?>
</td>
</tr>
<?php } ?>
</table>
<?php }} // hide discounts ?>
</div>
***************************************************************************
Now we start the configuration:
At the top of the file, edit these lines:
$username=""; //username that controls your mysql account
$password=""; //password to that username
$database=""; //database that zen runs in
All of that information can be found in configure.php
SET ALL THAT ASIDE BUT DO NOT EXIT PAGES/FILES
Open your admin section of Zen and create a new group, name it whatever you want. DO NOT SET A DISCOUNT PRICE!!!!!!!!!!
Keep in mind the ID of the group:
EX...
ID Group Name % Discount
1 Wholesale 0.00
My ID is '1'. REMEMBER YOURS!!!
Open the text editor with the file. Find the line:
if ($row['customers_group_pricing'] == '1') {
change the '1' to your number '#'. If your number was 7, then your line would look like this:
if ($row['customers_group_pricing'] == '7') {
Whew, if you made it this far, then you are finished. Save that file as:
tpl_modules_products_quantity_discounts.php
And upload it to the ftp folder you opened earlier. When it asks if you would like to overwrite the file, select yes!
Goodluck, post any questions you may have. I know my instructions were very difficult to follow. Maybe someone can make a user-friendly version of this.
Bookmarks