[Skip to main content](#vessel-content)

#   How can I insert a column with product code in the backend in the new version 3

##

- **[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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

9 years 1 month ago -  6 years 4 months ago [\#279676](#279676) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#279676 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")* was created by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")*

-- HikaShop version -- : 3.2
-- Joomla version -- : 3.8
-- PHP version -- : 7.1
-- Browser(s) name and version -- : chrome

Hello,
In previous verions, I could insert a column in the backend, with the product code, as you can see below:

[attachme  [ ![hika-01.jpg](/forum/attachment/49902) ](/forum/attachment/49902 "hika-01.jpg")

In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.

Thank you so much

- [ ![hika-01.jpg](/forum/attachment/49902) ](/forum/attachment/49902 "hika-01.jpg") [ ](/forum/attachment/49902?download=1 "hika-01.jpg")

Last edit: 6 years 4 months ago by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile"). Reason: The image show personal data

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

9 years 1 month ago [\#279679](#279679) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#279679 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hello,

Nothing changed since previous versions for the back-end product listing, so the solution will still be to directly adapt the code of the "Listing" file of the "Product" view of your front-end template.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

6 years 4 months ago [\#321371](#321371) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321371 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hello,

Hello,

I have updated to HikaShop Business version: 4.3.0.
With your excellent help, I made some modifications to the files:

administrator / components / com_hikashop / views / order / view.html.php
and
screen -&gt; Views -&gt; order -&gt; listing

Some changes so that the username, address telephone and product code fields appear in the list of orders in the administration.

[ ![screen-1&#95;2020-06-27.jpg](/forum/attachment/49894) ](/forum/attachment/49894 "...2020-06-27.jpg")

Those fields continue to appear in the order list, but when placing a new order from the administration, assigning a user and adding their data, the fields are not filled out, they are left blank.

[ ![screen-2.jpg](/forum/attachment/49895) ](/forum/attachment/49895 "screen-2.jpg")

[ ![screen-3.jpg](/forum/attachment/49896) ](/forum/attachment/49896 "screen-3.jpg")

I have tried to fix it by myself, but am not able to. Can you give me a hand.

Thank you very much and congratulations on the constant updates and better.

A cordial greeting.

- [ ![screen-1&#95;2020-06-27.jpg](/forum/attachment/49894) ](/forum/attachment/49894 "...2020-06-27.jpg") [ ](/forum/attachment/49894?download=1 "...2020-06-27.jpg")
- [ ![screen-2.jpg](/forum/attachment/49895) ](/forum/attachment/49895 "screen-2.jpg") [ ](/forum/attachment/49895?download=1 "screen-2.jpg")
- [ ![screen-3.jpg](/forum/attachment/49896) ](/forum/attachment/49896 "screen-3.jpg") [ ](/forum/attachment/49896?download=1 "screen-3.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

6 years 4 months ago [\#321397](#321397) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321397 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi,

From what I can see, these are custom address fields.
So you can change them by editing the billing or shipping address of the order.
The update didn't change anything to that.

The following user(s) said Thank You: [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

6 years 4 months ago -  6 years 4 months ago [\#321430](#321430) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321430 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hello,

Thanks for your quick response.

I already had it configured in both and the data is not loaded.

[ ![Sinttulo-1&#95;2020-06-29.jpg](/forum/attachment/49905) ](/forum/attachment/49905 "...2020-06-29.jpg")

Also errors come out in case of putting the web in error report

[ ![Sinttulo-2-.jpg](/forum/attachment/49908) ](/forum/attachment/49908 "Sinttulo-2-.jpg")

[ ![Sinttulo-3.jpg](/forum/attachment/49907) ](/forum/attachment/49907 "Sinttulo-3.jpg")

thank you for your attention.

- [ ![Sinttulo-1&#95;2020-06-29.jpg](/forum/attachment/49905) ](/forum/attachment/49905 "...2020-06-29.jpg") [ ](/forum/attachment/49905?download=1 "...2020-06-29.jpg")
- [ ![Sinttulo-2&#95;2020-06-29.jpg](/forum/attachment/49906) ](/forum/attachment/49906 "...2020-06-29.jpg") [ ](/forum/attachment/49906?download=1 "...2020-06-29.jpg")
- [ ![Sinttulo-3.jpg](/forum/attachment/49907) ](/forum/attachment/49907 "Sinttulo-3.jpg") [ ](/forum/attachment/49907?download=1 "Sinttulo-3.jpg")
- [ ![Sinttulo-2-.jpg](/forum/attachment/49908) ](/forum/attachment/49908 "Sinttulo-2-.jpg") [ ](/forum/attachment/49908?download=1 "Sinttulo-2-.jpg")

Last edit: 6 years 4 months ago by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile"). Reason: personal data view

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

6 years 4 months ago [\#321441](#321441) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321441 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi,

Ah, so you're saying that the issue is with the addresses not being automatically filled with the address of the customer when you change it ?
That's a bug. Download the install package of HikaShop on our website and install it on yours and it will add a patch for that.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

6 years 4 months ago -  6 years 4 months ago [\#321480](#321480) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321480 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi Nicolas,

With the file of the update the custom fields come out very well, and the client's data is loaded when a new order is successfully made.

But I can't make the product code appear, in the list of orders (in my case it is only one product per order).

Nor manage to perform searches for the product code.

Now I have the file view.html.php placed. Original of the update and the result of the display is correct in the custom fields, but the column of the product code appears blank.

Thanks, best regard.

Last edit: 6 years 4 months ago by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

6 years 4 months ago -  6 years 4 months ago [\#321485](#321485) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321485 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi,

You need to update to the latest version of HikaShop and use the default view.html.php file and it will work fine. Then, just add your modifications again to the new version of the file.
I suppose it should be a few lines of PHP and a MySQL query to load the product data from the hikashop_order_product table and add it to each order object.

Last edit: 6 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile").

The following user(s) said Thank You: [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

6 years 4 months ago -  6 years 4 months ago [\#321558](#321558) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321558 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi Nicilás:

Thank you very much for your indications and sorry for not having understood before.
I've only had one problem:
If the order_product_code field does not exist and you try to enter the order by clicking on the order number, you do not access the order details.

I have changed: Code:

&lt;td class="hikashop_order_payment_value"&gt; &lt;?php if(!empty($row-&gt;order_payment_method)){ if(!empty($this-&gt;payments[$row-&gt;order_payment_id])){ echo $this-&gt;payments[$row-&gt;order_payment_id]-&gt;payment_name; }elseif(!empty($this-&gt;payments[$row-&gt;order_payment_method])){ echo $this-&gt;payments[$row-&gt;order_payment_method]-&gt;payment_name; }else{ echo $row-&gt;order_payment_method; } } ?&gt; &lt;/td&gt;

For:
Code:

&lt;td class="hikashop_order_payment_value"&gt; &lt;?php echo $row-&gt;order_product_code;?&gt; &lt;/td&gt;

Thank you!

Last edit: 6 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

6 years 4 months ago [\#321568](#321568) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321568 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi,

I don't see why that would be the case with just that modification.
I can only think that you have another modification.
Could you give the URL you get when the link doesn't work ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

6 years 4 months ago [\#321586](#321586) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321586 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi Nicolas,

When I click on the order number in the administration list, it returns me to the order list again, only in the case where there is no product assigned in the order

Yes these are the changes that I have made.

On /mysite/administrator/components/com_hikashop/views/order/view.html.php

1.-

The original code:

$searchMap = array('c.id','c.username','c.name','a.user_email','b.order_user_id','b.order_number','b.order_id','b.order_invoice_number','b.order_invoice_id','b.order_full_price','d.address_firstname','d.address_lastname');

The midified code:

$searchMap = array('c.id','c.username','c.name','a.user_email','b.order_user_id','b.order_number','b.order_id','b.order_invoice_id','b.order_full_price','d.address_firstname','d.address_lastname','p.order_product_code');

2.-

The original code is:

$query = ' FROM '.hikashop_table('order').' AS b '.
' LEFT JOIN '.hikashop_table('address').' AS d ON b.order_billing_address_id = d.address_id '.
' 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 ' .
implode(' ', $tables) . ' ' . $filters . $order;
$database-&gt;setQuery('SELECT a.*,b.*,c.*,d.*'.$query, (int)$pageInfo-&gt;limit-&gt;start, (int)$pageInfo-&gt;limit-&gt;value);

The modified code is:

$query = ' FROM '.hikashop_table('order').' AS b '.
' LEFT JOIN '.hikashop_table('address').' AS d ON b.order_billing_address_id = d.address_id '.
' 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 ' .
' LEFT JOIN '.hikashop_table('order_product').' AS p ON b.order_id = p.order_id' .
implode(' ', $tables) . ' ' . $filters . $order;
$database-&gt;setQuery('SELECT a.*,b.*,c.*,d.*,p.*'.$query, (int)$pageInfo-&gt;limit-&gt;start, (int)$pageInfo-&gt;limit-&gt;value);

3.-

The original code is:

$searchMap = array(
'j_user.id',
'j_user.username',
'j_user.name',
'hk_user.user_email',
'hk_order.order_user_id',
'hk_order.order_id',
'hk_order.order_full_price'
);

The modified code is:

$searchMap = array(
'j_user.id',
'j_user.username',
'j_user.name',
'hk_user.user_email',
'hk_order.order_user_id',
'hk_order.order_id',
'hk_order.order_full_price',
'hk_order.order_product_code'
);

___

In HikaShop &gt; Display &gt; Views, edit the view "order / listing"

1.-
The Original code:

&lt;th class="hikashop_order_number_title title"&gt;
&lt;?php echo JHTML::_('grid.sort', JText::_('ORDER_NUMBER'), 'b.order_number', $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir,$this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value ); ?&gt;
&lt;br/&gt;
&lt;?php echo JHTML::_('grid.sort', JText::_('INVOICE_NUMBER'), 'b.order_invoice_number', $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir,$this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value ); ?&gt;
&lt;/th&gt;

The midified code:

&lt;th class="hikashop_order_number_title title"&gt;
&lt;?php echo JHTML::_('grid.sort', JText::_('ORDER_NUMBER'), 'b.order_number', $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir,$this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value ); ?&gt;
&lt;br/&gt;
&lt;/th&gt;

2.-

The original code:

&lt;th class="hikashop_order_payment_title title"&gt;
&lt;?php echo JHTML::_('grid.sort', JText::_('PAYMENT_METHOD'), 'b.order_payment_method', $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir,$this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value ); ?&gt;
&lt;/th&gt;

The midified code:

&lt;th class="hikashop_order_payment_title title"&gt;
&lt;?php echo JHTML::_('grid.sort', JText::_('Código'), 'b.order_payment_method', $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir,$this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value ); ?&gt;
&lt;/th&gt;

3.-

The original code:

&lt;th class="hikashop_order_id_title title"&gt;
&lt;?php echo JHTML::_('grid.sort', JText::_( 'ID' ), 'b.order_id', $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir, $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value ); ?&gt;
&lt;/th&gt;

The modified code:

&lt;th class="hikashop_order_id_title title"&gt;
&lt;?php echo JHTML::_('grid.sort', JText::_( 'Teléfono' ), 'b.order_id', $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir, $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value ); ?&gt;
&lt;/th&gt;
&lt;th class="hikashop_order_id_title title"&gt;
&lt;?php echo JHTML::_('grid.sort', JText::_( 'DNI' ), 'b.order_id', $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;dir, $this-&gt;pageInfo-&gt;filter-&gt;order-&gt;value ); ?&gt;
&lt;/th&gt;

Thanks very much

4.-

The original code:

&lt;?php if(!empty($row-&gt;order_invoice_number)) {
if($this-&gt;manage){ ?&gt;
&lt;a title="&lt;?php echo JText::_('INVOICE_NUMBER'); ?&gt;" href="&lt;?php echo hikashop_completeLink('order&amp;task=edit&amp;cid[]='.$row-&gt;order_id.'&amp;cancel_redirect='.urlencode(base64_encode(hikashop_completeLink('order')))).$target; ?&gt;"&gt;
&lt;?php } ?&gt;
&lt;?php echo '&lt;br/&gt;'.$row-&gt;order_invoice_number; ?&gt;
&lt;?php if($this-&gt;manage){ ?&gt;

The modified code:

&lt;?php if(!empty($row-&gt;order_invoice_number)) {
if($this-&gt;manage){ ?&gt;
&lt;a title="&lt;?php echo JText::_('INVOICE_NUMBER'); ?&gt;" href="&lt;?php echo hikashop_completeLink('order&amp;task=edit&amp;cid[]='.$row-&gt;order_id.'&amp;cancel_redirect='.urlencode(base64_encode(hikashop_completeLink('order')))).$target; ?&gt;"&gt;
&lt;?php } ?&gt;

&lt;?php if($this-&gt;manage){ ?&gt;

5.-
The original code:

&lt;td class="hikashop_order_payment_value"&gt;
&lt;?php if(!empty($row-&gt;order_payment_method)){
if(!empty($this-&gt;payments[$row-&gt;order_payment_id])){
echo $this-&gt;payments[$row-&gt;order_payment_id]-&gt;payment_name;
}elseif(!empty($this-&gt;payments[$row-&gt;order_payment_method])){
echo $this-&gt;payments[$row-&gt;order_payment_method]-&gt;payment_name;
}else{
echo $row-&gt;order_payment_method;
}
} ?&gt;
&lt;/td&gt;

The modified code:

&lt;td class="hikashop_order_payment_value"&gt;
&lt;?php echo $row-&gt;order_product_code; ?&gt;
&lt;/td&gt;

6.-
The original code:

&lt;td class="hikashop_order_id_value"&gt;
&lt;?php echo $row-&gt;order_id; ?&gt;
&lt;/td&gt;

The modified code:

&lt;td class="hikashop_order_id_value"&gt;
&lt;?php echo $row-&gt;address_telephone; ?&gt;
&lt;/td&gt;
&lt;td class="hikashop_order_id_value"&gt;
&lt;?php echo $row-&gt;username; ?&gt;
&lt;/td&gt;

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

6 years 4 months ago [\#321599](#321599) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321599 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi,

I don't see why that would be the case with just these modifications.
Could you give the URL you get when the link doesn't work ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

6 years 4 months ago [\#321601](#321601) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321601 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hello and thenks Nicolas,

I have made you a copy of the link.
When the page loads, it shows the list of orders.

[ universidadpopular.es/administrator/inde...=order&amp;task=edit&amp;cid](https://universidadpopular.es/administrator/index.php?option=com_hikashop&ctrl=order&task=edit&cid)[]=&amp;cancel_redirect=L2FkbWluaXN0cmF0b3IvaW5kZXgucGhwP29wdGlvbj1jb21faGlrYXNob3AmYW1wO2N0cmw9b3JkZXI%3D

A cordial greeting.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

6 years 4 months ago [\#321606](#321606) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321606 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi,

The order_id is missing in the cid[] parameter of the URL. This indicates that either $row-&gt;order_id is missing or that you're modified the code which generate the URL of the order number to not use the variable.

So please check that line in the file : Code:

&lt;a title="&lt;?php echo JText::_('ORDER_NUMBER'); ?&gt;" href="&lt;?php echo hikashop_completeLink('order&amp;task=edit&amp;cid[]='.$row-&gt;order_id.'&amp;cancel_redirect='.urlencode(base64_encode(hikashop_completeLink('order')))).$target; ?&gt;"&gt;

The following user(s) said Thank You: [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

6 years 4 months ago [\#321669](#321669) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#321669 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Sorry Nicolas,

I have made the following ccamnio and now it works perfectly.

My code with error
Code:

$query = ' FROM '.hikashop_table('order').' AS b '. ' LEFT JOIN '.hikashop_table('address').' AS d ON b.order_billing_address_id = d.address_id '. ' 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 ' . ' LEFT JOIN '.hikashop_table('order_product').' AS p ON b.order_id = p.order_id' . implode(' ', $tables) . ' ' . $filters . $order; $database-&gt;setQuery('SELECT a.*,b.*,c.*,d.*,p.*'.$query, (int)$pageInfo-&gt;limit-&gt;start, (int)$pageInfo-&gt;limit-&gt;value); $rows = $database-&gt;loadObjectList();

Rectified code:
Code:

$query = ' FROM '.hikashop_table('order').' AS b '. ' LEFT JOIN '.hikashop_table('address').' AS d ON b.order_billing_address_id = d.address_id '. ' 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 ' . ' INNER JOIN '.hikashop_table('order_product').' AS p ON b.order_id = p.order_id' . implode(' ', $tables) . ' ' . $filters . $order; $database-&gt;setQuery('SELECT a.*,b.*,c.*,d.*,p.*'.$query, (int)$pageInfo-&gt;limit-&gt;start, (int)$pageInfo-&gt;limit-&gt;value); $rows = $database-&gt;loadObjectList();

Thanks for everything, I really appreciate your constant help and patience.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

3 years 3 months ago -  3 years 3 months ago [\#353287](#353287) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#353287 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi Nicolas,

Is it possible to replace the marked values that appear in the column "Courses and activities" (products), by their corresponding codes (order_product_code)?
How could I make this substitution?
Would it be possible in this case to be able to search by code?

[ ![imagen1.jpg](/forum/attachment/57360) ](/forum/attachment/57360 "imagen1.jpg")

Thank you!

- [ ![imagen1.jpg](/forum/attachment/57360) ](/forum/attachment/57360 "imagen1.jpg") [ ](/forum/attachment/57360?download=1 "imagen1.jpg")

Last edit: 3 years 3 months ago by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

3 years 3 months ago [\#353290](#353290) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#353290 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi,

Edit the file order / listing for your backend template via the menu Display&gt;Views.
There, change the line: Code:

$products .= '&lt;li&gt;'.$p-&gt;order_product_name.' (x'.$p-&gt;order_product_quantity.')&lt;/li&gt;';

to: Code:

$products .= '&lt;li&gt;'.$p-&gt;order_product_code.' (x'.$p-&gt;order_product_quantity.')&lt;/li&gt;';

The following user(s) said Thank You: [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

3 years 3 months ago [\#353326](#353326) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#353326 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi Nicolas,

Thanks, it works perfectly, but I can't make searches that work in the search engine, entering the name of the course or the code.
Is there any way to get it?
Thanks again!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

3 years 3 months ago [\#353327](#353327) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#353327 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Hi,

For performance reasons, the search is only done on the hikashop_order table in the database. The data of the products in the order is in the table hikashop_order_product. So that's why the search doesn't return any result if you search for product codes.
I would recommend using this plugin:
[ www.hikashop.com/marketplace/product/272...-product-filter.html](https://www.hikashop.com/marketplace/product/272-orders-product-filter.html)
It adds a product filter on the order listing page so that you can easily select a product and have it filter the orders based on that selection.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) 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") Topic Author
- [ Offline](/forum/user/7721-dvddvd)

Less More

- Posts: 267
- Thank you received: 5
-
-
-
-

3 years 3 months ago [\#353333](#353333) by [dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")  Replied by *[dvddvd](/forum/user/7721-dvddvd "View dvddvd's Profile")* on topic *[How can I insert a column with product code in the backend in the new version 3](/forum/4-how-to/892201-how-can-i-insert-a-column-with-product-code-in-the-backend-in-the-new-version-3#353333 "-- HikaShop version -- : 3.2 -- Joomla version -- : 3.8 -- PHP version -- : 7.1 -- Browser(s) name and version -- : chrome  Hello, In previous verions, I could insert a column in the backend, with the product code, as you can see below:  &#91;attachme  In the current version 3.2, I tried several ways to make this modification, but I do not get the same result.  Thank you so much")*

Thanks very mach

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg5MjIwMS1ob3ctY2FuLWktaW5zZXJ0LWEtY29sdW1uLXdpdGgtcHJvZHVjdC1jb2RlLWluLXRoZS1iYWNrZW5kLWluLXRoZS1uZXctdmVyc2lvbi0zP3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.103 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
