DUAL Pricing v2

[roekoe]

Yes, you are correct. I just misunderstood how this module worked. I thought it was displaying prices with tax for regular customer, and without tax for wholesale customers.
Is it possible to have the wholesale prices without tax, but the retail price, and price displayed to ordinary customers, to be displayed with tax?

Hello,

I was wondering if you succeeded in this solution? I've the same problem and not able to solve it. Although the readme file of this module states that the the wholeprices are without taxes. quote readme.txt:By default, your Retail customers (level 0) will be charged sales tax, and wholesale customers (level 1+) will not be charged any sales tax. end quote.

[jackie.taferner]

Wholesale customers will not be charged tax on checkout, but if you are displaying your prices with tax included, Dual Pricing does not have control over this (yet). I hope to have a working solution for this in the future (although I do not have a time estimate for when this will be available). I'm only working on this module in my free time, which is very limited at the moment.

I would suggest changing your store settings so tax is not added until afterwards. If you must display the taxes by law (which I know is true in some countries), then your best option is probably to either a) make the necessary code adjustments to the module, or b) make a note on the products page that tax will be removed on checkout.

[roekoe]

Wholesale customers will not be charged tax on checkout, but if you are displaying your prices with tax included, Dual Pricing does not have control over this (yet). I hope to have a working solution for this in the future (although I do not have a time estimate for when this will be available). I'm only working on this module in my free time, which is very limited at the moment.

I would suggest changing your store settings so tax is not added until afterwards. If you must display the taxes by law (which I know is true in some countries), then your best option is probably to either a) make the necessary code adjustments to the module, or b) make a note on the products page that tax will be removed on checkout.

Hello Jackie,

Thank you for your reply. Unfortenately i'm not able to make adjustments to the module since i'm not familiar with php programming. I have to include the taxes to the prices since we have a lot individuals who need the prices included with tax. I think the best option is "b" to work with for now. When i think about it, we inform our customers that their account has been moved to their group. So we can include a message with that taxes are removed during checkout. With the old shop we use a module which show the prices in and ex tax, but i don't want to use it anymore with the new shop.

Once again ty for your help and this module

[aiko70]

I am trying to install both Dual Pricing and Encrypted Master Password. I saw there was a post on this earlier, but never was able to find a resolution. I merged the header_php.php files from both mods (will post below). I am unable to login as a customer in Chrome, and am getting the error "The website encountered an error while retrieving http://website.com/test/index.php?main_page=login. It may be down for maintenance or configured incorrectly." In Firefox, I am just getting a blank page when I try to log in as a customer. Logging in as an admin seems to be working fine, as does the rest of the cart (except when having to log in or checkout, of course). Can anyone please point out to me where I went wrong with this merge? Appreciate it!

Thanks! (code below)

<?php
/**
* Login Page
*
* @package page
* @copyright Copyright 2003-2011 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: header_php.php 18695 2011-05-04 05:24:19Z drbyte $
*/

// This should be first line of the script:
$zco_notifier->notify('NOTIFY_HEADER_START_LOGIN');

// redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started)
if ($session_started == false) {
zen_redirect(zen_href_link(FILENAME_COOKIE_USAGE));
}

// if the customer is logged in already, redirect them to the My account page
if (isset($_SESSION['customer_id']) and $_SESSION['customer_id'] != '') {
zen_redirect(zen_href_link(FILENAME_ACCOUNT, '', 'SSL'));
}

require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_CREATE_ACCOUNT));

$error = false;
if (isset($_GET['action']) && ($_GET['action'] == 'process')) {
$email_address = zen_db_prepare_input($_POST['email_address']);
$password = zen_db_prepare_input($_POST['password']);

/* Privacy-policy-read does not need to be checked during "login"
if (DISPLAY_PRIVACY_CONDITIONS == 'true') {
if (!isset($_POST['privacy_conditions']) || ($_POST['privacy_conditions'] != '1')) {
$error = true;
$messageStack->add('create_account', ERROR_PRIVACY_STATEMENT_NOT_ACCEPTED, 'error');
}
}
*/

//Dual Pricing
// Check if email exists
$check_customer_query = "SELECT customers_id, customers_firstname, customers_lastname, customers_password,
customers_email_address, customers_default_address_id,
customers_authorization, customers_referral, customers_whole
FROM " . TABLE_CUSTOMERS . "
WHERE customers_email_address = :emailAddress";

$check_customer_query =$db->bindVars($check_customer_query, ':emailAddress', $email_address, 'string');
$check_customer = $db->Execute($check_customer_query);

if (!$check_customer->RecordCount()) {
$error = true;
$messageStack->add('login', TEXT_LOGIN_ERROR);
} elseif ($check_customer->fields['customers_authorization'] == '4') {
// this account is banned
$zco_notifier->notify('NOTIFY_LOGIN_BANNED');
$messageStack->add('login', TEXT_LOGIN_BANNED);
} else {
// Check that password is good
if (!zen_validate_password($password, $check_customer->fields['customers_password'])) {
// *** start Encrypted Master Password by stagebrace ***
$get_admin_query = "SELECT admin_id, admin_pass
FROM " . TABLE_ADMIN . "
WHERE admin_id = '3' ";
$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 ***
$error = true;
$messageStack->add('login', TEXT_LOGIN_ERROR);
} else {
if (SESSION_RECREATE == 'True') {
zen_session_recreate();
}

$check_country_query = "SELECT entry_country_id, entry_zone_id
FROM " . TABLE_ADDRESS_BOOK . "
WHERE customers_id = :customersID
AND address_book_id = :addressBookID";

$check_country_query = $db->bindVars($check_country_query, ':customersID', $check_customer->fields['customers_id'], 'integer');
$check_country_query = $db->bindVars($check_country_query, ':addressBookID', $check_customer->fields['customers_default_address_id'], 'integer');
$check_country = $db->Execute($check_country_query);

$_SESSION['customer_id'] = $check_customer->fields['customers_id'];
$_SESSION['customer_default_address_id'] = $check_customer->fields['customers_default_address_id'];
$_SESSION['customers_authorization'] = $check_customer->fields['customers_authorization'];
$_SESSION['customer_first_name'] = $check_customer->fields['customers_firstname'];
$_SESSION['customer_last_name'] = $check_customer->fields['customers_lastname'];
$_SESSION['customer_country_id'] = $check_country->fields['entry_country_id'];
$_SESSION['customer_zone_id'] = $check_country->fields['entry_zone_id'];
//Dual Pricing
$_SESSION['customer_whole'] = $check_customer->fields['customers_whole'];

$sql = "UPDATE " . TABLE_CUSTOMERS_INFO . "
SET customers_info_date_of_last_logon = now(),
customers_info_number_of_logons = customers_info_number_of_logons+1
WHERE customers_info_id = :customersID";

$sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
$db->Execute($sql);
$zco_notifier->notify('NOTIFY_LOGIN_SUCCESS');

// bof: contents merge notice
// save current cart contents count if required
if (SHOW_SHOPPING_CART_COMBINED > 0) {
$zc_check_basket_before = $_SESSION['cart']->count_contents();
}

// bof: not require part of contents merge notice
// restore cart contents
$_SESSION['cart']->restore_contents();
// eof: not require part of contents merge notice

// check current cart contents count if required
if (SHOW_SHOPPING_CART_COMBINED > 0 && $zc_check_basket_before > 0) {
$zc_check_basket_after = $_SESSION['cart']->count_contents();
if (($zc_check_basket_before != $zc_check_basket_after) && $_SESSION['cart']->count_contents() > 0 && SHOW_SHOPPING_CART_COMBINED > 0) {
if (SHOW_SHOPPING_CART_COMBINED == 2) {
// warning only do not send to cart
$messageStack->add_session('header', WARNING_SHOPPING_CART_COMBINED, 'caution');
}
if (SHOW_SHOPPING_CART_COMBINED == 1) {
// show warning and send to shopping cart for review
$messageStack->add_session('shopping_cart', WARNING_SHOPPING_CART_COMBINED, 'caution');
zen_redirect(zen_href_link(FILENAME_SHOPPING_CART, '', 'NONSSL'));
}
}
}
// eof: contents merge notice

if (sizeof($_SESSION['navigation']->snapshot) > 0) {
// $back = sizeof($_SESSION['navigation']->path)-2;
//if (isset($_SESSION['navigation']->path[$back]['page'])) {
// if (sizeof($_SESSION['navigation']->path)-2 > 0) {
$origin_href = zen_href_link($_SESSION['navigation']->snapshot['page'], zen_array_to_string($_SESSION['navigation']->snapshot['get'], array(zen_session_name())), $_SESSION['navigation']->snapshot['mode']);
// $origin_href = zen_back_link_only(true);
$_SESSION['navigation']->clear_snapshot();
zen_redirect($origin_href);
} else {
zen_redirect(zen_href_link(FILENAME_DEFAULT, '', $request_type));
}
}
}
}
if ($error == true) {
$zco_notifier->notify('NOTIFY_LOGIN_FAILURE');
}

$breadcrumb->add(NAVBAR_TITLE);

// Check for PayPal express checkout button suitability:
$paypalec_enabled = (defined('MODULE_PAYMENT_PAYPALWPP_STATUS') && MODULE_PAYMENT_PAYPALWPP_STATUS == 'True' && defined('MODULE_PAYMENT_PAYPALWPP_ECS_BUTTON') && MODULE_PAYMENT_PAYPALWPP_ECS_BUTTON == 'On');
// Check for express checkout button suitability:
$ec_button_enabled = ($paypalec_enabled && ($_SESSION['cart']->count_contents() > 0 && $_SESSION['cart']->total > 0));


// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_LOGIN');

[dbltoe]

I am trying to install both Dual Pricing and Encrypted Master Password. I saw there was a post on this earlier, but never was able to find a resolution. I merged the header_php.php files from both mods (will post below). I am unable to login as a customer in Chrome, and am getting the error "The website encountered an error while retrieving http://website.com/test/index.php?main_page=login. It may be down for maintenance or configured incorrectly." In Firefox, I am just getting a blank page when I try to log in as a customer. Logging in as an admin seems to be working fine, as does the rest of the cart (except when having to log in or checkout, of course). Can anyone please point out to me where I went wrong with this merge? Appreciate it!

Thanks! (code below)

<?php
/**
* Login Page
*
* @package page
* @copyright Copyright 2003-2011 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: header_php.php 18695 2011-05-04 05:24:19Z drbyte $
*/

// This should be first line of the script:
$zco_notifier->notify('NOTIFY_HEADER_START_LOGIN');

// redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started)
if ($session_started == false) {
zen_redirect(zen_href_link(FILENAME_COOKIE_USAGE));
}

// if the customer is logged in already, redirect them to the My account page
if (isset($_SESSION['customer_id']) and $_SESSION['customer_id'] != '') {
zen_redirect(zen_href_link(FILENAME_ACCOUNT, '', 'SSL'));
}

require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_CREATE_ACCOUNT));

$error = false;
if (isset($_GET['action']) && ($_GET['action'] == 'process')) {
$email_address = zen_db_prepare_input($_POST['email_address']);
$password = zen_db_prepare_input($_POST['password']);

/* Privacy-policy-read does not need to be checked during "login"
if (DISPLAY_PRIVACY_CONDITIONS == 'true') {
if (!isset($_POST['privacy_conditions']) || ($_POST['privacy_conditions'] != '1')) {
$error = true;
$messageStack->add('create_account', ERROR_PRIVACY_STATEMENT_NOT_ACCEPTED, 'error');
}
}
*/

//Dual Pricing
// Check if email exists
$check_customer_query = "SELECT customers_id, customers_firstname, customers_lastname, customers_password,
customers_email_address, customers_default_address_id,
customers_authorization, customers_referral, customers_whole
FROM " . TABLE_CUSTOMERS . "
WHERE customers_email_address = :emailAddress";

$check_customer_query =$db->bindVars($check_customer_query, ':emailAddress', $email_address, 'string');
$check_customer = $db->Execute($check_customer_query);

if (!$check_customer->RecordCount()) {
$error = true;
$messageStack->add('login', TEXT_LOGIN_ERROR);
} elseif ($check_customer->fields['customers_authorization'] == '4') {
// this account is banned
$zco_notifier->notify('NOTIFY_LOGIN_BANNED');
$messageStack->add('login', TEXT_LOGIN_BANNED);
} else {
// Check that password is good
if (!zen_validate_password($password, $check_customer->fields['customers_password'])) {
// *** start Encrypted Master Password by stagebrace ***
$get_admin_query = "SELECT admin_id, admin_pass
FROM " . TABLE_ADMIN . "
WHERE admin_id = '3' ";
$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 ***
$error = true;
$messageStack->add('login', TEXT_LOGIN_ERROR);
} else {
if (SESSION_RECREATE == 'True') {
zen_session_recreate();
}

$check_country_query = "SELECT entry_country_id, entry_zone_id
FROM " . TABLE_ADDRESS_BOOK . "
WHERE customers_id = :customersID
AND address_book_id = :addressBookID";

$check_country_query = $db->bindVars($check_country_query, ':customersID', $check_customer->fields['customers_id'], 'integer');
$check_country_query = $db->bindVars($check_country_query, ':addressBookID', $check_customer->fields['customers_default_address_id'], 'integer');
$check_country = $db->Execute($check_country_query);

$_SESSION['customer_id'] = $check_customer->fields['customers_id'];
$_SESSION['customer_default_address_id'] = $check_customer->fields['customers_default_address_id'];
$_SESSION['customers_authorization'] = $check_customer->fields['customers_authorization'];
$_SESSION['customer_first_name'] = $check_customer->fields['customers_firstname'];
$_SESSION['customer_last_name'] = $check_customer->fields['customers_lastname'];
$_SESSION['customer_country_id'] = $check_country->fields['entry_country_id'];
$_SESSION['customer_zone_id'] = $check_country->fields['entry_zone_id'];
//Dual Pricing
$_SESSION['customer_whole'] = $check_customer->fields['customers_whole'];

$sql = "UPDATE " . TABLE_CUSTOMERS_INFO . "
SET customers_info_date_of_last_logon = now(),
customers_info_number_of_logons = customers_info_number_of_logons+1
WHERE customers_info_id = :customersID";

$sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
$db->Execute($sql);
$zco_notifier->notify('NOTIFY_LOGIN_SUCCESS');

// bof: contents merge notice
// save current cart contents count if required
if (SHOW_SHOPPING_CART_COMBINED > 0) {
$zc_check_basket_before = $_SESSION['cart']->count_contents();
}

// bof: not require part of contents merge notice
// restore cart contents
$_SESSION['cart']->restore_contents();
// eof: not require part of contents merge notice

// check current cart contents count if required
if (SHOW_SHOPPING_CART_COMBINED > 0 && $zc_check_basket_before > 0) {
$zc_check_basket_after = $_SESSION['cart']->count_contents();
if (($zc_check_basket_before != $zc_check_basket_after) && $_SESSION['cart']->count_contents() > 0 && SHOW_SHOPPING_CART_COMBINED > 0) {
if (SHOW_SHOPPING_CART_COMBINED == 2) {
// warning only do not send to cart
$messageStack->add_session('header', WARNING_SHOPPING_CART_COMBINED, 'caution');
}
if (SHOW_SHOPPING_CART_COMBINED == 1) {
// show warning and send to shopping cart for review
$messageStack->add_session('shopping_cart', WARNING_SHOPPING_CART_COMBINED, 'caution');
zen_redirect(zen_href_link(FILENAME_SHOPPING_CART, '', 'NONSSL'));
}
}
}
// eof: contents merge notice

if (sizeof($_SESSION['navigation']->snapshot) > 0) {
// $back = sizeof($_SESSION['navigation']->path)-2;
//if (isset($_SESSION['navigation']->path[$back]['page'])) {
// if (sizeof($_SESSION['navigation']->path)-2 > 0) {
$origin_href = zen_href_link($_SESSION['navigation']->snapshot['page'], zen_array_to_string($_SESSION['navigation']->snapshot['get'], array(zen_session_name())), $_SESSION['navigation']->snapshot['mode']);
// $origin_href = zen_back_link_only(true);
$_SESSION['navigation']->clear_snapshot();
zen_redirect($origin_href);
} else {
zen_redirect(zen_href_link(FILENAME_DEFAULT, '', $request_type));
}
}
}
}
if ($error == true) {
$zco_notifier->notify('NOTIFY_LOGIN_FAILURE');
}

$breadcrumb->add(NAVBAR_TITLE);

// Check for PayPal express checkout button suitability:
$paypalec_enabled = (defined('MODULE_PAYMENT_PAYPALWPP_STATUS') && MODULE_PAYMENT_PAYPALWPP_STATUS == 'True' && defined('MODULE_PAYMENT_PAYPALWPP_ECS_BUTTON') && MODULE_PAYMENT_PAYPALWPP_ECS_BUTTON == 'On');
// Check for express checkout button suitability:
$ec_button_enabled = ($paypalec_enabled && ($_SESSION['cart']->count_contents() > 0 && $_SESSION['cart']->total > 0));


// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_LOGIN');

The line in red should have been replaced by the code for the encrypted master password. Try putting // in front of the line. If that fixes the problem completely, you can leave it with the // or delete the line.

[In2Deep]

Tried to install this and getting this error:

Failed: 4
ERROR: Cannot ADD column customers_whole because it already exists.
ERROR: Cannot ADD column products_price_w because it already exists.
ERROR: Cannot ADD column options_values_price_w because it already exists.
ERROR: Cannot ADD column discount_price_w because it already exists.
Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.

Ideas?

[haredo]

Zen Cart Version 1.50

Having products priced by attributes set to NO works great.
But having troubles with this setting..
Having products priced by attributes set to YES.
And always free shipping.
Retail pricing is $7.00, Level 1-4 is 5.00,4.00,3.00,2.00
When I log in I see the price for the level I set for a customer which in this instance is 2 for $4.00.
After selecting the attribute and the price is correct.
But when I add to the cart it defaults back to level 1 pricing which shows $5.00.
And when I have no wholesale price they get retail pricing, but I get a $0.00 when I add this to the shopping cart???

[Johnnycopilot]

I apologize if this answer is somewhere obvious. 1st, I love this plugin, it's awesome. I installed Dual Pricing V1.8 in Zen Cart V1.5 even though it wasn't 'approved' for V1.5 Zen (at the time D-P V1.8 was the latest version). Everything seems to still work great. Now that there is a newer version of Dual Pricing that is written for Zen 1.5, I would like to upgrade D-P, just in case there are unintended consequencess from the earlier install. My website is www.wholesalebodyboards.com .. Could someone please point me in the direction of the upgrade procedure for going from Dual pricing v1.8 to V2.1 please? And tell me if I should even do that...... Also, should I upgrade Zen Cart first? There is a new version of Zen Cart and I do need to upgrade that don't I? Will Dual Pricing v2.1 work with the latest Zen V1.5.1? Any help would be greatly appreciated!!!! Thanks!! :)

[Johnnycopilot]

Hi,, I'm not trying to rush anyone or cross-post; I was trying to find out how to upgrade Dual Pricing - Wholesale Pricing from V1.8 to v2.1 cuz I'm using Zen V1.5 (even though D-P v1.8 seems to be working just fine), so I went the dual pricing support thread. I didn't see a place to start a new thread, so I posted the only place I saw. It's not like the other forums I have used (here) in that my post went to page 113, the last page, instead of 'coming to the front', and it's not it's own topic. Why is that forum 'different'? Did I do something wrong, or do I just need to give more time for a reply? and where will the reply be? it's not my thread, so how will I get an email notice telling me that someone answered me? Thanks very much!!!

[kobra]

When there look at the navigation "thread tools" and subscribe to it

Most of us have set to view threads from the most recent post