Jason Judge

Hopefully version 0.6.1 will fix this problem.

I’ll copy in an email I sent to @@justinb81 after trying out his CSV file. It may be useful in analysing the issue:

I’m getting an error that the post_excerpt cannot be null. I’m not sure why it is trying to insert a null into that column, but I’ll look into that. This could well be a change to the WordPress database. It could be I’m only seeing that specific error message because I have debug turned on, and you are just seeing the end result (skipped records) with debug tuned off.

Adding a “csv_post_excerpt” column allows it to import. Your file is UTF-8, without a BOM, and with Unix line terminators, so nothing unusual there.

The csv_post_date is not getting imported, so far as I can see. I changed it to UK/international style dates, and it is still not being imported. Another one for me to look at, assuming the column name is correct.

Could you try one thing for me: uninstall the plugin, then remove all its files. Then reinstall. WordPress does normally do this, but just in case any of the old files are being left behind, it will be worth trying this.

[email protected] will get to me.

Yes, please do. Email it direct, stick it on a git issue – whatever is convenient – but do send it to me as a raw file and not cut-and-pasted, so I get *exactly* what you are seeing, complete with line endings and control codes that may be in the file. I’ll aim to get it fixed over the weekend.

Ditto – you will need to email me a file showing this behaviour, because it works fine for me with all the files I have been trying.

You will have to send me examples of the files you can’t import.

Try version 0.6.0 just released. That version treats all custom fields as unique, so no longer creates additional fields if they already exist, but updates those fields instead.

I’m going to ask the same question I ask most people: could you send me an example of the file, or part of a file, that causes this problem so I can reproduce it.

What kind of fields are being duplicated? Custom fields?

• This reply was modified 8 years, 5 months ago by Jason Judge.

Try it now. It looks like some extra directories were being created in subversion – I couldn’t see them from my end, but I could if I downloaded the plugin from www.remarpro.com

I’ve fixed that and forced an update to 0.5.4 to hopefully give you a cleaner version.

Uploading images via CSV is always a difficult problem to solve, since images don’t fit in a CSV file. URLs and file names can be supplied, and then additional processing is needed to fetch the image, add it to the site, then link to it, and on top of that, avoid importing duplicate images if the same image is used on multiple products.

If importing product images into WooCommerce, I would recommend using one the plugins specialised for WooCommerce. It will take account of the many additional custom fields that WooCommerce uses. There is the commercial “CSV Import Suite” from WooThemes, and a few clones of that around www.remarpro.com that work just as well.

Can you provide some further details. What are you putting in this thumbnail CSV column? How are your thumbnails being managed now – a plugin, the theme?

Updated to WP 4.6.1, removed the plugin, reinstalled plugin 0.5.3 from www.remarpro.com – all worked for me, and was able to import an 8-record file.

Using PHP 5.4.45 as mod-apache. Happy to try a later version (5.5, 5.6, or even 7.0) if that is what you are having troubles with.

What version of PHP are you on, in case something for a newer version has krept in.

I’ve just updated to 0.5.3 on one site and imported a CSV file. All seemed to work fine.

It was a slightly older version of WP, so I’ll update that and try a fresh install.

I wonder if this is something best done by a separate plugin, since I can imagine tracking would be a lot more involved than just storing a number. Changes to WC may well take this into account, as the last few versions seem to have picked up again on the concept of packages – something that was started some years ago then put on ice for a long time, kind of only half completed.