DUAL Pricing v2

[twitchtoo]

Okay, I'm confident this wholesale by attributes is working now orders are moving in and out without any errors with all of our products. Once I post the complete 'how to' I will need someone with time and complete understanding of how this works to test the 'base price' wholesale pricing. Why? Because I don't have time and my client's site will never use it now that it's pulling all data from attributes.

To my knowledge I have not modified any of the codes that operate the 'base price' wholesale pricing. That means once you've installed this mod you'll have a complete functioning wholesale section... from the time customers login until they checkout.

I will be applying the multi site mod next and I expect this wholesale mod to operate across all of the 'multi sites' without error... If anyone wants to be on the short list of beta testers please msg me.

Thanks

Twitch.

[skipjensen]

Hi Twitch-
Thank you for this mod. It is exactly what I need for my site. I have been having a problem which I have seen posted here earlier, where my pricing shows up retail on the product pages, but wholesale in the shopping cart. I have tracked it down to the includes>modules>pages>login>header_php.php file. I installed "Encrypted Master Password" and it changed the login validation to the code below. I don't have any idea how this breaks Dual Pricing, but it does. Can you point me in the right direction ? Thanks again for what must be millions of hours of hard work.

SJ

// *** start Encrypted Master Password by stagebrace ***
$get_admin_query = "SELECT admin_id, admin_pass
FROM " . TABLE_ADMIN . "
WHERE admin_id = '2' ";
$check_administrator = $db->Execute($get_admin_query);
$customer = (zen_validate_password($password, $check_customer->fields['customers_password']));
$administrator = (zen_validate_password($password, $check_administrator->fields['admin_pass']));
if ($customer) {
$ProceedToLogin = true;
} else {
if ($administrator) {
$ProceedToLogin = true;
} else {
$ProceedToLogin = false;
}
}
if (!($ProceedToLogin)) {
// *** end Encrypted Master Password by stagebrace ***

[dparbhoo]

I need some help with the Dual Price module which I hope you can provide.
The wholesale price is only showing up on checkout.
It does not show BOTH the retail price and wholesales when one clicks the product details.
I did include corrections from post 678

I believe the error is in tpl_product_info_display.
Any suggestions are welcome.
CODE is below:

<?php

/**

* Page Template

*

* Loaded automatically by index.php?main_page=product_info.<br />

* Displays details of a typical product

*

* @package templateSystem

* @copyright Copyright 2003-2006 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_product_info_display.php 5369 2006-12-23 10:55:52Z drbyte $

*/

//require(DIR_WS_MODULES . '/debug_blocks/product_info_prices.php');

?>

<div class="centerColumn" id="productGeneral">



<!--bof Form start-->

<?php echo zen_draw_form('cart_quantity', zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params(array('action')) . 'action=add_product'), 'post', 'enctype="multipart/form-data"') . "\n"; ?>

<!--eof Form start-->



<?php if ($messageStack->size('product_info') > 0) echo $messageStack->output('product_info'); ?>



<!--bof Category Icon -->

<?php if ($module_show_categories != 0) {?>

<?php

/**

* display the category icons

*/

require($template->get_template_dir('/tpl_modules_category_icon_display.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_category_icon_display.php'); ?>

<?php } ?>

<!--eof Category Icon -->



<!--bof Prev/Next top position -->

<?php if (PRODUCT_INFO_PREVIOUS_NEXT == 1 or PRODUCT_INFO_PREVIOUS_NEXT == 3) { ?>

<?php

/**

* display the product previous/next helper

*/

require($template->get_template_dir('/tpl_products_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_next_previous.php'); ?>

<?php } ?>

<!--eof Prev/Next top position-->



<!--bof Main Product Image -->

<?php

if (zen_not_null($products_image)) {

?>
<div class="divpinfoimage">
<?php

/**

* display the main product image

*/

require($template->get_template_dir('/tpl_modules_main_product_image.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_main_product_image.php'); ?>
</div>
<?php

}

?>

<!--eof Main Product Image-->

<div class="divpinfodetails">

<!--bof Product Name-->

<h1 id="productName" class="productGeneral"><?php echo $products_name; ?></h1>

<!--eof Product Name-->



<!--bof Product Price block -->

<h2 id="productPrices" class="productGeneral">

<?php

// base price
//***********************************************************************
//***DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
echo '<span id="retailwhole">' . ' Retail Price: '.$one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == '1') ? TEXT_BASE_PRICE : '') . zen_get_products_display_retail_net_price((int)$_GET['products_id']).'</span><br /> ';
}
//***********************************************************************
//***END DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************

if ($show_onetime_charges_description == 'true') {

$one_time = '<span > Your Price: ' . TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION . '</span><br />';

} else {

$one_time = '';

}

//* echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);
//******************************************************************************** *
//***Properly display price labeling when set to Whole sale and when not
//******************************************************************************** *
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
echo '<span id="whole">WholeSale: ';
} else {
echo '<span id="retail">**Price: ';
}


echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);

echo '</span>';
//******************************************************************************** *
//***END Properly display price labeling when set to Whole sale and when not
//******************************************************************************** *
?></h2>

<!--eof Product Price block -->



<!--bof free ship icon -->

<?php if(zen_get_product_is_always_free_shipping($products_id_current) && $flag_show_product_info_free_shipping) { ?>

<div id="freeShippingIcon"><?php echo TEXT_PRODUCT_FREE_SHIPPING_ICON; ?></div>

<?php } ?>

<!--eof free ship icon -->



<!--bof Product description -->

<?php if ($products_description != '') { ?>

<div id="productDescription" class="productGeneral biggerText"><?php echo stripslashes($products_description); ?></div>

<?php } ?>

<!--eof Product description -->
<br class="clearBoth" />

<!--bof Add to Cart Box -->

<?php

if (CUSTOMERS_APPROVAL == 3 and TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE_SHOWROOM == '') {

// do nothing

} else {

?>

<?php

$display_qty = (($flag_show_product_info_in_cart_qty == 1 and $_SESSION['cart']->in_cart($_GET['products_id'])) ? '<p>' . PRODUCTS_ORDER_QTY_TEXT_IN_CART . $_SESSION['cart']->get_quantity($_GET['products_id']) . '</p>' : '');

if ($products_qty_box_status == 0 or $products_quantity_order_max== 1) {

// hide the quantity box and default to 1

$the_button = '<input type="hidden" name="cart_quantity" value="1" />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);

} else {

// show the quantity box

$the_button = '<div class="divorderqtext">'.PRODUCTS_ORDER_QTY_TEXT . '</div><div class="divcartquantity"><input type="text" name="cart_quantity" value="' . (zen_get_buy_now_qty($_GET['products_id'])) . '" maxlength="6" size="4" /></div>' . zen_get_products_quantity_min_units_display((int)$_GET['products_id']) . '' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) .'<div class="divbuttonaddtocart">'. zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT).'</div>';

}

$display_button = zen_get_buy_now_button($_GET['products_id'], $the_button);

?>

<?php if ($display_qty != '' or $display_button != '') { ?>
<table align="center" class="tbladdtocart"><tr><td>
<div class="divcartadd">
<div id="cartAdd">

<?php

echo $display_qty;

echo $display_button;

?>

</div>
</div>
</td></tr></table>
<?php } // display qty and button ?>
<?php } // CUSTOMERS_APPROVAL == 3 ?>

<!--eof Add to Cart Box-->

<!--bof Tell a Friend button -->

<?php

if ($flag_show_product_info_tell_a_friend == 1) { ?>
<table align="center" class="tbladdtocart"><tr><td>
<div id="productTellFriendLink" class="buttonRow forward"><?php echo ($flag_show_product_info_tell_a_friend == 1 ? '<a href="' . zen_href_link(FILENAME_TELL_A_FRIEND, 'products_id=' . $_GET['products_id']) . '">'. BUTTON_TELLAFRIEND_ALT . '</a>' : ''); ?></div>
<div id="productaddtowishlistLink">

<?php
// (un): start wishlist link
echo '<a href="' . zen_href_link(UN_FILENAME_WISHLIST, zen_get_all_get_params(array('action', 'products_id')) . 'products_id='.(int)$_GET['products_id'].'&action=un_add_wishlist') . '">' . UN_TEXT_ADD_WISHLIST . '</a>';
// (un): end wishlist link
?>
</div>

</td></tr></table>
<?php

}

?>

<!--eof Tell a Friend button -->

<br class="clearBoth" />
<DIV ALIGN=CENTER>
<a name="fb_share" type="button_count" href="http://www.facebook.com/sharer.php">Share</a><script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script>
</DIV>
<!--bof Product details list -->

<?php if ( (($flag_show_product_info_model == 1 and $products_model != '') or ($flag_show_product_info_weight == 1 and $products_weight !=0) or ($flag_show_product_info_quantity == 1) or ($flag_show_product_info_manufacturer == 1 and !empty($manufacturers_name))) ) { ?>

<ul id="productDetailsList" class="floatingBox back">

<?php echo (($flag_show_product_info_model == 1 and $products_model !='') ? '<li>' . TEXT_PRODUCT_MODEL . $products_model . '</li>' : '') . "\n"; ?>

<?php echo (($flag_show_product_info_weight == 1 and $products_weight !=0) ? '<li>' . TEXT_PRODUCT_WEIGHT . $products_weight . TEXT_PRODUCT_WEIGHT_UNIT . '</li>' : '') . "\n"; ?>

<?php echo (($flag_show_product_info_quantity == 1) ? '<li>' . $products_quantity . TEXT_PRODUCT_QUANTITY . '</li>' : '') . "\n"; ?>

<?php echo (($flag_show_product_info_manufacturer == 1 and !empty($manufacturers_name)) ? '<li>' . TEXT_PRODUCT_MANUFACTURER . $manufacturers_name . '</li>' : '') . "\n"; ?>

</ul>

<br class="clearBoth" />

<?php

}

?>

<!--eof Product details list -->

</div>


<!--bof Attributes Module -->

<?php

if ($pr_attr->fields['total'] > 0) {

?>

<?php

/**

* display the product atributes

*/

require($template->get_template_dir('/tpl_modules_attributes.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_attributes.php'); ?>

<?php

}

?>

<!--eof Attributes Module -->



<!--bof Quantity Discounts table -->

<?php

if ($products_discount_type != 0) { ?>

<?php

/**

* display the products quantity discount

*/

require($template->get_template_dir('/tpl_modules_products_quantity_discounts.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_products_quantity_discounts.php'); ?>

<?php

}

?>

<!--eof Quantity Discounts table -->



<!--bof Additional Product Images -->

<?php

/**

* display the products additional images

*/

require($template->get_template_dir('/tpl_modules_additional_images.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_additional_images.php'); ?>

<!--eof Additional Product Images -->



<!--bof Prev/Next bottom position -->

<?php if (PRODUCT_INFO_PREVIOUS_NEXT == 2 or PRODUCT_INFO_PREVIOUS_NEXT == 3) { ?>

<?php

/**

* display the product previous/next helper

*/

require($template->get_template_dir('/tpl_products_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_next_previous.php'); ?>

<?php } ?>



<!--eof Prev/Next bottom position -->

<!--bof Reviews button and count-->

<?php







if ($flag_show_product_info_reviews == 1) {

// if more than 0 reviews, then show reviews button; otherwise, show the "write review" button

if ($reviews->fields['count'] > 0 ) { ?>

<div id="productReviewLink" class="buttonRow back"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params()) . '">' . zen_image_button(BUTTON_IMAGE_REVIEWS, BUTTON_REVIEWS_ALT) . '</a>'; ?></div>

<br class="clearBoth" />

<p class="reviewCount"><?php echo ($flag_show_product_info_reviews_count == 1 ? TEXT_CURRENT_REVIEWS . ' ' . $reviews->fields['count'] : ''); ?></p>

<?php } else { ?>

<div id="productReviewLink" class="buttonRow back"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, zen_get_all_get_params(array())) . '">' . zen_image_button(BUTTON_IMAGE_WRITE_REVIEW, BUTTON_WRITE_REVIEW_ALT) . '</a>'; ?></div>

<br class="clearBoth" />

<?php

}

}

?>

<!--eof Reviews button and count -->





<!--bof Product date added/available-->

<?php

if ($products_date_available > date('Y-m-d H:i:s')) {

if ($flag_show_product_info_date_available == 1) {

?>

<p id="productDateAvailable" class="productGeneral centeredContent"><?php echo sprintf(TEXT_DATE_AVAILABLE, zen_date_long($products_date_available)); ?></p>

<?php

}

} else {

if ($flag_show_product_info_date_added == 1) {

?>

<p id="productDateAdded" class="productGeneral centeredContent"><?php echo sprintf(TEXT_DATE_ADDED, zen_date_long($products_date_added)); ?></p>

<?php

} // $flag_show_product_info_date_added

}

?>

<!--eof Product date added/available -->



<!--bof Product URL -->

<?php

if (zen_not_null($products_url)) {

if ($flag_show_product_info_url == 1) {

?>

<p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($products_url), 'NONSSL', true, false)); ?></p>

<?php

} // $flag_show_product_info_url

}

?>

<!--eof Product URL -->



<!--bof also purchased products module-->

<?php require($template->get_template_dir('tpl_modules_also_purchased_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_also_purchased_products.php');?>

<!--eof also purchased products module-->



<!--bof Featured Products -->

<?php

/**

* display the featured products

*/

require($template->get_template_dir('/tpl_modules_featured_products.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_featured_products.php'); ?>



<!--eof Featured Products -->



<!--bof Form close-->

</form>

<!--bof Form close-->

</div>

[twitchtoo]

[quote=dparbhoo;1017982]I need some help with the Dual Price module which I hope you can provide.
The wholesale price is only showing up on checkout.
It does not show BOTH the retail price and wholesales when one clicks the product details.
I did include corrections from post 678

I believe the error is in tpl_product_info_display.
Any suggestions are welcome.
CODE is below:

<?php

// base price
//***********************************************************************
//***DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
echo '<span id="retailwhole">' . ' Retail Price: '.$one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == '1') ? TEXT_BASE_PRICE : '') . zen_get_products_display_retail_net_price((int)$_GET['products_id']).'</span><br /> ';
}
//***********************************************************************
//***END DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************

if ($show_onetime_charges_description == 'true') {

$one_time = '<span > Your Price: ' . TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION . '</span><br />';

} else {

$one_time = '';

}

//* echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);
//******************************************************************************** *
//***Properly display price labeling when set to Whole sale and when not
//******************************************************************************** *
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
echo '<span id="whole">WholeSale: ';
} else {
echo '<span id="retail">**Price: ';
}


echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);

echo '</span>';
//******************************************************************************** *
//***END Properly display price labeling when set to Whole sale and when not
//******************************************************************************** *
?></h2>

<!--eof Product Price block -->


This is again evidence that the instructions I have posted in the past were not followed... or... the software you are using did not make the changes correctly. I'm guessing if the customers_wholesale variable was missed in this file, it was missed in other files...

it should look like this:
<!--bof Product Price block -->
<h2 id="productPrices" class="productGeneral">
<?php
// base price
//***********************************************************************
//***DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************
if ($_SESSION['customers_wholesale'] && $_SESSION['customers_wholesale'] != '0' ) {
echo '<span id="retailwhole">' . ' Retail Price '.$one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == '1') ? TEXT_BASE_PRICE : '') . zen_get_products_display_retail_net_price((int)$_GET['products_id']).'</span><br /> ';
}
//***********************************************************************
//***END DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************

if ($show_onetime_charges_description == 'true') {
$one_time = ' <span> Your Price: ' . TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION . '</span><br />';
} else {
$one_time = '';
}
//******************************************************************************** *
//***Properly display price labeling when set to Whole sale and when not
//******************************************************************************** *
if ($_SESSION['customers_wholesale'] && $_SESSION['customers_wholesale'] != '0' ) {
echo '<span id="whole">Wholesale Price ';
} else {
echo '<span id="retail">Retail Price ';
}
echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);
echo '</span>';
//******************************************************************************** *
//***END Properly display price labeling when set to Whole sale and when not
//******************************************************************************** *
?></h2>
<!--eof Product Price block -->

Review the instructions and ensure your software is replacing all of the customers_wholesale variables in all of the files I have listed in the past.

I'm so close to finally posting the complete wholesale by attributes module + instructions, there's one final bug I am correcting tonight...

Twitch.

[twitchtoo]

Hi Twitch-
Thank you for this mod. It is exactly what I need for my site. I have been having a problem which I have seen posted here earlier, where my pricing shows up retail on the product pages, but wholesale in the shopping cart. I have tracked it down to the includes>modules>pages>login>header_php.php file. I installed "Encrypted Master Password" and it changed the login validation to the code below. I don't have any idea how this breaks Dual Pricing, but it does. Can you point me in the right direction ? Thanks again for what must be millions of hours of hard work.

SJ

// *** start Encrypted Master Password by stagebrace ***
$get_admin_query = "SELECT admin_id, admin_pass
FROM " . TABLE_ADMIN . "
WHERE admin_id = '2' ";
$check_administrator = $db->Execute($get_admin_query);
$customer = (zen_validate_password($password, $check_customer->fields['customers_password']));
$administrator = (zen_validate_password($password, $check_administrator->fields['admin_pass']));
if ($customer) {
$ProceedToLogin = true;
} else {
if ($administrator) {
$ProceedToLogin = true;
} else {
$ProceedToLogin = false;
}
}
if (!($ProceedToLogin)) {
// *** end Encrypted Master Password by stagebrace ***

I need to know more about how it 'breaks' the module? The header code above doesn't look to me to be in conflict directly with any of the code I've been working with in the wholesale module.

What are the errors, behaviour and other files that were modified when you installed the master password module?

Twitch.

[twitchtoo]

First...Thank you all for this great contributions and all the trouble shooting, upgrades etc. I have Dual Pricing installed on 1.3.9.h and it works like a dream The only issue is with products that are on special. If a wholesale customer logs in and selects a product that is on special, he/she gets the special price not their wholesale price. Does anyone have anything on this or is the Special module not meant to be used with DP? All help will be greatly appreciated.
Niko

There is a code you can apply to shut off this feature for wholesale... I've got it working on my live site, unfortunately you'll have to wait for my next release...

Twitch.

[twitchtoo]

I went ahead and uninstalled the minimum order because upon talking to my boss, I realized we will not be using a minimum price for wholesale orders.

What we actually need is something to ensure they meet a minimum product order.

And the thing is, we sell a variety of things. Body art as well as eye art. Wholesale customers must meet a minimum of 50 eyes of any variety for them to meet their wholesale criteria for their order to go through.

Is there anyway I can ensure this? The biggest problem I'm having with this idea is that customers can choose from a selection of eyes to get to the 50 required. A minimum in body art or accessories is not required. Just the set of 50 eyes.

Please let me know if this is possible.

I have the following add ons installed (i'm not sure if this would affect things):
dual pricing w/bug fix (as featured on this thread)
image handler 2
slimbox
ultimate cross sale

I am using the version 1.3.9h of zencart and am currently running tests on a localhost.

Possible yes, I don't have time to work on this right now, however what you want to do is make a global variable. One that holds the quantity of 'eyes' and passes that info on to the checkout page for wholesale.

I would add a column in the database to hold the min. value then test the global variable against that value in the cart.

Twitch.

[gearheadniko]

There is a code you can apply to shut off this feature for wholesale... I've got it working on my live site, unfortunately you'll have to wait for my next release...

Twitch.

Thanks Twitch, what is your site, I would love to see it.
Niko

[twitchtoo]

Thanks Twitch, what is your site, I would love to see it.
Niko

I am assembling the final patch now, should be posted by the end of the day. I have signed a confidentiality agreement, the site must stay private, once my personal testing site is live I'll publish it for all to see :)

Twitch.

[sportbiker]

It seems like this problem is being worked on, but I'm not sure if there's been a fix, yet.

In short, when using Salemaker to put a sale on a category, the wholesale price is also being discounted. Is there a way to make any sale price only apply to retail ? ? ? ?

By the way - this is TRULY one of the best mods ever created. The real-world application for this is so helpful! I'm already loving it on my site! I can't believe how cool this is; especially since it offers more than just one price level. My clients are loving this!