Add a customization field to all my products programmatically

[powdermonkey1850]

Hi there, 

 

I am trying to add a customization field to all my products either programmatically in a module or by direct manipulation and update of the database tables.

 

I have tried updating the ps_customization_field, ps_customization_field_lang and ps_product tables,  to reflect DB changes made when adding a product through the back office CMS, but my changes do not appear at the back office under the 'customization' tab.  If I then save the product my DB changes are overwritten and removed.

 

If this is achieved in a module, the info entered in the front end should be displayed with the product in the cart and other order documentation.

I have looked for info on the web for 3 days now and don't seem to be able to find what I am looking for.

Thank you in advance to any body who is able to point me in the right direction or offer any advice to help get me started.

 

Pat

Edited September 10, 2013 by powdermonkey1850 (see edit history)

[franmille]

Hi,

You need modify the fields (customization, customization_files, text_fields) at the table ps_product in every product that you want add a customization.

Customization=1

customization_number=wherever you need

text_fields=wherever you need

Regards

[josh barak]

Hi,

I have the exact same question!

@powdermonkey1850 Where you able to figure this out??

[josh barak]

Ah!! Solved it!!

you have to changed the fields in "product_shop" table, not in "product" table.

resource https://www.prestashop.com/forums/topic/223189-solved-updating-price-in-mysql-table-doesnt-work/

Hope this helps someone.