I have a few hundred rows of product data that is going to be displayed as posts on the wordpress site. I'm sure there's a way I can load all this data directly into the database and then have both the admin & frontend UIs populate with these as new posts. But from what I can tell, various aspects of a post are populated/stored in different tables. Which tables should I load this data into to avoid having to create each one manually from the admin UI?
I found this after some additional searching and it seems like one of the plugins suggested here will work for what I'm trying to do.
The 2 options given there are:
I'm going to give these a try and will post back here if they work.
Just an update - the plugins linked above weren't compatible with my version of wordpress but I just searched the plugin directory and found Ultimate CSV Importer and it worked perfectly for what I needed to do. I guess I should've tried looking for a plugin first instead of trying to load manually myself.
Here's the link for the plugin I used: