2010-04-22 23:39:24
Damodar Bashyal
How to add new fields in magento e-commerce?
There is no easy method like adding product attribute for category yet. But we can achieve this by adding from database. You just need to deal with three tables in the database.
First one is: eav_attribute
Insert details as: [change as you need]
03 `attribute_code` = 'logo_size' ,
04 `attribute_model` = NULL,
05 `backend_model` = '' ,
06 `backend_type` = 'text' ,
07 `backend_table` = '' ,
08 `frontend_model` = '' ,
09 `frontend_input` = 'textarea' ,
10 `frontend_label` = 'Embroidery Size Options' ,
11 `frontend_class` = NULL,
14 `is_user_defined` = 0,
15 `default_value` = '' ,
Note the inserted attribute_id's value and insert data on another table: eav_entity_attribute
1 `entity_attribute_id` = '' ,
3 `attribute_set_id` = 12,
4 `attribute_group_id` = 7,
5 `attribute_id` = 968, [attribute_id you get from first table insert]
Now the final one: catalog_eav_attribute
01 `attribute_id` = 968, [attribute_id you get from first table insert]
02 `frontend_input_renderer` = NULL,
08 `is_visible_on_front` = 0,
09 `is_html_allowed_on_front` = 0,
10 `is_used_for_price_rules` = 1,
11 `is_filterable_in_search` = 0,
12 `used_in_product_listing` = 0,
13 `used_for_sort_by` = 0,
14 `is_configurable` = 1,
16 `is_visible_in_advanced_search` = 0,
18 `is_wysiwyg_enabled` = 0
Thats all you need to do to add new field in the manage category for magento e-commerce based websites.
Same as other values you can get the value of this field in the frontend template as below:
1 $this ->getCurrentCategory()->getLogoSize();
You can modify rest as your need.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
