Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.
You will need to create table for example that contain one string column(days) and all other have to be integers(each product) Like
Date Product1 Product2...
01.01.2021 10 5
02.01.2021 11 12
....
If you have that data in database then you will need to create query that will return data in that format so you will be able to create chart like you need.
Please be advised that preparing MySQL queries for you is not included in the plugin support.
If you look below I have three products and I would like to see the sales of each products individual on the day. The products are in woocommerce. But this one I manually created. How do i create wordpress query to create a table that constantly feeds data from the products. I see so many options but I dont know how to do it
Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.
You can try to get data what you need with but choosing properties from post types that you need with our query constructor.
Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.
If it is not returning data that you need you will need to make custom query to return data that you need.
Please be advised that preparing MySQL queries for you is not included in the plugin support.
Hi,
I was wondering how to create a chart for a specific product to show in front, how many products were sold in each day.
Hi Eventik,
Thank you for your purchase.
Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.
You will need to create table for example that contain one string column(days) and all other have to be integers(each product) Like
Date Product1 Product2...
01.01.2021 10 5
02.01.2021 11 12
....
If you have that data in database then you will need to create query that will return data in that format so you will be able to create chart like you need.
Please be advised that preparing MySQL queries for you is not included in the plugin support.
Best regards
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi,
If you look below I have three products and I would like to see the sales of each products individual on the day. The products are in woocommerce. But this one I manually created. How do i create wordpress query to create a table that constantly feeds data from the products. I see so many options but I dont know how to do it
How do I create a table like this from below?.
Date Product1 Product2...
01.01.2021 10 5
02.01.2021 11 12
....
Hi Eventik,
Thank you for your purchase.
Sorry for the late response, we have some agents that have contracted Covid-19, so our team is cut in half.
You can try to get data what you need with but choosing properties from post types that you need with our query constructor.
Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.
If it is not returning data that you need you will need to make custom query to return data that you need.
Please be advised that preparing MySQL queries for you is not included in the plugin support.
You can check out a lot of examples how to create query to retrieve products from woocommerce on web or to get orders by day and probably you will need to adopt it for your needs.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables