Search options in 'Orders' page

  • Posts: 159
  • Thank you received: 2
4 years 5 months ago #319978

-- 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

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
4 years 5 months ago #319983

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.

Please Log in or Create an account to join the conversation.

  • Posts: 159
  • Thank you received: 2
4 years 5 months ago #320121

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

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
4 years 5 months ago #320126

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.

Please Log in or Create an account to join the conversation.

  • Posts: 159
  • Thank you received: 2
4 years 5 months ago #320156

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

Please Log in or Create an account to join the conversation.

  • Posts: 2143
  • Thank you received: 747
4 years 5 months ago #320163

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.


Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
4 years 5 months ago #320166

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

Please Log in or Create an account to join the conversation.

  • Posts: 195
  • Thank you received: 13
  • Hikashop Business
3 years 7 months ago #331135

Was this plug-in ever developed?


3by400, Inc.
3by400.com
Websites that Work, Marketing that Matters

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
3 years 7 months ago #331144

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.089 seconds
Powered by Kunena Forum