Custom advanced filters

Hi @rivmedia

Is there anyway we can add our own advanced filter, for example if we have a custom field “supplier_field” , we’d like to “Supplier” as a filter and then search based on the custom field values.

I did some digging, it appears that this is going to need some additional custom coding. I tried checking if this can be done with a set of hooks or filters. It appears that adding such a filter might need some advanced coding in JavaScript. Here’s how you can do that:

https://github.com/woocommerce/woocommerce-admin/blob/833b973fea0dff8cacd36e0b2aad83da0c21d21b/packages/components/src/filter-picker/README.md

In case you’d like development assistance on how to do this, we highly recommend contacting one of the services on our Customizations page (https://woocommerce.com/customizations/).

Hi @rivmedia, thanks for your question. Yes! its possible.

@harishanker Thanks for the response, our documentation is out of date. Sorry about that! We are updating it in the current development cycle.

The config object that powers the Orders Report can be seen here:

https://github.com/woocommerce/woocommerce-admin/blob/61922809e05d0511032a7e97def86d61c8985c9a/client/analytics/report/orders/config.js#L59

It can be modified by the woocommerce_admin_orders_report_advanced_filters filter.

Via the advanced filter you can add an argument ?supplier=best_buy to requests and handle that by modifying the SQL to filter data according to supplier. You can also add a column to the table to list out the supplier.

Check out the example code found here:

https://github.com/woocommerce/woocommerce-admin/tree/1f261998e7287b77bc13c3d4ee2e84b717da7957/docs/examples/extensions/sql-modification

Apologies that the documentation is lacking, but in the meantime, I’ll be happy to answer questions via issues in the repository, https://github.com/woocommerce/woocommerce-admin/issues. Tag me @psealock on Github.

Hi there!

We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Hello,

I’m wondering if there is a way to add an advanced filter to filter by state as well?

Thanks!