Everything you need for
your creative projects, for
one low cost
This author's response time can be up to 5 business days.
After this update, the tabs inside the “Settings” are not shown. It shows on the url but does not get activated. Can you please check that please?
This is most probably some kind of conflict on your Site,
your current Theme or another Plugin might be having a conflict with our Plugin, which prevents the tabs inside Settings to properly load.
Can you please change the theme and see if the issue is resolved?
If not, then please deactivate all other plugins except for our plugin, refresh the page where the issue is, and see if it is resolved (it should be).
If it is, then start activating other plugins one by one, and after each activation refresh the page to see if the issue reoccurred.
Once it does reoccur, you will have found the plugin causing the issue.
Let us know how it goes.
I have 3 lakh data in CSV of the files, And I want to show this data in a page. Will it slow down the site? I installed the free version and checked and I see my website is very slow.
Will this be a problem if I take the premium version? And what configuration do I need for hosting?
We would like to begin by extending our heartfelt apologies for the delay in our response, which is due to an unusually high volume of tickets. We sincerely regret any inconvenience this may have caused, and we truly appreciate your patience during this time.
In regards to your questions :
1. In regards to slow load,
The loading speed depends on a lot of factors – your hosting plan, server’s performance, amount of other data on the page, internet speed, etc.
For example, you can take a look at
this SQL table on our documentation
, which contains around 2.600.000 rows, and see how it loads. The more data the table has, the more chance that it will impact the loading time.
When it comes to tables linked to a CSV file specifically ( same goes for Excel, Google Sheet, basically all tables which are not SQL based),
it depends how many rows that CSV has.
You can try with our Cache and Auto Update cache feature (https://wpdatatables.com/documentation/table-features/caching-data-and-auto-update-cache-in-wordpress-tables/)
this can help with the load time significantly for tables that have approximately between a thousand and 5 thousand rows,
but we still recommend keeping the data in these files down to around 5.000 rows.
If your source data goes above that size,
then we recommend to try with our Premium Plugin version and import the CSV data to make a new Manual Table. (https://wpdatatables.com/documentation/creating-new-wpdatatables-with-table-constructor/importing-data-to-editable-mysql-table-from-excel-or-csv-with-table-constructor/)
This table won’t be synchonized with your source CSV,
but it is ediable in our Plugin.
Tables like this have server-side processing, which helps with the loading time.
3. When it comes to a configuration from the Hosting’s End,
there is no ‘universal’ configuration,
but a general rule is that , the higher you can get their PHP Memory Limit, the more data your WordPress Page will be able to handle.
Same goes for PHP TimeOut limit, the higher you set it , your WordPress will be able to handle any kind of a ‘time out’ error in general.
We hope that helps.
No problem, we are happy to advise.
If you encounter any issue with the subjects/points we wrote about here,
our Main Support Agents are always available to help you in more details,
so please don’t hesitate to reach out to them on our Main Support here. https://tmsplugins.ticksy.com/
Can’t update the theme, can’t get support. This is a mess.
See me try to update theme – https://www.loom.com/share/Settings-Alaskit-WordPress-12-September-2023-fbd510284bab4930a9bc1dc918c98a85?sid=cbf223dd-f7c0-4227-b631-064c6a7e0a24
See me try to reset my password so I can submit a ticket – https://www.loom.com/share/Cant-update-password-da367646b9784b7b9b89c295d31845eb?sid=45d424cd-5f8b-4e18-bcc2-fbf11377b7ee
So… what am I suppose to do? What am I suppose to do? I can’t contact support. I can’t activate the theme. I can’t update it. This is ridiculous.
Firstly, we would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. We are sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
1. In regards to the activation with the Envato API :
This happens because the Envato’s API is limited to linking 3 requests per second you will probably need to click on “Activate with Envato” a few times until the license is activated,
but once it is activated, it will stay active and you will be able to update the plugin through the Plugins page.
Can you please try now, and let me know if it works?
Just remember that you probably will need to click on “Activate with Envato” a few times before it actually activates the license.
2. In regards to the Ticksy issue for the password reset,
we apologise for this inconvenience, our managers will help you, they can set up a password for you and they can send you the new password to resolve this issue.
If you could please contact them on this email firstname.lastname@example.org and they will help you resolve this issue.
Let us know if that sounds OK. Thank you.
My support has expired so I cant write to you on your ticket portal – so frustrating! I need the latest update! I cannot activate my install with my legit licence code either. I am pretty fed up with your poor administration of this product.
We sincerely apologize for the challenges you’re currently facing.
Your feedback is highly valued, and we’re committed to addressing your concerns promptly.
Rest assured, we’re forwarding your feedback to our management team for immediate attention. We’re dedicated to making necessary improvements to enhance the user experience as swiftly as possible.
Regarding the matter of opening a ticket, when the Support from the Envato side is no longer available,
you have the option to select the “Pre-purchase questions for wpDataTables” category.
This will enable you to open a ticket on our main support platform without requiring your license code.
We kindly ask that you consider opening a ticket through this channel.
Our Support Agents will promptly respond to your query.
They’ll simply need to verify your details there before providing you with the latest installation package.
We once again apologize for any inconvenience this may have caused. Your understanding and patience are greatly appreciated.
Why aren’t you updating the download here with the latest version ?
We sincerely apologize for any inconvenience caused.
Our dedicated Team responsible for updating the download version on the Envato Store has encountered a technical challenge.
Rest assured, we are diligently working to rectify this issue within the upcoming couple of days.
In the meantime, our primary Support Team is more than willing to provide you with the latest installation file.
Should you desire this, we kindly invite you to initiate a support ticket on our official platform.
They will be more than happy to assist you.
If your support subscription has expired, please select the pre-purchase ticket category that does not necessitate a purchase code.
( They will still need to verify some details with you, of course)
Once again, we extend our sincerest apologies for any disruption this may have caused. Your understanding is greatly appreciated.
I want to buy the plugin, but I want to make sure if it will be useful for my exact scenario. Let’s assume I have a scenario where I have a table with rows of people’s information, where the first column contains their names and the second column contains their phone numbers. I want to use another table for a different purpose, but I want to automatically retrieve the names, surnames, and phone numbers of individuals from the first table. For example, I want to select a person’s name and have their corresponding phone number automatically populate from the same row. Is this possible? Because in your demo, it seems that a separate call is required for each row.
Thank you for reaching out to us.
Users can’t click on a row and have that info automatically be populated in another table. That’s not possible.
If this is a database table, you can create a custom query that will pull only the name and the phone number in a new table. Or, you can create a separate table that will consist of numbers only (integers). You could then use those numbers as Foreign Keys that will pull the data from the 1st table.
At the moment, only these two options are available for pulling the data from one table into another.
Official Support |
Back-end Demo |
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi, recently, in the new entries, the date changed to something like “WedWed JulJulJul 2023”, and it won’t let to register it! Do you have any idea of what I have to do?
This could be caused by the date format configured in WordPress’ General Settings.
Try selecting one of the predefined date formats in there, and make sure the date format is properly saved in wpDataTables Settings.
If this doesn’t help, please feel free to open a ticket on our official support platfrom. If your support expired, make sure to open a pre-purchase ticket which doesn’t require a purchase code.
I have changed the WP date format to “j F Y” and wpDataTables Date Setting to “d Mon Y” but still the same thing happens!!!
We aren’t able to replicate this issue locally, so it’d be best to open a pre-purchase ticket which doesn’t require a purchase code and provide our technical support agents with remote access credentials for your site, so they can take a look and see what’s going on.
Pre-purchase question: I need to show a table with dynamic data from MySQL, but I need to do some operations with the values. For example: if it is an URL, I don’t want to show the full URL, but a link to it:
< a href="%URL%">external link< / a >
Is this possible?
I need also to write the column values depending on an evaluation of the value, For example: if I have an “Age” column I need to write:
if %AGE% < 18 then
echo "is a minor"
echo "is not a minor"
Are these kind of operations with dynamic values possible with your plugin?
Thank you in advance
You can use HTML in the tables without issues, so you can use hyperlinks.
As for dynamic queries, you would be able to configure a custom query with conditions, but you’ll need to create a CASE similar to this.
Please note that constructing custom queries and using hooks is not included in the provided support for the plugin, so we wouldn’t be able to construct these queries for you.
Ok, thank you. But where is your documentation to do that? is there a variable that I can use like in my example, something like: %cell-value%? I need to add/modify text in the cells, is that possible?
The only documentation we have is purely informational as it’s to be used by developers, who know how to apply it.
You can take a look at our hooks, filters, and front-end table callbacks, and see what you can use to achieve this.
You can also use our placeholders, which allow you to change the data plotted or filtered in the table.
Dynamically adding/editing the data in an existing table can’t be achieved with wpDataTables as you need to manually edit one row at a time.
This: INNER JOIN (SELECT artist_meta_artistband_name_tbl_posts.ID as id, meta_value, meta_key FROM wp_postmeta AS artist_meta_artistband_name_tbl_postmeta INNER JOIN wp_posts AS artist_meta_artistband_name_tbl_posts ON artist_meta_artistband_name_tbl_postmeta.post_id = artist_meta_artistband_name_tbl_posts.ID AND artist_meta_artistband_name_tbl_posts.post_type = ‘artist’) AS artist_meta_artistband_name_tbl
Gives me: No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable.
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INNER JOIN (SELECT artist_meta_artistband_name_tbl_posts.ID as id, meta_value…’ at line 3
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types
SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN, and DESCRIBE.
Some of them are disabled for security reasons.
Filtering, sorting, and searching may not work properly if you include:
Accent graves ( ` ) around the table name
You can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like “SELECT * FROM view1″.
The “Editing” menu is not present, why?
The Tab i mean…
Hello and thank you for reaching out to us.
The Editing tab is only present on editable tables (manual, SQL query-based tables, and imported tables).
If you created a table linked to an existing data source, or you haven’t enabled “Server-Side Processing” in an SQL query-based table, the Editing tab won’t show.
Will it be a problem or loading speed will slow down if data is fetched from google sheet using API when there are more than 50000 rows in the sheet?
Most likely, yes.
Using the newer, Google Sheets API method it’s a lot better, but a table this big will probably cause prolonged loading times.
We can suggest copying this data and importing it in the database, so you can pull the table using a MySQL query which has server-side processing, and is only pulling the rows currently visible in the table.
Hello, could you please check my ticket #3389243?
Sorry for the delay.
We respond to tickets in the order in which they arrive, so it may take time before our agents reach yours.
We’ll ask them to check it out as soon as possible, so expect their response soon.
I need the plugin to take a csv file that will be updated daily via FTP
Your plugin automatically update the chart?
If you don’t change the title of the file, and you don’t change the structure of the table, the plugin will load the table from the source file (CSV) every time the table (page) loads, so if you’re updating the source file via FTP, the data will automatically be updated in wpDataTables.
iam using some other solution at the movement but now i was thinking to buy this. can you tell me one thing can i default sort per column like ascending order or descending order. so every column will be different shorting after one time assign the order ?
so for example i have 3 columns in that i will assign first one descending and second one ascending and 3rd descending ?. it should not be like fliter it will be like one time assign and it should works
At the moment, multiple columns in wpDataTables can’t be sorted. In the plugin, you can only select one column to be the default sorting column, while the others will depend on it.
A workaround would be to custom sort the columns through an SQL query, which will return the data you need in a preselected sorting fashion.
Why do you not update your plugin file at codecanyon – at least then I would keep it updated as activation does not work and has not for many releases? I have tried to contact you but my support has run out – Not sure why I need paid support for a fault your end!
We apologize for the delay.
All updates pushed on our website are pushed to CodeCanyon with up to 24 hours of delay. We’re not sure what happened with the last one, but we’ll check it out and push the update today if we accidentally uploaded the old version instead.
The support terms for CodeCanyon licenses are defined by CodeCanyon, not wpDataTables, but you can always open a pre-purchase ticket which doesn’t require validation or purchase codes.
Sorry for the inconvenience once again.
The latest version of WPDataTables (5.6.1) is not appearing in my downloads
If I click on the Download option on this page, I just get 5.6, not 5.6.1
Hi there – it’s happened again. There’s a new version of wpdatatables that came out several days ago and it’s not available on my downloads page.
I am creating a new version of the website for my client. I need to transfer to it all the tables that were on the old page along with their settings.
Is there any quick way for me to export them from the old site and import them to the new version of the site?
Other than cloning the site, another option would be to copy all database tables (wp_wpdatatable_#) along with tables wp_wpdatatables, wp_wpdatacharts, wp_wpdatatables_rows and wp_wpdatatables_columns. Then, in wp_options table, you would also need to export the following option_names:
It is rather cumbersome to do all this, but unfortunately at the moment it’s the only way. Also, for tables linked to an existing data source, you would need to change the file path, because at the moment the file path depends on the domain, so if you change the domain, the URL to the file will also have to be changed.
Our developers are working on creating an “Export” function, so this will be much simpler in the future.
Hi. Does this plugin have a function to import tables created in Tablepress?
That depends on the structure of Tablepress tables. You can use the import feature of wpDataTables and import tables previously exported into Excel or CSV format.
They will then be added to wpDataTables’ database, and you’ll be able to use them as manual tables.
Let us know if there’s anything else we can help you with.
I’m very interested in using this plugin, but I am unsure if it can conflict with my theme. Out of curiosity, here is my website: https://vlanderon.com
Does this plugin align with my theme?
Sorry for the late response.
wpDataTables generally works well with most themes, but we can’t guarantee that there will be no conflicts.
We do have a 15-day money-back guarantee, so if you purchase the plugin and find it’s not working well with your theme, you can submit a refund request.
Do you currently have plans to integrate WooCommerce data automatically to create tables based on that? It would be amazing to see that in a plugin like yours. Thank you!
Thanks for reaching out!
At the moment, we don’t have the WooCommerce integration but the good news is that our developers are working on that, so hopefully it will be included soon.
Use, by you or one client, in a single end product which end users are not charged for. The total price includes the item price and a buyer fee.
Use, by you or one client, in a single end product which end users can be charged for. The total price includes the item price and a buyer fee.
View license details
Price is in US dollars and excludes tax
Power Elite Author
Millions of creative assets, unlimited downloads.
One low cost subscription. Cancel any time.
Effortless design and video. Made online by you.
Smart templates ready for any skill level.
We'd like to ask you a few questions to help improve CodeCanyon.