Import post images via URL in CSV files

Which plugin are you using? Link please?

Well I have tried two.

The most luck i’ve had is “CSV Importer”. I have successfully imported the custom taxonomies and all custom fields except for the image. I’ve tried image url with several heading title variations but nothing works.

The other one I’ve tried is “WP Export” It has both import and export functions. However I cannot for the life of me bring in my custom taxonomies with that one. I have gotten real close with a successful image upload by using the heading: IMAGE. However, I have this error on my post page where the image should be:

Warning: fopen(https://activestatedesigns.com/?attachment_id=1467) [function.fopen]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/bourdod1/public_html/activestatedesigns.com/wp-content/themes/TheJewelryShop/lib/engine/cat_navi.php on line 1810

. When I check my media uploader, the correct image is shown as part of the gallery. So maybe I need to import it as the featured image too? I’m curious what heading in the csv file that needs to be.

So basically depending on which plugin I use, I run into different issues. If I can get the image and custom taxonomies figured out for either plugin, then I will roll with either one.

Thanks in advance,
Lorne

Any ideas?

Thanks,
Lorne

Hi is there any progress on this? I am busy with CSV Importer with some success but am also not able to link the images with the posts being imported.

The plugin works perfectly but I am not sure what to call the image link headers in the csv or even if it is possible this way. Any advice?

Hey Bazonline,

I have made progress on this. I got the pictures working now! Basically I have gotten the pictures attached and one picture as a featured image.

Basically name header for your featured image: image_thumb and name any other image header as: post_img. You can have multiple post_img columns depending on however many images you need to be attached. Obviously you need to upload the images first, I upload them to wordpress and then just put the URL in.

Let me know if that helps!

Lorne

Thanks Lorne, will play with those options. So I do have to upload the images first and not merely place them in the correct directory? – what is the string to use, I see you posted the following example is this correct?

<img src=”https://activestatedesigns.com/wp-content/uploads/TEE-I-CO-Ski02_Design.jpg&#8221; />

Thanks for your help, I have been battling with this for a while now

Hey bazonline,

Yea basically I upload my images through the media library, then if you go view your image it will show you the image URL and you just copy that and paste it. No special directory or anything needed.

Hope that helps,
Lorne

Oh, and you don’t need the <img src=” tag. Just put the URL in there.

HTH,
Lorne

Thanks Lorne, you are a star

Hello again,

So I am trying to mass import my post via csv again. Turns out I was wrong, the header post_img, does not work ?? image_thumb is the only one I got working properly for the main image.

Does anyone have any idea what slug or tag I should use for the header to attache images to my post?

Thanks,
Lorne

Does anyone know how to import another image that is attached to the post? The only image URL that I can get to work is the image_thumb. However I want 2 images in my posts.

Thoughts?

Hi Lorne,

I see we are both still battling with this. I had no luck at all but found a plugin called Add From Server that pulls in photos that have already been FTP to the server, the only limitation I had was I needed to do it in batches of about 250 at a time or it bombed out.

Then came the tedious task under WP Media Library of attaching manually each one to a post.

Hey Bazonline,

Well I have uploaded my images via the media library tool and uploaded them all at the same time. Now it’s a matter of attaching the second image to my posts. So it sounds like with your method you still need to manually add each image to the posts. Unless I’m misunderstanding you?

Yes it is a manual link to each post once you have imported all the images. I cannot find any reference to an easier method; at least this way is slightly faster than doing it the ordinary way through Upload New Media in back-office. Good luck! Let me know what your site looks like once you done,
Barry.

Hey Barry,

I appreciate the quick response. Ya, I have uploaded all my images for one of my product lines already. I had no issues using the Media Uploader.

I guess I’ll have to manually attach the second image.

If you want my site is already up and running, however I have quite a bit to do still: https://www.activestatedesigns.com

Basically if you search Denver in the top bar, you’ll get 6 products but all the same design. I am trying to figure out a way to make that one product and have a dropdown on the product page to select if it’s mens, womens, american apparel, etc. Then the buy now link jumps to the correct page since I don’t host my own shopping cart. I also am planning on adding the rest of my products and t-shirt designs for more than just Colorado.

Look through the site and feel free to give me any feedback! I’d greatly appreciate it. I too would be interested to see your site and what you do.

Thanks,
Lorne
ActiveState Designs | State Inspired Designs