Error: Unauthorized–CSV import to replace product images

  • Resolved sevans917

    (@sevans917)


    2 years, 5 months ago

    I am replacing hundreds of images on existing products (variable and simple). All new images were uploaded to the media library in advance, with a new prefix on the file names. I then exported products, edited file names to include the new prefix, then attempted to import the changes. For most products this worked fine, but ~15% of the products failed to accept the new file name.

    When I CSV import the entire image file path, the error is simply “Unauthorized“.

    When I CSV import just the new file name, the error is “Unable to use image…”

    If I edit an individual product itself, and replace old image with new, no problems at all.

    Looking through similar questions, I saw suggestions to try Disable Real Mime Type plugin. Did not help.

    • This topic was modified 2 years, 5 months ago by sevans917.
Viewing 6 replies - 1 through 6 (of 6 total)

  • Hello,

    For most products this worked fine, but ~15% of the products failed to accept the new file name.

    To take a better look, can you provide a copy of the CSV file? Can you keep one product that worked fine, and one product that failed? No need to keep more products, so that we can check.

    You can share the URL to the file once it is uploaded via Google Docs, for example.

    We’ll look forward to hearing from you.

    • This reply was modified 2 years, 5 months ago by Igor H.
    Thread Starter sevans917

    (@sevans917)

    @ihereira — thanks. I’ve come to realize the issue is primarily with the primary and gallery images, when product has more than one image.

    Variants only have one image, and those were mostly fine. It’s the simple and variable products that have at least one gallery image (in addition to primary image) that result in failures.

    To that end, in the IMAGES column of the CSV, I tried both pipe and comma separated, but neither work.

    Wondering why the CSV format doesn’t match the product edit page, for images. Should have two columns, not one?

    Hello,

    when product has more than one image.

    You can check the Product CSV Import Schema:
    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

    If the column images need to include multiple image URLs you can separate them by , example below:


    Link to image: https://snipboard.io/iUwIfo.jpg

    I hope this provides clarity.

    Thread Starter sevans917

    (@sevans917)

    Yes, your example is exactly how I started. It isn’t working with every product. Anyway, thanks for your input.

    Hi @sevans917

    Another thing I’d suggest is to disable all plugins except WooCommerce, switch theme to Storefront, and try updating the CSV file again to see if you still get the same error.

    You can find a detailed explanation on how to do a conflict test here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    Additionally, as @ihereira asked previously, sharing your CSV file will be helpful to troubleshoot further. You can use an online fileshare like file.io, Google Drive, DropBox, etc.

    Hi @sevans917

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem! If you have further questions, please feel free to open a new topic.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Error: Unauthorized–CSV import to replace product images’ is closed to new replies.