field on csv is blank after upload – no image shown

  • justanotherguy

    (@justanotherguy)


    3 years, 11 months ago

    I am setting up a multi-site. I have Network Media Library installed, and can see all of my media across all sites. I have added an image to use as default, instead of the wc placeholder, on ONE site. Other sites use default wc placeholder.

    I have an issue which I have replicated numerous times on all sites, and cannot move past. Basically:

    My products are uploaded, but they have no images.

    If I manually add an image from library to Product, it works fine when I visit the site and scroll through the shop, and click on item.

    If I export the product csv and open in excel, the URL for the image is there. If I then import that file back into wc, the importer runs, and all is good with no error messages (it even shows the URL from the Image field when verifying mapping). BUT – after the importer has finished, the image is now missing from product. On websites with default wc placeholder, it does NOT show, but on site that I changed the placeholder, that default will show.

    If I export again and open csv in excel, the Image field is blank.

    I have tried adding numerous images manually, and also via copy and paste in excel. They all disappear when I upload. If I never upload, the manually added images stay on site. But, I need to upload / update via csv.

Viewing 6 replies - 1 through 6 (of 6 total)
  • dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    3 years, 11 months ago

    Hi @justanotherguy

    If I export the product csv and open in excel, the URL for the image is there. If I then import that file back into wc, the importer runs…after the importer has finished, the image is now missing from product

    Can you let me know what happens if you:

    a) re-export the products, is there no Image file or URL shown in the export?
    b) what happens if you manually Update the image?

    Thanks,

    Thread Starter justanotherguy

    (@justanotherguy)

    3 years, 11 months ago

    a) If I re-export and open in excel, Image field is blank – no URL or filename shown.
    b) If I manually update (edit) the product in wc and select an image from the media library, it works and I can view images fine. However, this would take forever to do all. Plus, the next time I uploaded a csv (to edit pricing, etc) I would lose all the images.

    Further to “b” above, I have manually updated a product and added image from library. Then exported the csv and noted the URL is there. Then imported same csv, and image disappears. Then re-exported csv, and URL is gone from <image> field.

    Thread Starter justanotherguy

    (@justanotherguy)

    3 years, 11 months ago

    Still looking for a fix for this

    Thread Starter justanotherguy

    (@justanotherguy)

    3 years, 11 months ago

    In case someone finds this thread from a search. I eventually tried to add the image IDs directly to my wp database for each product ID. When I downloaded the appropriate table as a csv I noticed that the ID numbers for the images are wrong in the wp database, so there is no chance of the images showing correctly.

    dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    3 years, 11 months ago

    Hi @justanotherguy

    I’ve re-read your query again and I only noticed this

    I have Network Media Library installed

    .

    My apologies, I thought you meant the standard media library and not a plugin. I can’t find this exact plugin so I’m not able to test.

    From what I understand, it sounds like your issue is related to how this plugin is handling the images rather than WooCommerce.

    Thanks,

    Thread Starter justanotherguy

    (@justanotherguy)

    3 years, 11 months ago

    I missed your reply, sorry.

    There are issues with the db tables from before I added the plugin. Essentially, when I converted to a multisite, there were multiple db created for some reason, even though the main db had tables for each subsite. There was also overlap of ID numbers. The plugin was added after the sites (and db) were created, and after the products were added. I tried to verify and repair db, but there was no action taken.

    I cleaned a lot of it up by getting rid of duplicate db and am now addressing the conflicting ID numbers.

    I now believe it is not a woocommerce issue, but stems from the multisite conversion. I stumbled upon the db issues after my initial post, hence the followup a week ago. Thanks for your time.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘field on csv is blank after upload – no image shown’ is closed to new replies.