Extra Fields for Customer Sign Up (Create Account) Page

[jackie.taferner]

OFFICIAL SUPPORT THREAD for the following contribution:
Extra Fields for Customer Sign Up
Zen Cart 1.3.9

Not yet in the downloads section, but has been submitted.

Enjoy!

[jackie.taferner]

UPDATE: module can now be downloaded from here:

http://www.zen-cart.com/index.php?ma...oducts_id=1694

[eOstrE]

I have downloaded your contribution, and it works fine for me! Tx!

I'm using this field for the tax number of my costumer.

I wonder how to add this additional field (code) on the invoice.php (Admin section) and packingslip.php, so it will appear on the order when i'm printing it!

Could you help me out with this one?

[jackie.taferner]

eOstrE, I haven't tried this yet, but in another thread a user posted this solution:

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
<?php echo ENTRY_TAXID_NUMBER; ?></b><?php echo ' ' . $customers_taxid; ?>

regards
Steve

Original thread: http://www.zen-cart.com/forum/showthread.php?t=73181

[eOstrE]

I have pasted the code in the document as shown, and i get this error message:


1054 Unknown column 'c.customers_taxid' in 'field list'
in:
[SELECT o.customers_id, c.customers_taxid from zenbooksorders o, zenbookscustomers c WHERE c.customers_id= o.customers_id and o.orders_id = '93806']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


This is rather Chinese to me...

[jackie.taferner]

Ahh... sorry that must have been personalized to the name of their custom field. If you installed the module exactly as I built it, the custom field will be named "customers_extrafield"

So, I *think* this would be the correct code instead. Give it a shot and see what happens :)

Add this code at line 28:

$oID = zen_db_prepare_input($_GET['oID']);
//start extrafield
$sql = "SELECT o.customers_id, c.customers_extrafield from " . TABLE_ORDERS . " o, " . TABLE_CUSTOMERS . " c WHERE c.customers_id= o.customers_id and o.orders_id = '" . $oID . "'";
$chk_customers_extrafield = $db->Execute($sql);
$customers_extrafield = $chk_customers_extrafield->fields['customers_extrafield']; 
//end extrafield

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

<?php echo ENTRY_EXTRAFIELD; ?></b><?php echo ' ' . $customers_extrafield; ?>

[ofincorp]

Is there a way to make the field a non required field? I noticed it shows up as a required field and I'm using the field so Affilliates can enter their registration number to qualify for a group discount. All of the customers are not affilliate members so if they're not I'd like them not to have to put something in this field. Thanks in advance!

EDIT---
Never mind! I found it in the extrafield_defines.php file!

[jackie.taferner]

You can make the field required or turn it on/off in Admin > Configuration > Customer Details

[Soniccc]

Is there a way to include the information from the Extra Field in the order confirmation e-mail?

Thanks

[jahmar]

Hello, this add-on is a lifesaver and I greatly appreciate it. Thank you!

I'm looking to add multiple extra fields to the account creation and account edit pages. I've used the plugin and have been able to get everything working correctly during account creation. The problem is that when attempting to update an account, only the first extrafield that I added is being updated in the database.

Heres what I have done so far:
1. I've added the db fields for extrafield, extrafield2, and extrafield3
2. I've updated all of the files that came with the add-on to reflect all three extrafields is each place that the original extrafield was added. (I've double checked this)

Any suggestions?