• Resolved ruphusroger

    (@ruphusroger)


    Hello,

    so today I somehow screwed up my product images and thumbnails. I try to explain all my steps, I did so far.

    First things first. I do update my products through import of a .csv file. Normally that works quite good. Within that .csv file I give the exact path to the image/thumbnail of each product in the row ‘Images’. And that works – mostly. In the past those images were used as product images and as thumbnail, which is exactly what I need. Yesterday I realizes that some of my images were flawed and I had to recreate & upload them. Those images are saved in the /thumbnails folder. So I uploaded the updated images to that folder, believing that Woocommerce will now load the updated images – nope it did not. Then I thought maybe I need to import the products again so that the system flushes its cache (or something like that…) – noope. Then I deleted all products and reimported them – nothing changed.
    Then I followed the image URL form within the shop (private tab) and saw those images in a different folder under /uploads/2018/11/…png

    Then I deleted those files and since then I have no images shown at all. I repeated the steps from above and also deactivated and reactivated the whole Woocommerce plugin and I switched themes back and forth – nothing helped so far.

    So in short words: How can I tell Woocommerce to load the product images again from their original path, which is given by importing a .csv file?

    Here is my status report:

    
    ### WordPress Environment ###
    
    Home URL: https://www.gunbot-settings.com
    Site URL: https://www.gunbot-settings.com
    WC Version: 3.5.1
    Log Directory Writable: ?
    WP Version: 4.9.8
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.0.32 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP Post Max Size: 256 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 5000
    cURL Version: 7.60.0
    OpenSSL/1.0.2k
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.24
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 3.5.1
    WC Database Prefix: wpgs_
    Total Database Size: 12.99MB
    Database Data Size: 9.21MB
    Database Index Size: 3.78MB
    wpgs_woocommerce_sessions: Data: 0.84MB + Index: 0.05MB
    wpgs_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_downloadable_product_permissions: Data: 0.01MB + Index: 0.01MB
    wpgs_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.02MB
    wpgs_woocommerce_tax_rates: Data: 0.01MB + Index: 0.01MB
    wpgs_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wpgs_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wpgs_cfs_contacts: Data: 0.00MB + Index: 0.00MB
    wpgs_cfs_countries: Data: 0.01MB + Index: 0.00MB
    wpgs_cfs_forms: Data: 0.13MB + Index: 0.00MB
    wpgs_cfs_membership_presets: Data: 0.00MB + Index: 0.00MB
    wpgs_cfs_statistics: Data: 0.00MB + Index: 0.00MB
    wpgs_commentmeta: Data: 0.00MB + Index: 0.00MB
    wpgs_comments: Data: 0.01MB + Index: 0.01MB
    wpgs_failed_jobs: Data: 0.00MB + Index: 0.00MB
    wpgs_links: Data: 0.00MB + Index: 0.00MB
    wpgs_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
    wpgs_options: Data: 0.96MB + Index: 0.07MB
    wpgs_postmeta: Data: 6.05MB + Index: 2.76MB
    wpgs_posts: Data: 0.70MB + Index: 0.19MB
    wpgs_queue: Data: 0.00MB + Index: 0.00MB
    wpgs_termmeta: Data: 0.01MB + Index: 0.02MB
    wpgs_terms: Data: 0.00MB + Index: 0.02MB
    wpgs_term_relationships: Data: 0.26MB + Index: 0.58MB
    wpgs_term_taxonomy: Data: 0.01MB + Index: 0.01MB
    wpgs_UPCP_Catalogues: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Catalogue_Items: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Categories: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Custom_Fields: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Fields_Meta: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Items: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Item_Images: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_SubCategories: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Tagged_Items: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Tags: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Tag_Groups: Data: 0.00MB + Index: 0.00MB
    wpgs_UPCP_Videos: Data: 0.00MB + Index: 0.00MB
    wpgs_usermeta: Data: 0.19MB + Index: 0.02MB
    wpgs_users: Data: 0.00MB + Index: 0.01MB
    wpgs_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wpgs_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wpgs_wpgdprc_consents: Data: 0.00MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    attachment: 187
    customize_changeset: 23
    nav_menu_item: 16
    page: 14
    post: 2
    product: 278
    revision: 62
    shop_coupon: 4
    shop_order: 17
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (6) ###
    
    Contact Form 7: by Takayuki Miyoshi – 5.0.5
    GDPR Cookie Consent: by WebToffee – 1.7.0
    Enhanced E-commerce for Woocommerce store: by Tatvic – 2.1.4
    Mailchimp for WooCommerce: by Mailchimp – 2.1.11 – Not tested with the active version of WooCommerce
    MyCryptoCheckout: by edward_plainview – 2.25
    Woo Checkout for Digital Goods: by Multidots – 2.3
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: right_space
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    ### WC Pages ###
    
    Shop base: #5 - /shop/
    Cart: #6 - /cart/
    Checkout: #7 - /checkout/
    My account: #8 - /account/
    Terms and conditions: #11 - /terms/
    
    ### Theme ###
    
    Name: Storefront
    Version: 2.3.5
    Author URL: https://woocommerce.com/
    Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: –
    

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter ruphusroger

    (@ruphusroger)

    Update:
    When I now import brand new products, those will have their individual image shown.
    So only “old” products which I want to UPDATE will not receive their correct image.

    I remember, that the import would even fail, if the stated image and its path can not be found.

    Thread Starter ruphusroger

    (@ruphusroger)

    Update:
    When I export the products, the Image coloumn states a different (standard?) URL path to the image, which logically does not exists.

    On Export the URL states: …/wp-content/uploads/2018/10/….png

    But on import the Image coloumn states: wp-content/thumbnails/…..png

    Why does WooCommerce change my cutsotm URL to that standard one on import?!

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    Thank you for all of that information! I’m glad you were able to narrow it down a bit further.

    I have a few more questions to ask to better understand what’s happening:

    * New products are now working correctly – is that right?
    * Old / already existing products no longer have product images – is that right?
    * What happens if you try to manually update a product’s image – does the image show up correctly?

    Thread Starter ruphusroger

    (@ruphusroger)

    Hello Hannah,
    thank you very much for your response.

    To answer your questions:
    * New products are now working correctly – is that right?
    Correct. It works with my custom path ….com/wp-content/thumbnails/image.png

    * Old / already existing products no longer have product images – is that right?
    Correct. When I export products it show the path ….com/wp-content/uploads/image.png

    * What happens if you try to manually update a product’s image – does the image show up correctly?
    If I manually change the product image:
    1. I can not choose the image from my custom folder, which is used by importing through CSV.
    2. If I use the upload function and use that uploaded image, that image is shown. The image is then stored again in ….com/wp-content/uploads/image.png

    So I question myself:
    1. Why did it work with my custom folder before?
    2. Is there no way to individually structure my data like thumbnails / product images?

    Thread Starter ruphusroger

    (@ruphusroger)

    Please can you assist me, to prevent WooCommerce from resetting my custom URL?

    I assume WC is always resetting the Image URL to the default one, which is for (most) products /wp-content/uploads/2018/11 or 10 or 9 or something. depends on the product.

    Some days earlier I disabled to WP option to structure the media in subdirectories like /2018/11. So new product image URLs are rewritten to /wp-content/uploads/ while old product image URLs are rewritten to /wp-content/uploads/2018/**

    None of my products uses my custom URL which points to the folder /wp-content/thumbnails/

    Thread Starter ruphusroger

    (@ruphusroger)

    I really do not understand what the heck woocommerces problem is!?

    Right now I followed the first post on this topic: https://gist.github.com/mikaelz/d574457cb22f1f79f337 and deleted all products from the SQL database using the SQL statements.

    Then I imported my CSV file again and the freshly created products still seek their product images in wp-content/uploads/2018/11/ or 10 or 9

    wth?

    • This reply was modified 6 years, 3 months ago by ruphusroger.
    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    I’m sorry for the slow response time – the notifications for this post got lost on my end.

    At this point, I’m not sure what’s going on without being able to log into your site. That’s not something that we can do from forum support. I highly recommend contacting one of the services on our customizations page: https://woocommerce.com/customizations/

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Product Images and Thumbnails not loading’ is closed to new replies.