Kryptronic Software Support Forum

On the above codes, you need to apply an if statement with a category_id_encoded then equal it with your $tracking_subtotal.

Try this:

$sale_pct = "20";
$total_needed = "81.00";
$category_total = "0.00";

$sql_statement = "

SELECT cart_amtprod,cart_cat
FROM cart

";

@cat = database_call('cart','SELECT',$sql_statement);

foreach $row(@cat) {

($cart_amtprod,$cart_cat) = @$row;

if ($cart_cat eq "YOUR_CAT_STRING_HERE") {

$category_total = ($category_total + $cart_amtprod);

} ######### End of if statement.

} ######### End of foreach statement.

if ($category_total >= "$total_needed") {

$sale_pct_calc = ($sale_pct / 100);

$tracking_saletotal = ($category_total * $sale_pct_calc);
$tracking_saletotal = sprintf("%.2f", $tracking_saletotal);

$tracking_saledesc = "Spend $currency_symbol$total_needed Or More - Save $sale_pct\%";

} ######### End of if statement.

In this case, replace

this line :

if ($cart_cat eq "YOUR_CAT_STRING_HERE") {

with this line :

In this case,

replace this :

if ($cart_cat eq "YOUR_CAT_STRING_HERE") {

with this :

   (Thanks)  Any combination of 36 ceramic coffee mugs should drop the price of each mug to $2.00 per mug.  Since 36 x 2.25 = $81.00, once they reach this amount, the 20% discount should kick in, dropping the price to $72.00. 

I'm realizing that I figured the math incorrectly also, but that's not the point.  All I need to do is drop the price by .25 for each mug AFTER 36 have been added to the cart.  I'm now thinking that maybe I should be using the Total of X Save Y Amount discount instead of this one.  Anyhoo, here's what I've got for this one.

#########
######### This custom script calculates a sale
######### at checkout based on the contents of
######### the user's shopping cart when they enter
######### checkout.
#########
######### A listing of available variables:
#########
######### $cart_quantity_found   Total quantity of items
######### $tracking_subtotal     Subtotal for all items
#########
######### This script sets X percent off on purchases of
######### Y amount or more.
#########

$sale_pct = "20";
$total_needed = "81.00";
$category_total = "0.00";

$sql_statement = "

SELECT cart_amtprod,cart_cat
FROM cart

";

@cat = database_call('cart','SELECT',$sql_statement);

foreach $row(@cat) {

($cart_amtprod,$cart_cat) = @$row;

if ($cart_cat eq "CCM") {

$category_total = ($category_total + $cart_amtprod);

} ######### End of if statement.

} ######### End of foreach statement.

if ($category_total >= "$total_needed") {

$sale_pct_calc = ($sale_pct / 100);

$tracking_saletotal = ($category_total * $sale_pct_calc);
$tracking_saletotal = sprintf("%.2f", $tracking_saletotal);

$tracking_saledesc = "Spend $currency_symbol$total_needed Or More - Save $sale_pct\%";

} ######### End of if statement.

That did it.  Thanks! 

Follow the example given in the sample provided with the program.  You'll find it under Orders & Payment -> Manage Custom Sale Methods -> Buy X Items Save Y Amount.  You can modify that one to suit or make a new one using that as a guide.

If you just want it to deduct a specific amount, instead of a percentage, then just remove the percentage calculation and replace it with a fixed number.  In other words, take this line:

$tracking_saletotal = ($category_total * $sale_pct_calc);

And replace it with something like:

$tracking_saletotal = 4.95;

Not a lot more to it than that, unless I'm misunderstanding something you're asking.

I was not abbreviating the script, only changing the one line where it calculates the discount.  The rest of the script that figures out which products are in the right category would remain the same, I think.  As for applying another discount to the rest of the products, that could certainly be done, but it would take a bit more programming.  If you need professional help with it, Stephen at cartmod.com would be able to help.

You can just change the one line from a multiplication to a fixed assignment, like I demonstrated above, if you just want to change from percentage to a fixed amount.  If you need something more involved than that though, probably best to look for a quote.