DUAL Pricing v2

[idc1]

Does the includes/functions/functions_price.php AND/OR admin/includes/functions/functions_price.php need to be updated with this? I've actually tried both, reviewed the update several times making sure to place the code in the appropriate spot according to the second revision by edingtoncollection with no success. So starting simple, I wanted to again verify which file or files needed to be updated.

Thanks

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.

[buzzfever]

I've just installed this and while it does reflect the wholesale price in the shopping cart (once an item is added), it does not show the wholesale price on the product listing or on the individual product page. Does anyone know how to fix this?

[twitchtoo]

I've just installed this and while it does reflect the wholesale price in the shopping cart (once an item is added), it does not show the wholesale price on the product listing or on the individual product page. Does anyone know how to fix this?

yes, it's fixed i haven't released the update, life is a mess code is not.

Twitch

[gearheadniko]

yes, it's fixed i haven't released the update, life is a mess code is not.

Twitch

Have you released any updates? if so where?

gearheadniko

[idc1]

I just realized edingtoncollections fix is for DP 1.8 and I am using DP 1.7

Would anyone happen to know if edintoncollections fix will work on 1.7?

Thanks

[buzzfever]

For a few products, I need to have a wholesale price only for a certain quantity (6 or 12). I found this in an earlier post:

Well I did some experimenting and concluded that Product Price Manager isn't working with this pre 1.3 version. I finally learned how to do attributes, and found the problem others have mentioned, that is I see a 0 unless logged in (or was it logged out, can't remember).

But as I said, I have just a few items that have quantity needs, so......

I just created a new category, with my quantity discounted products duplicated in this area. And used no attributes. Then I put a minimum quantity in for each one, such as 15. and the retail and a wholesale price. If someone is not wholesale authorized they will not see the discount. When logged in, all is good. And my other products can also be selective wholesale. Neat.

Is that the best way to do it? I'm assuming I'd also need Hidden Wholesale to make that work (so regular retail customers wouldn't see the duplicate product)?

[roby]

Is there a way to include 2 price options for a product?
Example: New $100
Refurbished / Used $75.00

Is there a way to do this? I searched everywhere couldnt find an answer. Vustomers will have a choice of either adding the product to their cart new or refurbished.
Thanks

[buzzfever]

Is there a way to include 2 price options for a product?
Example: New $100
Refurbished / Used $75.00

Is there a way to do this? I searched everywhere couldnt find an answer. Vustomers will have a choice of either adding the product to their cart new or refurbished.
Thanks

You could do that with attributes.

[idc1]

From what I can tell, edingtoncollection's changes should work in both DP1.7 and DP1.8. But with or without the code added in, I have both Retail and Wholesale price showing as the same Sales price.

I do have the Column/Grid 1.3.8 installed. Does anyone know or think that anything in the Column/Grid 1..8 add on would cause this?

[DCoalson1]

Ive got v1.8 installed with zencart1.3.9h and I cant figure out whats going on with the attributes? I enter in the price for the attribute in the "trade" field and click update and I get sent directly to the admin homepage, no changes to the attribute is retained. Can you give me some assistance with what/where Im going wrong? Thanks!