I am currently using WooCommerce to give users some products to buy. And I am using WooCommerce default shop and checkout page for that. After some users have made the purchase successfully, I can check the existing purchase information on the back end in WooCommerce plugin.
However, I want to view the purchase and order information in front end. So I am wondering is wpDataTables able to get these data from WooCommerce and store the data in wpDataTables table? Then the table can be showen the table in the front end for me to view.
At the moment, we don't have a native WooCommerce integration, so pulling data from WooCommerce's database can only be achieved using MySQL query-based tables. If you're not that good with MySQL, you can try using our Query Constructor, but please note that this constructor is just a helper - it's not an ultimate query generator.
It constructs a suggestion of a query, that you often need to modify to get the data you need. Included support for the plugin doesn't cover writing custom queries, so we wouldn't be able to help you with that.
Hi Sir/Madam
I am currently using WooCommerce to give users some products to buy. And I am using WooCommerce default shop and checkout page for that. After some users have made the purchase successfully, I can check the existing purchase information on the back end in WooCommerce plugin.
However, I want to view the purchase and order information in front end. So I am wondering is wpDataTables able to get these data from WooCommerce and store the data in wpDataTables table? Then the table can be showen the table in the front end for me to view.
Thanks for help
Kind regards
Hi Hao
Thank you for reaching out to us.
At the moment, we don't have a native WooCommerce integration, so pulling data from WooCommerce's database can only be achieved using MySQL query-based tables. If you're not that good with MySQL, you can try using our Query Constructor, but please note that this constructor is just a helper - it's not an ultimate query generator.
It constructs a suggestion of a query, that you often need to modify to get the data you need. Included support for the plugin doesn't cover writing custom queries, so we wouldn't be able to help you with that.
Hi Blazenka
Thanks for your reply. I'm not so good at SQL but I'll have a try anyway.
Thanks
Kind regards
Thank you for responding Hao.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables