DUAL Pricing v2

[townsend2009]

I too cannot get this to work with the latest version:
Zen Cart 1.3.9h

1.6 worked great then I upgrade which of course wiped it all out...it was okay since I found that the mod was updated to 1.7 but the instructions aren't clear to install and it's not changing anything when I upload and install. Hmmm...I'll be watching this thread. I really LOVE this mod.

[supersnow]

I too cannot get this to work with the latest version:
Zen Cart 1.3.9h

1.6 worked great then I upgrade which of course wiped it all out...it was okay since I found that the mod was updated to 1.7 but the instructions aren't clear to install and it's not changing anything when I upload and install. Hmmm...I'll be watching this thread. I really LOVE this mod.

Not sure what trouble you are having but I installed this and I couldn't for the life of me work out the problem with my attributes controller then I did a quick winmerge of the admin/attributes_controller.php and realized that this mod needed an updated version to work with 1.3.9h


It was missing

<?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?>

From a number of sections

I hope this helps - this made it work on my store (cross the fingers there is no other issues)

I have attached my version if anyone can use it!

[ZL Conquistador]

Not sure what trouble you are having but I installed this and I couldn't for the life of me work out the problem with my attributes controller then I did a quick winmerge of the admin/attributes_controller.php and realized that this mod needed an updated version to work with 1.3.9h


It was missing

<?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?>

From a number of sections

I hope this helps - this made it work on my store (cross the fingers there is no other issues)

I have attached my version if anyone can use it!

Is it still working? I'm very interested in this mod

[twitchtoo]

Major Big Bug Fix here!

the variable 'customers_whole' was not consistently written throughout the current install package for 1.3.9h!!!

there are two ways to correct this, by doing a find for the words 'customer_whole' and replacing it with 'customers_whole' (plural)

or

follow the list i made below:

includes/functions/functions_prices.php

from line 120
// is there a products_price to add to attributes
if ($_SESSION['customer_whole']) {
if ($_SESSION['customer_whole'] != '0') {
$i = (int)$_SESSION['customer_whole'];
to:
// is there a products_price to add to attributes
if ($_SESSION['customers_whole']) {
if ($_SESSION['customers_whole'] != '0') {
$i = (int)$_SESSION['customers_whole'];


from line 154
if ($_SESSION['customer_whole']) {
if ($_SESSION['customer_whole'] != '0') {
$i = (int)$_SESSION['customer_whole'];
to:
if ($_SESSION['customers_whole']) {
if ($_SESSION['customers_whole'] != '0') {
$i = (int)$_SESSION['customers_whole'];


from line 1302
if ($_SESSION['customer_whole']) {
if ($_SESSION['customer_whole'] != '0') {
$i = (int)$_SESSION['customer_whole'];
to:
if ($_SESSION['customers_whole']) {
if ($_SESSION['customers_whole'] != '0') {
$i = (int)$_SESSION['customers_whole'];


includes/modules/products_quantity_discounts.php

from line 101
// percentage discount
case '1':
if ($products_discount_type_from == '0') {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
// percentage discount
case '1':
if ($products_discount_type_from == '0') {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {


from line 107
if (!$display_specials_price) {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
if (!$display_specials_price) {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {


from line 118
// actual price
case '2':
if ($products_discount_type_from == '0') {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
// actual price
case '2':
if ($products_discount_type_from == '0') {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {


from line 134
// amount offprice
case '3':
if ($products_discount_type_from == '0') {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
// amount offprice
case '3':
if ($products_discount_type_from == '0') {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {


from line 143
if (!$display_specials_price) {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
if (!$display_specials_price) {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {


includes/modules/pages/login/header_php.php

from line 90
$_SESSION['customer_whole'] = $check_customer->fields['customers_whole'];
to:
$_SESSION['customers_whole'] = $check_customer->fields['customers_whole'];



includes/templates/YOUR_TEMPLATE_NAME_HERE/templates/tpl_product_info_display.php

from line 69
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {

to:

if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {

from line 84
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {

to:
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {


there are more bugs i have fixes for i will post shortly, the cart will now see the wholesale customer as well as the prices for a wholesale customer!

Twitch

[twitchtoo]

Scrap the above post #685! I have finally FINALLY found the source of the problem!

I will post the correct install.sql, and all of the changes required to make the cart not only see the wholesale customer, but use the correct pricing AND allow the admin to see and control the customer type. Now working in 1.3.9h!!!

Twitch

[twitchtoo]

Ok, here it is, step by step installation, bug fix and testing!

Install instructions for Dual Pricing - Wholesale Pricing v1.9t

This version works on ZenCart 1.3.9.h as of Jan 15th 2011

I'm not responsible for anything you do to your ZenCart, please backup your files and your database... in two locations.

Step 1 - download and extract
'dual_pricing_wholesale_pricing_1-7c.zip

located here:
http://www.zen-cart.com/index.php?ma...roducts_id=166

DO NOT use the install.sql.
Instead use the following SQL patch:
----------

ALTER TABLE `products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_wholesale`;

----------

Step 2 - rename the 'control' folder to the name of your 'admin' folder.

Step 3 (Optional) - rename 'template_default' with the name of the template you are currently using.
Note: this will prevent overwriting the original Zen Cart core template file.

Step 4 - merge the new 'admin' folder and the 'includes' folder with your ZenCart install.

Step 5 (Optional) - download and unzip the attributes controller found here:
http://www.zen-cart.com/forum/showpo...&postcount=683

attributes_controller.zip
from: supersnow

Step 6 (Optional) - merge 'attributes_controller.php' to admin/attributes_controller.php in your ZenCart install.

Step 7 - You must first replace all instances of 'customer_whole' and 'customer_wholesale' with 'customers_whole' and 'customers_wholesale'

Step 8 - Replace all 'customers_whole" with 'customers_wholesale'

Step 9 - Remove the duplicate instances of 'customers_wholesale':

delete line 100 in admin/customers.php - $customers_wholesale = zen_db_prepare_input($_POST['customers_wholesale']);
delete line 258 in admin/customers.php - 'customers_wholesale' => $customers_wholesale
remove duplicate 'c.customers_wholesale' in line 350 of admin.customers.php


These files will be modified:

includes/functions/functions_prices.php
includes/modules/products_quantity_discounts.php
includes/modules/pages/login/header_php.php
includes/templates/YOUR_TEMPLATE_NAME/templates/tpl_product_info_display.php
admin/customers/php
includes/classes/shopping_cart.php

Step 10 - Add the following code to view Wholesale Price Level in the admin right listBox:

look in file - admin/customers.php for: $contents[] = array('text' => '<br />' . CUSTOMERS_REFERRAL . ' ' . $cInfo->customers_referral);

and add this line below it: $contents[] = array('text' => '<br />' . ENTRY_WHOLESALE_PRICING_LEVEL . ' ' . $cInfo->customers_wholesale);

Step 11 - Correct the variable in admin/customers.php:

search for: '$customers_query_raw'

you will find: 'customers_wholesale' at the end of the statement.

replace it with: 'c.customers_wholesale'

Step 12 - Ensure that you have uploaded all of the files in the package!

Step 13 - Log in to admin, go to customers/customers and notice the column 'Request Wholesale' defaults to 0.

Step 14 - Click on your test account name, notice the right listBox reads 'Wholesale pricing level 0'.

Step 15 - Edit your account and change the 'Wholesale pricing level' to 1, click update.

Step 16 - You will return to the admin page and see the value has changed in the 'Request Wholesale' column.

Step 17 - Click on Catalog, Select a Product, Add in a Wholesale Price (right below the 'Products Price (Gross)')

Step 18 - Log into your live ZenCart test account - like a customer would, you will see 'Whole Sale Price:' below the retail price of the product you added a wholesale price to in Step 17.

Step 19 - Thank me.

NOTES: Know that the login page (includes/modules/pages/login/header_php.php) holds the first 'switch' to find the 'customers_wholesale' price level. If the cart timed out or the switch didn't get turned on via the login page, the cart won't see the wholesale pricing level.

I thank you. Twitch.

[twitchtoo]

Hi Everyone,

Just spent 3 hours of browsing through forums for the answer of one simple question:

Is it possible with this dual pricing mod to display the wholesale prices without taxes. While the retail prices are shown with taxes?

This question has been asked several times on different forums but there is no clear answer on this.

Thanks in advance

Yes it's possible, it would require some hard coding and a mitt full of time.

[Hollywood691]

when installing the sql patch I got this:

1054 Unknown column 'customers_wholesale' in 'zen_customers'
in:
[ALTER TABLE zen_customers ADD customers_wholesale VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER customers_wholesale;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[Hollywood691]

when I went to Admin->customers->customers: I get this page : "Parse error: syntax error, unexpected T_STRING in /home/xxx/xxx/Admin/customers.php on line 91



Line 91 reads: sale = zen_db_prepare_input($_POST['customers_wholesalesale']);

[green couch designs]

Is it possible to have different shipping rates for wholesale customers with this mod?
Thanks.