• Resolved kyperstudios

    (@kyperstudios)


    Hi,

    I was trying to bulk update stock value of more than 3000 products. After I have imported the CSV with updated stock value (I also have checked the checkbox of “Existing products that match by ID or SKU will be updated. Products that do not exist will be skipped.”), there are 50 products did not get updated with their stock, 48 of them got the unrelevant error log as shown in the image below:

    https://ibb.co/pjjDmwZ

    Then I tried again to import another CSV again, this time only with these 50 products. the 2 products without the error log can be updated now, but the 48 products was still skipped.

    My question is
    1. The bulk update by CSV importer seems inconsistent as it took me multiple time of import to ensure they update all the updated value? Is it true that it sometimes happen or have I missed out any detail to make it work like it should during the first import (I expected when i checked the checkbox, all existing product with updated value should be successfully updated in just one time of import)?

    2. The unrelevant error log was about error getting remote image. error: forbidden. It did not show the image of product like the image below show:
    https://ibb.co/BNqmnZK

    But when I clicked the empty space, it somehow pop out this:
    https://ibb.co/kQ6Wnw4

    The photos are hosted in photobucket, the other products work well but only these 48 images are having this error. Anything I should look into?

    Thanks.
    Kyper Studios

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter kyperstudios

    (@kyperstudios)

    And also another related question here:

    I tried to update the stock value to out of stock doing bulk action here:
    https://ibb.co/ngNZbKY
    https://ibb.co/vvNwL2Q

    But after I click the button “Updated”, the stock is still not able to be updated. Why is that so?

    Hello @kyperstudios ,

    If I understand correctly, you are trying to import products using the default product import feature in WooCommerce available under in wp-admin > Products > Import section, right?

    1. The bulk update by CSV importer seems inconsistent as it took me multiple time of import to ensure they update all the updated value? Is it true that it sometimes happen or have I missed out any detail to make it work like it should during the first import (I expected when i checked the checkbox, all existing product with updated value should be successfully updated in just one time of import)?

    The CSV import feature will continue to run as long as the server time does not exceed for a single operation. All products should be imported/updated if there are no errors shown after the import.

    You can try after increasing your maximum execution time following this guideline: How to increase Maximum Execution Time for WordPress site

    2. The unrelevant error log was about error getting remote image. error: forbidden. It did not show the image of product like the image below show:
    https://ibb.co/BNqmnZK

    At the time of import, the images need to be available online. If the image is not available at the time of import you will most likely get the “Error getting remote image” message. I will recommend trying to access the image files directly first and see if you can see the direct image file. Make sure that the image files are available publicly which means anyone can open the image if they have the image link.

    I tried to update the stock value to out of stock doing bulk action here:
    https://ibb.co/ngNZbKY
    https://ibb.co/vvNwL2Q
    But after I click the button “Updated”, the stock is still not able to be updated. Why is that so?

    Do you see any error message when you try to update the stock value using the “Bulk Update” option?

    Could you please navigate to **WooCommerce > Status > Logs** and from the dropdown on the right side, please see if there are any logs starting with the words **fatal-error**?

    It will be great if you could share your current System Status Report. You can get it by navigating to the WooCommerce > Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

    Thank you ??

    Plugin Support Stuart Duff – a11n

    (@stuartduff)

    Automattic Happiness Engineer

    Hey @kyperstudios,

    With regards to updating products using the CSV import method, it the error log which is displaying indicates that WooCommerce could not fetch the images. The reason for that error is that the website you were fetching those images from returned a Forbidden message. Forbidden means the images at that time could not be accessed from the remote website.

    Any images imported from a remote website would should also be created in the WordPress Media Libray. It then those images with the Media Library that would be assigned to the products.

    https://docs.woocommerce.com/document/product-csv-import-suite-faq-troubleshooting/#section-3

    Ideally, the image string being imported should end with either .jpg or .png with no other parameters after it as I can see in this example below.

    Image Link: https://cloudup.com/cRq4chGUiOf

    One test would be to upload the images for several of the failures to the WordPress media library. Then reference those Media Library images from the CSV file you importing. If the import does not then fail for those image imports that indicates the issue is with the Photobucket imports for some peculiar reason.

    The documentation below may also offer some assistance with image failures.

    https://docs.woocommerce.com/document/product-csv-import-suite-faq-troubleshooting/#section-9

    I tried to update the stock value to out of stock doing bulk action here:
    https://ibb.co/ngNZbKY
    https://ibb.co/vvNwL2Q

    But after I click the button “Updated”, the stock is still not able to be updated. Why is that so?`

    Testing for us today on several of my installations of WooCommerce I was able to successfully update my site’s product manage stock in bulk. After doing so all of the products I set as Out of Stock displayed as Out of Stock on my test installation. Regrettably, I wasn’t able to replicate the behaviour which you describe on two separate test installations I have.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Few Products Update is skipped even SKU is matched, error getting remote image’ is closed to new replies.