[Magento] How to add new fields?

How to add new fields in magento e-commerce?

There is no easy method like adding product attribute for categoryyet. But we can achieve this by adding from database. You just needto deal with three tables in the database.

First one is: eav_attribute

Insert details as: [change as you need]

<wbr></wbr>

01	`attribute_id` =<wbr></wbr>'',

02	`entity_type_id` = 9,

03	`attribute_code` =<wbr></wbr>'logo_size',

04	`attribute_model` = NULL,

05	`backend_model` =<wbr></wbr>'',

06	`backend_type` =<wbr></wbr>'text',

07	`backend_table` =<wbr></wbr>'',

08	`frontend_model` =<wbr></wbr>'',

09	`frontend_input` =<wbr></wbr>'textarea',

10	`frontend_label` =<wbr></wbr>'EmbroiderySize Options',

11	`frontend_class` = NULL,

12	`source_model` =<wbr></wbr>'',

13	`is_required` = 0,

14	`is_user_defined` = 0,

15	`default_value` =<wbr></wbr>'',

16	`is_unique` = 0,

17	`note` =<wbr></wbr>''

Note the inserted attribute_id's value and insert data on anothertable: eav_entity_attribute

1	`entity_attribute_id` =<wbr></wbr>'',

2	`entity_type_id` = 9,

3	`attribute_set_id` = 12,

4	`attribute_group_id` = 7,

5	`attribute_id` = 968, [attribute_id you get from first tableinsert]

6	`sort_order` = 8