member discount Mod question

[teksigns]

i have the member discount mod installed ......

 

however if i give a certain customer a discount of 50%

 

and i place the item on sale ......

 

the customer buy it and gets there 50% off

of the special . now the product is cheaper

than my cost .....

 

 

i want to stop customers with a discount

from being able to add specials items to there cart.

 

and prompt them with a message to contact us for ordering

items that are on sale .

 

 

i use this to tell if they have a discount

 

 

$query = tep_db_query("select customer_discount from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'");

$query_result = tep_db_fetch_array($query);

if ($query_result['customer_discount'] > 0) {

tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'));

}

 

 

now what else do i need to check if a product is on sale

and not to allow in cart .

 

and where do i put it ......

 

 

thanks for any help !

[elari]

use customer status

 

you can set a discount for each group of customers. this discount apply on each product basis, and the advantage is that for each product you can set the max allowed discount depending of the margin you have for this product.

 

you can also set a global discount (same member discount) but will not be limited by the max allowed discount on a product basis

 

many others options are avalaible too

[teksigns]

i would love to do that ....

 

 

but my cart is so heavly modded with just things i changed

here and there .....

 

 

i would not even know how to start compairing files

and making changes........

 

 

 

i just need the one piece of script

to keep my customers with discount from being able

to add products on sale to there cart.

 

 

 

i have there rest of my site already working

with discounts and showing the different prices .