Forum Replies Created

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

    (@cjholdsworth)

    SOLVED! Yes, you can use html code in the Google Sheet cell and it imports across perfectly well.

    I just manually added the image (from my media library) to the cell in TablePress, then copied that text it created and pasted it in to the equivalent cell in my Google Sheet. Now the autoimport simply copies that html from Google Sheet in to TablePress and it all works exactly as I had hoped.

    Thread Starter cjholdsworth

    (@cjholdsworth)

    Thank you. I will look in to this. The table did autoupdate overnight, so it must be to do with site traffic.
    Thanks for your help!
    Chris

    Thread Starter cjholdsworth

    (@cjholdsworth)

    @tyfricko
    I’ve not solved this but I’ve found a work around that worked for me.

    Go to Products/Attributes

    Click ‘Configure terms’ (in an attribute that is counted incorrectly)

    Click on the ‘Count’ column for a term that is counted incorrectly (in my error the count would be 0 but I would have way more than zero products that listed when I did this)

    Click ‘Edit’ on any product in that list.

    Click Publish/Update.

    In my error this would then correctly count every product in that Attribute/term. I then needed to do that for every term of every attribute to get all the counts correct.

    Hope this helps you and someone else, so frustrating!

    Thread Starter cjholdsworth

    (@cjholdsworth)

    No, its not solved. I haven’t performed the following which was recommended to me…

    Hi Chris,

    Thanks for those credentials. I was able to log in and check some things on your site. I also tried:

    Recounting terms (WooCommerce > Status > Tools > Term counts > Click – Recount Terms (Button on right))
    Rebuilding the product lookup table again (WooCommerce > Status > Tools > Product lookup tables > Click – Regenerate (Button on right))
    Checking for any errors coming from these updates under WP Admin > WooCommerce > Status > Logs

    I wasn’t able to get the attribute count to change, and I see that there are other attributes acting the same way:

    Image Link: https://d.pr/i/3Sg59f

    For each of those, I could see products listed when I click on the zero.

    Is there anything about the products with those attributes that are different from the products with the correct counts appearing? If they’re using a particular feature, that may help us narrow this down.

    Conflict Testing

    If that doesn’t identify the issue, this may be caused by a conflict with your theme or with another plugin. In this case, it may be a plugin or theme conflict interfering with the proper operation of the product lookup tables rebuild or the term count checks. I’d recommend cloning your site to a staging environment and performing the following tests without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

    On that site, deactivate all plugins on your site except WooCommerce and switch to a default theme like Storefront or Twenty Twenty. Then, use the Recount Terms and Regenerate product lookup tables tools to regenerate everything (That last one does take some time to regenerate everything. You can check the status of the process from your Scheduled Actions tab. That link will take you directly to the running processes for this tool, or you can navigate to WooCommerce > Status > Scheduled Actions > Pending and search for wc_update_product_lookup_tables).

    If that sets the right counts. Enable your theme and plugins one at a time, checking to make sure the counts stay correct as you go. If everything goes back to 0 again, then that plugin is causing the issue.

    Next steps

    Let us know if it still doesn’t work with the other plugins deactivated or if you need any further assistance.

    Also, I see that you’re using the Stripe extension. That actually qualifies you for WooCommerce.com support, so you can get assistance via our support page any time.

    Best,

    Mike S – Happiness Engineer

    Thread Starter cjholdsworth

    (@cjholdsworth)

    Hi Con,
    Did you have any further ideas? Can I give you access to see the issue for yourself?
    Kind regards,
    Chris.

    Thread Starter cjholdsworth

    (@cjholdsworth)

    Hi Con,
    I did try that before, and I have tried it again now. It hasn’t changed anything unfortunately.
    I also tried to ‘regenerating product lookup tables’ but that didn’t change anything either.
    Thank you for your continuing help.

    Thread Starter cjholdsworth

    (@cjholdsworth)

    Hello,
    Thank you so much for your reply!

    You mean this here: https://d.pr/i/eXCsdx – correct?

    Yes, Attribute-Metal->Tantalum has a count of 0
    https://www.holdsworthbros.com/wp-content/uploads/2020/08/MetalsTantalum.jpg

    It does load the backend page – exactly as you described, but with the 9 items in it.

    https://www.holdsworthbros.com/wp-content/uploads/2020/08/MetalsTantalumProducts.jpg

    And I don’t know why 🙁
    Kind regards,
    Chris.

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