No discount for a particular item

I have created varied discounts for certain users logged in. As a result, when a user is logged in and is making a purchase, the cart will reflect the total with the discount applied (i.e.: 25% off).

However, I am selling a particular item that I do not want my users getting a discount on. I would prefer that the item be purchased at regular price. How can I update my eCart Object to take a particular item into consideration and not apply a discount to just that one item?

on the column tab, you need to create a new column to flag items the discount should apply to. set the column name to something like "discountable" for items the discount applies to, set the value to 1, for items the discount does not apply to set the value for the discountable column to 0.

in the discount calculations, set the calculation to "Based on items with a specific value":

Total of 'TotalPrice' where 'discountable' has a value of '1' 'times' '.15'

I understand what you saying here, but I am uncertain as to the next step. With the addition of the new "discountable" column, how and where do I enter the values for the discountable items?

Do I need to update the cart.php page? Do I need to enter the discountable column to the cart page or any other page?

you need to update the add to cart button to assign the value discountable value to the item.


If you are using a static cart, enter the value directly in the add to cart bindings.

If you are using a dynamic cart, you need to add a new column to your database, assign the value in the database, then update the add to cart button , and bind the new cart column to the new database column.

Thank you for your solution suggestions.

I have a similar issue pertaining to taxable items. There are number of items that not considered taxable. How would I modify the eCart to only tax items that are taxable?

same idea. create a new cart column called taxable.

Set the value to 1 for items that should be taxed and 0 for items that should not be taxed.

In the tax rule, set the calculation to "Based on items with a specific value":

Total of 'TotalPrice' where 'taxable' has a value of '1' 'times' '.8'