Percentage discount for a specific item in cart

I'm sure it's something stupid, but for the life of me I can't spot what I'm doing wrong.

I have to put in a discount rule that allows the customer to apply a coupon for a given percentage off on one item with a specific ProductID.

I set up database-driven coupons for flat-rate and percentage off (they work great), but adapting them for specific products doesn't seem to work for me.

I have session variables in place for the coupon's PromoProduct, PromoAmount and PromoType, and the correct values are showing. I also have a column in the eCart object for ProductID.

This is the rule that appears in eCart1.php:

function WAEC_eCart1_PercentageOffProduct() {
$totalDiscount = 0;
if (true && ((sizeof($this->Items) > 0) && (isset($_SESSION['PromoCode'])) && (isset($_SESSION['PromoAmount'])) && (isset($_SESSION['PromoProduct'])) && ((isset($_SESSION['PromoPSpecific'])?$_SESSION['PromoPSpecific']:"") == "product") && ($this->ConditionalTotal("Quantity", "ProductID", "".$_SESSION['PromoProduct'] ."") > 0))) {
$totalDiscount += (floatval($this->GetInfo("".$_SESSION['PromoProduct'] ."", "Price")) * ($_SESSION['PromoAmount'] / 100));//Result
}
return WA_eCart_FormatNumber($totalDiscount, $this->ForceDecimalsC, $this->DecimalPlacesC);
}

I've confirmed that all the session variables, the eCart columns, and the discount calculation are returning the expected values.

for troubleshooting, create a new php page, add a cart display to it, on the second step, set it to show all columns

then add the following code at line 1:
<?php @session_start(); ?>

to force php to look for the session, and add the following code in the body to write the session contents to the page:
<?php var_dump($_SESSION); ?>

send a link to the product page that should trigger the discount and a link to the new cart display page so i can see what is going on.

see pm

the cart ID column is a numeric column

you are passing in a text value.

the Conditional total is failing to find the product ID because the id you are using is a text value and it cannot do the number comparison.

edit the product ID value to be numeric instead of using text.

I don't think that's it, Jason.

I use the ID column in the eCart object for the id of an SKU table which holds individual records for each distinct product (unique combinations of products, colors, sizes, widths, etc). I have to do it this way instead of your productoptions solution to better produce ordering coordination with my clients many vendors. That ID is numeric.

The id of the products table is text. That table contains all the information related to a given product - description, base price, brand, etc. That's why I add a ProductID column to the eCart object.

When I check on the values of $_SESSION['PromoProduct'] used in the discount rule and the eCart "ProductID", they match.

I'll need to troubleshoot directly, see the private message section.


please send a link to your site where i can see the problem occur and ftp login details so I can access the site files directly to troubleshoot.

see pm

i see the probelm:

$this->GetInfo("".$_SESSION['PromoProduct'] ."", "Price")


Get Info takes the ID column, the ID value is 31562

you are trying to use the ProductID column in the GetInfo function

use ConditionalTotal instead
$this->ConditionalTotal("Price", "ProductID", "".$_SESSION['PromoProduct'] ."")

Thank you, Jason. You just made my life much easier.

you're welcome.