I don’t think you should create a new column in wp_posts…
This kind of info is stored in wp_postmeta.
When I need this kind of importing (Excel->WP), I use CSV Importer, as you can assign categories, tags and custom field to the imported data.
You’ll probably need to do a couple of tests with few entries until get the right CSV format.
And maybe, you’ll also need to manipulate the CSV in an advanced text editor before importing (as Microsoft software is not always that smart).
Related Posts:
- Exclude posts that only have the ‘Uncategorized’ category [duplicate]
- How are terms connected with posts in database?
- get_terms parent for current product only
- deleting terms programmatically
- Adding Multiple Values to a Post Meta Key
- Avoid duplicate post from same Taxonomy
- Set terms in a custom post
- Get posts of ONE taxonomy term of custom post type
- Setting posts_per_page for taxonomy term template
- How to display posts via custom taxonomy terms using checkboxes?
- Loop parent terms {display posts} AND loop child terms {display posts}
- Displaying Results From Custom Taxonomy Query
- How to get all the terms of a post
- Get Posts Under Custom Taxonomy
- How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms
- Different post sort order within different categories
- Displaying the category name of a custom post type
- Elegant way to include only published posts with get_objects_in_term()?
- Show WordPress Custom Taxonomy Items Based On a Selected Item From Another Custom Taxonomy
- Convert IPTC keywords to blog post tags
- How to force update all posts after import
- Show Custom Taxonomy Categories, Listing of Posts, and Single Post via AJAX
- How can I export and then import posts with featured images?
- How do I get the slug of a custom taxonomy category of a post?
- Post taxonomy from exif data
- Redirection to taxonomy posts list after post submit.
- Remove custom posts that match taxonomy value
- Importing New Posts from Live Site into Local Dev Site
- ‘Invalid post type’ error when importing from one site to another
- Does an action fire when adding a tag via the “Tags” meta box?
- disable column on post and user list
- How much of my site can I recover from public_html?
- Get taxonomy terms only of the WP_Query current posts
- Automatically Updating Publish Date Bug
- Get posts by name and taxonomy term
- How to display data in archive page?
- Choose whether to automatically add a taxonomy with the same name as the post
- Display tag image in post using Taxonomy Images plugin index.php
- wp_get_object_terms returns only Uncategorized on first publish
- Polylang post_translations key [closed]
- Force the “Choose from the most used tags” meta box section to always be expanded
- Posts list in custom taxonomy
- How to Restrict Previous & Next Post Link to Posts of Same Category?
- Get Posts Under Custom Taxonomy
- Prepending %category% onto default posts fails
- get_adjacent_post by language
- Duplicate Custom Post Type and Taxonomy Slug
- WordPress Local And Live Site
- Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
- How can I setup a relationship using categories in WordPress?
- sql select for post_title and a term name
- How can I hide tags on a child-category page, if that tag has not been used?
- 404 error on default post type and default taxonomy fronted page
- outputting posts’ taxonomies: cant get ‘get_the_taxonomies’ working
- Copy taxonomy terms from one post to another programmatically
- relating business and products with custom taxonomy?
- Importing posts only – consequences?
- Is there a query string for edit.php to show all posts that have no custom taxonomy terms?
- WordPress bulk category select when publishing post
- How to import nested categories from XML file?
- Check if current user has a post and that post has any term/s from a specific custom taxonomy outside the loop
- Parent category / child category posts
- wp_set_object_terms NOT working on CPT, but wp_set_post_terms does
- Output Post with ACF Fields into other Post
- Only allow posts with a specific term to only be viewed by other authors with the same term in their post
- Count the number of a post types associated with another post type
- When moving a WordPress installation to a new server, why do I have to update each post before content shows?
- Unable to differentiate between two categories under custom post type on single.php
- Get current post’s nav menu name (term name)
- Accessing Post ID Within Loop
- Cannot select certain authors for posts after import
- How To Use Custom Tax of a Post Type
- How to output all taxonomy links from a custom post type in a menu?
- Geting error in post and category [closed]
- Custom post type and taxonomy page templates
- How to display the post categories for each post inside the loop with custom format?
- WP query taxonomy optimization
- Post not using taxonomy template
- Show post count in custom taxonomy page
- Create/Set Category as Title of Post
- Page with Category Returning 1
- Slug collision between page, taxonomy and custom post type
- Customizing URL slugs of Custom Post Type and Taxonomy make posts/pages 404
- How can we print out total number of posts filtered by post type and category?
- wordpress display posts by terms id or name
- How to get post count including nested categories
- Custom Taxonomy From Database
- Multiple Custom Post Type loop logic
- How to list all names and descriptions of a custom taxonomy
- Update all images url imported from HTML pages
- How to display term in archive page?
- Loop through posts by each term and exclude duplicate posts assigned to several terms
- Moving Posts to a new site and maintaining URLs
- Multiple loops on a Search result page?
- Special Query: Title, Terms, Content – %LIKE%
- Tumblr importer
- retrieve post slug by post_tags taxonomy
- How to detect if an ACF custom-field is really in use?
- Export Posts Without Categories In An XML File
- Filter/Sort Post Form On Taxonomy page