Zen Cart Logo

DUAL Pricing v2

Views: 363,323

Results 1,121 to 1,140 of 1,504
4 Jan 2013, 10:07 PM
#1121
jackie_taferner avatar

jackie_taferner

Totally Zenned

Join Date:
Jun 2009
Location:
Orange County, California
Posts:
547
Plugin Contributions:
3

DUAL Pricing v2

@nizernoj,

Dual Pricing allows granular pricing on a per-product and per-customer basis. You can set multiple levels by assigning a number to each customer (for example, 0=Retail, 1=Wholesaler, 2=Distributor, etc). Then, you set each product's pricing for each level like so: $100-$50-$25

Please download the module and see the Read Me file for further details.

5 Jan 2013, 6:54 PM
#1122
roekoe avatar

roekoe

New Zenner

Join Date:
Feb 2010
Posts:
38
Plugin Contributions:
0

Re: DUAL Pricing v2

RoyM:

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.

7 Jan 2013, 5:08 PM
#1123
jackie_taferner avatar

jackie_taferner

Totally Zenned

Join Date:
Jun 2009
Location:
Orange County, California
Posts:
547
Plugin Contributions:
3

Re: DUAL Pricing v2

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.

8 Jan 2013, 8:34 PM
#1124
roekoe avatar

roekoe

New Zenner

Join Date:
Feb 2010
Posts:
38
Plugin Contributions:
0

Re: DUAL Pricing v2

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.

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

15 Jan 2013, 8:04 PM
#1125
aiko70 avatar

aiko70

New Zenner

Join Date:
Jan 2013
Posts:
18
Plugin Contributions:
0

Re: DUAL Pricing v2

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');
16 Jan 2013, 6:38 AM
#1126
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,763
Plugin Contributions:
9

Re: DUAL Pricing v2

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');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.
23 Jan 2013, 11:05 PM
#1127
in2deep avatar

in2deep

Zen Follower

Join Date:
Jul 2011
Posts:
214
Plugin Contributions:
0

Re: DUAL Pricing v2

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?

30 Jan 2013, 3:43 AM
#1128
haredo avatar

haredo

Totally Zenned

Join Date:
Apr 2006
Location:
Texas
Posts:
6,176
Plugin Contributions:
0

Re: DUAL Pricing v2

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???

30 Jan 2013, 5:53 AM
#1129
johnnycopilot avatar

johnnycopilot

Zen Follower

Join Date:
Mar 2012
Posts:
325
Plugin Contributions:
0

Re: DUAL Pricing v2

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 https://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!! :)

1 Feb 2013, 3:12 AM
#1130
johnnycopilot avatar

johnnycopilot

Zen Follower

Join Date:
Mar 2012
Posts:
325
Plugin Contributions:
0

Re: DUAL Pricing v2

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!!! :smile:

1 Feb 2013, 3:23 AM
#1131
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: DUAL Pricing v2

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

1 Feb 2013, 6:57 AM
#1132
johnnycopilot avatar

johnnycopilot

Zen Follower

Join Date:
Mar 2012
Posts:
325
Plugin Contributions:
0

Re: DUAL Pricing v2

Thanks Kobra

3 Feb 2013, 7:44 PM
#1133
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,763
Plugin Contributions:
9

Re: DUAL Pricing v2

Version 1.5.1 clean install (using standard ZC installation guide) with classic template and NO other mods.
All demo items are installed and we are using the installed customer with the password of "admin" (done by inserting just the password from http://tinyurl.com/a3zh37h into the test database).
Using latest Wamp Server as testing base.
PHP 5.4.3
MySQL 5.5.24 UTF 8

Specifically, we are working with the two Graphics Cards under Category 1 (Hardware) and the sub-cat 4 (Graphics Cards).

Dual Pricing is installed into the classic template (BTW, error in the readme under Affected Files -- should be includes\templates\YOUR_TEMPLATEtemplatestpl_product_info_display.php)

ID 1 (Matrox G200 MMS is NOT set to Priced by Attributes and the Wholesale Prices are entered in the "Wholesale Price(Net)" field using the ##.##-##.##-##.##-##.## Format as prescribed by the mod.

ID 2 (Matrox G400 32MB IS set to Priced by Attributes and the attribute's wholesale prices (four separate wholesale prices in all) are set in the "Trade Price" field of each attribute in the ##.##,##.##,##.##,##.## format as prescribed by the mod. NOTE: We added Option Values of "Please Select" for both Model and Memory in order to match real world usage. Both the "Please Select" are marked as "Display Purposes Only" and "Default Selected". Since the mod states that a wholesale user will receive the retail price if

Everything works as advertised when the user is set to zero (0 = Retail).

Everything works fine with both items when the user is set to 1 (1 = first level of wholesale). ID 2 has no problem dealing with the varying prices for the product's two options as some have reported earlier in this thread.

The mod fails for ID 2 (Priced by Attributes) when the user is set to 2 (2 = second level of wholesale). The cart is gathering wholesale pricing BUT it is gathering the pricing that is only correct for user level 1. NONE of the level two values are displayed in any place that the wholesale price is shown.

In looking through the code, I cannot find anywhere that the code applies the wholesale level as a means of extracting the proper price from the string (four wholesale prices separated by a comma). I can see several instances of looping to obtain the wholesale price for a priced-by-attributes method but none appear to control which part of the string is being used (it appears to default to 1).

In reading through the thread (started reading at November of 2011 since the mod 2.0 was released in November of 2012) I cannot find clear evidence where this mod has been installed without other mods and found to work.

I assume (I KNOW) by my reading that it may require another mod to work with products that are priced by attribute as Stock by Attributes is mentioned in one declared success.

BOTTOM LINE

  1. Has anyone been able to get this mod working with a clean install, the customer set to OTHER THAN level 1, and a product set to Product Priced by Attributes?
  2. IF you have this mod working with a product set to Product Priced by Attributes, the customer set to OTHER THAN level 1, AND other mods are installed, what mods are you using?
  3. There is prior mention in this thread of changing all variables from customer_whole, customers_whole, and customer_wholesale to simply customer_wholesale. This version of uses the first two and on one line of code, sets customers_whole using customer_whole as the beginning value. Has any one had success changing any of this in any way?
  4. Again, my PHP knowledge is just above "don't let him touch it", but I cannot see where the values entered are filtered according to the wholesale level set for the customer. Can anyone point me to the place in the code that I am missing this action?

I think this mod is just a slight correction from really doing what we need but I'm gonna need some help here.

THANX

4 Feb 2013, 8:37 PM
#1134
in2deep avatar

in2deep

Zen Follower

Join Date:
Jul 2011
Posts:
214
Plugin Contributions:
0

Re: DUAL Pricing v2

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?

Anyone?

4 Feb 2013, 8:40 PM
#1135
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,683
Plugin Contributions:
56

Re: DUAL Pricing v2

@In2Deep, it looks like someone has already done the database portion of the installation of this mod for you. That's what those messages mean.

5 Feb 2013, 3:25 PM
#1136
ideasgirl avatar

ideasgirl

Totally Zenned

Join Date:
Aug 2005
Location:
Trujillo Alto, Puerto Rico
Posts:
1,437
Plugin Contributions:
3

Re: DUAL Pricing v2

Hi,

Is there any new easypopulate file that goes along with the new EP4?

5 Feb 2013, 8:50 PM
#1137
in2deep avatar

in2deep

Zen Follower

Join Date:
Jul 2011
Posts:
214
Plugin Contributions:
0

Re: DUAL Pricing v2

swguy:

@In2Deep, it looks like someone has already done the database portion of the installation of this mod for you. That's what those messages mean.

Though when you go into your attribute controller in the admin you get a white screen with an error message. Something is wrong, just can't figure out what it is.

5 Feb 2013, 8:53 PM
#1138
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,683
Plugin Contributions:
56

Re: DUAL Pricing v2

If you're getting a white screen, you need to follow the debugging procedure for that.

http://www.zen-cart.com/content.php?124

5 Feb 2013, 9:18 PM
#1139
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,763
Plugin Contributions:
9

Re: DUAL Pricing v2

and... Maybe share the error message.

5 Feb 2013, 10:00 PM
#1140
johnnycopilot avatar

johnnycopilot

Zen Follower

Join Date:
Mar 2012
Posts:
325
Plugin Contributions:
0

Re: DUAL Pricing v2

I'm back.. haha.. I posted my Dual Pricing - Wholesale Pricing upgrade question on the 30th, 5 days ago. Since then nobody has replied to my post. Question.... How long should I wait to assume that I am not going to get an answer (in a usable time-frame); and then when/if that time comes, what should I do? Post in another area? I want to stress that I am not trying to rush anyone. This particular issue isn't 'breaking' my website, nor is it a huge deal; but in the future I may have more important questions, and I would like to know the best way to deal with a 'no reply' that is posted in one of these threads in which I don't get to post my own topic.. Thanks!!