http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=5944 Posted: 2009-04-14 15:19:24
Category: Categories
Version: 1.3.0
Priority: normal
Status: closed
Reported By: vligard

Problem description:

When working with pricing rules, the custom attributes will not show up in the list of product attribute conditions. This is true whther one works with 'Catalog Price Rules' or 'Shopping Cart Price Rules'

Temporary Solution (for those who cannot wait for a bug fix):
All product atributes are stored in the table 'eav_attribute'

Find the custom attribute in the table and set the field is_used_for_price_rules=1

Now, go back to Catalog Price Rules, and it will diplay in the dropdown box.

Not, sure bu there might be some other requirements for the attribute to display (like the attribute is of the correct type (dropdown, multiselect, etc) or visible is set to 1)

Run this query:
UPDATE `eav_attribute` SET `is_used_for_price_rules` = '1' WHERE `entity_type_id` = 4;

(Do a select first to make sure the where clause is right)

Recommended Permanent Fix:

This field 'is_used_for_price_rules' in the table 'eav_attributes' either needs to be set to 1 when a new attribute is added, or it needs to be displayed under Catalog -> Attributes -> Manage Attributes in the Admin Panel so that a user can manually set it to 1.

---

]]> #1 / Comment by Magento Team

Hello vligard,

This issue was fixed. The changes will be available in the next bugfix release.

Thank you.]]>