How do I add fields to filter orders by?

-- url of the page with the problem -- : www.claycellar.co.uk
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 2.5.14
-- Browser(s) name and version -- : Firefox

Hi there,

I want to be able to filter my orders by billing address. i.e. enter a name/postcode in the filter field and get all orders who's billing address satisfies this. Our odd arrangement has customers each with many billing addresses.

I'm aware this will need some coding, so am really just asking for pointers to "start the trail".

Is it as simple as adding some extra fields to a list that already exists somewhere? I'm guessing not...

Many thanks,

Jonathan

Hi,

You will have to edit the view "order / listing" in the backend template and in the file "administrator/components/com_hikashop/views/order/view.html.php", function "listing()" load the address table, etc.

Thanks for this. It helped me get the job done much faster than it would have otherwise taken.

Hello Xavier,

(first of all happy new year !)

I am struggling with a similar need.
I am using Hikashop Business 2.6.0
I would like to add a "shipping method" filter in the orders listing page (in the backend)

I already did modify the view "order / listing" in order to get what you can see in the attached image. (new column with orders shipping id)

Could you be more explicit concerning the changes to operate in order to get the additional "shipping method" filter ?
I also would lke to replace the shipping methods ids with their actual names.
For that purpose I tried with that in the order listing view :

<td class="hikashop_order_shipping_value">	
	<?php if(!empty($row->order_shipping_method)){
		if(!empty($this->shippings[$row->order_shipping_id])){
			echo $this->shippings[$row->order_shipping_id]->shipping_name;
		}elseif(!empty($this->shippings[$row->order_shipping_method])){
			echo $this->shippings[$row->order_shipping_method]->shipping_name;
		}else{
			echo $row->order_shipping_id;
		}
	} ?>
</td>

$shippings= $pluginClass->getMethods('shipping');

Thank you very much ! It works like a charm !

You just made a little mistake with the quote : $this->assignRef('shippings', $shippings);

Also, I would like to add the filter on top of the page (similar to the payment method drop down filter) to show only orders with such or such shipping method.

Could you help me with that ?

Thanks a lot again !

Ok thank you, I understand but my php/mySQL level is not sufficient to allow me to do that without a little bit more help. (sorry for than, I'm just a mechanical engineer... )

I think the best option for me would be the plugin option.

Tell me if I am wrong but I noticed that the payment filter also works with the acymailing plugin when adding users in the lists through filters.
I think taking the plugin option would allow me to use the shipping method filter also in acymailing. Right ?

I am then trying to locate where the payment filter plugin is to copy its code and transform it in shipping filter plugin.

Could you help me with that please ?

You are right, I just figured after writing my message that these filters were coded directly in the core files.

I will give it a try all the same, I sleep very little maybe that will allow me to make it.

Thank for the contacts, if necessary I will contact them.