Multiple MRPs of a product based on pack size

[devyani]

Hi,
I have products that come in various pack sizes and the price differs for each pack size.
So i have :
1. Created an option Name - Pack Size
2. Created option Values for this as : 2, 5, 16, 30 , 56
3. Given Price for each of them.
All this is fine, and works well if I keep the price( this price is the one that i enter when i enter product name etc) as 0.
But then on the site this shows as product price as '0' on the main page.
I tried the base price flag, but doesn't work.
Is there any other way out?

Also, I need to do this for a lot of products. Is there any direct SQL statement that i can use, at least for each product?

Thanks !

[Ajeh]

As the Prices are all in the Attributes and not on the Product itself, mark the Product as Priced by Attribute ...

[devyani]

Thanks, will try it right away!
also is there a way of doing this product by product, in a batch? I have various products and each of them have various pack sizes.

[devyani]

Works Great !
Thanks so much !

[devyani]

Just checked, as mentioned in the remark of price by attributes, Display price will include lowest group attributes prices plus price.
So, shall i keep my price as 0 ? If I do that, then on selection, the price is shown as '0' and pack options are shown as radio buttons. On selecting a pack size, the price is still shown as '0'.
I am attaching a screen shot of this.

Pls help me out here.

[devyani]

Hi,
I found a workaround to my above problem by editing tpl_product_info_display.php
I commented the part where the price is displayed. So this takes care of the '0' being displayed as price.
But now the next challenge is that I offer flat 5% off on MRP of these products.
I had created this thru salemaker. But the salemaker calculated discounts on the price, and not on the attribute price. So, the discounts are not being given.
Any suggestions, what can be the other way to offer 5% off on MRP chosen thru attributes ?
Thanks

[lat9]

Hi,
I found a workaround to my above problem by editing tpl_product_info_display.php
I commented the part where the price is displayed. So this takes care of the '0' being displayed as price.
But now the next challenge is that I offer flat 5% off on MRP of these products.
I had created this thru salemaker. But the salemaker calculated discounts on the price, and not on the attribute price. So, the discounts are not being given.
Any suggestions, what can be the other way to offer 5% off on MRP chosen thru attributes ?
Thanks

Are each of the attributes marked with "Apply Discounts Used by Product Special/Sale" set to Yes (the purple button is active)?

[devyani]

yes, I just checked. It is marked as 'yes'

[devyani]

yes, i just checked, the purple button is active

[lat9]

Also, make sure that each attribute is marked as "Include in Base Price When Priced by Attributes" set to Yes.