DUAL Pricing v2

[idc1]

Very glad to see the forums are back up and running. To follow up on my last post:

Original (from /includes/modules/YOUR_TEMPLATE/product_listing.php):

case 'PRODUCT_LIST_PRICE':
$lc_text = TABLE_HEADING_PRICE;
$lc_align = 'right' . (PRODUCTS_LIST_PRICE_WIDTH > 0 ? '" width="' . PRODUCTS_LIST_PRICE_WIDTH : '');
$zc_col_count_description++;
break;


Trying to take a bit of code out of /includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php from the Dual pricing add-on and blend with the /includes/modules/YOUR_TEMPLATE/product_listing.php. Think I should end up with something like below, but it's not giving me the results I'm after

case 'PRODUCT_LIST_PRICE':
$lc_text-> if ($_SESSION['customers_wholesale'] && $_SESSION['customers_wholesale'] != '0' ) {
echo '<span id="whole">Dealer: ';
} else {
echo '<span id="retail">MSRP: ';
}
;

$lc_align = 'right' . (PRODUCTS_LIST_PRICE_WIDTH > 0 ? '" width="' .
PRODUCTS_LIST_PRICE_WIDTH : '');
$zc_col_count_description++;
break;

[edingtoncollection]

I am using zen 1.3.9h and have installed Dual Pricing - Wholesale Pricing v 1.8. It is working great and I love it! Now I am looking for the same feature in categories.

I have read postings about hideCategories and hidden wholesale working with Dual Pricing. What I have found is hideCategories just generally hides Categories from everyone. And hidden wholesale just hides wholesale "products" not categories.

I found Display Specific Categories for a logged in Customer Only at http://www.zen-cart.com/index.php?ma...oducts_id=1763. This module allows a category to be seen by everyone or only seen by the "one" customer it is assigned to.

I am a beginner at PHP but it would seem that the Display Specific Categories for a logged in Customer code could easily be modified to incorporate the Dual Pricing code. Instead of assigning a category to a specific customer, assign a number higher than zero - like the way you do a customer in Dual Pricing.

By merging these two modules together we could have Dual Pricing and Dual Categories.

This way wholesale products; bulk items, marketing supplies, etc. categories could be visible to wholesale Dual Price customers. Please consider this.

[al-musafir]

Hi,

I founded the same problem and fixed it. When I added and attribute to a products send me directly to index admin.

I compare the original attributes_controller.php from last zencart verison 1.3.h with the attributes_controller.php from Dual price and I found that <?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?> are missing three times. I added it and now works rigth.

But now I have another problem, in the front when I add a product with attribute to the shopping car show the wholesale prices but add the retail price attribute. I founded it in another last version but now I don´t know how to fix.

¿any one can help me?

Thanks

[joeyrocket]

I don't know if this has been covered, but is there a way to make a certain module only available to one customer group?

Specifically, I want to make the Optional Shipping Insurance Module by Numinix available only to wholesale customers.

[al-musafir]

Hi,
In older version attributes works fine.
I dont know why not runs now.

Can any one fix that?

:-) Thanks

[edingtoncollection]

I use Zen Cart 1.3.9h and Dual Price v 1.8. When there is a special or sale price I was having a problem with the special or sale price overwriting the wholesale price when a wholesaler was logged in. Ex: Retail: $99.99, On Sale for $89.99, Wholesale price $59.99 and if logged in as a wholesaler the resulting price would be $89.99, not the $59.99.

To fix this I made the following changes in the functions_prices.php page:

under: //get specials price or sale price
find:

if ($specials->RecordCount() > 0) {
// if ($product->fields['products_priced_by_attribute'] == 1) {
$special_price = $specials->fields['specials_new_products_price'];
} else {
$special_price = false;
}

replace with:

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
$special_price = false;
} else {

if ($specials->RecordCount() > 0) {
// if ($product->fields['products_priced_by_attribute'] == 1) {
$special_price = $specials->fields['specials_new_products_price'];
} else {
$special_price = false;
}
}



and under: // get sale price
find:
if ($sale->RecordCount() < 1) {
return $special_price;
}

replace with:

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
$tmp_special_price = $product_price;
} else {
if ($sale->RecordCount() < 1) {
return $special_price;
}
}

******

Now the special or sale prices are ignored when a wholesale customer is logged in. I processed orders both under a retail test customer and a wholesale test customer and it is working fine.

[edingtoncollection]

******

Now the special or sale prices are ignored when a wholesale customer is logged in. I processed orders both under a retail test customer and a wholesale test customer and it is working fine.

I realized I placed some code in the wrong spot.... here is the corrected code:

The following changes in the functions_prices.php page:

under: //get specials price or sale price
find:

if ($specials->RecordCount() > 0) {
// if ($product->fields['products_priced_by_attribute'] == 1) {
$special_price = $specials->fields['specials_new_products_price'];
} else {
$special_price = false;
}

replace with:

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
$special_price = false;
} else {

if ($specials->RecordCount() > 0) {
// if ($product->fields['products_priced_by_attribute'] == 1) {
$special_price = $specials->fields['specials_new_products_price'];
} else {
$special_price = false;
}
}



and under: // return special price only
find:

if ($specials_price_only==true) {
if (zen_not_null($special_price)) {
return $special_price;
} else {
return false;
}
} else {
// get sale price

// changed to use master_categories_id
// $product_to_categories = $db->Execute("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "'");
// $category = $product_to_categories->fields['categories_id'];

$product_to_categories = $db->Execute("select master_categories_id from " . TABLE_PRODUCTS . " where products_id = '" . $product_id . "'");
$category = $product_to_categories->fields['master_categories_id'];

$sale = $db->Execute("select sale_specials_condition, sale_deduction_value, sale_deduction_type from " . TABLE_SALEMAKER_SALES . " where sale_categories_all like '%," . $category . ",%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '" . $product_price . "' or sale_pricerange_from = '0') and (sale_pricerange_to >= '" . $product_price . "' or sale_pricerange_to = '0')");
if ($sale->RecordCount() < 1) {
return $special_price;
}

replace with:

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
return false;
} else {
if ($specials_price_only==true) {
if (zen_not_null($special_price)) {
return $special_price;
} else {
return false;
}
} else {
// get sale price

// changed to use master_categories_id
// $product_to_categories = $db->Execute("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "'");
// $category = $product_to_categories->fields['categories_id'];

$product_to_categories = $db->Execute("select master_categories_id from " . TABLE_PRODUCTS . " where products_id = '" . $product_id . "'");
$category = $product_to_categories->fields['master_categories_id'];

$sale = $db->Execute("select sale_specials_condition, sale_deduction_value, sale_deduction_type from " . TABLE_SALEMAKER_SALES . " where sale_categories_all like '%," . $category . ",%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '" . $product_price . "' or sale_pricerange_from = '0') and (sale_pricerange_to >= '" . $product_price . "' or sale_pricerange_to = '0')");

if ($sale->RecordCount() < 1) {
return $special_price;
}
}

******

Without this correction there was a problem with the prices being displayed as both a wholesale price and a sale price with the same figures. Sorry for any confusion.

[al-musafir]

Hi,
Thanks that´s works fine.

There is no solution for attribute´s problem?
Is very important for this contribution. Now is like a beta.

If anywant found a fix I can make same donations.

[mercurysoun.it]

thank you very much your edit is fine but I still have a problem on the quantity discount.
When I log as wholesale I can see the wholesale prices for quantity, but in the basket is indicated only the first wholesale price.
The volume discount will not work. What can I do?

[al-musafir]

Hi,
50$ to anyone fix the attributes problem.
Contact my in private.
Thanks.