Import posts from CSV files into WordPress.
The only issues I had getting this to work turned out to be from improperly exported csv files. I had to tell OpenOffice to quote all text fields. And then when it imported products as posts I realized I had to include the post_type column. Woocommerce product_tag and product_cat come in as custom taxonomies, and my custom fields come in just by using their names for additional columns. Sweet.
This plugin is hard to understand, but it actually works :) I use LibreOffice to create .csv files. If you copy variables like csv_post_title or csv_post_post from the plugin FAQ, don't forget to remove the empty space afrer text. If you have empty space after variables, the plugin don't work correctly. Just remove empty space after ex. csv_post_post
You definitely have to read the docs, but it has never let me down.
Doesnt work this plugin,
I couldnt even import a single post using examples.
Tried using WP Ultimate CSV importer first, but it had no support for custom taxonomies (unless I wanted to pay $250, of course).
This plugin worked beautifully the first time! No complaints at all!
This plugin supports more wordpress features than any other csv importer that I could find (custom post types, custom taxonomies, custom fields).
My only request would be that the plugin author add some hooks to the source code! I have been working for hours on customizing the formatting of the data that gets imported, and have been able to do almost everything using really roundabout hook methods. I'm on the last task I need to do, and it turns out I will need to edit the source code of the plugin. A hook to filter the post before it's inserted, and hooks before and after the import would have saved me tons of time.
Otherwise this plugin works great!
What could be nice is to be able to tag a post as being sticky too.
I had a HARD time figuring this out (I ended up creating my spreadsheet in excel, copying it to google docs and downloading it as a CSV file from there...). But now it works and it's going to save me a TON of time. Thank you :)
Lots of trouble getting this plugin to work, but I kept coming back to it because it's the only one which seems to deal with custom taxonomies, and allows you to specify the post plug, both features I needed in my application. In the final analysis, it is working, and I am very pleased.
The plugin's philosophy is "follow my format". You need to label the columns the way it needs them labeled. This is slightly inconvenient: it would be nicer if you could map your column headings to theirs. This is why I downgraded to **** instead of 5.
A lot of my issues, I believe, are due to my working on a Mac. The native MAC csv files that Excel 2008 wants to generate are not compatible with what this plugin wants; the program purports to output windows-style and dos-style CSVs as well, but none seemed to work.
It was tough to figure out a process that worked. Open Office on the Mac didn't really help: files which included quotes just weren't being escaped properly. At one point I was uploading an ODS file to a MySQL table, and then exporting a CSV using phpMyAdmin. The resulting CSV file would upload via the CSV Importer properly as long as I selected the correct CSV file format variant at export-time (phpMyAdmin gives you at least 3 different ones and I frankly forget which permutation worked: but one did).
The problem is that I wanted my CLIENT to be able to do this, and I thought this was pushing things. Ultimately I realized I could run Excel 2007 under Windows and it would generate an acceptable CSV. The client is a Windows shop anyway, so should be OK.
You must log in to submit a review. You can also log in or register using the form near the top of this page.