[Skip to main content](#vessel-content) # Add a column to Sales View in Backend ## - **[RageHats](/forum/user/6919-ragehats "View RageHats's Profile")** - [![RageHats's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6919-ragehats "View RageHats's Profile") Topic Author - [ Offline](/forum/user/6919-ragehats) Less More - Posts: 1 - Thank you received: 0 - - 14 years 4 months ago [\#53045](#53045) by [RageHats](/forum/user/6919-ragehats "View RageHats's Profile") *[Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#53045 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* was created by *[RageHats](/forum/user/6919-ragehats "View RageHats's Profile")* I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up all the time, and they usually don't have their invoice number. I tried editing the sales view file in the views menu Even when I fully deleted that file, the sales view was unchanged. How can I add a column to the sales view in the backend? Thanks! Jesse RageHats.com Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 14 years 4 months ago [\#53132](#53132) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#53132 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Hi RageHats, You can d oit by editing the view order / listing.php in HikaShop > Display > Views. Then add: Code: $address_id = $row->order_shipping_address_id; $fieldClass = hikashop_get('class.field'); $addressClass = hikashop_get('class.address'); $order->fields = $fieldClass->getData('backend','address'); if(!empty($address_id)){ $order->name=$addressClass->get($address_id); } After: Code: $target = ''; if($this->popup) $target = '" target="_top'; $k = 0; for($i = 0,$a = count($this->rows);$i<$a;$i++){ $row =& $this->rows[$i]; And add a column with the value: Code: <?php echo $order->name->address_lastname; ?> Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 14 years 1 month ago [\#66533](#66533) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#66533 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* how I can replace the column "method of payment" for "product code" and that at the top: echo $ this-> payment-> display ("filter_payment", $ this-> PageInfo-> filter-> filter_payment, false); To output the filter by "Product Code" instead of "payment method". thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 14 years 1 month ago [\#66566](#66566) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#66566 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Hi dvddvd, Can you explain in more details what you need ? A sale have many products, so we can't add a filter on the product code in the listing of the sales. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 14 years 1 month ago [\#66603](#66603) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#66603 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Sorry, in my case only allows one product per order Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 14 years 1 month ago [\#66609](#66609) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#66609 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Ok so in your case, you can edit the file: "yourSite/administrator/components/com_hikashop/views/order/show.html.php And add the line: Code: $tables = ' INNER JOIN '.hikashop_table('order_product').' AS d ON b.order_id = d.order_id'; Just before: Code: $query = ' FROM '.hikashop_table('order').' AS b LEFT JOIN '.hikashop_table('user').' AS a ON b.order_user_id=a.user_id LEFT JOIN '.hikashop_table('users',false).' AS c ON a.user_cms_id=c.id '.$tables.$filters.$order; Then in HikaShop > Display > Views, edit the view "order / listing" And replace the title "Payment method" by "Product code", and replace: Code: <?php if(!empty($row->order_payment_method)){ if(!empty($this->payments[$row->order_payment_method])){ echo $this->payments[$row->order_payment_method]->payment_name; }else{ echo $row->order_payment_method; } } ?> By: Code: <?php echo $row->order_product_code; ?> Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 14 years 1 month ago - 14 years 1 month ago [\#66633](#66633) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#66633 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Hello Xavier thank you very much for your help I made ​​the following changes 1) add the following code: Code: $tables = ' INNER JOIN '.hikashop_table('order_product').' AS d ON b.order_id = d.order_id'; Just before of: Code: $query = ' FROM '.hikashop_table('order').' AS b LEFT JOIN '.hikashop_table('user').' AS a ON b.order_user_id=a.user_id LEFT JOIN '.hikashop_table('users',false).' AS c ON a.user_cms_id=c.id '.$tables.$filters.$order; Being the "/ administrator / components / com_hikashop / views / order / view.html.php" so: Code: code removed by the administrator. Please do not paste entire files here and also by changing the title and replacing the code that you show me, being so "listing.php" Code: code removed by the administrator. Please do not paste entire files here But I only get the code column empty and the upper flange as before. Thanks Last edit: 14 years 1 month ago by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 14 years 1 month ago [\#66643](#66643) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#66643 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Sorry for paste entire files. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 14 years 1 month ago - 14 years 1 month ago [\#66644](#66644) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#66644 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Oh I forgot one thing, , you need to add ",d.*" like this: Code: $database->setQuery('SELECT a.*,b.*,c.*,d.*'.$query,(int)$pageInfo->limit->start,(int)$pageInfo->limit->value); in the file: "yourSite/administrator/components/com_hikashop/views/order/view.html.php and in the function listing(). Add "d.order_product_code" in the searchmap: Code: $searchMap = array('c.id','c.username','c.name','a.user_email','b.order_user_id','b.order_number','b.order_id','b.order_full_price','d.order_product_code'); And then you can filter by product code in the filter field on the left. Last edit: 14 years 1 month ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 14 years 1 month ago [\#66658](#66658) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#66658 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* thank you very much now all right !!!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 14 years 1 month ago [\#67111](#67111) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#67111 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Hello again, I'm trying to replace the 'id column' by 'telephone', following the steps you've RageHats indicated earlier in this post, but I just get the blank column. thnaks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 14 years 1 month ago [\#67137](#67137) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#67137 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Hi dvddvd, You need to display "echo $order->name->address_telephone;" instead of "echo $order->name->address_lastname" like I said to RageHats. The following user(s) said Thank You: [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 14 years 1 month ago [\#67143](#67143) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#67143 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* ok operates correctly. Thank you very much Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 13 years 2 months ago [\#120712](#120712) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#120712 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Hello Xavier, We use HikaShop for university courses. We deleted all the orders last year and since then, the field added to order / listing is blank. I was using "echo $ order-> name-> address_telephone;?". What is the new command I use to take that data table address and field address_telephone ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 13 years 2 months ago [\#120716](#120716) 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 a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#120716 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* It's still the same. Are you sure that it's not because the address_telephone has been unpublished or something like that ? The following user(s) said Thank You: [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 13 years 2 months ago [\#120731](#120731) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#120731 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Thanks Xavier. I see that to enlist new orders from the administration and assign a customer, goes blank the form to the right which is where the data takes. Because if I put the phone there, if it appears Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 13 years 2 months ago [\#120736](#120736) 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 a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#120736 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* I'm not following you. Could you maybe give more information on the problem ? Maybe screenshots ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 13 years 2 months ago - 13 years 2 months ago [\#120743](#120743) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#120743 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* [ ![hbe16b2b.png](/forum/attachment/11942) ](/forum/attachment/11942 "hbe16b2b.png") In the screenshot I show you what I mean: 1. - I have assigned the customer Dulce Pascual. 2. - Load data into Student form 3. - Form STUDENT DATA - Billing, left blank I think in this last form, in the field where it takes the data phone address_telephone. So I do not go out, to call it from <td class="hikashop_order_id_value">              <? php echo $ order-> name-> address_telephone;?>            </ td> - [ ![hbe16b2b.png](/forum/attachment/11942) ](/forum/attachment/11942 "hbe16b2b.png") [ ](/forum/attachment/11942?download=1 "hbe16b2b.png") Last edit: 13 years 2 months ago by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 13 years 2 months ago [\#120753](#120753) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#120753 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* I only needed to change $ address_id = $ row-> order_shipping_address_id, for $ address_id = $ row-> order_billing_address_id, in <? php          $ target ='';          if ($ this-> popup)            $ target = "" target = "_top";          $ k = 0;          for ($ i = 0, $ a = count ($ this-> rows); $ i <$ a, $ i + +) {            $ row = & $ this-> rows [$ i];         $ address_id = $ row-> order_billing_address_id;         $ fieldClass = hikashop_get ('class.field');         $ AddressClass = hikashop_get ('class.address');         $ order-> fields = $ fieldClass-> getData ('backend', 'address');         if (! empty ($ address_id)) {         $ order-> name = $ AddressClass-> get ($ address_id);         }        ?> Thank very much Xavier Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")** - [![dvddvd's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7721-dvddvd "View dvddvd's Profile") - [ Offline](/forum/user/7721-dvddvd) Less More - Posts: 267 - Thank you received: 5 - - - - 11 years 8 months ago [\#188640](#188640) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile") Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[Re: Add a column to Sales View in Backend](/forum/4-how-to/53045-add-a-column-to-sales-view-in-backend#188640 "I am looking for a way to add a users last name to the sales view in the backend. I do not use user registration, so I am trying to pull the users shipping last name in the backend. Customers call up...")* Hi Xavier, I just upgrade to HikaShop bussiness. This modification we do not work anymore. In the country where the product code was to appear, is now blank. It could appear again in the updated version of the product code in this field. Thank You Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzUzMDQ1LWFkZC1hLWNvbHVtbi10by1zYWxlcy12aWV3LWluLWJhY2tlbmQ/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.740 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)