Customer Custom Fields

[lesliekirk]

My custom field condition foo is weak. I would like to be able to check to see if any customer might have a Customer Custom Field and then if it does be able to display the content of that field in the Printable Invoice used in the batch reports.

I'm trying to display a message for someone processing the order that a customer may have specific needs such as drop shipping, special labels, etc. This would be a constant that the customer should not have to enter in the Order Information type custom field. It would not be part of the checkout process but retained in the Customer Information.

[Nick]

You could add this to the Printable Invoice template:

<mvt:do file="l.customfields_module:module" name="l.success" value="CustomerFieldValue_Load_CodeAndCustomer( 'customer_customfield_code', l.settings:order:cust_id, l.settings:customer_customfield_code:field, l.settings:customer_customfield_code:value )" />
<mvt:if expr="l.settings:customer_customfield_code:value">
    &mvt:customer_customfield_code:value;
</mvt:if>

This will pull the value for the customer custom field and output if it is available.

Let me know if you have trouble implementing.

[Kent Multer]

Hi Nick,
Is there some reason why the usual mvt:item tag won't work on this template? E.g.

<mvt:item name="customfields" param="Read_Customer_ID( g.Customer:id, 'custom_field_code', l.settings:MyDestination )" />

[Nick]

Kent Multer No the only caveat with using the item tag is that you need to assign the item to the template. I was just being lazy and did not want to explain assigning the item to the template.

[Bruce - PhosphorMedia]

totally apropos of nothing, and this may be totally outside your realm, but why is the primary key 'l.settings:order:cust_id' not first? (otherwise, cool API call to know about).

[Nick]

Bruce - PhosphorMedia I do not think there is a specific reason but if I were to guess it would be because of the name of the function: CustomerFieldValue_Load_CodeAndCustomer

Code comes first in the order of the name.

[Bruce - PhosphorMedia]

well, that makes some sense. and as much as i try to keep my own code 'syntax' orthogonal, i have many a 'bad' moment.

[lesliekirk]

You could add this to the Printable Invoice template:

<mvt:do file="l.customfields_module:module" name="l.success" value="CustomerFieldValue_Load_CodeAndCustomer( 'customer_customfield_code', l.settings:order:cust_id, l.settings:customer_customfield_code:field, l.settings:customer_customfield_code:value )" />
<mvt:if expr="l.settings:customer_customfield_code:value">
&mvt:customer_customfield_code:value;
</mvt:if>

This will pull the value for the customer custom field and output if it is available.

Let me know if you have trouble implementing.

It didn't seem to pull anything in.

[Nick]

It didn't seem to pull anything in.

Can you show me what you added? Are you sure the variables customer ID and custom field are correct?

[lesliekirk]

Do I have to specify a single customer ID? If so, this isn't going to work the way I'd like it to.

[Nick]

Do I have to specify a single customer ID? If so, this isn't going to work the way I'd like it to.

No you can use a variable, what is the variable you are using?

[lesliekirk]

No you can use a variable, what is the variable you are using?

My Custom Customer Field code is "test"

<mvt:do file="l.customfields_module:module" name="l.success" value="CustomerFieldValue_Load_CodeAndCustomer( 'test', l.settings:order:cust_id, l.settings:customer_customfield_code:field, l.settings:customer_customfield_code:value )" />
<mvt:if expr="l.settings:customer_customfield_code:value"> &mvt:customer_customfield_code:value; </mvt:if>

[Kent Multer]

Just guessing here, but: for the above code snippet, does the variable l.customfields_module:module have a value? It looks to me like either it needs to be initialized, or maybe it's supposed to be "l.settings:..." instead of just "l...."

[lesliekirk]

Just guessing here, but: for the above code snippet, does the variable l.customfields_module:module have a value? It looks to me like either it needs to be initialized, or maybe it's supposed to be "l.settings:..." instead of just "l...."

That's a good question - what would the "module" be?

[Nick]

Sorry all, I got a little ahead of myself and forgot to add some code:

<mvt:do file="g.Module_Library_DB" name="l.loaded_module" value="Module_Load_Code_Cached( 'customfields', l.customfields_module )" />
<mvt:if expr="l.loaded_module">
    <mvt:do file="g.Module_Root $ l.customfields_module:module" name="l.success" value="CustomerFieldValue_Load_CodeAndCustomer( '
customer_customfield_code', l.settings:order:cust_id, l.customfield:field, l.customfield:value )" />
    <mvt:eval expr="decodeattribute(glosub(miva_array_serialize( l.customfield), ',', '<br>'))" />
</mvt:if>

All that being said the most optimized way of getting the customer custom field would be to assign the custom field item to the page then run the Read_Customer_ID function:

<mvt:item name="customfields" param="Read_Customer_ID( CUST_ID, 'custom_field_code', l.settings:customfields )" />

More information can be found here: https://docs.miva.com/template-langu...-documentation