Add a field into create account

has anyone got information how to add a dropdown list for references (where they heard about us) into the login section?

I followed all the the suggested steps and all works, except when creating an account for the first time, a user receives this error when submitting their login info.

1062 Duplicate entry '2' for key 1
in:
[insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('2', '0', now())]

They still get an account, and everything saves to the database, but it doesnt transfer them to the confirmation page.

Any ideas how to fix this?

Hi, after going over and over this I still can't seem to get it up and running. So I was wondering. If someone who has this Add field thing up and running on their site, could they post up for download the pages they updated to make it work with just one added field "With Comments like /* Add Additional Field Here */ ", so I and probably quite a few others can simply add as many fields to it as we like following the added code as a guide, and it would still work when uploaded to our sites.

Could this be a possibility.

Cheers
J#xx
(Scott Perry)

I added my old client database through phpadmin and now it shows this error messages above my customer panel in admin.

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/evergree/public_html/shop/admin/customers.php on line 1155

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/evergree/public_html/shop/admin/customers.php on line 1157

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/evergree/public_html/shop/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/evergree/public_html/shop/admin/includes/classes/object_info.php on line 30

any ideas what I must do to fix it?

Hi and thanks to those who share their knowledge...

Could some one help me out to include this taxid field in the order email and to print.

Thanks in advance.

Thanks for sharing. I created a different type of field, but this thread gave me a good idea of what needed to be edited.

Great post!

I'm sorry but this is probably a really stupid question.

How do I just echo the data from the customers table, without an editable field?

Thanks:blush:

I have been right through all the instrcutions on this thread and still stumped. I am trying to add a field to allow customer to enter thier website address.
When I get to

9. Now open file: includes/templates/YOURTEMPLATE/templates/tpl_modules_create_account.php

9a. Now search for the following code:

I open the file and find the above section but it is slightly different to what I have. This is not in my file
$account->fields['customers_fax'],

So I tried entering

And if I make the changes as suggested then view the page /index.php?main_page=login The ID and Password fields are still there , but everything else has gone. :ohmy:

help, please :D

I followed the instruction below, everthing works fine EXCEPT
when I edit any of the newely added customer info from ADMIN panel,
then all the customer info is gone, except the one in zencart default customer field.

Do I miss something? Anybody have same problem as me. Please help!

thanks in advance,,

Tharina:

word doc did not upload sorry
I replaced taxid with cellphone, children, children_ages and occupation.

Works like a charm. Added 2 fields, they populate the database. How do I get them in to show up in invoice???

mnemos:

Works like a charm. Added 2 fields, they populate the database. How do I get them in to show up in invoice???
Can't edit ... Little snag also: while from the signup it all works, editing the new data from the admin area seems to get the data lost. Any ideas?

and no one bothers to answer the question about displaying the Tax ID in the invoice?

Hi,
to display the taxid in the invoice either you can edit the ordering code so the taxid is included in the order information posted to the order table (would be better in future zen core) or you can get the taxid from customer table using the customer info from the order info as the reference.
I found the code for the second option by accident and I preferred it as it leaves the base code intact.

So, in admin/invoice.php add this query at line 28

$oID = zen_db_prepare_input($_GET['oID']);
//THESE LINES ADDED TO GET INFO FROM CUSTOMERS TABLE
$sql = "SELECT o.customers_id, c.customers_taxid from " . TABLE_ORDERS . " o, " . TABLE_CUSTOMERS . " c WHERE c.customers_id= o.customers_id and o.orders_id = '" . $oID . "'";
$chk_customers_taxid = $db->Execute($sql);
$customers_taxid = $chk_customers_taxid->fields['customers_taxid'];

so now you can use the $customers_taxid variable where you want, for example in one of the table cells

regards
Steve

thank you very much steve/torvista, that worked :clap:

but there's one more problem - tax id is now 'always on'

for my purposes (and I presume many others) it would be ideal if taxid would show up in the invoice only when company name is displayed

I have managed to make zc display Tax ID line in create account only when company name is set to 'true' in admin-configuration-customer details

and it was simple: just added this to create_account.php

if (ACCOUNT_COMPANY == 'true') $taxid = zen_db_prepare_input($_POST['taxid']);

but I dont know how to do the same thing for the invoice

any ideas?

bump...

I posted this back in Sept, but not had any response. It's a huge pain for us, so I was really hoping someone had an idea.

I've got a bit of a weird problem. The field added very easily and the instructions were great.

However, I added my field right below the phone and fax numbers called "customsid". When a customer does not fill in his fax number (which is not required) but fills in this customsid, in admin it shows the customs id in the fax field. If he fills in the fax field, then it puts it in the correct place.

Any ideas what I did wrong? Either way I get the number, but I have to manually move it down to the customs id box from Admin and it's huge pain.

This is where it puts it in the admin when they don't fill out the fax number and we have to manually cut and paste it into the correct field.

Hi I had a similar mix up problem, to fix it go into admin/tools/developers tool box, go to the bottom where it says "look up in all files" and type in "Your field Name", ie: customsid select all files catalogue/admin and you should get a long list of files with that name included, when it comes up carefully check all the lines of code with your fieldname in and make sure that customers_fax is not mixed up anywhere in your customsid lines of code and vise versa.

Good luck and hope you fix it !

Cheers
J#xx
(Scott Perry)

Thank you so much Scott!! That worked. Really need to pay more attention when doing these things!!

No problem !, glad it works !

Cheers
J#xx
(Scott Perry)

I changed 'fax' to "company description" and moved it up the create account page

But it echo's in a one line text field, but I want it to echo in a multiline text area, or just eco as text in the admin customers information.

For the create account page, I just changed;

to

and this send the information fine, but when it is viewed in the admin customers information, is shows in a small one line box

anyone know how to echo it in a multiline text area, or just echo in the customers information as text

 <tr>
<td class="main"><?php echo 'Tax ID:'; ?></td>
<td class="main">
<?php
if ($processed == true) {
echo $cInfo->customers_taxid . zen_draw_hidden_field('customers_taxid');
} else {
echo zen_draw_input_field('customers_taxid', $cInfo->customers_taxid, zen_set_field_length(TABLE_CUSTOMERS, 'customers_taxid', 15));
}
?>
</td>