Backoffice Search Tracking number

[Pressed0024]

Surprised BO search bar cannot search by tracking number. Anyone with a quick fix for this?

[vekia]

back office search bar searching only features in the store, as i understood - you want to search in the orders by tracking number?

[JaivyDaam]

Hello,

 

sorry to bump this 1 year old post, but i also want this. just as you stated vekia. search orders by tracking number.

 

I am on 1.6.0.5

[vekia]

 

 

 

controllers/admin/adminOrdersController.php

 

 

use this code for $this->_join

	$this->_join = '
		LEFT JOIN `'._DB_PREFIX_.'customer` c ON (c.`id_customer` = a.`id_customer`)
		INNER JOIN `'._DB_PREFIX_.'address` address ON address.id_address = a.id_address_delivery
		INNER JOIN `'._DB_PREFIX_.'country` country ON address.id_country = country.id_country
		INNER JOIN `'._DB_PREFIX_.'country_lang` country_lang ON (country.`id_country` = country_lang.`id_country` AND country_lang.`id_lang` = '.(int)$this->context->language->id.')
		LEFT JOIN `'._DB_PREFIX_.'order_state` os ON (os.`id_order_state` = a.`current_state`)
        LEFT JOIN `'._DB_PREFIX_.'order_carrier` oc ON a.`id_order` = oc.`id_order`
		LEFT JOIN `'._DB_PREFIX_.'order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = '.(int)$this->context->language->id.')';

and for $this->fields_list use this one:

	$this->fields_list = array(
			'id_order' => array(
				'title' => $this->l('ID'),
				'align' => 'text-center',
				'class' => 'fixed-width-xs'
			),
			'reference' => array(
				'title' => $this->l('Reference')
			),
            'tracking_number' => array(
		'title' => $this->l('tracking number'),
                'havingFilter' => true,
			),
...
...
...
...

effects above :-)

[JaivyDaam]

Awesome! Thank you!

[vekia]

here is the guide:

http://mypresta.eu/en/art/developer/tracking-number-orders-list.html