Generate reports for WooCommerce (using Kibana + ES Stack)

[myworkpool]

The problem is when you reach hundred thousand or above of WooCommerce Order, a normal MySql report will have a problem due to it slow and unreliable from taking too long time to finish creating report.

My idea is to generate report using Kibana stack. It would be great to create a dashboard for my boss to see which product is doing well from millions of records. If anyone create the template I think it can be sold, or be shared.

Does ElasticPress currently saved the sales info or any query example of "how much does this user has spent" ? Due to it hardly to do with WP_Query so my small brain is out of memory crash right now.

[ivankristianto]

@myworkpool ElasticPress it not built to that level yet. But it does store order data to elasticsearch for you to process and show it using kibana.

[tlovett1]

This would be a great addition!

[myworkpool]

It seems that order total price and line item in the order doesn't indexed into the elastric server. I will check again.

…

On Thu, Apr 20, 2017 at 10:25 PM Taylor Lovett ***@***.***> wrote: This would be a great addition! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#808 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AJ5b2iFuhW42dvkLZ4-IjT_zUr5WQZTEks5rx3jFgaJpZM4NB_Vp> .