Customization of products

[HOCKE2]

I have alot of product I want to customize with a text field, but I don't want to do it manually in prestashop admin. I have a excel file with products and I can't import Customization of the products, I don't think its possible.

I can do it in excel I think and get a big SQL Query with everything, have someone a better solution?



Query for 1 product

UPDATE ps_product SET customizable = '1', text_fields='1' where id_product = 31210352;

INSERT INTO `ps_customization_field` VALUES
('31210352','31210352','1','0');

INSERT INTO `ps_customization_field_lang` VALUES
('31210352','1','text'),
('31210352','2','text'),
('31210352','3','text'),
('31210352','4','text'),
('31210352','5','text'),
('31210352','6','text');