0+
March 28, 2025
October 12, 2024
This plugin helps you migrate legacy SQL database tables to WordPress’ Custom Post Types (CPT). It provides a user-friendly UI interface that enables users upload an SQL file which is then parsed and converted to a CPT with meta data that is recognisable within WordPress.
If you ever need to migrate a non-WordPress database table into WP, look no further. This is exactly what you need!
Our plugin comes with everything you need to easily migrate SQL tables to CPTs.
✔️ Import & Convert to CPT feature.
✔️ Quick & Lightening Fast uploads.
✔️ Friendly, User Interface (UI).
✔️ Custom Post Type Capabilities.
✔️ Error Loggging Capabilities.
✔️ Custom Hooks to help you customize plugin behaviour.
✔️ Available in mutiple langauges such as Arabic, Chinese, Hebrew, Hindi, Russian, German, Italian, Croatian, Spanish & French languages.
✔️ Backward compatible, works with most WP versions.
Head over to the SQL to CPT options page. Upload an SQL file of your choice by clicking on the Import SQL File. This would analyse your SQL table and show you the table name and table columns you are about to import. Once ready, click on the Convert to CPT button to complete the process.
On import completion, you should now be re-directed to the Custom Post Type page of your newly imported data!
You can get a taste of how this works, by using the demo link.
NB: At the moment, the SQL to CPT plugin currently does not provide a way for users to import more than one SQL table at a time, this feature should be available in future releases as well as the option to remove unused CPTs.
The SQL to CPT plugin is built to work right out of the box. Simply install, activate and start using.
Want to add your personal touch? All of our documentation can be found here. You can override the plugin’s behaviour with custom logic of your own using hooks.
If you’d like to contribute to the development of this plugin, you can find it on GitHub.
To build, clone repo and run yarn install && yarn build
No FAQ provided.
sqlt_cpt_post_title
to sqlt_cpt_post_values
.Import
route class.Post
class for handling CPTs.sqlt_cpt_post_title
, sqlt_cpt_post_labels
, sqlt_cpt_post_options
.sqlt
prefix.sqlt_cpt_table_name
, sqlt_cpt_table_columns
, sqlt_cpt_table_rows
.sqlt_cpt_table_name
, sqlt_cpt_table_columns
, sqlt_cpt_table_rows
.