[Skip to main content](#vessel-content) # How do I add additional fields to the notification of a new order of the goods? ## - **[Denys](/forum/user/38002-denys "View Denys's Profile")** - [![Denys's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38002-denys "View Denys's Profile") Topic Author - [ Offline](/forum/user/38002-denys) Less More - Posts: 77 - Thank you received: 1 - - 9 years 11 months ago [\#255350](#255350) by [Denys](/forum/user/38002-denys "View Denys's Profile") *[How do I add additional fields to the notification of a new order of the goods?](/forum/4-how-to/887509-how-do-i-add-additional-fields-to-the-notification-of-a-new-order-of-the-goods#255350 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 Hi! I created an additional field when ordering through the basket. And i want when the person their fills so that they appear in the letter at the mail. INSERT INTO `cwi8p_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_street2`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`, `address_default`, `mlstrana`, `mldostavka`, `mlotdelenie`, `mlgorod`, `mlgoroda`, `mlindex`, `mloblast`, `mlulichay`, `mldom`, `mldostavkaross`, `mlindexross`, `mloblastross`, `mlgorodross`, `mlulichayross`, `mldomross`, `mldostavkabel`, `mlindexbel`, `mloblastbel`, `mlgorodbel`, `mlulichaybel`, `mldombel`, `mlgorodnewpost`) VALUES вот мои поля из mysql where I can be fit? which file. I thought they should be automatically added to the mail")* was created by *[Denys](/forum/user/38002-denys "View Denys's Profile")* -- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 Hi! I created an additional field when ordering through the basket. And i want when the person their fills so that they appear in the letter at the mail. INSERT INTO `cwi8p_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_street2`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`, `address_default`, `mlstrana`, `mldostavka`, `mlotdelenie`, `mlgorod`, `mlgoroda`, `mlindex`, `mloblast`, `mlulichay`, `mldom`, `mldostavkaross`, `mlindexross`, `mloblastross`, `mlgorodross`, `mlulichayross`, `mldomross`, `mldostavkabel`, `mlindexbel`, `mloblastbel`, `mlgorodbel`, `mlulichaybel`, `mldombel`, `mlgorodnewpost`) VALUES вот мои поля из mysql where I can be fit? which file. I thought they should be automatically added to the mail Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg4NzUwOS1ob3ctZG8taS1hZGQtYWRkaXRpb25hbC1maWVsZHMtdG8tdGhlLW5vdGlmaWNhdGlvbi1vZi1hLW5ldy1vcmRlci1vZi10aGUtZ29vZHM/dG1wbD1tYXJrZG93bg==) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14294 - - 9 years 11 months ago [\#255382](#255382) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How do I add additional fields to the notification of a new order of the goods?](/forum/4-how-to/887509-how-do-i-add-additional-fields-to-the-notification-of-a-new-order-of-the-goods#255382 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 Hi! I created an additional field when ordering through the basket. And i want when the person their fills so that they appear in the letter at the mail. INSERT INTO `cwi8p_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_street2`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`, `address_default`, `mlstrana`, `mldostavka`, `mlotdelenie`, `mlgorod`, `mlgoroda`, `mlindex`, `mloblast`, `mlulichay`, `mldom`, `mldostavkaross`, `mlindexross`, `mloblastross`, `mlgorodross`, `mlulichayross`, `mldomross`, `mldostavkabel`, `mlindexbel`, `mloblastbel`, `mlgorodbel`, `mlulichaybel`, `mldombel`, `mlgorodnewpost`) VALUES вот мои поля из mysql where I can be fit? which file. I thought they should be automatically added to the mail")* Hi, No, they are not automatically added. You need to edit the "address_template" file for both your frontend and backend template and add the corresponding tags for the custom fields of the table "address". The following user(s) said Thank You: [Denys](/forum/user/38002-denys "View Denys's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg4NzUwOS1ob3ctZG8taS1hZGQtYWRkaXRpb25hbC1maWVsZHMtdG8tdGhlLW5vdGlmaWNhdGlvbi1vZi1hLW5ldy1vcmRlci1vZi10aGUtZ29vZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Denys](/forum/user/38002-denys "View Denys's Profile")** - [![Denys's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38002-denys "View Denys's Profile") Topic Author - [ Offline](/forum/user/38002-denys) Less More - Posts: 77 - Thank you received: 1 - - 9 years 11 months ago [\#255505](#255505) by [Denys](/forum/user/38002-denys "View Denys's Profile") Replied by *[Denys](/forum/user/38002-denys "View Denys's Profile")* on topic *[How do I add additional fields to the notification of a new order of the goods?](/forum/4-how-to/887509-how-do-i-add-additional-fields-to-the-notification-of-a-new-order-of-the-goods#255505 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 Hi! I created an additional field when ordering through the basket. And i want when the person their fills so that they appear in the letter at the mail. INSERT INTO `cwi8p_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_street2`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`, `address_default`, `mlstrana`, `mldostavka`, `mlotdelenie`, `mlgorod`, `mlgoroda`, `mlindex`, `mloblast`, `mlulichay`, `mldom`, `mldostavkaross`, `mlindexross`, `mloblastross`, `mlgorodross`, `mlulichayross`, `mldomross`, `mldostavkabel`, `mlindexbel`, `mloblastbel`, `mlgorodbel`, `mlulichaybel`, `mldombel`, `mlgorodnewpost`) VALUES вот мои поля из mysql where I can be fit? which file. I thought they should be automatically added to the mail")* Thank you so much Nicolas! Where can I change the view of letter? ![=)](/smile.gif "=)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg4NzUwOS1ob3ctZG8taS1hZGQtYWRkaXRpb25hbC1maWVsZHMtdG8tdGhlLW5vdGlmaWNhdGlvbi1vZi1hLW5ldy1vcmRlci1vZi10aGUtZ29vZHM/dG1wbD1tYXJrZG93bg==) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14294 - - 9 years 11 months ago [\#255506](#255506) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How do I add additional fields to the notification of a new order of the goods?](/forum/4-how-to/887509-how-do-i-add-additional-fields-to-the-notification-of-a-new-order-of-the-goods#255506 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 Hi! I created an additional field when ordering through the basket. And i want when the person their fills so that they appear in the letter at the mail. INSERT INTO `cwi8p_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_street2`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`, `address_default`, `mlstrana`, `mldostavka`, `mlotdelenie`, `mlgorod`, `mlgoroda`, `mlindex`, `mloblast`, `mlulichay`, `mldom`, `mldostavkaross`, `mlindexross`, `mloblastross`, `mlgorodross`, `mlulichayross`, `mldomross`, `mldostavkabel`, `mlindexbel`, `mloblastbel`, `mlgorodbel`, `mlulichaybel`, `mldombel`, `mlgorodnewpost`) VALUES вот мои поля из mysql where I can be fit? which file. I thought they should be automatically added to the mail")* Hi, What do you mean by "the view of letter" ? Could you provide a screenshot of what you mean ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg4NzUwOS1ob3ctZG8taS1hZGQtYWRkaXRpb25hbC1maWVsZHMtdG8tdGhlLW5vdGlmaWNhdGlvbi1vZi1hLW5ldy1vcmRlci1vZi10aGUtZ29vZHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Denys](/forum/user/38002-denys "View Denys's Profile")** - [![Denys's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/38002-denys "View Denys's Profile") Topic Author - [ Offline](/forum/user/38002-denys) Less More - Posts: 77 - Thank you received: 1 - - 9 years 11 months ago [\#255848](#255848) by [Denys](/forum/user/38002-denys "View Denys's Profile") Replied by *[Denys](/forum/user/38002-denys "View Denys's Profile")* on topic *[How do I add additional fields to the notification of a new order of the goods?](/forum/4-how-to/887509-how-do-i-add-additional-fields-to-the-notification-of-a-new-order-of-the-goods#255848 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 Hi! I created an additional field when ordering through the basket. And i want when the person their fills so that they appear in the letter at the mail. INSERT INTO `cwi8p_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_street2`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`, `address_default`, `mlstrana`, `mldostavka`, `mlotdelenie`, `mlgorod`, `mlgoroda`, `mlindex`, `mloblast`, `mlulichay`, `mldom`, `mldostavkaross`, `mlindexross`, `mloblastross`, `mlgorodross`, `mlulichayross`, `mldomross`, `mldostavkabel`, `mlindexbel`, `mloblastbel`, `mlgorodbel`, `mlulichaybel`, `mldombel`, `mlgorodnewpost`) VALUES вот мои поля из mysql where I can be fit? which file. I thought they should be automatically added to the mail")* This is [ prnt.sc/dad567](http://prnt.sc/dad567) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg4NzUwOS1ob3ctZG8taS1hZGQtYWRkaXRpb25hbC1maWVsZHMtdG8tdGhlLW5vdGlmaWNhdGlvbi1vZi1hLW5ldy1vcmRlci1vZi10aGUtZ29vZHM/dG1wbD1tYXJrZG93bg==) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14294 - - 9 years 11 months ago [\#255851](#255851) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How do I add additional fields to the notification of a new order of the goods?](/forum/4-how-to/887509-how-do-i-add-additional-fields-to-the-notification-of-a-new-order-of-the-goods#255851 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.4.8 -- PHP version -- : 5.6 Hi! I created an additional field when ordering through the basket. And i want when the person their fills so that they appear in the letter at the mail. INSERT INTO `cwi8p_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_street2`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`, `address_default`, `mlstrana`, `mldostavka`, `mlotdelenie`, `mlgorod`, `mlgoroda`, `mlindex`, `mloblast`, `mlulichay`, `mldom`, `mldostavkaross`, `mlindexross`, `mloblastross`, `mlgorodross`, `mlulichayross`, `mldomross`, `mldostavkabel`, `mlindexbel`, `mloblastbel`, `mlgorodbel`, `mlulichaybel`, `mldombel`, `mlgorodnewpost`) VALUES вот мои поля из mysql where I can be fit? which file. I thought they should be automatically added to the mail")* Hi, That's an order notification email. You can edit it via the menu System>Emails. If you just want to modify the text of the email, you can instead use translation overrides: [ www.hikashop.com/download/languages.html#modify](https://www.hikashop.com/download/languages.html#modify) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg4NzUwOS1ob3ctZG8taS1hZGQtYWRkaXRpb25hbC1maWVsZHMtdG8tdGhlLW5vdGlmaWNhdGlvbi1vZi1hLW5ldy1vcmRlci1vZi10aGUtZ29vZHM/dG1wbD1tYXJrZG93bg==) 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.049 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)