Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
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