[Skip to main content](#vessel-content) # Add custom user field to Order Number format ## - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13407](#13407) by [momentis](/forum/user/364-momentis "View momentis's Profile") *[Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13407 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* was created by *[momentis](/forum/user/364-momentis "View momentis's Profile")* Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 15 years 6 months ago [\#13465](#13465) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13465 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Hi, If you add the code: if(preg_match_all('#\{([a-z_0-9]+)\}#i',$format,$matches)){ foreach($matches[1] as $match){ if(isset($data->$match)){ $format = str_replace('{'.$match.'}',$data->$match,$format); }else{ $format = str_replace('{'.$match.'}','',$format); } } } after the code: if(strpos($format,'{automatic_code}')!==false){ $format = str_replace('{automatic_code}',hikashop::base($id),$format); } in the file administrator/components/com_hikashop/helpers/helper.php you will be able to add tags for your custom order fields: {custom_field_column_name} We'll add that to next version. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13515](#13515) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13515 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Okay, I can now declare you to be a GENIUS!!! Thank you so, so much for this! Because of this, we can now perfectly match the online order numbers with our internally-generated ones. What a help!!! FYI - I posted a review on the JED (username: momentis) yesterday. I wish I could have written more. In nearly 5 years working within Joomla I have come across very, very few developers as responsive, polite and talented! Rick Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13516](#13516) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13516 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Nicolas, Your code sets up the order number perfectly. However, the emails that are being generated do not include the custom field. Any way to add this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13527](#13527) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13527 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Getting to understand this a little better. It seems, from looking at the database, that the order number is not stored in the "hikashop_order" table. When I change the configuration setting for generating the order number, all existing orders in the system will change to adopt the new structure. So it appears that the order number is really generated dynamically, based on the view, which would be why it did not appear in the emails. Would there be a way, in future versions, to have the generated order number stored statically within the database whenever the order is created? That way the order number would be consistent across the application. Any changes made to the order number structure in the configuration settings would, therefore, only affect ongoing orders. Just a suggestion! Rick Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 15 years 6 months ago [\#13531](#13531) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13531 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* The order numbers are indeed generated on the fly based on the order number format option. The goal was to avoid users asking why all their orders don't have the new format (yes...), and since you normally set the order number format before starting your shop, it doesn't matter to store the order number generated when the order was created. So far, no one had a problem with that way of doing it... We'll see. If others have the same remark we might change the system in the future, we'll see ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13533](#13533) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13533 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* I understand! My background is really in db development, so for me it seemed counter-intuitive to NOT store the order number. As a business, you run the risk of losing historical tracking of the order if someone changes the config setting. But I can certainly appreciate that you are providing what people want!!! Anyway, is there a way to get the order number into the emails? It is not using the custom field. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 15 years 6 months ago [\#13539](#13539) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13539 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Looking at the emails on our end, the order number is correctly replaced in them. Did you customize your emails ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13541](#13541) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13541 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* I commented out the pricing fields (our products have no prices), but that's about it. Let me try to revert back to the installed version and I will let you know. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13544](#13544) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13544 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Nope. Still not seeing it, even after removing my changes to the email. Here's what the store admin is seeing: > The order is now created. > > This notification was for the order -04072011-00022 on the website [ thegragroup.com/storefront/](http://thegragroup.com/storefront/) > Total : $0.00 > You can access the order details directly by clicking on the link below after logging in your back end: > [ thegragroup.com/storefront/administrator...ask=edit&order\_id=22](http://thegragroup.com/storefront/administrator/index.php?option=com_hikashop&ctrl=order&task=edit&order_id=22) The order number in the system is RLS-04072011-00022. Same in the email going to the person placing the order. I am using the latest version of HikaShop on Joomla 1.6.1 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 15 years 6 months ago [\#13545](#13545) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13545 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* What order format are you using ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13548](#13548) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13548 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Do you mean Order Number format? I am using: {cust_code}-{date format="mdY"}-{id size="5"} Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 15 years 6 months ago [\#13550](#13550) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13550 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* We tried again but we correctly see the order number. When you say you removed your changes , do you mean that you removed the customization of your emails using the trash icon available on the listing of emails ? If you edit your emails, what is the version written at the top ? Maybe you're using a previous version email ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13551](#13551) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13551 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Sorry, yes. I used the trashcan to remove the changes. The top of the email shows: Code: /** * @package HikaShop for Joomla! * @version 1.4.8 * @author hikashop.com * @copyright (C) 2010 HIKARI SOFTWARE. All rights reserved. * @license http://www.hikashop.com/commercial_license.php */ Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13555](#13555) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13555 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* It is also not showing the order number correctly under CUSTOMER ACCOUNT > ORDERS on the front-end. I am attaching a screenshot. [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/order_screen.jpg) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/order_screen.jpg "[img") - [ ![order_screen.jpg](/forum/attachment/904) ](/forum/attachment/904 "order_screen.jpg") [ ](/forum/attachment/904?download=1 "order_screen.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 15 years 6 months ago [\#13557](#13557) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13557 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Could you do a screenshot of the options of your custom field because that's the only thing left I can see... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13559](#13559) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13559 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Sure! Here is the screenshot of the custom field. [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/customer_code.jpg) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/customer_code.jpg "[img") - [ ![customer_code.jpg](/forum/attachment/905) ](/forum/attachment/905 "customer_code.jpg") [ ](/forum/attachment/905?download=1 "customer_code.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 15 years 6 months ago [\#13563](#13563) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13563 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* Ah ! Something I overlooked in your message is that you're using a custom user field. The modification I posted allows you to do it for custom order fields and not really for custom user fields. It's just that the information is loaded there in some places. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13564](#13564) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13564 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* I set up a Super User account for you, and can get you the credentials if you want to get into the system. I don't mind. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[momentis](/forum/user/364-momentis "View momentis's Profile")** - [![momentis's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar364.jpg)](/forum/user/364-momentis "View momentis's Profile") Topic Author - [ Offline](/forum/user/364-momentis) Less More - Posts: 202 - Thank you received: 2 - - 15 years 6 months ago [\#13566](#13566) by [momentis](/forum/user/364-momentis "View momentis's Profile") Replied by *[momentis](/forum/user/364-momentis "View momentis's Profile")* on topic *[Re: Add custom user field to Order Number format](/forum/4-how-to/13407-add-custom-user-field-to-order-number-format#13566 "Nicolas, I have created a custom user field named "Customer Number". This number matches our internal tracking system. Is there a way to include this field in the Custom Order Number Format? Ideally, my order number would be: {customer_no}-{full date of order}-{sequential ID} I can get the date and ID just as I'd like them, but can't figure out how (if) I can include the customer number. Thanks!!! Rick")* So is there a way to accomplish this? It would work just fine if the order number was stored in the database ![;-)](/media/kunena/emoticons/14.png ";-)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNDA3LWFkZC1jdXN0b20tdXNlci1maWVsZC10by1vcmRlci1udW1iZXItZm9ybWF0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.488 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)