• Resolved purevelvetdesign

    (@purevelvetdesign)


    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]

Viewing 15 replies - 1 through 15 (of 19 total)
  • Stef

    (@serafinnyc)

    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!

    Thread Starter purevelvetdesign

    (@purevelvetdesign)

    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
    
    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    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.

    Thread Starter purevelvetdesign

    (@purevelvetdesign)

    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 ??

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    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?

    Stef

    (@serafinnyc)

    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?

    Thread Starter purevelvetdesign

    (@purevelvetdesign)

    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é

    Thread Starter purevelvetdesign

    (@purevelvetdesign)

    and is still loading after 30 Minutes ??

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    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.

    Thread Starter purevelvetdesign

    (@purevelvetdesign)

    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 regards

    Stef

    (@serafinnyc)

    Hey @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.

    Thread Starter purevelvetdesign

    (@purevelvetdesign)

    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 100

    Stef

    (@serafinnyc)

    For 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.

    Thread Starter purevelvetdesign

    (@purevelvetdesign)

    What do you mean with “PHP workers” ? Do you mean CPU cores?
    I hope I can find any way without custom developement.

    Best regards

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘126 variations bulk price update don’t work’ is closed to new replies.