[Skip to main content](#vessel-content) # How do I add fields to filter orders by? ## - **[jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile")** - [![jberry210490's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6511-jberry210490 "View jberry210490's Profile") Topic Author - [ Offline](/forum/user/6511-jberry210490) Less More - Posts: 76 - Thank you received: 2 - - - 11 years 7 months ago - 11 years 7 months ago [\#195543](#195543) by [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile") *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#195543 "-- 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")* was created by *[jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile")* -- url of the page with the problem -- : [ www.claycellar.co.uk](http://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 Last edit: 11 years 7 months ago by [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/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) - 11 years 7 months ago [\#195549](#195549) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#195549 "-- 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. The following user(s) said Thank You: [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile")** - [![jberry210490's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6511-jberry210490 "View jberry210490's Profile") Topic Author - [ Offline](/forum/user/6511-jberry210490) Less More - Posts: 76 - Thank you received: 2 - - - 11 years 7 months ago [\#195767](#195767) by [jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile") Replied by *[jberry210490](/forum/user/6511-jberry210490 "View jberry210490's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#195767 "-- 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")* Thanks for this. It helped me get the job done much faster than it would have otherwise taken. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile")** - [![maxlamenaxme's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39097.png)](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") - [ Offline](/forum/user/39097-maxlamenaxme) Less More - Posts: 17 - Thank you received: 0 - - 10 years 10 months ago - 10 years 10 months ago [\#225460](#225460) by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") Replied by *[maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#225460 "-- 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")* 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 : Code: <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> and added : Code: $shippings= $pluginClass->getMethods('shipping'); in the "administrator/components/com_hikashop/views/order/view.html.php", function "listing()" But this keeps showing only the shipping_id and not the shipping_name... The additional toolbar button I would like to add (see image) should probably be the subject of another post right ? Thank you for your help. - [ ![orders.png](/forum/attachment/28696) ](/forum/attachment/28696 "orders.png") [ ](/forum/attachment/28696?download=1 "orders.png") Last edit: 10 years 10 months ago by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 10 months ago [\#225517](#225517) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#225517 "-- 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 need to add the line: Code: $this->assignRef('shippings", $shippings); after the line: Code: $shippings= $pluginClass->getMethods('shipping'); otherwise, $shippings won't be available as $this->shippings in the view file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile")** - [![maxlamenaxme's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39097.png)](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") - [ Offline](/forum/user/39097-maxlamenaxme) Less More - Posts: 17 - Thank you received: 0 - - 10 years 10 months ago - 10 years 10 months ago [\#225763](#225763) by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") Replied by *[maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#225763 "-- 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")* 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 ! Last edit: 10 years 10 months ago by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 10 months ago [\#225823](#225823) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#225823 "-- 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, Ah yes, sorry for the typo. Regarding the addition of a filter for the orders, you can add code similar to the payment dropdown after the line: echo $this->payment->display("filter_payment",$this->pageInfo->filter->filter_payment,false); Like that: $shipping = hikashop_get('type.shipping'); $this->assignRef('shipping',$shipping); echo $this->shipping->display("filter_shipping",$this->pageInfo->filter->filter_shipping,false); But then, to have it processed by the MySQL query loading the orders, you can't do that in a view override. So you would have to either hack the file administrator/components/com_hikashop/views/order/view.html.php with code similar to what is there for the payment, or create a new hikashop plugin implementing the onBeforeOrderListing trigger in order to add your filter to the query via the plugin. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile")** - [![maxlamenaxme's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39097.png)](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") - [ Offline](/forum/user/39097-maxlamenaxme) Less More - Posts: 17 - Thank you received: 0 - - 10 years 9 months ago [\#227139](#227139) by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") Replied by *[maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#227139 "-- 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")* 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... ![;)](/media/kunena/emoticons/24.png ";)") ) 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 ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 9 months ago [\#227141](#227141) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#227141 "-- 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, There is no shipping filter plugin. The code is directly in the core files of HikaShop as you can see in the view.html.php file. And you won't be able to use the payment plugin in AcyMailing by doing that. You would have to modify the AcyMailing HikaShop plugin in that case. If you're not a developer, I'm afraid you'll have to contact one in order to help you with all that as it's more complex than just one or two lines of code. You can potentially contact our partners on this page for that: [ www.hikashop.com/home/our-partners.html](http://www.hikashop.com/home/our-partners.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile")** - [![maxlamenaxme's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39097.png)](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") - [ Offline](/forum/user/39097-maxlamenaxme) Less More - Posts: 17 - Thank you received: 0 - - 10 years 9 months ago [\#227207](#227207) by [maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile") Replied by *[maxlamenaxme](/forum/user/39097-maxlamenaxme "View maxlamenaxme's Profile")* on topic *[How do I add fields to filter orders by?](/forum/35-orders-management/875819-how-do-i-add-fields-to-filter-orders-by#227207 "-- 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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3NTgxOS1ob3ctZG8taS1hZGQtZmllbGRzLXRvLWZpbHRlci1vcmRlcnMtYnk/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.076 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)