save custom fields in checkout to user table

Hello,

I created a custom field, referee, in user table. My client required me to display an editable field during checkout for the first order and save this field to referee column in user table when submitting the order. Checkout process seemed to only deal with the custom field created in order table. Is there a way I can do this? Any hint is welcome.

Nicolas,

Thanks for the reply. my requirement is to have an editable field displayed during checkout and when the order is submitted, the value of this field will be saved into a field in user table I previously created. I know normally, the custom field created for checkout can be saved into order table, but instead of saving it into order table, I want to save it into user table - only for the first order the user created.

I am talking about having a text field displayed in the front-end checkout screen (the screen having payment/billing address/order) but being saved into user table.

But if I create a custom field in user table, it only show up in registration screen. It won't show up in the checkout screen. How can I make it show up in the checkout screen?

I need the same. I need some custom User fields (i.e. measurements) that are:
- stored in the user profile
- showed in the check-out process
- can be updated during check-out and stored back to the user profile

Preferably on a separate step in the check-out process.

I do not mind to do some programming if you could point me in the right direction.
EDIT: i.e. show fields on FIELDS step with a link to the registration page would be a start

Thanks in andvance

Thanks, I understand the concept. I need a bit more help though:

1. How do I display the specific user fields, assuming they all start with m_ (i.e. m_body_length, m_waist_length). I would like to use the foreach construct to loop through them and put them in a table, just like the custom fields are processed in the default view.

something like:

$user = hikashop_loadUser(true);
foreach($user->Fields as $field ...filter on fieldname starts with 'm_'...
{
...create table rows containing label and value...
}

2. How do I make them editable in this step, just like the custom fields are.

Sorry, I'm a c# man, just cannot figure out how to do it in php