How to import a custom MySQL DB table into a WordPress custom post type

WordPress Posts are not stored in a single table. Postmeta is stored elsewhere, and of course each table has its own format. If you ever publish content directly in WordPress (posts, pages, attachments, etc.) you could quickly run into issues with post IDs. Even if not, it would potentially require some fairly significant data manipulation to convert your non-WP data to WP-useable structure.

In this case, I’d say a REST API would be a much better way to go, and it would also be more forward-compatible.

Related Posts:

  1. Adding custom tables to WordPress
  2. Create Pages from Database
  3. How do I write this SQL statement for Posts written in last 24 hours?
  4. wpdb custom post_type problem
  5. Assign External Database Queries to Global Variables and Make Them Accessible
  6. Function causing the loop display posting more (empty)
  7. I’m trying to create a custom version of the wp_list_authors function that includes custom post types
  8. when looping through custom post data not appearing
  9. Custom post type and custom taxonomy key lenght & query performance
  10. Populate custom post type/custom fields from an external database
  11. Inconsistent temporary 404s on whole install | PHP error with post-template.php
  12. Search that will look in custom field, post title and post content
  13. Load custom posts with same tag as page
  14. Date archives for custom post type
  15. modify all posts of a category to “no comments allowed”
  16. If featured image doesn’t exist, show post content
  17. How can I add dropdown widget/box to admin post page?
  18. How to Join two tables from separate databases within WordPress
  19. Meta Query “IN” doesn’t work with ACF checkbox filter
  20. How do I redirect all 404 errors of a specific post type to another URL?
  21. Using ‘strtotime’ function to convert a custom-meta-box to a date-stamp
  22. How to save the checked boxes?
  23. How to get only one category of custom post type?
  24. Error after deleting Custom Post Type with a function (no trash used)
  25. Using posts and postmeta table to store custom Address Book Plugin data
  26. Import 10,000 Users into WordPress WITH a specific ID for each user
  27. Append taxonomy terms as class names in markup?
  28. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  29. Change message given when deleting post from custom post type
  30. Using WPAlchemy metabox values in another metabox
  31. Recent comments from my blogs only
  32. Calculating Bayesian average for custom post type
  33. Display custom field of specific post where post title matches variable
  34. GravityForm: Populate Dropdown with custom post type [closed]
  35. How to output wordpress custom tags separated by comma?
  36. Show Different Header on a Specific Post ID
  37. Admin notice not displaying
  38. Dynamic page outside WordPress
  39. Custom query to filter posts that have current post as a taxonomy [closed]
  40. get_posts of Custom Post Type AND Custom Taxonomy
  41. Changing number of posts per page on CPT-archive.php, have tried 20-30 code chunks so far
  42. Custom Post Type Loop throws 500 error when used in widget
  43. Received nothing after executing AJAX post function
  44. Sorting custom post type columns with external data and without meta values
  45. I need to add endpoint for wordpress categories
  46. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  47. How to change wp prefix for custom post type only?
  48. Categorize custom post type
  49. Hide a widget inside a div on specific type of post
  50. Static apple-app-site-association file with wordpress
  51. Breaking up CPT output into two columns
  52. Not connecting to database in file with multiple MySQL connections
  53. how to echo meta tag in header using php
  54. PHP question: how to combine syntax?
  55. Add first letter of titles to array, then compare arrays
  56. Replace dynamically content in a custom database table when a custom post is created
  57. Save and user submitted data from a form and display them in the wp backend
  58. How do I add custom HTML to the content of an archive page’s posts?
  59. widget_posts_args not using the number of posts in widget
  60. How To Post WordPress Custom Post Types to Twitter via IFTTT
  61. Undefined $post in wp_query
  62. Update all published posts at once
  63. Importing JSON feed giving Notice: Array to string conversion error
  64. List latest post out of 2 custom post types
  65. Ideas to connect external database table to wordpress posts as custom field source
  66. custom post type: own database table structure and custom “new-post” interface
  67. Fetch data from two custom post types and create multidimensional array for output to html table
  68. Create a Dropdown Selector and Redirect for a Custom Taxonomy in WordPress?
  69. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  70. Create an user checklist system for a course plateform using ACF Pro and ACF Extended
  71. How to get the custom post data using post id in WordPress?
  72. See if the email exists or not
  73. On saving Post My permalink is updated and category is removed automatically which cause the 404
  74. How to add specific terms in a custom post type?
  75. Limit custom post type to the authors only on front-end!
  76. WP_Query – How To Query Only Custom Posts With No Children of Their Own?
  77. programmatically generated custom post type is created more than once
  78. Using wpdb to connect to a different database is not working
  79. Accessing download link from the loop with WP Download Manager Pro
  80. Create posts inside CPT post
  81. Taxonomies are not showing in the category dropdown
  82. Combine multiple separate lists into one
  83. Custom Taxonomy – fields
  84. Insert data from form to database
  85. Print post category name from a custom post type wordpress
  86. CPT post doesnt shows tags and category on backend admin page
  87. How to make sure, that only the selected post is changing?
  88. Automatically convert standard posts with custom fields to custom post types
  89. Create 2-layered dropdown menus for custom taxonomy and custom post type
  90. Get month and day from a Date Picker custom field
  91. two wordpress sites, two themes, one database, same content
  92. Show Custom Post Type taxonomy term that matches custom field
  93. custom post type for custom talbe
  94. Select Menu for Custom post Type does not save
  95. MySQL database migration to WordPress
  96. is_singular won’t call my functions?
  97. Custom query_posts() parameter
  98. Inserting two categories
  99. Comments are not working on Custom Post Type
  100. Display total count of products in orders of a specific order status
tech