How to add discount to item for only one attribute value?

Hi everyone,
I'm selling paintings and reproductions from my site. The reproductions are priced according to an attribute, canvas size -- either 24" or 30". Here's an example:
http://www.lifeengineering.org/index.php?main_page=product_info&cPath=1_3_9&products_id=26

As you can see, the base price is set at a certain point and I've set up the canvas size attribute so that switching to 30" adds $150. All good.

Now I want to put the 24" item for sale, but not the 30" one. I tried to set this up in Catalog -> Specials by adding a $100 discount on the item. It works great for the 24" item, but I don't want it to apply to the 30" item.

Note: I'd rather not create two separate items -- a 24" inch version and a 30" version. And, I'd like to use a special instead of changing the regular price, so the sale is showcased in various places around the site.

Can anyone tell me how to apply the sale to only the 24" attribute version? Other suggestions are also welcome.

Thanks!

PS: Using Zen Cart v1.3.9b

Really?! No one has any suggestions?

Put the Product on Special and mark the Attribute to not use the Special ...

Thanks for the reply. Well, I've tried this, but it doesn't seem to work.

I applied the reduce price to the item, then went to the attribute controller and set the following property to false for the second attribute on the item: 'Apply Discounts Used by Product Special/Sale".

But that didn't work. The second attribute still applies the discount. I also tried this in the opposite order, in case it mattered. It didn't.

It should be noted that the way I have it set up is the first attribute (24") is the base price, and the second size (32" attribute) adds price.

Is this the problem?

Any other suggestions?

Now you are trying to get Quantity Discounts to work with Attributes and those are not friends ...

The Attributes can get the Special Discount but not the Quantity Discount ...

NOTE: you might look at the Quantity Discount on the specific attributes and see if that helps you on this ...

Ajeh:

Put the Product on Special and mark the Attribute to not use the Special ...

Still can't figure this out...
Can you describe how to do this?

Hi, have you had any luck resolving this issue?

I am facing the same issue with adding a second size to my products. I want to be able to put the second size on sale using Sale Maker, and cannot get it to work properly in my test environment.

I've set my products to be Priced by Attributes and set the price at the product level to $0. The first size attribute price is $11.75 and the second size attribute is $15.75. Since Sale Maker has no provision to set a sale at the attribute level, I set the first size attribute to NOT apply discounts/specials, only allowing Sale Maker to apply to the second size attribute. While that does work as far as adding the proper price to the shopping cart, the discounted price erroneously shows on the first size, even though it adds to the cart at the undiscounted price.

So this is not a resolution because the customer sees all products with the first size at a sale price (when it actually isn't), and when added to the cart, adds at the full (non sale) price (which is correct).

Now, of course the second size attribute, which is set to apply discounts/specials, is working properly, which is what I want, but cannot properly achieve.

Also, this method would not be efficient because I would have to update all products' first size attribute when changing and applying sales.

After applying some changes based on this thread: https://www.zen-cart.com/forum/showthread.php?t=94538,
I have a working result. Here is my setup:

Products are Priced by Attributes. Product price is $0.
Each product has 2 sizes, priced by attributes. 11"=$11.75, 17"=$15.75. 11" size has attribute: Apply Discounts Used by Product Special/Sale: set to NO, while 17" is set to YES.

I want to put the 17" on sale for $13.75. In Sale Maker, I set my Deduction to 12.7%. I set the Product Price Range to $15.75. I set If Product is a Special: to Apply SaleDeduction to Specials Price - Otherwise Apply to Price. I set my Date range and checked the appropriate Categories.

What this does is, at the Product level, show the 11" size as $11.75 and the 17" size as $13.75 (instead of $15.75). However, what it does not do is show the 17" as a sale with the original price, strikethrough, and sale price. (but no biggie, I'll accomplish that with a banner)

Another however, it is still not practical to implement because I have to change the 11" attribute: Apply Discounts Used by Product Special/Sale:, everytime I change sales.

And, this works for me because i don't have many variations in prices (or should I say many different products with similar pricing).

This is in no way an ideal method. But if you don't have many products and pricing variations, it will do the job without much hassle. And if you have some SQL experience, you can write some scripts to change the product attributes en masse.

(And it REALLY helps to set up a test environment with your current store configuration. I have a Reseller Hosting Account and I can set up as many web servers and Zen Cart installations as I want in my 50GB of server space.)

I was never able to figure out how to do this. I eventually switched to two different items, each representing a different size.

BTW, here is the SQL script I ran to update my 11" size to set the Apply Discount attributes flag to NO.

update zen_products_attributes

set attributes_discounted=0

where (options_id=25 and options_values_id=3)

options_id=25 is the Option Name - Size

options_values_id=3 is the Option Value - 11"

You will have to apply the id's for your Option Names and Option Values.

To set to YES, set attributes_discounted=1

(as always, BACKUP YOUR DATABASE BEFORE RUNNING SCRIPTS!)

Good Luck.