Extra Fields for Customer Sign Up (Create Account) Page

Wow, I managed to make the extra column on the admin/customers.php.
To my own surprise it even works!

Glad to hear you were able to add the column! Let us know if you need anything else.

Hello, I have implimented this plugin and it works well. My issue is this. I am using T-Hub with Zen Cart and of course the extra fields information does not import into T-Hub and therefor not into Quickbooks as well. The T-hub people seem as thougbh they are willing to modify t-hub but it is up to me to figure out were the information is beeing located. Can you tell me, were in the database tables the Extra filed information is placed so I can further my dialog with T-hub? Thank you

Extra field data is kept in the customers table along with all the other customer info. They are labeled customers_extrafield, customers_extrafield2, and so on.

Thank you!

Very first post, running zen cart 1.5. Installed the module and it seems to work, I can see the value in the data base using phpmyadmin. It is shown as customers_extrafield and varchar (32). It is a 15 character field in format NNN.NNN.NNN.NNN. so everything seems to have worked. Which is great.

My backoffice vendor has supplied a .php file that creates an orderpacket that is sent to me to process the order. There is a field I can use in this packet UDF01 to send this value to my backend system but I can't seem to get the value to the packet. Here is what the code looks like,

$sessID = zen_session_id();

        //Begin Packet -----------------------------------------------------------------------------
        $in = "1007|WID=" . $sessID . 
              "|LID=" . substr($order->customer['email_address'], 0, 80) .
                      ...snip...
                        "|OID=" . $oID .
                        "|CN=" . substr($order->billing['company'], 0, 40) .
                        "|FN=" . substr($order->billing['firstname'], 0, 40) .
                        "|LN=" . substr($order->billing['lastname'], 0, 40) .
                        "|BA1=" . substr($order->billing['street_address'], 0, 40) .
		    "|BA2=" . substr($order->billing['suburb'], 0, 40) .
                       ...snip....
                        "|EM=" . substr($order->customer['email_address'], 0, 80) . 

So I added this code, since it was in the same customer table as the email address I thought I would copy the email mapping ....

		    "|UDF01=" . substr($order->customer['extrafield'], 0, 25) .

The packet shows the UDF01 but it is blank so my code must not be quite right in getting the value mapped.

I am pretty technical but not a PHP programmer or a sql data base expert. Any help would be greatly appreciated.

Hi stevehdp, It's tough for me to troubleshoot without being hands-on with your code. However, I think you'll find some very useful nuggets of code in the /admin/customers.php file from the module download package. Just search for "extrafield" and you'll find comments for every change made in the file. You will likely find the sq_data_array and extrafield display code the most helpful for your needs. Good luck!

Great Mod thank you, but I need a bit of help please.

I have created an extra field with 2 radio buttons on the account registration page titled "account type", where people select what account type they want to register for. Options are: wholesale account or retail account. This works well and the customer's selection values show on the client info page in admin.
However, I want the chosen field value to also be displayed in a column in the customer list view as well, so that I can see at a glance who has selected wholesale account or retail account during the sign-up process.
I have managed to get a new column appearing in the customer list view titled "Account Type", but I can't seem to get the coding right to get the selected extra field value to appear in the new column. I've tried various permutations of the code in customer.php, to no avail..

Please advise what code to add to customer.php to get the selected values to appear in this column?

The code I added to customer.php:

            <td class="dataTableHeadingContent" align="left" valign="top">
              <?php echo (($_GET['list_order']=='extrafield-asc' or $_GET['list_order']=='extrafield-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_EXTRAFIELD . '</span>' : TABLE_HEADING_EXTRAFIELD); ?><br>
              <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=extrafield-asc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='extrafield-asc' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a> 
              <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=extrafield-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='extrafield-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
            </td>

But obviously this is not enough/correct to display the values the customer selected.

@enigma, I suggest searching for **extrafield **within the customers.php file. You will see all of the display code used to show the field on the individual customer page, which is commented throughout the file to make it easier to find. From there, you can figure what needs to be copied to your new column.

jackie.taferner:

shellbell, to move the field open this file:

includes/templates/YOUR_TEMPLATE/templates/tpl_modules_create_account.php

and move this code to the section you want the field in:

Jackie, thanks for this great mod.

This above code does it move all the extra fields or just one? I would like to use 2 or maybe 3 extra fields but 1 needs to be below company name, like VAT number or so.

For me the above cut and paste is not 100% clear for me, can you help?

Thanks
Regards from Holland
Henk

Hi rmcp, That code moves just one of the fields. You will see additional sets of code for EXTRAFIELD2, EXTRAFIELD3, and so on. Just find the code for the Company name, then cut and paste the EXTRAFIELD code right below it.

If you want this field moved on both the Create Account page and the Edit Account page, make sure you change both templates located in /includes/templates/yourtemplate/templates/

Thanks for the reply

Just to be on the save side :

HERE IS WERE I PUT The <!-- start extrafield -->the extra fiels<!-- end extrafield -->?

What I want to add are 2 fields, one field below Company name that will be VAT number and also a field were my customers can fill in the model of Motorcycle they use for ordering parts.

Regards
Henk

Please upload your files and I will edit them for you.

Hi Jackie,

Thanks a lot!

I have not changed anything to your files yet so you might as well use the original ones?

If not which file dou you need?

Regards

Henk

I would need both of your files located in: /includes/templates/yourtemplate/templates/

Which version of the plugin are you using?

Sorry for the late answer Jackie

I am sorting out a other problem first ; by some strange reason not all orders show in the admin, id I search for order number I find it and can change it or print invoice but not all orders show in admin orders like you normaly see..........

I'll be back asap with the extra line help

Thanks

Henk

Hi Jackie

Thanks for the plugin, do you know of any issues with the how did you hear about us plugin as your plugin seems to override HDYHAU plugin.

I had how did you hear about us up and running but it is lost.

I am running V2.0 extra fields on Zencart V1.51

Any suggestions would be appreciated.

Peter
https://www.tenthilltoys.com.au

Yes, this module affects the same files so you will need to compare the files from each module and merge them using a tool such as WinMerge.

Thanks for the fast reply Jackie

I have merged the create account and the customers files, These seem to be the only file that needed doing.

uploaded again, cleared the cache on the browser. but no extra drop down menu.

I will just keep working away at it. I would prefer to have your plugin as it suits me better.

Thanks again
Peter