DUAL Pricing v2

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

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

edingtoncollection:

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.

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?

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?

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

Twitch

twitchtoo:

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

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

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

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

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

You could do that with attributes.

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?

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!

edingtoncollection:

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

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

Ok, so I got the code working.
When logged in - sales price does NOT display.
When not logged in - sales price displays.

I would like the reverse to happen. I want MSRP to always remain as it is and the wholesale price to be the one discounted.

How can I make this happen? I tried several variations of the above code with no success.

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!

After a comparing the dual pricing attributes_controller.php with the default /[your_admin]/attributes_controller.php] file I see that there are several instances where this code has been omitted:

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

Once adding this code back, the page seems to work properly on initial testing.

daniel

I have a problem with the dual pricing,
If I have a retail price of R100.00 and wholesale price of R60.00 but I have the product on special on the retail side at R80.00 the system still charge my wholesale client the special price of R80.00 instead of the wholesale price of R60.00

It displays the whole sale price as R60.00 , stroked out and special price next to it at R80.00

If the wholesaler ads it to his cart he pays the "special" price

Is there a way around this?

Pls check the post 878 before. edingtoncollection has the solution for this.

idc1:

Does the **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 update this file includes/functions/functions_price.php successfully.

Thanx Ironman, it works perfectly

i have installed the dual pricing .

Each category has a percentage discount.

Example :

Category - Salemaker - Mentalism discount 28.0000 Percent

special price for all customers - wholesale & retial
Ghost Nail 2.0 Laser Edition
$40.00 special price $34.00
After Discount category Sale: $24.48

Admin product :
Products Price (Net): 40
Products Price (Gross): 40
Wholesale Price (Net) : 29

Normal mode no special price
wholesale accout log in - After %28 salesmaker Applied show
wholesale Sale: $20.88

How can ignore the special price but not the salesmaker for wholesale account ?

When I logged a wholesaler account The page items show me like that :

**Retail Price: $3.60 $2.80
Sale: $2.02

Whole Sale Price: $1.80 $2.80
Sale: $2.02
**

The 2.02 is **special price . **
The 1.80 is **wholesale price . **

How to disable the special price for wholesale account .but not for retial accounts .

Wholesale customer would see his wholesale price. Including Percent discount of sales maker.

The below is from edingtons fix:

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

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

The code works as follows:
When logged in - sales price does NOT display.
When not logged in - sales price displays.

I have yet to get the reverse to happen. I want:
When logged in - sales price displays.
When not logged in - sales price does not display.

How can I make this happen? If I change
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' )

to

if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] = '0' )

That made the sales price display both when logged in and not logged in.