cjholdsworth
Forum Replies Created
-
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.
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!
ChrisForum: Plugins
In reply to: [WooCommerce] WooCommerce product attribute count is wrong@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!
Forum: Plugins
In reply to: [WooCommerce] WooCommerce product attribute count is wrongNo, 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 > LogsI 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
Forum: Plugins
In reply to: [WooCommerce] WooCommerce product attribute count is wrongHi Con,
Did you have any further ideas? Can I give you access to see the issue for yourself?
Kind regards,
Chris.Forum: Plugins
In reply to: [WooCommerce] WooCommerce product attribute count is wrongHi 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.Forum: Plugins
In reply to: [WooCommerce] WooCommerce product attribute count is wrongHello,
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.jpgIt 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.