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. Understanding Post Formats/Custom Post types Etc
  12. Custom post type causes php-error in php version 5.2.17
  13. Trying to get custom post of a custom taxonomy
  14. How can I group posts by months and years?
  15. Specifying meta field’s column type in Database using add_post_meta
  16. PHP question: how to combine syntax?
  17. Trying to Create a PHP Variable for post_type that can be referenced Site Wide
  18. Add first letter of titles to array, then compare arrays
  19. Replace dynamically content in a custom database table when a custom post is created
  20. Loop increase number
  21. custom post for slider
  22. WordPress Block developer from exporting Database via PHP
  23. Using wp_query to modify the loop in index.php for a CPT
  24. WP_Query Custom Post Type if Category ID Equals
  25. Running a song lyrics site on WordPress
  26. Save and user submitted data from a form and display them in the wp backend
  27. Assign category a default post type
  28. Front end access to a SQL data repository – recommended way?
  29. Navigate posts with different post type that are in the same categories
  30. Dump custom post type database
  31. Not sure why this template for custom post type posts isn’t displaying anything. What’s missing?
  32. Should I use custom taxonomies or not?
  33. Is This Code Efficient – Or is there a better way?
  34. wpdb prepare insert table doesn’t work
  35. Should I use WordPress to skin a database website?
  36. How do I display offsite database info on my wordpress site?
  37. Control content before and after custom post type loop
  38. Custom Post not working as expected
  39. How to use a variable as a function name?
  40. Creating Database Table vs. Adding MetaData to Post & User
  41. Designing a custom post type with a minimum number of meta fields
  42. Check IF single OR multiple custom data has been entered
  43. Get custom post type categories to show up in menus
  44. Saving fields in a drop-down in WordPress
  45. Allow front end users to add data to a custom post type
  46. Displaying custom post types as a gallery
  47. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  48. Assigning a category to a custom post type in WordPress
  49. Show current custom taxonomy
  50. finding and using post type fields in WordPress
  51. I need to add a filter to prepend the term ‘National – ‘ to the post title if the post is tagged to multiple states
  52. Is there a way to create two template for single custom post type page?
  53. How exclude or skip post type with get_next_post_link
  54. WordPress: Custom User Role cannot access Custom Post Type | “Sorry, you are not allowed to access this page”
  55. Most commented posts by time period (last 12h, last 24h and etc)
  56. How do I add custom HTML to the content of an archive page’s posts?
  57. Update post if exist from PHP
  58. Different options per post type in WP_Query
  59. After creating Custom post type by user delete old one
  60. widget_posts_args not using the number of posts in widget
  61. Show message when query has no posts
  62. Create short URL with auto 301 redirect
  63. How To Post WordPress Custom Post Types to Twitter via IFTTT
  64. Pagination hitting 404 page on /page/4
  65. Get data from PHP to JavaScript to set position of each post on front page
  66. Undefined $post in wp_query
  67. Get posts from Custom Taxonomy
  68. WordPress hook which triggers on post import
  69. I can’t update my data through $wpdb
  70. How do I create a new post upon registration with the users first and last name as title
  71. Removing full title and breadcrumb header container for a specific post type
  72. Is it possible to use array_walk() to append terms to an array of posts?
  73. Update all published posts at once
  74. Query entries from custom post type in an ACF flexible content field
  75. get_post_types() can’t get some of my post type
  76. Creating a non-hierarchical Taxonomy that behaves like categories
  77. Creating shortcode id for custom post types
  78. When I choose category from dropdown then everything working fine.But in backend it checked only child not parent [closed]
  79. Shortcode is displaying the content on top of the page [duplicate]
  80. get_terms() returns Trying to get property of non-object error for custom taxonomy
  81. Filter content in shortcode
  82. Query custom post types & Taxonomies and list them in a table on a page
  83. Custom post type and custom taxonomy 404 on page 2
  84. Creating a “glossary” of WordPress posts of a specific post type
  85. Show current user posts in custom post type query
  86. Using Pagination for Custom Post Type and keeps returning 404
  87. Custom Ratings for Theme, Proper way to Refactor Code and Clean up Template File
  88. Importing JSON feed giving Notice: Array to string conversion error
  89. How to add new post using a form to categories when categories are using as menu
  90. How to set the mainpage of a custom post type?
  91. Different post title, keywords and description
  92. Entity to store contact form entries?
  93. post_content is stripping HTML when adding a new post? [closed]
  94. custom post type by author – wp job manager
  95. Querying a custom post type, but not show duplicates
  96. Nested Custom Taxonomies | Incorrect posts when querying
  97. List latest post out of 2 custom post types
  98. Validate Custom Post Type fields
  99. meta query not retrieving posts
  100. Using Wp_Query, Json to add Highcharts series data
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)