Setting up a percentage discount

I'm trying to create a 10% discount for products in a specific category. So far, nothing is showing in the cart. Here's what I've done:

- eCart object > Columns tab > created a new column called Category, set to text.
- eCart object > Discounts tab >
- - created a new entry named 10% off.
- - Triggered by "Number of items with Category of sonicAlertPhones > 0.
- - Calculation, based on quantity of item: Quantity of item 1 timex .10

In the Add to Cart button for the item to be discounted:
- - Bindings tab: bound <?php echo $row_rsPhone['category']; ?> to column Category.

My cart display is set to show discounts, charges, etc.

As I said, no discount appears in cart. What am I missing?

Thanks - Joe

quantity of item uses the item ID

Calculation, based on quantity of item: Quantity of item 1 timex .10

would apply only if the item with Item ID 1 where in the cart

What is the ID of the item that is in the cart?

To help in troubleshooting issues like this, i like to create a separate cart display page, and on the second screen of the cart display manager, set it to show all columns, that way you can see all the info in the cart, including IDs.

The problem is that there is more than one item in a category; in this instance 3. Will I have to set up an individual discount rule for each item ID? Or is there a way to apply the discount to a group (category) of items?

- Joe

if you have a category column in the cart, you can use that to apply the discount to the category:

"based on items with a specific value"
Total of "Quantity" Where "Category" has a value of "Some category" "Times" "0.1"

Hmmm... I'm getting a discount now, but it's wrong. If I have two of the desired items in the cart, it gives me a discount of $0.20 - 10% of 2. How do I get 10% of the price for all the items in the designated category?

use the total price column

Total of "TotalPrice" Where "Category" has a value of "Some category" "Times" "0.1"

Bingo! Thanks, Jason.

No Worries, Joe.

Related question. On the cart page, the display is set up not to show details in the discounts, etc. section. Is there a way to change that without deleting and re-inserting the cart display?

It's much easier to recreate the display using the display manager.

to create it manually, you would need to add the rules repeater server behavior (Open the server behaviors panel, click the plus button and select eCart -> Cart Display -> Rules repeater) and the rule name rule total bindings to the page.