Images being imported incorrectly

  • Resolved matthew_astutech

    (@matthew_astutech)


    10 years, 1 month ago

    I’m having a lot of difficulty importing some product images.

    I can run the import task, and the rest of the data appears to go in fine. However, the featuredimages aren’t being picked up correctly – most of them don’t have an image, the rest have the wrong image. They do seem to be imported into WordPress – they just don’t get matched up with the products.

    During the import, every row seems to return a message like that below:

    --> row:1562 / 1566

ID : not found!

ID :397 not found!

    Here’s a sample of the data from the file:

    ID,Post_title,Bottle Size,ABV,Category,Brand,Sub-Style,Country,post_content,Grape Variety,Cocktails,ManagersChoice,Food Match,1 Red Meat,2 White Meat,3 Seafood,4 Salads,5 Cheese,6 Desserts,7 Aperitif,8 BBQ,9 Pasta,10 Asian/Spicy,11 Tapas,12 Fish,13 Poultry,14 Game,15 Pizza,Sell Price(per bottle) Inc VAT,Sell Price(per bottle) Ex VAT,Special Offer Price,Offer Text,X FOR ?XX?Offer Qty,X FOR???XX Offer Price,Offer Start,Offer Finish,Save,Multibuy Text,Multibuy Price (bottle),,Featured_Image,Stock
5475,Kuyen Malbec,75cl,12.50%,"Wine, Champagne, Sparkling and Fortified Wine->Wine->Red",Kuyen,,Argentina,"An easy drinking ruby-red wine with a soft and persistent aroma, a delicate and pleasant bouquet of young wood and a rounded velvety flavour.",Malbec,,,"Red Meat,Cheese,BBQ",Red Meat,,,,Cheese,,,BBQ,,,,,,,,6.2,5.17,,,,,,,,,,,5475.jpg,instock

    Can anyone suggest what might be going wrong?

    https://www.ads-software.com/plugins/woocommerce-csvimport/

Viewing 9 replies - 1 through 9 (of 9 total)

  • I’m having same issue. The images aren’t being picked up correctly because the products are being matched with the same issue. I’ve spent tons of hours on this.

    Any suggestion as to what’s going on?

    Plugin Author allaerd

    (@allaerd)

    if you have the ID field, it tries to find the product in in the database with that ID ( this is something else than SKU). Of it can not find it, it will show that message.

    you have 5475.jpg as a featured image. this means you do have to upload this image up front in the media manager. If you do so, the importer will link that image to your product.

    @allaerd,

    You mention uploading images via the Media Manager. Does that mean that FTP uploads do no longer work anymore?
    In previous versions we just uploaded images on FTP and inserted the whole url of the images folder in the CSV to import ‘images’ column. (https://site.com/images/shop/image1.jpg|http:/site.com/images/shop/image2.jpg)

    Does your response mean that this no longer works and that we have to import all images manually using the WP media manager prior to running CSV importer?

    To make it clear (the reason for posting this):
    The above import from ftp folder does not work anymore. The images are on the FTP and after visiting the link to the ftp folder, the image shows correctly. However, after running CSVimporter, the images are not imported/linked to the products.

    Developer seems to be unresponsive on this thread, as well as on a message send on the contact form on his own website.

    Plugin Author allaerd

    (@allaerd)

    Uploading with URL works great. You must have cURL installed. BEWARE, images will be uploaded every time. This can lead to duplicated images!

    Else use the filename and upload the images in front in the media manager of wordpress.

    @allaerd,

    It still does not work.
    cURL is installed, path to images is correct, but the plugin does not import the images.

    I also checked for duplicated images, but the images are just not there.

    I use this type of notation that worked fine for hundreds of past uploaded products:
    https://www.site.nl/images/shop/F/700001030-1-800×600.jpg|https://www.site.nl/images/shop/F/700001030-2-800×600.jpg|https://www.site.nl/images/shop/F/700001030-3-800×600.jpg|https://site.nl/images/shop/F/700001030-4-800×600.jpg

    Plugin Author allaerd

    (@allaerd)

    are you using the product_gallery field?

    I’m experiancing this problem aswell..
    I’ll debug it tomorrow and see what i can find.

    Plugin Author allaerd

    (@allaerd)

    make sure you use version 3.0.3 or later. Extra functionality is added there for image URL’s

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Images being imported incorrectly’ is closed to new replies.