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; ?>

[eOstrE]

And it worked!
Thank you so much!

[Cyndi]

Using V. 1.3.9, fresh install

Almost worked perfect for me, got this on the sign-up page:

EIN Number: (with a box)
ENTRY_EXTRAFIELD (box) ENTRY_EXTRAFIELD_TEXT

[jackie.taferner]

Cyndi,

Try step 3 of the installation process:

3. Open the 2 language files and define the names of your new field:
/includes/languages/english/extra_definitions/extrafield_defines.php
/admin/includes/languages/english/customers.php

[Cyndi]

I'll try again, I thought I did that but I may have mistyped too...be right back and thanks for the awesome quick answer.