Show custom field in order listing view

-- HikaShop version -- : 4.4.1
-- Joomla version -- : 3.9.24
-- PHP version -- : 7.3.27

Hello,

I want to show a custom field in the order listing view and I don't know how to acces to it, the custom field is located in item table.

<?php if(!empty($row->extraData->topLeft)) { echo implode("\r\n", $row->extraData->topLeft); } ?>
<a class="hika_order_number" href="<?php echo $order_link; ?>">
<span class="hika_order_number_title"><?php echo JText::_('ORDER_NUMBER'); ?> : </span>
<span class="hika_order_number_value"><?php echo $row->order_number; ?></span>
<?php if(!empty($row->order_invoice_number)) { ?>
<br class="hika_order_number_invoice_separator"/>
<span class="hika_invoice_number_title"></span>
<span class="hika_invoice_number_value"></span>

<?php echo CUSTOM FIELD;} ?>

hello,

In order to be more specific in our answer can you details better your idea, can you precise the context like frontend or backend or better via an Url link ?
And any details, that help us to better understand your needs, the context, and any specific details.

Awaiting news from you to progress on your subject.
Regards

I want to show the custom field where is indicated in the screen capture.
Thanks so much

Hello,

This will required advanced view override and good knowledge of html & php.
Plus, I draw your attention to the fact that the items are dependent on the products, meaning that each Item Custom field is linked to one product.
Maybe display as a start the product name, and not only then the Item Custom field will be a good way.
I think that you can take a good example in the order/show.


The code part that manage the item custom field is around line 240.
Hope this will help you to achieved what you need.
Regards

This is the custom field that I want to show in the order / listing.php view. I tried with this code but I can't acces to the field.
Please, just show me the way to acces to the custom field value.

Hello,

Please, provide a complete custom field setting screenshot and in English in order to help us to better understand the situation.
For your provided code please provide more details about how do you create it, Template association, view references, line where you paste your custom code, and/or after which original code part.

Awaiting your elements to be able to guide you.
Regards

First of all excuse me for the undetailed question
This is the complete screenshot of the custom field.


And this is where I want to show it, in the order / listing.php view.


Thanks for your time and attention.
Fernando

Hi,

The problem is that there is an inconsistency between the custom field table and what you want to do.
An order can have several products. And your custom field is of the table "item" not "order", and thus for one order, you'll have a value of that custom field for each product in the order.
So either:
- you want to actually use a custom field of the table "order" and not "item" so that the custom field is linked to the order and not to each product of the order. In that case, you'll have display options to directly display the value there, without the need for any custom code.
- you want to use a custom field of the table "item" as you want to have the custom field for each product of the order. In that case, you first need to load the products of the order and then encapsulate your code in a foreach on the products. Something like that:

Hi,
Finally I have created a custom field in the order table, is better this way:


But I can't show it n the order/listing.php, I tried with this code extracted from order/show.php


Thanks again

Hi,

You don't need to add any code for the display of custom order fields on the orders listing.
They will display automatically if:
- the "backend listing" setting of the custom field is activated
- at least one order on the current listing has something entered in that custom field
So please check on that.

It is shown in the order/show.php


but in the order/listing.php it is NOT shown:


Thanks

Hi,

Ah, you're talking about the frontend order listing. I thought you were talking about the backend.
For the frontend, you'll indeed need to modify order / listing.php
However, it's really easy to do.
You can just add such code:
<?php echo $row->referencia; ?>

Now is working fine!!! Great!

Thanks so much