SQL Query

Hi All,

I hope that this is OK to post here, as I have already raised a ticket on the tmsplugins ticket system, but not received a reply and their reduced price offer finishes in a few hours…

I am looking for a way of presenting product data which is stored in a SQL database. There are just over 2 million lines of product information which is updated regularly.

At the moment I delete all the data in the product table in the SQL database and re-import hourly from suppliers FTP feeds. At the moment I use a custom PHP site which works perfectly, but looks very dated. I plan to import this data into a custom table in a WordPress installation and then I will write a PHP cron job to run on the host Ubuntu Server to delete all the data and reimport hourly.

I came across wpDataTables Plugin and wondered whether this will allow me to create a front-end to search table/s stored in the WordPress database?

I installed the free version as a trial, but to choose SQL as a data source it needs to be the premium version… obviously I don’t want to pay for a product which wont do what I need.

Can anyone offer any experiences, or advice? Particularly as the backend SQL table is updated regularly outside of WordPress, so I am wondering how this plugin will cope and whether it needs to be refreshed on the users frontend after the data is replaced? If so, is there a way to se the plugin to refresh just after the time that the data has been re-imported?

Thanks in advance

• This topic was modified 9 months, 3 weeks ago by slimat.