How to Customize Registration Fields in Prestashop (No IT Experience)

[chulien]

Hi, I want to add custom fields to my prestashop registration form. and rename some of the fields that I dont need. 
I have no IT experience. But I can follow instructions.


I tried to follow this, http://prestacraft.com/adding-new-fields-to-the-registration-form/#

but I cant proceed because, when I try to follow this,,,

 

I am unsure if what i did is correct. 

Where should I execute this? is it under "phpmyadmin" or under "prestashop?" os somewhere else?

 

 

anyways, I tried to execute it in both of them. but i still get an error message.

 

 

 

 

is there something that i need to change?

[sandipchandela]

see there some syntaxes for all programming languages.

like in post (http://prestacraft.com/adding-new-fields-to-the-registration-form/#),

they are entering in ps_customer, so this ps_customer is an table. ps_ is prefix by default in prestashop, in your case table prefix is ch_ (as per picture).

 

One more thing, as per ref page, they are adding two fields in one is my_field, and my_required_field.

If you want to add two fields then okay other wise you need to make changes for only one field.

 

sql related help : http://www.w3schools.com/sql/

 

Then change according to tpl , class, controller files.

Take a backup first, then do the changes only.

[chulien]

Hi sorry but I did not get you that much.

Aside from changing the ps_ to ch_? what more should I do?

[chulien]

I am no IT so i cant understand the terms that much. if possible please tell me specifically what to do.

 

 I just ask someone and told me that I should execute it like this. but I am afraid to try. 

he said that I should execute

the mysql command not like this

 

ALTER TABLE ps_customer 

ADD COLUMN my_field VARCHAR(250)
ADD COLUMN my_field_required VARCHAR(250)

 

he said the what is correct is this

 

this first
 

 

ALTER TABLE ps_customer 
ADD COLUMN my_field VARCHAR(250)

then
ALTER TABLE ps_customer 
ADD COLUMN my_field_required VARCHAR(250)

Is it alright?

[sandipchandela]

Ok start from the scratch

How many fields you want to add in registration field ?

one two three?