Search options in 'Orders' page

-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.18

Hi,
we would need the possibility to sort orders by the clients countries and by ordered product. Is there a possibility to do this?
I attched a screenshot of the page where we want to have this function.
Thanks
Roger

Hi,

There is no option to add that, but it would be possible with some development.
You would have to develop a "hikashop" plugin, implementing the events :
- onBeforeOrderListing($paramBase, &$extrafilters, &$pageInfo, &$filters, &$tables, &$searchMap)
To be able to add conditions to the MySQL query searching for the orders in the $filters array
- onHikashopBeforeDisplayView(&$view)
To be able to add to the $view->extraFilters array an object with a method displayFilter($name, $data) to display the HTML of your filter.

Hi Nicolas,
thanks for your answer. Will this plugin show the search fields in the order view? The reason we need this search function is, to export invoices by country and payment option for our accountant. For instance: all invoices of the last month for France payed with PayPal.
Maybe there is another way to achieve this. If not, would you be able to do a plugin for us?
Thanks
Roger

Hi,

Yes, such plugin will add these search fields in the orders listing.
Now if you want to do an export of the orders data filtered on the payment method and country, it's possible with a mass action.
You can add a filter on the order column order_payment_method and a second filter on the billing or shipping address_country and have an action "export a CSV".
It's a bit of tinkering, but it should work fine.
But otherwise, we could develop such plugin for you, yes.

Hi Nicolas,
I thought about mass action, but I can only export a CSV. We need the invoice PDFs for our accountant. Could you please let me know how much it would cost, if you do it for us?
Thanks
Roger

Hi,

How I've done it:
1. If you don't have it yet, there's a PDF Invoice Plugin for just EUR 10.00
2. BCC the accountant on order status notification emails.
3. Client and accountant = happy.

Hi,

Such plugin development would cost 300€.
If you're interested, you can contact us with a link to this thread via our contact form:
www.hikashop.com/support/contact-us.html

Was this plug-in ever developed?

Hi,

No.
Between the PDF invoice plugin for PDFs and the mass action export for CSVs it covers a wide range of cases I suppose.