Custom Input Text Field for all products

[cromata]

Good day,

I'm looking for a way to add two customization fields (text fields in this case) to all products, right now i have to do it one by one but i have over 200 products i have to do.

So i'm trying to find a way to have the two input text fields for all the products instead of doing it manually.

Any help is greatly appreciated.

Have a great day

Mario

[rocky]

You could try modifying the database directly use PHPMyAdmin. Go to the ps_customization_field and ps_customization_field_lang tables and then insert as many rows as you need.

For the ps_customization_field, enter the product ID, the type as 1, and required as 0 or 1 (required or not required).
For the ps_customization_lang_field, enter the customization ID, the language as 1, and the name you want the field to have.

Perhaps you could come up with an SQL query to make it easier.

[shindigDADA]

after i create the customization fields, how would i connect them to the particular product? almost all my producst require some customization and i would like an easier way to do this...
see pictures of 2 tables-
this is the customizations tables:
text fields #10, 11, 12 are connected to product amarelas
!http://shindigDada.com/slips/ps_customization_field.jpg!
but in the product table i can only see that it specifies 3 text fields but not which text fields...
!http://shindigdada.com/slips/text-fields.jpg!

[shindigDADA]

it was right in front of my face !!!
!http://shindigDada.com/slips/duh.jpg!

[deiutz]

it was right in front of my face !!!<br/>!http://shindigDada.com/slips/duh.jpg!

can you post your solution please?