126 variations bulk price update don’t work
-
Hi,
I created 126 product variations but bulk price update don’t work because it’s never finished.
It’s always the loading icons showing…
Can you help to get this work? Thank you very much.
Best regards
AndréThe page I need help with: [log in to see the link]
-
The max used to be 30 I know you can add more than that now, but 126 on a standard server isn’t going to happen. Your putting too much load on the server to handle.
Hey there, @purevelvetdesign! Thanks for contacting us. I’m happy to help you.
I just tested a product with 150 variations on my website and I was able to bulk-set the price.
Can you please share the System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support so we can take a look?
Looking forward to your reply.
Have a wonderful day!
Hi there, thank you very much for testing that for me! :) So I already requested to increase the max execution time limit by the webhoster. I send you the system report. Thank you very much for assisting and supporting me here :) Best regards André
WordPress Environment WordPress address (URL): https://stage.bowling-shop.de Site address (URL): https://stage.bowling-shop.de WC Version: 8.8.3 REST API Version: ? 8.8.3 Action Scheduler Version: ? 3.7.4 Log Directory Writable: ? WP Version: 6.5.3 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: 8.2.18 PHP Post Max Size: 16 MB PHP Time Limit: 60 PHP Max Input Vars: 1000 cURL Version: 7.61.1 OpenSSL/1.1.1k SUHOSIN Installed: – MySQL Version: 10.6.17-MariaDB Max Upload Size: 16 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 8.8.3 WC Database Prefix: b_wp_ Datenbank-Gesamtgr??e: 902.06MB Datenbank-Datengr??e: 833.25MB Datenbank-Indexgr??e: 68.81MB b_wp_woocommerce_sessions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_woocommerce_api_keys: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_attribute_taxonomies: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB b_wp_woocommerce_order_items: Daten: 0.33MB + Index: 0.13MB + Engine InnoDB b_wp_woocommerce_order_itemmeta: Daten: 1.52MB + Index: 2.00MB + Engine InnoDB b_wp_woocommerce_tax_rates: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB b_wp_woocommerce_tax_rate_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_shipping_zones: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_woocommerce_shipping_zone_locations: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB b_wp_woocommerce_shipping_zone_methods: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_woocommerce_payment_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_woocommerce_payment_tokenmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_log: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB address_book: Daten: 0.27MB + Index: 0.08MB + Engine MyISAM address_format: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM admin_access: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM banktransfer: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM banktransfer_blz: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM banners: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM banners_history: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM bewertung: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM bewertung_config: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM billpay_bankdata: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM billpay_edit_orders_buffer: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM b_wp_actionscheduler_actions: Daten: 0.30MB + Index: 0.45MB + Engine InnoDB b_wp_actionscheduler_claims: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_actionscheduler_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_actionscheduler_logs: Daten: 0.22MB + Index: 0.19MB + Engine InnoDB b_wp_aws_cache: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_aws_index: Daten: 4.52MB + Index: 4.53MB + Engine InnoDB b_wp_commentmeta: Daten: 1.52MB + Index: 0.55MB + Engine InnoDB b_wp_comments: Daten: 2.52MB + Index: 1.47MB + Engine InnoDB b_wp_elex_bep_bulk_edit_job_schedule: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_elex_bep_bulk_edit_subjob_schedule: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_elex_bep_jobs: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_elex_bep_job_undo_products: Daten: 1.52MB + Index: 0.00MB + Engine InnoDB b_wp_et_bloom_stats: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_hcaptcha_events: Daten: 0.02MB + Index: 0.09MB + Engine InnoDB b_wp_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_lockdowns: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_login_fails: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_nextcart_seo_url: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_options: Daten: 4.06MB + Index: 0.17MB + Engine InnoDB b_wp_postmeta: Daten: 11.50MB + Index: 11.52MB + Engine InnoDB b_wp_posts: Daten: 18.48MB + Index: 0.84MB + Engine InnoDB b_wp_rank_math_404_logs: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_rank_math_internal_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_rank_math_internal_meta: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_rank_math_redirections: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_rank_math_redirections_cache: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_storeabill_documentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_storeabill_documents: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB b_wp_storeabill_document_itemmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_storeabill_document_items: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB b_wp_storeabill_document_noticemeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_storeabill_document_notices: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_storeabill_journals: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_tcb_api_error_log: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_td_fields: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_td_groups: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_termmeta: Daten: 0.08MB + Index: 0.11MB + Engine InnoDB b_wp_terms: Daten: 0.05MB + Index: 0.03MB + Engine InnoDB b_wp_term_relationships: Daten: 0.11MB + Index: 0.08MB + Engine InnoDB b_wp_term_taxonomy: Daten: 0.06MB + Index: 0.03MB + Engine InnoDB b_wp_thrive_reporting_logs: Daten: 0.02MB + Index: 0.08MB + Engine InnoDB b_wp_tve_leads_contacts: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_tve_leads_contact_download: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_tve_leads_event_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_tve_leads_form_summary: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_tve_leads_form_variations: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB b_wp_tve_leads_group_options: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_tve_leads_saved_group_options: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_tve_leads_split_test: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_tve_leads_split_test_items: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_usermeta: Daten: 6.52MB + Index: 7.03MB + Engine InnoDB b_wp_users: Daten: 0.48MB + Index: 0.45MB + Engine InnoDB b_wp_usin_events: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_usin_user_data: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_wc_admin_notes: Daten: 0.06MB + Index: 0.00MB + Engine InnoDB b_wp_wc_admin_note_actions: Daten: 0.06MB + Index: 0.02MB + Engine InnoDB b_wp_wc_category_lookup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_wc_customer_lookup: Daten: 0.36MB + Index: 0.23MB + Engine InnoDB b_wp_wc_download_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_wc_orders: Daten: 0.30MB + Index: 0.83MB + Engine InnoDB b_wp_wc_orders_meta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_wc_order_addresses: Daten: 1.52MB + Index: 0.69MB + Engine InnoDB b_wp_wc_order_coupon_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_wc_order_operational_data: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_wc_order_product_lookup: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB b_wp_wc_order_stats: Daten: 0.28MB + Index: 0.28MB + Engine InnoDB b_wp_wc_order_tax_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_wc_product_attributes_lookup: Daten: 0.06MB + Index: 0.06MB + Engine InnoDB b_wp_wc_product_download_directories: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_wc_product_meta_lookup: Daten: 0.22MB + Index: 0.31MB + Engine InnoDB b_wp_wc_rate_limits: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_wc_reserved_stock: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_wc_tax_rate_classes: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_wc_webhooks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_woocommerce_gzd_dhl_im_products: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_gzd_dhl_im_product_services: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_gzd_packaging: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_woocommerce_gzd_packagingmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_gzd_shipmentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_gzd_shipments: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB b_wp_woocommerce_gzd_shipment_itemmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_gzd_shipment_items: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB b_wp_woocommerce_gzd_shipment_labelmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_gzd_shipment_labels: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB b_wp_woocommerce_gzd_shipping_provider: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB b_wp_woocommerce_gzd_shipping_providermeta: Daten: 0.05MB + Index: 0.03MB + Engine InnoDB b_wp_wpae_blocked_ip: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_wpae_spammer_ip: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_wpae_spam_data: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB b_wp_wpae_submission_id: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB campaigns: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM campaigns_ip: Daten: 1.18MB + Index: 0.00MB + Engine MyISAM categories: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM categories_description: Daten: 0.03MB + Index: 0.01MB + Engine MyISAM cm_file_flags: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM configuration: Daten: 0.05MB + Index: 0.02MB + Engine MyISAM configuration_group: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM content_manager: Daten: 0.16MB + Index: 0.00MB + Engine MyISAM counter: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM counter_history: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM countries: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM coupons: Daten: 0.06MB + Index: 0.01MB + Engine MyISAM coupons_description: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM coupon_email_track: Daten: 0.05MB + Index: 0.01MB + Engine MyISAM coupon_gv_customer: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM coupon_gv_queue: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM coupon_redeem_track: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM currencies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM customers: Daten: 0.37MB + Index: 0.04MB + Engine MyISAM customers_basket: Daten: 0.04MB + Index: 0.01MB + Engine MyISAM customers_basket_attributes: Daten: 0.03MB + Index: 0.01MB + Engine MyISAM customers_info: Daten: 0.08MB + Index: 0.04MB + Engine MyISAM customers_ip: Daten: 0.39MB + Index: 0.23MB + Engine MyISAM customers_memo: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM customers_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM customers_status_history: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM database_version: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM geo_zones: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM gls_country_to_postal: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM gls_postal_to_weight: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM gls_weight: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM imagesliders: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM imagesliders_info: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM languages: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM lexikon: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM live_shopping: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM mail_templates: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM manufacturers: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM manufacturers_info: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM media_content: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM module_newsletter: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM module_newsletter_temp_1: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM module_newsletter_temp_2: Daten: 0.07MB + Index: 0.01MB + Engine MyISAM module_newsletter_temp_3: Daten: 0.23MB + Index: 0.00MB + Engine InnoDB module_newsletter_temp_4: Daten: 0.05MB + Index: 0.00MB + Engine InnoDB module_tag_cloud: Daten: 0.99MB + Index: 1.08MB + Engine MyISAM news: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM newsletters: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM newsletters_history: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM newsletter_recipients: Daten: 0.07MB + Index: 0.01MB + Engine MyISAM news_description: Daten: 0.03MB + Index: 0.00MB + Engine MyISAM orders: Daten: 1.02MB + Index: 0.05MB + Engine MyISAM orders_products: Daten: 0.47MB + Index: 0.13MB + Engine MyISAM orders_products_attributes: Daten: 0.14MB + Index: 0.03MB + Engine MyISAM orders_products_download: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM orders_recalculate: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM orders_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM orders_status_history: Daten: 1.45MB + Index: 0.14MB + Engine MyISAM orders_total: Daten: 0.65MB + Index: 0.20MB + Engine MyISAM payment_moneybookers: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM payment_moneybookers_countries: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM payment_moneybookers_currencies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM paypal: Daten: 0.30MB + Index: 0.04MB + Engine MyISAM paypal_status_history: Daten: 0.06MB + Index: 0.02MB + Engine MyISAM personal_offers_by_customers_status_0: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM personal_offers_by_customers_status_1: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM personal_offers_by_customers_status_2: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM personal_offers_by_customers_status_3: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM products: Daten: 0.12MB + Index: 0.02MB + Engine MyISAM products_attributes: Daten: 0.08MB + Index: 0.07MB + Engine MyISAM products_attributes_download: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_content: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_description: Daten: 0.92MB + Index: 0.05MB + Engine MyISAM products_gift: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_graduated_prices: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_images: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM products_notifications: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_options: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_options_values: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_options_values_to_products_options: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_parameters: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_parameters_description: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_parameters_groups: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_parameters_groups_description: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_to_categories: Daten: 0.01MB + Index: 0.03MB + Engine MyISAM products_vpe: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_xsell: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM products_xsell_grp_name: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM reviews: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM reviews_description: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM scart: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM search_keywords: Daten: 28.08MB + Index: 1.63MB + Engine MyISAM sessions: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM shipping_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM shop_configuration: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM slimstat_cache: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM slimstat_hits: Daten: 526.58MB + Index: 21.97MB + Engine MyISAM slimstat_visits: Daten: 210.80MB + Index: 9.04MB + Engine MyISAM specials: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM tax_class: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM tax_rates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM whos_online: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM xtb_auctions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM xtb_transactions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM xtc_boxes: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM yatego_articles: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM yatego_category_mapping: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM zones: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM zones_to_geo_zones: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM Post Type Counts attachment: 1171 customize_changeset: 171 document_template: 5 filter-field: 9 filter-set: 1 gblocks_global_style: 3 gp_elements: 4 nav_menu_item: 68 page: 24 post: 2 product: 796 product_variation: 179 revision: 644 shop_coupon: 1 shop_order: 2209 wpcf7_contact_form: 1 wp_block: 2 wp_navigation: 1 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (27) Advanced Woo Search PRO: von ILLID – 3.03 Block Visibility: von Nick Diego – 3.4.0 Bulk Edit Products, Prices & Attributes for Woocommerce: von ELEXtensions – 2.1.2 Payment Gateway Based Fees and Discounts for WooCommerce: von Tyche Softwares – 2.12.2 Contact Form 7: von Takayuki Miyoshi – 5.9.4 Filter Everything PRO: von Andrii Stepasiuk – 1.8.3 Filter Everything?— WooCoomerce Produkt & WordPress Filter: von Andrii Stepasiuk – 1.8.4 GenerateBlocks Pro: von Tom Usborne – 1.6.0-rc.2 GenerateBlocks: von Tom Usborne – 1.9.0 GP Premium: von Tom Usborne – 2.4.0 hCaptcha for WordPress: von hCaptcha – 4.1.1 WP Armour - Honeypot Anti Spam: von Dnesscarkey – 2.1.20 Login Lockdown PRO: von WebFactory Ltd – 5.53 Product Variation Swatches for Woocommerce: von ThemeHigh – 2.3.6 Rank Math SEO PRO: von Rank Math – 3.0.51 Rank Math SEO mit den besten KI-SEO-Werkzeugen: von Rank Math – 1.0.218 Server IP & Memory Usage Display: von Apasionados Apasionados del Marketing – 2.1.0 SumUp Payment Gateway For WooCommerce: von SumUp – 2.5 Benutzerinfos: von Pexeto – 4.2.1 Woo Custom Stock Status: von Softound Solutions – 1.4.9 Germanized für WooCommerce Pro: von vendidero – 3.10.2 Germanized für WooCommerce: von vendidero – 3.16.5 WooCommerce PayPal Payments: von WooCommerce – 2.7.0 Product Variation Swatches for WooCommerce (Pro): von ThemeHigh – 2.2.3 WooCommerce: von Automattic – 8.8.3 WP Armour Extended - Honeypot Anti Spam: von Dnesscarkey – 1.25 WP Swiper: von Digital Apps – 1.1.6 Inactive Plugins (0) Dropin Plugins () maintenance.php: maintenance.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: ? HPOS feature screen enabled: ? HPOS feature enabled: ? Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore HPOS data sync enabled: – Logging Enabled: ? Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 30 Tage Level threshold: – Log directory size: 182 kB WC Pages Shop-Basis: #5 - /shop/ Warenkorb: #6 - /warenkorb/ Kasse: ? Die Seite enth?lt nicht den [woocommerce_checkout]-Shortcode oder woocommerce/checkout-Block. Mein Konto: #8 - /mein-konto/ Allgemeine Gesch?ftsbedingungen: #4657 - /agb/ Theme Name: Bowling Shop Version: 0.1 Author URL: https://purevelvet.design Child Theme: ? Parent Theme Name: GeneratePress Parent Theme Version: 3.4.0 Parent Theme Author URL: https://tomusborne.com WooCommerce Support: ? Templates Overrides: – WooCommerce PayPal Payments Onboarded: ? Shop country code: DE WooCommerce currency supported: ? Advanced Card Processing available in country: ? Pay Later messaging available in country: ? Webhook status: – PayPal Vault enabled: – ACDC Vault enabled: ? Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: – Subscriptions Mode: Disabled Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customize-store customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management product-virtual-downloadable product-external-affiliate product-grouped product-linked product-pre-publish-modal remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience product-custom-fields settings async-product-editor-category-field launch-your-store Daily Cron: ? Next scheduled: 2024-05-12 12:37:20 +02:00 Options: ? Notes: 66 Onboarding: completed Action Scheduler Complete: 852 Oldest: 2024-04-18 13:58:02 +0200 Newest: 2024-05-11 11:57:03 +0200 Failed: 5 Oldest: 2024-04-05 12:23:23 +0200 Newest: 2024-05-08 21:11:18 +0200 Pending: 5 Oldest: 2024-05-11 20:03:22 +0200 Newest: 2024-05-12 11:57:03 +0200 Status report information Generated at: 2024-05-11 15:25:46 +02:00
- This reply was modified 6 months, 3 weeks ago by purevelvetdesign.
Hello André (purevelvetdesign),
Thank you for your reply.
Please note that you may need to also increase the WP Memory Limit to accommodate this large query.
To be sure, you may check the error log at WooCommerce > System Status > Logs.
If you see any errors, copy them and share them with me here.By looking at the error log, we will be able to know what exactly is happening at the backend and how we can fix that.
To confirm, you have one variable product that has 126 variations in it.
Is my understanding correct?Looking forward to your response. ??
Best regards.
To confirm, you have one variable product that has 126 variations in it.
Is my understanding correct?
Yes that is correct, there will follow other products with also that amount of variations.
WP Memory Limit is actually set to 256MB and at WooCommerce > System Status > Logs there are no entries regarding this issue.
Thank you very much ??Hi there @purevelvetdesign,
WP Memory Limit is actually set to 256MB and at WooCommerce > System Status > Logs there are no entries regarding this issue.
Thanks for sharing further details on this.
Could you please increase your memory limit from 256 to 512MB and check if this will lead to any difference?
Hello @purevelvetdesign Your host has what we call a kill switch. It’s set to 30 by default. They’re most likely not going to increase thar for security reasons. Especially on shared hosting.
I recommend creating a product with 5 variants and seeing if that works fine. Maybe even 10. Just know that anything over 25 to 30 is a load on the server. Just because WooCommerce allowed more variants to be added doesn’t mean servers did.
Who’s your host by the way?
PHP Time Limit is now set to 300 but when I bulk update price here:
https://stage.bowling-shop.de/produkt/vise-grip-ultimate-power-lift-oder-oval/
it’s still loading and loading and never finish. Is 5 Minutes, 300 seconds too less?
Hosting provider is not a popular one but a german one.
Best regards
André- This reply was modified 6 months, 2 weeks ago by purevelvetdesign.
and is still loading after 30 Minutes ??
- This reply was modified 6 months, 2 weeks ago by purevelvetdesign.
Hi again @purevelvetdesign,
Were you able to try the suggestions by community member @serafinnyc? If not, please try the above suggestions and let us know if this makes any difference.
I recommend creating a product with 5 variants and seeing if that works fine. Maybe even 10. Just know that anything over 25 to 30 is a load on the server. Just because WooCommerce allowed more variants to be added doesn’t mean servers did.
Looking forward to your reply.
Hi,
I tested it with 6 variations and it worked fine with bulk price updating. Without any problem.
So but how can I identify the exact webhosting parameter that prevent from bulk updating 126 variations? php time limit is 300 (5 min.) – memory limit is up to 512MB
Best regardsHey @purevelvetdesign your host will not allow you to change anything higher than these, unless you are on a dedicated server. All hosts have different configurations. You may even need more workers, more cpu.
How did you increase your Max Time? php.ini or htaccess or config?
You can try adding
php_value max_input_vars 5000
to see if that helps, but I’m not sure of your host and their rules.Hi Stef,
hmm okay, then I have to tell my customer, that his webhosting needs an upgrade.
I updated it in the PHP settings of PLESK. PHP Version 8.2.19
memory_limit 512M
max_execution_time 300
max_input_time 300
post_max_size 128M
upload_max_filesize 128M
opcache on
pm.max_children 250
pm.max_requests 100For this they’ll need more PHP workers. Default is usually 2, will need 6 to 8 and might even need a Redis.
Another way to get around this though, (possibly) is to custom code a hook that uses Ajax to call them dynamically. That’s pretty involved and would require an expert developer.
What do you mean with “PHP workers” ? Do you mean CPU cores?
I hope I can find any way without custom developement.
Best regards
- The topic ‘126 variations bulk price update don’t work’ is closed to new replies.