add extra information in admin/orders.php

[pelotuo]

i have the contribution "customers_extra_fields"

 

i created 2 new extra fields when someone create a account

i have all working... i see the information in the database and my question is the next

 

1.- how i can see the 2 extra fields information in admin/orders.php (because only show name,adress,country,phone,ect) how i can do that bc i need that information to complete the sale

 

2.- how the ppl can edit this 2 extra fields anytime when they are buying someting before complete all transaction???

 

thanks for all

really :)

[♥geoffreywalton]

1. You would need to some extra sql to the code and display the fields. Probably be able to use the code in the contribution as a guide.

 

2. Might be better to add a contribution that allows the customer to add text when ordering a product.

 

G

[pelotuo]

the 2 fields are ok

 

i have the contribution "customers_extra_fields" installed and working

and inside the database i see the information when a new user write in the 2 extra fields

 

my qustion is the same

 

1.- how i can see the 2 extra fields information inside admin/orders.php (because only show name,adress,country,phone,ect) how i can do that bc i need that information to complete the sale

 

 

i have the contribution "customers_extra_fields" installed and the tables are here

 

 

2.- how the ppl can edit this 2 extra fields anytime when they are buying someting before complete all transaction???

 

the 2º isn't very important but the first yes :P

 

thanks for all

[pelotuo]

PS: i see the 2 extra field and the information wrote inside when i edit 1 customer

 

1.- how i can see the 2 extra fields information inside admin/orders.php (because only show name,adress,country,phone,ect) how i can do that bc i need that information to complete the sale???

[juniorprg]

this is some example i used to help a user...what this example does is showing mobile no in admin/order.php

 

insert this code

$the_extra_query= tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

$the_extra= tep_db_fetch_array($the_extra_query);

$the_customers_id= $the_extra['customers_id'];

// Look up things in customers

$the_extra_query= tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $the_customers_id . "'");

$the_extra= tep_db_fetch_array($the_extra_query);

$the_customers_fax= $the_extra['customers_mobile'];

 

below this code

 

if (!tep_db_num_rows($orders_query)) {

$order_exists = false;

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');

}

}

 

and above this

include(DIR_WS_CLASSES . 'order.php');

 

 

 

and call it whereever you want to call in order.phpusing this

<tr>

<td class="main"><b><?php echo 'Mobile #:'; ?></b></td>

<td class="main"><?php echo $the_customers_mobile; ?></td>

</tr>

 

this example is under the assumption that their is field already in the table and users are able to fill info into this field during checkout

[juniorprg]

also i think there is a contribution that will include a field in the checkout process that users can use to add comments about their order...i think this answers your answer2