With few lines of code you can transfer your data from your custom table to post table.
- Do some
MySQL queryusing $wpdb Object to get data from your custom table. - And then in foreach() loop use
wp_insert_postandadd_post_metato add all those rows in your post table.
And you are Done!
Related Posts:
- modify all posts of a category to “no comments allowed”
- Ordering Post 2 Post admin meta box by meta from CPT
- Create Pages from Database
- How do I write this SQL statement for Posts written in last 24 hours?
- Combine tax_query and meta_query in WP_Query
- Query to change custom post type with specific category
- Mass convert MySQL data entries into custom post type?
- Calculating Bayesian average for custom post type
- Deleting Custom Post type data using mySQL command
- wpdb custom post_type problem
- Adding custom tables to WordPress
- $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
- Insert post metadata for all posts in CPT at once if metadata no existent
- Convert simple SQL Query to WordPress query
- Assign External Database Queries to Global Variables and Make Them Accessible
- How to import a custom MySQL DB table into a WordPress custom post type
- Function causing the loop display posting more (empty)
- wp_insert_post sometimes fails after API call
- Proper way to display latest 5 posts grouped by post type?
- Front end access to a SQL data repository – recommended way?
- Navigate posts with different post type that are in the same categories
- Update post if exist from PHP
- I’m trying to create a custom version of the wp_list_authors function that includes custom post types
- Convert Custom Taxonomy Posts to Normal Posts
- How to import database table as custom post type and custom fields?
- $wpdb is queried but results don’t show
- SQL query – get ids – Advanced Custom Fields / WPeC
- Why doesnt my tag page populate with this custom post type?
- Fetch data of 2 relational Custom Post in WordPress
- Custom post type and custom taxonomy key lenght & query performance
- Why is this function so slow?
- Sql Update CPT from publish to draft and particular custom field
- Dropwdown: Get taxonomy terms from posts that share preselected terms from 3 other taxonomies
- Post that populates itself (almost) automatically using data from imported excel file
- Populate custom post type/custom fields from an external database
- Custom post order when using OR relation
- Problem with a query in custom posts
- Filtering problem
- Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
- Assign a tag to custom post type using a query
- Query custom fields with three dates – start and end does not work
- Pretty URLs and custom post types
- Grouping of CPTs and taxonomies into menu groups in admin
- next/previous links on custom post single a little screwy
- Best way to organize book-page structure
- Use date in the URL of custom post type
- Form action doesn’t work if slug isn’t same as custom post title
- How to change custom post type position from backend
- Adding custom image sizes and post types to a plugin or to a theme?
- using wp_update_post for updating custom post type
- Custom post type archive page for multiple post types
- How to make permalink structure %category%/%postname%/ work for custom post type?
- Limit Search to Post Type With Apostrophe return search not found
- Get url.com/post_type/taxonomy/term work!
- How does the filter post_updated_messages work?
- Displaying custom-taxonomy-terms sorted by parent/child-hierarchy?
- Specific routing for CPT
- Invalid argument supplied in register_taxonomy $args->taxonomies
- Hierarchical custom fields
- 2 Different Custom Post Types in Submenu
- set permalink for CPT
- How to assign classes to all elements?
- Post 2 Post: Getting connected ‘person’ from post author
- Search filter triggered & sort by custom post type
- How to get a custom field value of a custom post?
- Select event where start date is smaller than current date and end date is greater than current date
- Top Level pages in wordpress giving 404, but child pages working fine
- Ignoring slug capitalization on rewrite rule for custom post type archive page
- Set Custom Post Type in Widget Settings for use in Widget
- How to order posts of a custom post type by date DESC in dashboard Admin?
- Add CPT values to Database
- Fields for different parts of a page
- Sitemap generation
- Plugin fatal error
- Is it possible to activate customfield ‘text description’ upon activating the customfield ‘checkbox’?
- Lost of query parameter when using permalink
- next_/previous_post_link() `in_same_category` appears to fail when true
- Custom permalinks rules don’t match and lost of query var in the process
- CPT Parent as a page and CPT Child as a posts
- Multiple templates for single custom post type
- Custom post type RSS feed, multiple post published on same day bug
- Order post by date with ACF
- Facebook social publisher and custom post type fields [closed]
- Custom Post Type – Duplicate Page Slugs
- Custom post type conditional in loop
- How to display products name in a non-alphabetical order, in a custom field (taxonomy)?
- Taxonomy/Custom post type structure suggestion on a movie site
- how to show a category from a CPT?
- Refine custom posts by author
- Displaying custom field according to date
- Custom post type’s permalink adds the name of the post type before the post name
- Displaying and searching Custom Posts
- Get Tags by specific Category of Custom Post Type
- Post2Post refusing to show linked posts
- Search by tag name and category
- How to sort the admin area of a WordPress custom post type by a custom field
- Checking if $_FILE isset for an array of file upload metaboxes
- Importing Data from a Non-WordPress database, into WP
- How can I show 1 featured post in a styled element, and the next few below differently styled
- Taxonomy in URL