ProductCategory Widget not updating Products

here some pictures…
https://ibb.co/YcSXxCb
https://ibb.co/xSDRkJS
https://ibb.co/7YHTzgN
https://ibb.co/Jd5hBVG

if i would quick edit the product and just press update, without any actions, this product will be shown.

• This reply was modified 2 years, 6 months ago by sectomy. Reason: typo

Hi @sectomy

Thank you for reaching out!

In order for us to get a better understanding of your site setup, could you please share a copy of your website’s 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.

hi,

### WordPress Environment ###

WordPress address (URL): https://thewildstyle.de
Site address (URL): https://thewildstyle.de
WC Version: 6.9.3
REST API Version: ? 6.9.3
WC Blocks Version: ? 8.3.2
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: de_DE
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.30
PHP Post Max Size: 75 MB
PHP Time Limit: 180
PHP Max Input Vars: 1500
cURL Version: 7.61.1
OpenSSL/1.1.1k

SUHOSIN Installed: –
MySQL Version: 5.7.39-log
Max Upload Size: 50 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.9.3
WC Database Prefix: wp_
Datenbank-Gesamtgr??e: 964.18MB
Datenbank-Datengr??e: 544.91MB
Datenbank-Indexgr??e: 419.27MB
wp_woocommerce_sessions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_api_keys: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Daten: 13.40MB + Index: 4.67MB + Engine MyISAM
wp_actionscheduler_claims: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Daten: 8.98MB + Index: 6.82MB + Engine MyISAM
wp_aioseo_cache: Daten: 7.17MB + Index: 0.26MB + Engine MyISAM
wp_aioseo_links: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_aioseo_links_suggestions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aioseo_notifications: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_aioseo_posts: Daten: 43.49MB + Index: 1.46MB + Engine MyISAM
wp_aioseo_redirects: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_aioseo_redirects_404: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aioseo_redirects_404_logs: Daten: 0.03MB + Index: 0.01MB + Engine MyISAM
wp_aioseo_redirects_hits: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aioseo_redirects_logs: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aioseo_terms: Daten: 0.15MB + Index: 0.05MB + Engine MyISAM
wp_cmplz_cookiebanners: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cmplz_cookies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cmplz_services: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_comments: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_fbv: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fbv_attachment_folder: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_import_detail_log: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_log_detail: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_postID: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_monsterinsights_pageinsights_cache: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Daten: 3.62MB + Index: 0.14MB + Engine MyISAM
wp_pmxi_files: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_hash: Daten: 1.51MB + Index: 1.44MB + Engine MyISAM
wp_pmxi_history: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_images: Daten: 2.28MB + Index: 0.21MB + Engine MyISAM
wp_pmxi_imports: Daten: 0.20MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_posts: Daten: 14.27MB + Index: 0.61MB + Engine MyISAM
wp_pmxi_templates: Daten: 0.20MB + Index: 0.00MB + Engine MyISAM
wp_postmeta: Daten: 137.38MB + Index: 48.83MB + Engine MyISAM
wp_posts: Daten: 50.83MB + Index: 7.35MB + Engine MyISAM
wp_smackcsv_file_events: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smackuci_events: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_social_users: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_termmeta: Daten: 0.20MB + Index: 0.18MB + Engine MyISAM
wp_terms: Daten: 0.26MB + Index: 0.28MB + Engine MyISAM
wp_term_relationships: Daten: 5.39MB + Index: 11.37MB + Engine MyISAM
wp_term_taxonomy: Daten: 0.15MB + Index: 0.19MB + Engine MyISAM
wp_ultimate_csv_importer_acf_fields: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_mappingtemplate: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_media: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_shortcode_manager: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_post_entries: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_users: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_admin_notes: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_category_lookup: Daten: 0.04MB + Index: 0.06MB + Engine MyISAM
wp_wc_customer_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_download_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_stats: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_tax_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_attributes_lookup: Daten: 5.81MB + Index: 7.32MB + Engine MyISAM
wp_wc_product_download_directories: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_product_meta_lookup: Daten: 2.69MB + Index: 3.15MB + Engine MyISAM
wp_wc_rate_limits: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_reserved_stock: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpforms_tasks_meta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wps_hit: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wps_index: Daten: 193.36MB + Index: 296.39MB + Engine MyISAM
wp_wps_key: Daten: 2.49MB + Index: 3.19MB + Engine MyISAM
wp_wps_object_term: Daten: 13.34MB + Index: 17.73MB + Engine MyISAM
wp_wps_object_type: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wps_query: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wps_uri: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wps_user_agent: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_action_history: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wt_iew_mapping_template: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yith_wapo_groups: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yith_wapo_types: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yith_wcwl: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yith_wcwl_lists: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_indexable: Daten: 34.50MB + Index: 3.00MB + Engine MyISAM
wp_yoast_indexable_hierarchy: Daten: 0.27MB + Index: 0.63MB + Engine MyISAM
wp_yoast_migrations: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_primary_term: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_prominent_words: Daten: 2.47MB + Index: 3.75MB + Engine MyISAM
wp_yoast_seo_links: Daten: 0.19MB + Index: 0.05MB + Engine MyISAM

### Post Type Counts ###

attachment: 13193
blocks: 22
customize_changeset: 121
featured_item: 8
nav_menu_item: 384
page: 121
post: 67
product: 44156
revision: 163
ux_template: 1
wp_global_styles: 2

### Security ###

Secure connection (HTTPS): ?
Dein Shop benutzt kein HTTPS. Erfahre mehr über HTTPS und SSL-Zertifikate.
Hide errors from visitors: ?

### Active Plugins (27) ###

Preserve Page and Taxonomy Hierarchy on Edit Menus Screen: von Sergey Biryukov – 0.1
AIOSEO – Image SEO: von All in One SEO Team – 1.1.0.1
AIOSEO – IndexNow: von All in One SEO Team – 1.0.5
AIOSEO – Link Assistant: von All in One SEO Team – 1.0.9
AIOSEO – Redirects: von All in One SEO Team – 1.2.3
All in One SEO Pro: von All in One SEO Team – 4.2.5.1
Complianz | GDPR/CCPA Cookie Consent: von Really Simple Plugins – 6.3.3
Complianz – Allgemeine Gesch?ftsbedingungen: von Really Simple Plugins – 1.1.2
MonsterInsights Pro: von MonsterInsights – 8.8.2
WP All Import – All In One SEO Add-On: von Soflyy – 2.0.0
Impressum: von Epiphyt – 2.0.0
Max Mega Menu: von megamenu.com – 2.9.8
Menu Management Enhancer: von Chris Mavricos
SevenSpark – 1.2

MonsterInsights – EU Compliance: von MonsterInsights Team – 2.2.1
MonsterInsights – Google Optimize Addon: von MonsterInsights Team – 1.5.0
MonsterInsights – Page Insights Addon: von MonsterInsights Team – 1.4.1
MonsterInsights – Performance Addon: von MonsterInsights Team – 1.7.1
PW WooCommerce Bulk Edit: von Pimwick
LLC – 2.105

Real Category Management: von devowl.io – 4.1.21
WooCommerce Breadcrumbs: von Anthony Hortin – 1.0.8
WooCommerce Product Search: von itthinx – 4.7.0
WooCommerce: von Automattic – 6.9.3
WP All Import Pro: von Soflyy – 4.7.6
WP Super Cache: von Automattic – 1.9
WP All Import – WooCommerce Import Add-On Pro: von Soflyy – 3.3.3

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
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)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: ?

### WC Pages ###

Shop-Basis: #16 – /shop/
Warenkorb: #2504 – /cart/
Kasse: #2503 – /checkout/
Mein Konto: #2502 – /my-account/
Allgemeine Gesch?ftsbedingungen: #2735 – /allgemeine-geschaeftsbedingungen/

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL:
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.16.0
Parent Theme Author URL: https://uxthemes.com
WooCommerce Support: ?

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/rating.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
settings

Daily Cron: ? Next scheduled: 2022-09-22 09:40:42 +02:00
Options: ?
Notes: 24
Onboarding: completed

### Action Scheduler ###

Complete: 49.204
Oldest: 2022-09-10 13:50:09 +0200
Newest: 2022-09-21 17:53:49 +0200

Pending: 8
Oldest: -0001-11-30 00:53:28 +0053
Newest: 2022-09-25 17:12:15 +0200

### Status report information ###

Generated at: 2022-09-21 17:53:58 +02:00
`

Hi @sectomy

Thanks for sending the System Status Report.

Can you please resend the screenshots above as the links you provided were unreachable?

If you don’t already have a screenshot service installed, you can try https://snipboard.io or https://skitch.com/. You can share the direct link to the image as a response to this topic.

Real Category Management: von devowl.io – 4.1.21

MEanwhile, can you please try to disable this plugin and see if that works?

If that did not resolve the issue, please perform a full conflict test to rule out any possible conflict with your theme or third-party plugin present on your site:

https://woocommerce.com/document/how-to-test-for-conflicts/

hi,

this Plugin ive installed afterwards for this problem ??
but yes, ive disabled it, one more thing, when i reimport the same list and select “update” existing fields and set it to “republish”, then theyre visible. Ill run an import right now and ill test if the double import work, isnt good solution, but maybe a workaround so far we or I have a solution for the Problem.
The pictures:
https://snipboard.io/AwJxis.jpg
https://snipboard.io/RvqLpj.jpg
https://snipboard.io/v7eZnz.jpg
https://snipboard.io/E3bB6p.jpg
https://snipboard.io/NhkRiG.jpg
(last picture is when i click on the Category widget in the shop: it says: No selected Product in this category)

but on recent products it will be shown inclusive the Categories where its in)

funny thing is, some categories are showing some products, others dont…
or in category are 12 items, visible only 3….

is there maybe a cronjob i can install, just to make the publish status set ? problem here would be, i need to run it at once, i dont know how long it would take on 100K products ??

Hello!

I import CSV Data, the Categories will be created in the Lists and the Products are importing and show up on recent Items.
If i click on one Item it also tells me it is in the correct Category, BUT if i click on the Category its empty.

Regarding this part, can you provide a copy of your CSV at least with one of the products that is having the issue? So that we can try t reproduce the issue on our end.

Pending: 8

is there maybe a cronjob i can install, just to make the publish status set ?

I understand your point, can you please try the following, please navigate to WooCommerce > status > scheduled actions > pending Run all the pending actions (if applicable) then you can allow some time, and try again to check if the issue persists.

Let us know how that goes.

i think its an issue with the brands plug in, maybe, its the problem….
YITH Brands Add on
but unfortuneltly….. its all fine when i run the same WP all import once again and just say: update the visibility to show all
and it works, and i can go up with 300 updates per cycle….
its dumb….. but, tbh, i dont know what we could else do ??
for me…. would be nice if theres an DB Query, or maybe a php self plugin, which does the same on WordPress side, as this with the Importer.
It just need to be refreshed (set visibility on shop& search) again.
curios thing is, that just the widget of category dont update (does it need the wp_insert_post to be updated ?) cause, ill disable it during import….
and yes, i need to, ill import 40K items or more ??

Hello,

is there maybe a cronjob i can install, just to make the publish status set ?

To help you manage your crons you can use the plugin WP Crontrol.

i think its an issue with the brands plug in, maybe, its the problem….
YITH Brands Add on

I am unable to see the plugin YITH WooCommerce Brands Add-On on your site’s system status report. If this changed on your configuration please provide us the new System status report.

I have read you have disabled your plugins already, my recommendation is to run a fully conflict test, like this:

— Switch your theme temporarily to Storefront
— Disable all plugins, except WooCommerce
— Repeat the steps/actions that are causing the problem

At this point check if the issue is still present, if not, it means there was a conflict and you can reactivate the theme and plugins gradually one by one and check again after each reactivation until the cause of the issue is found.

More information is below:
https://docs.woocommerce.com/document/how-to-test-for-conflicts/

Let us know how this goes for you.