Page 1 of 20 12311 ... LastLast
Results 1 to 10 of 198
  1. #1
    Join Date
    Jun 2009
    Location
    Orange County, California
    Posts
    544
    Plugin Contributions
    18

    Default Extra Fields for Customer Sign Up (Create Account) Page

    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!

  2. #2
    Join Date
    Jun 2009
    Location
    Orange County, California
    Posts
    544
    Plugin Contributions
    18

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

    UPDATE: module can now be downloaded from here:

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

  3. #3
    Join Date
    Apr 2005
    Location
    Belgium
    Posts
    63
    Plugin Contributions
    0

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

    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?

  4. #4
    Join Date
    Jun 2009
    Location
    Orange County, California
    Posts
    544
    Plugin Contributions
    18

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

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


    Quote Originally Posted by torvista View Post
    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

  5. #5
    Join Date
    Apr 2005
    Location
    Belgium
    Posts
    63
    Plugin Contributions
    0

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

    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...

  6. #6
    Join Date
    Jun 2009
    Location
    Orange County, California
    Posts
    544
    Plugin Contributions
    18

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

    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:
    Code:
    $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:
    Code:
    <?php echo ENTRY_EXTRAFIELD; ?></b><?php echo ' ' . $customers_extrafield; ?>

  7. #7
    Join Date
    Apr 2005
    Location
    Belgium
    Posts
    63
    Plugin Contributions
    0

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

    And it worked!
    Thank you so much!

  8. #8
    Join Date
    Jan 2011
    Location
    US
    Posts
    37
    Plugin Contributions
    0

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

    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

  9. #9
    Join Date
    Jun 2009
    Location
    Orange County, California
    Posts
    544
    Plugin Contributions
    18

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

    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

  10. #10
    Join Date
    Jan 2011
    Location
    US
    Posts
    37
    Plugin Contributions
    0

    Default Re: Extra Fields for Customer Sign Up (Create Account) Page

    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.

 

 
Page 1 of 20 12311 ... LastLast

Similar Threads

  1. v150 additional create account fields for wholesale customer
    By newbieOK in forum General Questions
    Replies: 2
    Last Post: 23 Aug 2012, 04:17 AM
  2. Extra Fields for Customer Sign Up
    By divagal in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 31 Jan 2012, 11:51 PM
  3. Create Account - modify existing fields or add extra fields?
    By sopretty in forum General Questions
    Replies: 4
    Last Post: 30 Jul 2010, 08:26 PM
  4. Extra Box on Account Sign-up Page
    By paulssports in forum General Questions
    Replies: 6
    Last Post: 1 Dec 2006, 05:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR