Order creation is extremely slow (5-20 minutes)
-
Hi, I have a B2B site that needs to manage large orders. It is for a clothing distributor, so with size/color variations.
I can have an order of 50-60 products that, with variations, can generate 3.000-6.000 “pieces” in the cart (I mean, if product A red size S has 5 items and blu size S has 3 items, I count 8 “pieces” in total).
Each product can have from 4-5 (single color, multiple sizes) to 50-100 variations (multiple colors for each size).
There is no payment gateway as it is for reseller that will pay later.
as I click on “place order” button, the circle starts rotating and it remains that way for a time that may vary from 4-5 minutes to even 20 minutes.
The confirmation email arrive a couple of minutes before circle finish to rotate and lead to the confirmation page.
I already tried to:
– disable all the plugins except Woocommerce
– run it with twenty-twentytwo theme
– use add_filter( ‘woocommerce_defer_transactional_emails’,’__return_true’ );
– disable ajax on woocommerce > settings > products > general
– change server, it was on a good one, now is on a high performance server but the problem persists.
Any idea on why it happens and how to solve it?
Thanks
here it is the woocommerce > status codeWordPress Environment WordPress address (URL): https://staging.mysite.it Site address (URL): https://staging.mysite.it WC Version: 7.3.0 REST API Version: ?</img> 7.3.0 WC Blocks Version: ?</img> 9.1.5 Action Scheduler Version: ?</img> 3.4.0 Log Directory Writable: ?</img> WP Version: 6.1.1 WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: – WP Cron: ?</img> Language: it_IT External object cache: – Server Environment Server Info: Apache PHP Version: 8.1.13 PHP Post Max Size: 150 MB PHP Time Limit: 180 PHP Max Input Vars: 35000 cURL Version: 7.86.0 OpenSSL/1.1.1s SUHOSIN Installed: – MySQL Version: 5.7.38-log Max Upload Size: 150 MB Default Timezone is UTC: ?</img> fsockopen/cURL: ?</img> SoapClient: ?</img> DOMDocument: ?</img> GZip: ?</img> Multibyte String: ?</img> Remote Post: ?</img> Remote Get: ?</img> Database WC Database Version: 7.3.0 WC Database Prefix: wpck_ Dimensione totale database: 1207.98MB Dimensione dati database: 721.42MB Dimensione indice database: 486.56MB wpck_woocommerce_sessions: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_woocommerce_api_keys: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_woocommerce_attribute_taxonomies: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_woocommerce_downloadable_product_permissions: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpck_woocommerce_order_items: Dati: 13.52MB + indice: 3.52MB + motore InnoDB wpck_woocommerce_order_itemmeta: Dati: 122.64MB + indice: 117.33MB + motore InnoDB wpck_woocommerce_tax_rates: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpck_woocommerce_tax_rate_locations: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_woocommerce_shipping_zones: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_woocommerce_shipping_zone_locations: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_woocommerce_shipping_zone_methods: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_woocommerce_payment_tokens: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_woocommerce_payment_tokenmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_woocommerce_log: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_actionscheduler_actions: Dati: 27.06MB + indice: 28.09MB + motore InnoDB wpck_actionscheduler_claims: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_actionscheduler_groups: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_actionscheduler_logs: Dati: 19.55MB + indice: 16.03MB + motore InnoDB wpck_atum_order_itemmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_atum_order_items: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_atum_product_data: Dati: 5.52MB + indice: 4.55MB + motore InnoDB wpck_berocket_termmeta: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_braapf_product_stock_status_parent: Dati: 2.52MB + indice: 1.52MB + motore InnoDB wpck_braapf_product_variation_attributes: Dati: 5.52MB + indice: 12.55MB + motore InnoDB wpck_braapf_term_taxonomy_hierarchical: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpck_braapf_variable_attributes: Dati: 0.11MB + indice: 0.19MB + motore InnoDB wpck_check_email_log: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_cli_cookie_scan: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_cli_cookie_scan_categories: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_cli_cookie_scan_cookies: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_cli_cookie_scan_url: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_cli_scripts: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_commentmeta: Dati: 0.09MB + indice: 0.03MB + motore InnoDB wpck_comments: Dati: 24.52MB + indice: 0.81MB + motore InnoDB wpck_duplicator_packages: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_duplicator_pro_entities: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_duplicator_pro_packages: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_evf_entries: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_evf_entrymeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_evf_sessions: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_e_events: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_e_submissions: Dati: 0.06MB + indice: 0.27MB + motore InnoDB wpck_e_submissions_actions_log: Dati: 0.02MB + indice: 0.11MB + motore InnoDB wpck_e_submissions_values: Dati: 0.11MB + indice: 0.03MB + motore InnoDB wpck_fbv: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_fbv_attachment_folder: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_links: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_ms_snippets: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_options: Dati: 21.08MB + indice: 0.39MB + motore InnoDB wpck_pmxe_exports: Dati: 0.11MB + indice: 0.00MB + motore InnoDB wpck_pmxe_google_cats: Dati: 0.39MB + indice: 0.00MB + motore InnoDB wpck_pmxe_posts: Dati: 1.52MB + indice: 0.00MB + motore InnoDB wpck_pmxe_templates: Dati: 0.09MB + indice: 0.00MB + motore InnoDB wpck_pmxi_files: Dati: 0.11MB + indice: 0.00MB + motore InnoDB wpck_pmxi_hash: Dati: 4.52MB + indice: 0.00MB + motore InnoDB wpck_pmxi_history: Dati: 0.05MB + indice: 0.00MB + motore InnoDB wpck_pmxi_images: Dati: 0.13MB + indice: 0.00MB + motore InnoDB wpck_pmxi_imports: Dati: 7.52MB + indice: 0.00MB + motore InnoDB wpck_pmxi_posts: Dati: 6.52MB + indice: 0.00MB + motore InnoDB wpck_pmxi_templates: Dati: 1.52MB + indice: 0.00MB + motore InnoDB wpck_postmeta: Dati: 203.66MB + indice: 127.41MB + motore InnoDB wpck_posts: Dati: 42.55MB + indice: 18.13MB + motore InnoDB wpck_prflxtrflds_fields_meta: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_redirection_404: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpck_redirection_groups: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_redirection_items: Dati: 0.02MB + indice: 0.09MB + motore InnoDB wpck_redirection_logs: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpck_say_what_strings: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_simple_history: Dati: 22.56MB + indice: 11.03MB + motore InnoDB wpck_simple_history_contexts: Dati: 116.66MB + indice: 83.22MB + motore InnoDB wpck_sm_advanced_search_temp: Dati: 0.23MB + indice: 0.09MB + motore InnoDB wpck_sm_views: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_snippets: Dati: 0.20MB + indice: 0.03MB + motore InnoDB wpck_termmeta: Dati: 0.09MB + indice: 0.11MB + motore InnoDB wpck_terms: Dati: 0.09MB + indice: 0.09MB + motore InnoDB wpck_term_relationships: Dati: 2.52MB + indice: 2.52MB + motore InnoDB wpck_term_taxonomy: Dati: 0.09MB + indice: 0.11MB + motore InnoDB wpck_usermeta: Dati: 3.52MB + indice: 4.03MB + motore InnoDB wpck_users: Dati: 0.11MB + indice: 0.14MB + motore InnoDB wpck_wa_confirmationlinks: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wa_log: Dati: 0.13MB + indice: 0.00MB + motore InnoDB wpck_wa_queue: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wcpdf_invoice_number: Dati: 0.09MB + indice: 0.00MB + motore InnoDB wpck_wc_admin_notes: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wc_admin_note_actions: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wc_category_lookup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wc_customer_lookup: Dati: 0.09MB + indice: 0.06MB + motore InnoDB wpck_wc_download_log: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_wc_order_coupon_lookup: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_wc_order_product_lookup: Dati: 14.55MB + indice: 17.06MB + motore InnoDB wpck_wc_order_stats: Dati: 0.23MB + indice: 0.22MB + motore InnoDB wpck_wc_order_tax_lookup: Dati: 0.14MB + indice: 0.14MB + motore InnoDB wpck_wc_product_attributes_lookup: Dati: 5.52MB + indice: 5.52MB + motore InnoDB wpck_wc_product_download_directories: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wc_product_meta_lookup: Dati: 5.52MB + indice: 11.09MB + motore InnoDB wpck_wc_rate_limits: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wc_reserved_stock: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wc_tax_rate_classes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wc_webhooks: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wdp_orders: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpck_wdp_order_items: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpck_wdp_rules: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_wfblockediplog: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wfblocks7: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpck_wfconfig: Dati: 0.52MB + indice: 0.00MB + motore InnoDB wpck_wfcrawlers: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wffilechanges: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wffilemods: Dati: 6.52MB + indice: 0.00MB + motore InnoDB wpck_wfhits: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpck_wfhoover: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wfissues: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpck_wfknownfilelist: Dati: 7.52MB + indice: 0.00MB + motore InnoDB wpck_wflivetraffichuman: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wflocs: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wflogins: Dati: 0.44MB + indice: 0.16MB + motore InnoDB wpck_wfls_2fa_secrets: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wfls_settings: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wfnotifications: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wfpendingissues: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpck_wfreversecache: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wfsnipcache: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpck_wfstatus: Dati: 0.16MB + indice: 0.11MB + motore InnoDB wpck_wftrafficrates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wobef_history: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_wobef_history_items: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_wpfm_backup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wpie_template: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wpmembers_user_search_keys: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wpmm_subscribers: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wt_iew_action_history: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wt_iew_cron: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wt_iew_ftp: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_wt_iew_mapping_template: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpck_yoast_indexable: Dati: 18.55MB + indice: 13.56MB + motore InnoDB wpck_yoast_indexable_hierarchy: Dati: 2.52MB + indice: 4.55MB + motore InnoDB wpck_yoast_migrations: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpck_yoast_primary_term: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpck_yoast_seo_links: Dati: 0.14MB + indice: 0.09MB + motore InnoDB Post Type Counts attachment: 1505 atum_inventory_log: 1 automation-workflow: 1 awdp_pt_products: 5 awdp_pt_rules: 5 bnfw_notification: 1 br_product_filter: 5 custom_css: 3 elementor_library: 6 elementskit_template: 2 everest_form: 2 nav_menu_item: 104 page: 45 portfolio: 8 post: 1 postman_sent_mail: 250 product: 1084 product_variation: 43146 revision: 508 shop_coupon: 1 shop_order: 1843 shop_order_refund: 1 wcb2b_group: 16 wcssc-cart: 434 wp_global_styles: 2 wpcf7_contact_form: 1 wpsl_stores: 201 wpt_product_table: 1 Security Secure connection (HTTPS): ?</img> Hide errors from visitors: ?</img> Active Plugins (1) WooCommerce: by Automattic – 7.3.0 Inactive Plugins (67) Advanced AJAX Product Filters for WooCommerce: by BeRocket – 1.6.3.4 Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.3 Advanced Order Export For WooCommerce (Pro): by AlgolPlus – 3.2.2 All-in-One WP Migration With Import: by ServMask – 6.77 Allow Webp Image: by Top Infosoft – 1.0.1 Anti-Malware Security and Brute-Force Firewall: by Eli Scheetz – 4.21.90 ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.9.26.2 Bulk remove posts from category: by MasterNs – 3.3 Category Discount Woocommerce: by QuanticEdge – 4.7 Check & Log Email: by WPChill – 1.0.6 Child Theme Configurator: by Lilaea Media – 2.6.0 Code Snippets: by Code Snippets Pro – 3.2.2 Contact Form 7: by Takayuki Miyoshi – 5.7.3 CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.8 Database Collation Fix: by Dave Jesch – 1.2.7 Disable Real MIME Check: by Sergey Biryukov – 1.0 Duplicator: by Snap Creek – 1.5.2 DynamicConditions: by RTO GmbH – 1.6.0 Elementor: by Elementor.com – 3.7.2 Elementor Header & Footer Builder: by Brainstorm Force Nikhil Chavan – 1.6.13 Elementor Pro: by Elementor.com – 3.7.3 ELEX Dynamic Pricing and Discounts for WooCommerce Basic Version: by ELEXtensions – 1.2.9 Export All URLs: by Atlas Gondal – 4.4 FileBird Lite: by Ninja Team – 5.1.4 Flexible Checkout Fields: by WP Desk – 3.5.4 Flexible Checkout Fields PRO: by WP Desk – 3.5.1 Health Check & Troubleshooting: by The www.ads-software.com community – 1.5.1 Import and export users and customers: by codection – 1.21.4 iThemeland WooCommerce Bulk Orders Editing Lite: by iThemelandco – 2.0.0 LightStart - Maintenance Mode, Coming Soon and Landing Page Builder: by Themeisle – 2.6.2 Nav Menu Collapse: by Robert Noakes – 2.1.2 Ocean Extra: by OceanWP – 2.1.1 PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.3.1 Post SMTP: by Post SMTP – 2.3.2 Product Prices by User Roles for WooCommerce: by Tyche Softwares – 1.6.0 Product SKU Generator for WooCommerce: by SkyVerge – 2.4.8 Redirection: by John Godley – 5.3.9 Save and Share Cart for WooCommerce: by Ankit Gade – 2.0.5 Search Exclude: by Roman Pronskiy – 1.3.0 Show Hooks: by rafiq91 exlac – 0.4 Simple History: by P?r Thernstr?m – 3.3.1 Smart Manager - WooCommerce Advanced Bulk Edit, Inventory Management & more…: by StoreApps – 7.4.0 User Menus: by Code Atlantic – 1.3.1 User Role Editor: by Vladimir Garagulya – 4.63.2 WooCommerce B2B: by Code4Life – 3.1.2 WooCommerce B2B Sales Agents: by Code4Life – 1.2.4 WooCommerce PDF Invoices & Packing Slips Premium Templates: by Ewout Fernhout – 2.9.4 Woocommerce Product Feature Video: by motifcreatives – 2.0.3 WooCommerce Shipping & Tax: by WooCommerce – 2.2.1 Woocommerce Variations Table - Grid | VestaThemes.com: by Spyros Vlachopoulos – 1.3.10 Woo Login Redirect: by WP Doctor – 2.2.4 Wordfence Security: by Wordfence – 7.8.2 WordPress Importer: by wordpressdotorg – 0.8 WP-Members: by Chad Butler – 3.4.6 WP All Export: by Soflyy – 1.3.8 WP All Export - WooCommerce Export Add-On Pro: by Soflyy – 1.0.5 WP All Export Pro: by Soflyy – 1.8.1 WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 3.3.4 WP All Import Pro: by Soflyy – 4.7.8 WP Fastest Cache: by Emre Vona – 1.1.0 WP File Manager: by mndpsingh287 – 7.1.7 WP Import Export Lite: by VJInfotech – 3.9.24 WP Store Locator: by Tijmen Smit – 2.2.235 WP Store Locator - CSV Manager: by Tijmen Smit – 1.0.2 WunderAutomation: by Wundermatics – 1.9.0 Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5 Yoast SEO: by Team Yoast – 20.0 Must Use Plugins (1) Health Check Troubleshooting Mode: by – 1.8.1 Settings API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right 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) instock (instock) 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: – Order datastore: WC_Order_Data_Store_CPT WC Pages Shop base: #522 - /shop-2/ Carrello: #523 - /cart-2/ Pagamento: #12 - /checkout/ Il mio account: #13 - /my-account/ Termini e condizioni: ?</img> La pagina non è impostata Theme Name: Twenty Twenty-Two Version: 1.3 Author URL: https://www.ads-software.com/ Child Theme: ?</img> – Se stai modificando WooCommerce o un tema genitore che non hai costruito personalmente ti consigliamo di utilizzare un tema child. Vedi: Come creare un tema child WooCommerce Support: ?</img> Templates Overrides: – Admin Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-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 woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience settings Daily Cron: ?</img> Next scheduled: 2023-01-27 15:35:08 +01:00 Options: ?</img> Notes: 22 Onboarding: completed Action Scheduler Operazione annullata: 1 Oldest: 2023-01-26 15:38:48 +0100 Newest: 2023-01-26 15:38:48 +0100 Completato: 85.564 Oldest: 2022-07-26 19:03:26 +0200 Newest: 2023-01-26 19:35:20 +0100 In attesa: 74 Oldest: 2023-01-26 19:35:34 +0100 Newest: 2023-02-01 22:13:11 +0100 Status report information Generated at: 2023-01-26 19:35:50 +01:00
-
Hi,
there is no error in the log.
Here it is the link of a product:
https://staging.whitewise.it/product/abito-merinos-con-scollo-ciambella-ess164-2
Please consider that the staging site is currently used to create a new theme and for other purpose, so actually has many active plugins, but, as said, the test made with default theme and only woocommerce active gave the same problem.
You must be logged in to order, so:
{credentials removed by moderator}Hello,
Sorry to hear that the issue persists.
It took more than 30 minutes?to be completed...I was inspecting the site using a Chrome extension called Lighthouse, and it is pointing out performance issues:
Regarding the orders, you can switch the site theme to Storefront and disable all plugins except WooCommerce to see if that way it works without issues.
You can use the Meks Quick Plugin Disabler, this plugin will remember what other plugins you currently have active, so it’s easy to switch them back on.
Let us know how that goes.
- The topic ‘Order creation is extremely slow (5-20 minutes)’ is closed to new replies.
