Philwin login register.Makakuha ng libreng 700pho sa bawat deposito

Resolved dev1122
(@dev1122)

1 month, 4 weeks ago

We have an issue on our website related to slow checkout. When we click place order button on checkout the it takes 12 to 15 seconds to show the order confirmation page. We are using Square payment for processing.

The page I need help with: [log in to see the link]

Viewing 15 replies - 1 through 15 (of 21 total)

1 2 →

Thread Starter dev1122
(@dev1122)

1 month, 4 weeks ago

Below is my website’s system report.

` WordPress Environment WordPress address (URL): https://staging.primebrands.com Site address (URL): https://staging.primebrands.com WC Version: 9.3.2 Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site. Action Scheduler Version: ? 3.8.1 Log Directory Writable: ? WP Version: 6.6.2 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: ? Language: en External object cache: – Server Environment Server Info: Apache PHP Version: 7.4.33 PHP Post Max Size: 8 MB PHP Time Limit: 3000 PHP Max Input Vars: 3000 cURL Version: 7.61.1 OpenSSL/1.1.1k SUHOSIN Installed: – MySQL Version: 8.0.39 Max Upload Size: 8 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? Your server does not have the SoapClient class enabled – some gateway plugins which use SOAP may not work as expected. DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 9.3.2 WC Database Prefix: egm5_ Total Database Size: 192.94MB Database Data Size: 182.69MB Database Index Size: 10.25MB egm5_woocommerce_sessions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB egm5_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_woocommerce_order_itemmeta: Data: 0.13MB + Index: 0.14MB + Engine InnoDB egm5_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cust_net_30_invoices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cust_net_30_invoices_comments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_actionscheduler_actions: Data: 1.31MB + Index: 0.42MB + Engine InnoDB egm5_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_actionscheduler_logs: Data: 0.31MB + Index: 0.27MB + Engine InnoDB egm5_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_braapf_product_stock_status_parent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_braapf_product_variation_attributes: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_braapf_term_taxonomy_hierarchical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_braapf_variable_attributes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_comments: Data: 0.14MB + Index: 0.09MB + Engine InnoDB egm5_cr_reminders_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB egm5_customer_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB egm5_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB egm5_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB egm5_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_easywpsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_easywpsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_jetpack_sync_queue: Data: 0.42MB + Index: 0.06MB + Engine InnoDB egm5_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_options: Data: 6.42MB + Index: 0.20MB + Engine InnoDB egm5_postmeta: Data: 89.52MB + Index: 3.80MB + Engine InnoDB egm5_posts: Data: 61.52MB + Index: 0.50MB + Engine InnoDB egm5_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB egm5_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_usermeta: Data: 0.16MB + Index: 0.17MB + Engine InnoDB egm5_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB egm5_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB egm5_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_order_addresses: Data: 0.05MB + Index: 0.06MB + Engine InnoDB egm5_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_orders: Data: 0.06MB + Index: 0.13MB + Engine InnoDB egm5_wc_orders_meta: Data: 0.25MB + Index: 0.50MB + Engine InnoDB egm5_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wc_product_meta_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB egm5_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wc_smart_coupons: Data: 0.02MB + Index: 0.20MB + Engine InnoDB egm5_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wcs_payment_retries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wlr_earn_campaign: Data: 0.02MB + Index: 0.09MB + Engine InnoDB egm5_wlr_earn_campaign_transaction: Data: 0.02MB + Index: 0.17MB + Engine InnoDB egm5_wlr_levels: Data: 0.02MB + Index: 0.08MB + Engine InnoDB egm5_wlr_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB egm5_wlr_points_ledger: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_wlr_referral: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wlr_reward_transactions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB egm5_wlr_rewards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_wlr_user_rewards: Data: 0.02MB + Index: 0.11MB + Engine InnoDB egm5_wlr_users: Data: 0.02MB + Index: 0.08MB + Engine InnoDB egm5_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB egm5_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wpml_mails: Data: 16.52MB + Index: 0.02MB + Engine InnoDB egm5_wpr_above_the_fold: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB egm5_wsal_metadata: Data: 0.05MB + Index: 0.03MB + Engine InnoDB egm5_wsal_occurrences: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wt_iew_action_history: Data: 0.06MB + Index: 0.00MB + Engine InnoDB egm5_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_yoast_indexable: Data: 0.08MB + Index: 0.09MB + Engine InnoDB egm5_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB state_list: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wholeseller_location: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts acf-field: 28 acf-field-group: 4 attachment: 645 b2bwhs_custom_field: 10 b2bwhs_custom_role: 2 b2bwhs_group: 1 br_product_filter: 2 custom_css: 2 custom-css-js: 1 customize_changeset: 11 e-landing-page: 1 elementor_font: 1 elementor_library: 37 nav_menu_item: 22 oembed_cache: 3 page: 37 post: 14 product: 21 product_variation: 3 revision: 1939 shop_coupon: 9 shop_order: 78 shop_subscription: 5 viwec_template: 14 wapf_product: 1 wp_navigation: 1 wpcf7_contact_form: 3 wpforms: 1 yith_wcan_preset: 1 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (39) ManageWP – Worker: by GoDaddy – 4.9.20 Query Monitor: by John Blackbourn – 3.16.4 WooCommerce added to cart popup (Ajax): by XootiX – 1.7 Advanced Custom Fields: by WP Engine – 6.3.6 Advanced Product Fields for WooCommerce: by StudioWombat – 1.6.11 B2B & Wholesale Suite: by WebWizards – 1.6.34 Contact Form 7 Captcha: by 247wd – 0.1.6 Contact Form 7: by Takayuki Miyoshi – 5.9.8 Simple Custom CSS and JS: by SilkyPress.com – 3.48 Custom Order Numbers for WooCommerce: by Tyche Softwares – 1.7.1 Customer Reviews for WooCommerce: by CusRev – 5.60.0 Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.2 Easy WP SMTP: by Easy WP SMTP – 2.5.0 Elementor Pro: by Elementor.com – 3.24.2 Elementor: by Elementor.com – 3.24.4 Email Template Customizer for WooCommerce: by VillaTheme – 1.2.5 301 Redirects: by WebFactory Ltd – 2.76 Essential Addons for Elementor: by WPDeveloper – 6.0.5 Max Mega Menu: by megamenu.com – 3.3.2 Members: by MemberPress – 3.2.10 Permalink Manager Lite: by Maciej Bis – 2.4.4.1 User Switching: by John Blackbourn – 1.8.0 Premmerce Permalink Manager for WooCommerce: by Premmerce – 2.3.11 WooCommerce.com Update Manager: by Automattic – 1.0.3 Variation Swatches for WooCommerce: by Emran Ahmed – 2.1.2 Advanced AJAX Product Filters for WooCommerce: by BeRocket – 1.6.6 Woo All Products For Subscriptions: by Woo – 6.0.2 WooCommerce Net 30 Order Email: by Abdul Wahab – 1.0 PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.8.6 WooCommerce Smart Coupons: by StoreApps – 9.10.0 WooCommerce Square: by WooCommerce – 4.8.0 WooCommerce Subscriptions: by WooCommerce – 6.7.0 WooCommerce: by Automattic – 9.3.2 Yoast SEO: by Team Yoast – 23.5 WP Mail Logging: by WP Mail Logging Team – 1.12.0 WP Menu Cart: by WP Overnight – 2.14.6 WP Rocket: by WP Media – 3.16 Smush: by WPMU DEV – 3.16.6 XPS Ship Integration: by XPS Ship – Descartes – 2.0.7 Inactive Plugins (8) Converter for Media: by matt plugins – Optimize images by convert WebP & AVIF – 6.1.0 Procanatest NET-30 Terms for Woocommerce: by Dipak – 1.1 Qi Addons for Elementor: by Qode Interactive – 1.7.8 Subscription Addons: by Abdul Wahab – 1.0 WooCommerce Ship to Multiple Addresses: by Abdul Wahab – 1.0.0 WP-Optimize Premium – Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.3.2 WPLoyalty – WooCommerce Loyalty Points, Rewards and Referral: by Wployalty – 1.2.4 Yoast SEO Premium: by Team Yoast – 23.4 Dropin Plugins () advanced-cache.php: advanced-cache.php db.php: Query Monitor Database Class (Drop-in) maintenance.php: maintenance.php Must Use Plugins (2) ManageWP – Worker Loader: by GoDaddy – 1.0.0 WordPress automation by Installatron: by – Settings Legacy API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription) 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 enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: ? Logging Enabled: ? Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 30 days Level threshold: – Log directory size: 2 MB WC Pages Shop base: #13 – /shop/ Cart: #14 – /cart/ – Contains the [woocommerce_cart] shortcode Checkout: #15 – /checkout/ – Contains the [woocommerce_checkout] shortcode My account: #16 – /my-account/ Terms and conditions: ? Page not set Theme Name: Hello Elementor Child Version: 1.0.1 Author URL: https://elementor.com/ Child Theme: ? Parent Theme Name: Hello Elementor Parent Theme Version: 3.1.1 Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash WooCommerce Support: ? Templates Overrides: hello-elementor-child/woocommerce/checkout/form-checkout.php hello-elementor-child/woocommerce/checkout/payment.php hello-elementor-child/woocommerce/content-single-product.php hello-elementor-child/woocommerce/loop/add-to-cart.php version 9.0.0 is out of date. The core version is 9.2.0 hello-elementor-child/woocommerce/myaccount/dashboard.php hello-elementor-child/woocommerce/myaccount/form-login.php version 7.0.1 is out of date. The core version is 9.2.0 hello-elementor-child/woocommerce/single-product/rating.php hello-elementor-child/woocommerce/single-product-reviews.php Outdated Templates: ? <pre class=”wp-block-code”><code> Learn how to update | Clear system status theme info cache</code></pre> Subscriptions WCS_DEBUG: ? No Subscriptions Mode: ? Staging Subscriptions Live URL: https://primebrands.com Subscriptions-core Library Version: 7.5.0 Subscription Statuses: wc-active: 3 wc-cancelled: 2 WooCommerce Account Connected: ? Yes Active Product Key: ? Yes Custom Retry Rules: ? No Custom Retry Rule Class: ? No Custom Raw Retry Rule: ? No Custom Retry Rule: ? No Retries Migration Status: ? Completed Report Cache Enabled: ? Yes Cache Update Failures: ? 0 failure Store Setup Country / State: United States (US) — Florida Subscriptions by Payment Gateway Square: wc-active: 3 wc-cancelled: 2 Payment Gateway Support Square: products card_types payment_form authorization charge charge-virtual capture_charge refunds voids customer_id tokenization add_payment_method token_editor subscriptions subscription_suspension subscription_cancellation subscription_reactivation subscription_amount_changes subscription_date_changes multiple_subscriptions subscription_payment_method_change_customer subscription_payment_method_change_admin Square Environment: Production Tokenization Enabled: ? Debug Mode: Save to Log 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 pattern-toolkit-full-composability product-custom-fields remote-inbox-notifications remote-free-extensions payment-gateway-suggestions printful shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page launch-your-store Disabled Features: experimental-blocks minified-js product-pre-publish-modal settings async-product-editor-category-field product-editor-template-system blueprint reactify-classic-payments-settings Daily Cron: ? Next scheduled: 2024-09-24 14:41:04 -04:00 Options: ? Notes: 119 Onboarding: skipped All Products for Woo Subscriptions Template Overrides: hello-elementor-child/woocommerce/cart/cart-item-subscription-options.php hello-elementor-child/woocommerce/single-product/product-subscription-options-prompt-radio.php hello-elementor-child/woocommerce/single-product/product-subscription-options.php Action Scheduler Canceled: 9 Oldest: 2024-09-09 08:11:49 -0400 Newest: 2024-09-13 03:54:25 -0400 Complete: 1,140 Oldest: 2024-08-24 10:16:15 -0400 Newest: 2024-09-24 09:39:26 -0400 Failed: 100 Oldest: 2023-04-05 10:43:21 -0400 Newest: 2024-09-23 10:39:01 -0400 Pending: 9 Oldest: 2024-09-24 10:39:01 -0400 Newest: 2024-09-29 12:02:49 -0400 Smart Coupons related settings ?* Number of coupons to show: 5 ?* Number of characters in auto-generated coupon code: ?* Valid order status for auto-generating coupon: Processing | Completed ?* Automatic deletion: ? No ?* Coupon emails: ? No ?* Printing coupons: ? Yes ?* Sell gift cards at less price?: ? No ?* Use gift card applied in first subscription order for subsequent renewals until credit reaches zero: ? Yes ?* Renewal orders should not generate coupons even when they include a product that issues coupons: ? No ?* Allow sending of coupons to others: ? No ?* Allow schedule sending of coupons?: ? No ?* Combine emails: ? No ?* Auto generated coupon email: ? No ?* Combined auto generated coupons email: ? No ?* Acknowledgement email: ? No ?* Include tax in the amount of the generated gift card: ? No ?* Deduct credit/gift before doing tax calculations: ? No ?* Gift Card discount is inclusive of tax: ? No ?* Enable taxes: ? No ?* Prices entered with tax: ? No ?* Display prices in the shop: ? Excl ?* Display prices during cart and checkout: ? Excl ?* Rounding: ? No ?* Display tax totals: Itemized ?* Enable the use of coupon codes: ? Yes ?* Calculate coupon discounts sequentially: ? No ?* Account endpoints > Coupons: wc-smart-coupons ?* Block-enabled Cart: ? No ?* Block-enabled Checkout: ? No ?* WooCommerce Account Connected: ? Yes Status report information Generated at: 2024-09-24 10:12:20 -04:00 `

Plugin Support Shameem R. a11n
(@shameemreza)

1 month, 3 weeks ago

Hi @dev1122

This could be due to a number of reasons, including hosting issues, plugin conflicts, or problems with the Square payment gateway.

To make sure we are on the same page, does it occur with every order? How about using other payment methods like COD or direct bank? Also, can you please enable debug mode in the Square setting and share the log with us?

Looking forward to hearing from you!
Thread Starter dev1122
(@dev1122)

1 month, 3 weeks ago
Hi @shameemreza. Following are the steps that we have already performed to resolve this issue.
- We Deactivated ALL plugins except WooCommerce & Square payment
- We Tried a different payment processor “WooPayments”
- We Changed our server from shared hosting to Virtual Private Server VPS
- We got our Firewall and server side integrations checked and we don’t have any errors.
After performing all above steps still the slow checkout issue is not resolved. Our checkout is taking 12 to 15 seconds from the second place order button is clicked to the point order confirmation page appears on the screen.
- This reply was modified 1 month, 3 weeks ago by dev1122.
Thread Starter dev1122
(@dev1122)

1 month, 3 weeks ago
```
Logs for Square plugin are as follows.



2024-09-25T11:45:29+00:00 NOTICE Request
method:
uri: retrieveCustomer/9XNFNGCKCF3NKW2KPGVD2J07Y0
user-agent: WooCommerce-Square/4.8.1 (WooCommerce/9.3.2; WordPress/6.6.2)
headers: Array
(
)
body:
duration: 0.5072s
CONTEXT: {"_legacy":true}
2024-09-25T11:45:29+00:00 NOTICE Response
code: 200
message:
headers: Array
(
[0] => HTTP/1.1 200 OK
[Date] => Wed, 25 Sep 2024 11:45:29 GMT
[Content-Type] => application/json
[Content-Length] => 480
[Connection] => keep-alive
[CF-Ray] => 8c8ac4adbc5c2b84-LAX
[CF-Cache-Status] => DYNAMIC
[Content-Encoding] => gzip
[Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
[Vary] => Accept-Encoding
[frame-options] => DENY
[square-version] => 2024-03-20
[squareup--connect--v2--common--versionmetadata-bin] => CgoyMDI0LTAzLTIw
[x-content-type-options] => nosniff
[x-envoy-decorator-operation] => /v2/customers/**
[x-frame-options] => DENY
[x-sq-dc] => aws
[x-sq-region] => us-west-2
[x-xss-protection] => 1; mode=block
[Set-Cookie] => __cf_bm=ZAEGMsSEnWbat1BvV13R39E7DsQ0ZkoC4sv.kCqWJJY-1727264729-1.0.1.1-mDKC27oqXp.ayYXk9YO7Ji01yq7mZYe8popR24DRfQMCbNN4bThCXQLp1QRv2n1PpOJO1OLJfgeXu1HTJW9sOw; path=/; expires=Wed, 25-Sep-24 12:15:29 GMT; domain=.squareupsandbox.com; HttpOnly; Secure; SameSite=None
[Server] => cloudflare
)
body: {
"customer": {
"id": "9XNFNGCKCF3NKW2KPGVD2J07Y0",
"created_at": "2024-07-29T13:26:13.787Z",
"updated_at": "2024-07-29T13:26:13Z",
"cards": [
{
"id": "ccof:CA4SEMFvp_6ayS_Ic2tYYD9hF18oAg",
"card_brand": "VISA",
"last_4": "1111",
"exp_month": 12,
"exp_year": 2024,
"cardholder_name": "abdul wahab",
"billing_address": {
"address_line_1": "3220 m",
"locality": "Miramar",
"administrative_district_level_1": "FL",
"postal_code": "33025",
"country": "US"
}
}
],
"given_name": "abdul",
"family_name": "wahab",
"email_address": "[email protected]",
"address": {
"address_line_1": "3220 m",
"locality": "Miramar",
"administrative_district_level_1": "FL",
"postal_code": "33025",
"country": "US"
},
"phone_number": "242-424-2424",
"reference_id": "40",
"preferences": {
"email_unsubscribed": false
},
"creation_source": "THIRD_PARTY",
"segment_ids": [
"ML4XESCTD8YN5.CARDS_ON_FILE"
],
"version": 0
}
}
CONTEXT: {"_legacy":true}
2024-09-25T11:45:48+00:00 NOTICE Request
method:
uri: createOrder
user-agent: WooCommerce-Square/4.8.1 (WooCommerce/9.3.2; WordPress/6.6.2)
headers: Array
(
)
body:
duration: 0.47851s
CONTEXT: {"_legacy":true}
2024-09-25T11:45:48+00:00 NOTICE Response
code: 200
message:
headers: Array
(
[0] => HTTP/1.1 200 OK
[Date] => Wed, 25 Sep 2024 11:45:48 GMT
[Content-Type] => application/json;charset=utf-8
[Content-Length] => 533
[Connection] => keep-alive
[CF-Ray] => 8c8ac5217c952939-LAX
[CF-Cache-Status] => DYNAMIC
[Content-Encoding] => gzip
[Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
[Vary] => Accept-Encoding
[frame-options] => DENY
[square-version] => 2024-03-20
[x-content-type-options] => nosniff
[x-envoy-decorator-operation] => /v2/orders/**
[x-frame-options] => DENY
[x-sq-dc] => aws
[x-sq-region] => us-west-2
[x-xss-protection] => 1; mode=block
[Set-Cookie] => __cf_bm=3c448iV0T9av1dVgp8FXEKYg6eGgo5wAz5lhtq.IuEU-1727264748-1.0.1.1-AH253d6h9s3BoNpOoLd5fn3twKbyb1YlzL1Mi_IHws8lQ2GKF5zT24.vKXeXn2eBeBoK0fbRoh6osSyLTHk9Ag; path=/; expires=Wed, 25-Sep-24 12:15:48 GMT; domain=.squareupsandbox.com; HttpOnly; Secure; SameSite=None
[Server] => cloudflare
)
body: {
"order": {
"id": "Heo8G15QgKNZtDRZRVqD6NS72a4F",
"location_id": "LP62KVT13627K",
"reference_id": "PB10129",
"source": {
"name": "Sandbox for sq0idp-cqM0wILpVERKfaYrG8va8A"
},
"customer_id": "9XNFNGCKCF3NKW2KPGVD2J07Y0",
"line_items": [
{
"uid": "s21R2BJdPofHS9xDLJAs1B",
"name": "Lion's Mane Capsules",
"quantity": "1",
"item_type": "ITEM",
"base_price_money": {
"amount": 2299,
"currency": "USD"
},
"variation_total_price_money": {
"amount": 2299,
"currency": "USD"
},
"gross_sales_money": {
"amount": 2299,
"currency": "USD"
},
"total_tax_money": {
"amount": 0,
"currency": "USD"
},
"total_discount_money": {
"amount": 0,
"currency": "USD"
},
"total_money": {
"amount": 2299,
"currency": "USD"
},
"total_service_charge_money": {
"amount": 0,
"currency": "USD"
}
},
{
"uid": "rstfqcMSChHWaEtBJkDRqC",
"name": "Free shipping",
"quantity": "1",
"item_type": "ITEM",
"base_price_money": {
"amount": 0,
"currency": "USD"
},
"variation_total_price_money": {
"amount": 0,
"currency": "USD"
},
"gross_sales_money": {
"amount": 0,
"currency": "USD"
},
"total_tax_money": {
"amount": 0,
"currency": "USD"
},
"total_discount_money": {
"amount": 0,
"currency": "USD"
},
"total_money": {
"amount": 0,
"currency": "USD"
},
"total_service_charge_money": {
"amount": 0,
"currency": "USD"
}
}
],
"net_amounts": {
"total_money": {
"amount": 2299,
"currency": "USD"
},
"tax_money": {
"amount": 0,
"currency": "USD"
},
"discount_money": {
"amount": 0,
"currency": "USD"
},
"tip_money": {
"amount": 0,
"currency": "USD"
},
"service_charge_money": {
"amount": 0,
"currency": "USD"
}
},
"created_at": "2024-09-25T11:45:47.984Z",
"updated_at": "2024-09-25T11:45:47.984Z",
"state": "OPEN",
"version": 1,
"total_money": {
"amount": 2299,
"currency": "USD"
},
"total_tax_money": {
"amount": 0,
"currency": "USD"
},
"total_discount_money": {
"amount": 0,
"currency": "USD"
},
"total_tip_money": {
"amount": 0,
"currency": "USD"
},
"total_service_charge_money": {
"amount": 0,
"currency": "USD"
},
"net_amount_due_money": {
"amount": 2299,
"currency": "USD"
}
}
}
CONTEXT: {"_legacy":true}
2024-09-25T11:45:49+00:00 NOTICE Request
method:
uri: createPayment
user-agent: WooCommerce-Square/4.8.1 (WooCommerce/9.3.2; WordPress/6.6.2)
headers: Array
(
)
body:
duration: 0.96386s
CONTEXT: {"_legacy":true}
2024-09-25T11:45:49+00:00 NOTICE Response
code: 200
message:
headers: Array
(
[0] => HTTP/1.1 200 OK
[Date] => Wed, 25 Sep 2024 11:45:49 GMT
[Content-Type] => application/json
[Content-Length] => 987
[Connection] => keep-alive
[CF-Ray] => 8c8ac5245e8a2939-LAX
[CF-Cache-Status] => DYNAMIC
[Content-Encoding] => gzip
[Strict-Transport-Security] => max-age=631152000; includeSubDomains; preload
[Vary] => Accept-Encoding
[frame-options] => DENY
[square-version] => 2024-03-20
[squareup--connect--v2--common--versionmetadata-bin] => CgoyMDI0LTAzLTIw
[x-content-type-options] => nosniff
[x-envoy-decorator-operation] => /v2/payments/**
[x-frame-options] => DENY
[x-sq-dc] => aws
[x-sq-region] => us-west-2
[x-xss-protection] => 1; mode=block
[Set-Cookie] => __cf_bm=8fvKvvlpKt663WfwFHmKWdtzSDD0u5Lldo3puTZKtHw-1727264749-1.0.1.1-cwxanjJ_mUs1Vp7KHMkqiwsSl0J1NxSxrF0lgKWdzjywMF5eCw_RKpzc3sSuB.JrByTqUlQATEHz1OQTOldrXg; path=/; expires=Wed, 25-Sep-24 12:15:49 GMT; domain=.squareupsandbox.com; HttpOnly; Secure; SameSite=None
[Server] => cloudflare
)
body: {
"payment": {
"id": "Zy9lmjQcmSgvURBvxYUdyz4LISJZY",
"created_at": "2024-09-25T11:45:48.713Z",
"updated_at": "2024-09-25T11:45:49.004Z",
"amount_money": {
"amount": 2299,
"currency": "USD"
},
"total_money": {
"amount": 2299,
"currency": "USD"
},
"approved_money": {
"amount": 2299,
"currency": "USD"
},
"status": "COMPLETED",
"delay_duration": "PT168H",
"delay_action": "CANCEL",
"delayed_until": "2024-10-02T11:45:48.713Z",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "VISA",
"last_4": "1111",
"exp_month": 12,
"exp_year": 2024,
"fingerprint": "sq-1-ofTojqRtit88W1eITahAwM_VSb6odjtgXQGSm_Qpr4YxDTaW9mzQ0dgC5pUZ1X2Atw",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "411111"
},
"entry_method": "ON_FILE",
"cvv_status": "CVV_NOT_CHECKED",
"avs_status": "AVS_ACCEPTED",
"statement_description": "SQ *DEFAULT TEST ACCOUNT",
"card_payment_timeline": {
"authorized_at": "2024-09-25T11:45:48.838Z",
"captured_at": "2024-09-25T11:45:49.004Z"
}
},
"location_id": "LP62KVT13627K",
"order_id": "Heo8G15QgKNZtDRZRVqD6NS72a4F",
"reference_id": "PB10129",
"customer_id": "9XNFNGCKCF3NKW2KPGVD2J07Y0",
"risk_evaluation": {
"created_at": "2024-09-25T11:45:48.839Z",
"risk_level": "NORMAL"
},
"buyer_email_address": "[email protected]",
"billing_address": {
"address_line_1": "3220 m",
"address_line_2": "",
"locality": "Miramar",
"administrative_district_level_1": "FL",
"postal_code": "33025",
"country": "US",
"first_name": "abdul",
"last_name": "wahab"
},
"shipping_address": {
"address_line_1": "3220 m",
"address_line_2": "",
"locality": "Miramar",
"administrative_district_level_1": "FL",
"postal_code": "33025",
"country": "US",
"first_name": "abdul",
"last_name": "wahab"
},
"note": "PRIME BRANDS - Order PB10129",
"receipt_number": "Zy9l",
"receipt_url": "https:\/\/squareupsandbox.com\/receipt\/preview\/Zy9lmjQcmSgvURBvxYUdyz4LISJZY",
"application_details": {
"square_product": "ECOMMERCE_API",
"application_id": "sandbox-sq0idb-DhMqMIpYkXeaGgSyTgGXSA"
},
"version_token": "UWYLaiumu0ZyhYDcBG7q7hfdR0USefxGDsudTKwsDwH6o"
}
}
CONTEXT: {"_legacy":true}
```
Plugin Support Shameem R. a11n
(@shameemreza)

1 month, 3 weeks ago
Hi @dev1122

Looking at the logs you’ve shared, the Square payment gateway appears to be working correctly. The response times for the Square API calls are within acceptable limits, and no errors are reported in the logs.

However, there is a noticeable delay between the createOrder and createPayment requests. This delay could be contributing to the slow checkout time you’re experiencing.

The delay could be due to various factors such as network latency, server load, or database performance. Since you’ve already moved to a VPS and checked your server-side integrations, I would suggest looking into the following areas:
1. Check if the database queries are optimized and if the database server is not overloaded.
2. Try running a traceroute from your server to Square’s servers to check for any network-related issues.
3. Check if the PHP scripts are executing quickly on your server. You may need to increase the PHP memory limit or optimize the PHP code.
4. You can also install the Index WP MySQL For Speed plugin to make your MySQL database work more efficiently.
If you’re still unable to identify the issue, you may need to consider hiring a WooCommerce expert or contacting your hosting provider for further assistance.
Thread Starter dev1122
(@dev1122)

1 month, 3 weeks ago

Hi @shameemreza

I have checked and performed the following points.

1. Database Queries are optimized but still there is no difference in checkout loading time.
2. Can you please give some more detail about this. how can i perform this step?
3. I have checked this and increased the PHP memory limit to 2GB and as you can see in system report at the top.
4. I installed that and added the keys as well to recommended database tables. still I don’t see any difference or improvement.

Above answers are marked against the numbers that you sent in previous message. Can you please give some more insight how can i perform the point number 2 in you message? Related to running a trace out from your server to square.

I will be waiting for you reply.

Thread Starter dev1122
(@dev1122)

1 month, 3 weeks ago

@shameemreza The site URL for my staging site is https://staging.primebrands.com/. I have performed all above steps and if you want to process the order you can do at your end as well. There is already a sandbox account active for payment processing.

Plugin Support Zubair Zahid (woo-hc)
(@doublezed2)

1 month, 3 weeks ago

Hello dev1122,

Thank you for your reply.

I placed two test orders on the site.
The first order was Cash on Delivery and it was processed within 2 seconds.
The second order was using Square Sandbox and it took about 4-5 seconds.

Could you check again by placing a few orders and tell me the time for Square payment processing?

Looking forward to your response. ??

Thread Starter dev1122
(@dev1122)

1 month, 3 weeks ago

@doublezed2 can you please share any screenshot for placing order for square sandbox. Just to confirm the time that I am calculating is from the second the place order button is clicked to the second order confirmation screen is visible. Total time for this is 12 to 15 seconds almost on staging site.

I have placed another order and time was same that I confirmed. It would be really great if you can share the video please for this processing.

This is the video related to issue that I face on staging checkout.
https://www.loom.com/share/f6ed5bd23fc8477d9b2699a1d5d0b40b?sid=ec887cad-c38a-4593-8cd2-5616131cda66

Thread Starter dev1122
(@dev1122)

1 month, 3 weeks ago

@doublezed2 @shameemreza I tried to do a conflict test on the website as well. Means I tried to uninstall all the plugins except WooCommerce and WooCommerce Square and also changed the theme from Hello Elementor to Twenty Twenty-Four theme. And i also created a video of the slow checkout.
Video: https://www.loom.com/share/806eb6a115d4406c86d05d208456708b?sid=ea6d04bc-8791-4299-9d7d-17a6cdcd80a4

This video clearly show deactivating all plugins and changing the theme to Twenty Twenty-Four gives checkout loading time of 9.5 seconds. And I install all plugins and my customizations as well. The loading time goes to 12 to 15 seconds.

Hope this video will let you understand the issue more. I will be waiting for your reply. Really want to resolve this issue!
Plugin Support Beauty of Code (woo-hc)
(@beautyofcode)

1 month, 3 weeks ago
Hey @dev1122 ,

I’ve tested your staging site on my end and I’m experiencing the same issue. When using Square on checkout, the load time ranges from 15 to 20 seconds, whereas cash on delivery (COD) results in a load time of about 5 to 8 seconds.
```
PHP Version: 7.4.33
```
I noticed that your current PHP version is 7.4.33. Can you try updating your PHP version to 8.0 or higher (preferably 8.1), as WooCommerce and many plugins perform better on newer (supported) versions of PHP?

Also, can you check your server logs to see if there are any timeouts or slow queries related to the checkout process? The logs might reveal performance issues, such as database slowdowns or external API delays, that could be contributing to the longer load times with Square.

It may also be helpful to clear any server-side caching mechanisms to see if this makes any difference. You could also reach out to your host and ask them to make sure that your?Cart?and?Checkout?pages are excluded from being cached

Let us know how this goes!
Thread Starter dev1122
(@dev1122)

1 month, 3 weeks ago

@beautyofcode I have update the PHP version of the staging.primebrands.com site to 8.1. Following latest system report is attached

` WordPress Environment WordPress address (URL): https://staging.primebrands.com Site address (URL): https://staging.primebrands.com WC Version: 9.3.3 Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site. Action Scheduler Version: ? 3.8.1 Log Directory Writable: ? WP Version: 6.6.2 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: ? Language: en External object cache: – Server Environment Server Info: Apache PHP Version: 8.1.29 PHP Post Max Size: 8 MB PHP Time Limit: 3000 PHP Max Input Vars: 3000 cURL Version: 7.61.1 OpenSSL/1.1.1k SUHOSIN Installed: – MySQL Version: 8.0.39 Max Upload Size: 8 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? Your server does not have the SoapClient class enabled – some gateway plugins which use SOAP may not work as expected. DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 9.3.3 WC Database Prefix: egm5_ Total Database Size: 206.68MB Database Data Size: 189.67MB Database Index Size: 17.01MB egm5_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_woocommerce_order_items: Data: 0.05MB + Index: 0.02MB + Engine InnoDB egm5_woocommerce_order_itemmeta: Data: 0.16MB + Index: 0.16MB + Engine InnoDB egm5_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cust_net_30_invoices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cust_net_30_invoices_comments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_actionscheduler_actions: Data: 0.45MB + Index: 0.45MB + Engine InnoDB egm5_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_actionscheduler_logs: Data: 0.31MB + Index: 0.23MB + Engine InnoDB egm5_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_braapf_product_stock_status_parent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_braapf_product_variation_attributes: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_braapf_term_taxonomy_hierarchical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_braapf_variable_attributes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_commentmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_comments: Data: 0.16MB + Index: 0.17MB + Engine InnoDB egm5_cr_reminders_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB egm5_customer_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB egm5_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB egm5_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB egm5_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_easywpsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_easywpsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_options: Data: 5.33MB + Index: 0.28MB + Engine InnoDB egm5_postmeta: Data: 91.55MB + Index: 9.55MB + Engine InnoDB egm5_posts: Data: 64.52MB + Index: 0.80MB + Engine InnoDB egm5_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB egm5_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_termmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_usermeta: Data: 0.25MB + Index: 0.36MB + Engine InnoDB egm5_users: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB egm5_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB egm5_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_order_addresses: Data: 0.06MB + Index: 0.06MB + Engine InnoDB egm5_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_order_operational_data: Data: 0.05MB + Index: 0.03MB + Engine InnoDB egm5_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wc_orders: Data: 0.06MB + Index: 0.13MB + Engine InnoDB egm5_wc_orders_meta: Data: 0.34MB + Index: 0.80MB + Engine InnoDB egm5_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wc_product_meta_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB egm5_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wc_smart_coupons: Data: 0.02MB + Index: 0.20MB + Engine InnoDB egm5_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wcs_payment_retries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wlr_earn_campaign: Data: 0.02MB + Index: 0.09MB + Engine InnoDB egm5_wlr_earn_campaign_transaction: Data: 0.02MB + Index: 0.17MB + Engine InnoDB egm5_wlr_levels: Data: 0.02MB + Index: 0.08MB + Engine InnoDB egm5_wlr_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB egm5_wlr_points_ledger: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_wlr_referral: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wlr_reward_transactions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB egm5_wlr_rewards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB egm5_wlr_user_rewards: Data: 0.02MB + Index: 0.11MB + Engine InnoDB egm5_wlr_users: Data: 0.02MB + Index: 0.08MB + Engine InnoDB egm5_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB egm5_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_wpml_mails: Data: 20.52MB + Index: 0.02MB + Engine InnoDB egm5_wpr_above_the_fold: Data: 0.05MB + Index: 0.06MB + Engine InnoDB egm5_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB egm5_wsal_metadata: Data: 0.05MB + Index: 0.03MB + Engine InnoDB egm5_wsal_occurrences: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_wt_iew_action_history: Data: 0.06MB + Index: 0.00MB + Engine InnoDB egm5_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB egm5_yoast_indexable: Data: 0.08MB + Index: 0.09MB + Engine InnoDB egm5_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB egm5_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB egm5_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB egm5_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB state_list: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wholeseller_location: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts acf-field: 28 acf-field-group: 4 attachment: 645 b2bwhs_custom_field: 10 b2bwhs_custom_role: 2 b2bwhs_group: 1 br_product_filter: 2 custom_css: 2 custom-css-js: 1 customize_changeset: 4 e-landing-page: 1 elementor_font: 1 elementor_library: 37 nav_menu_item: 22 oembed_cache: 3 page: 37 post: 13 product: 21 product_variation: 3 revision: 1940 shop_coupon: 9 shop_order: 116 shop_subscription: 5 viwec_template: 28 wapf_product: 1 wp_navigation: 1 wpcf7_contact_form: 3 wpforms: 1 yith_wcan_preset: 1 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (39) ManageWP – Worker: by GoDaddy – 4.9.20 Query Monitor: by John Blackbourn – 3.16.4 WooCommerce added to cart popup (Ajax): by XootiX – 1.7 Advanced Custom Fields: by WP Engine – 6.3.6 Advanced Product Fields for WooCommerce: by StudioWombat – 1.6.11 B2B & Wholesale Suite: by WebWizards – 1.6.34 Contact Form 7 Captcha: by 247wd – 0.1.6 Contact Form 7: by Takayuki Miyoshi – 5.9.8 Simple Custom CSS and JS: by SilkyPress.com – 3.48 Custom Order Numbers for WooCommerce: by Tyche Softwares – 1.7.1 Customer Reviews for WooCommerce: by CusRev – 5.60.2 Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.2 Easy WP SMTP: by Easy WP SMTP – 2.6.0 Elementor Pro: by Elementor.com – 3.24.2 Elementor: by Elementor.com – 3.24.4 Email Template Customizer for WooCommerce: by VillaTheme – 1.2.5 301 Redirects: by WebFactory Ltd – 2.76 Essential Addons for Elementor: by WPDeveloper – 6.0.6 Index WP MySQL For Speed: by Oliver Jones Rick James – 1.5.2 Max Mega Menu: by megamenu.com – 3.3.2 Members: by MemberPress – 3.2.10 Permalink Manager Lite: by Maciej Bis – 2.4.4.1 User Switching: by John Blackbourn – 1.8.0 Premmerce Permalink Manager for WooCommerce: by Premmerce – 2.3.11 WooCommerce.com Update Manager: by Automattic – 1.0.3 Variation Swatches for WooCommerce: by Emran Ahmed – 2.1.2 Advanced AJAX Product Filters for WooCommerce: by BeRocket – 1.6.6 Woo All Products For Subscriptions: by Woo – 6.0.2 WooCommerce Net 30 Order Email: by Abdul Wahab – 1.0 PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.8.6 WooCommerce Smart Coupons: by StoreApps – 9.10.0 WooCommerce Square: by WooCommerce – 4.8.1 WooCommerce Subscriptions: by WooCommerce – 6.7.0 WooCommerce: by Automattic – 9.3.3 Yoast SEO: by Team Yoast – 23.5 WP Mail Logging: by WP Mail Logging Team – 1.12.0 WP Menu Cart: by WP Overnight – 2.14.6 Smush: by WPMU DEV – 3.16.6 XPS Ship Integration: by XPS Ship – Descartes – 2.0.7 Inactive Plugins (9) Converter for Media: by matt plugins – Optimize images by convert WebP & AVIF – 6.1.0 Procanatest NET-30 Terms for Woocommerce: by Dipak – 1.1 Qi Addons for Elementor: by Qode Interactive – 1.8.0 Subscription Addons: by Abdul Wahab – 1.0 WooCommerce Ship to Multiple Addresses: by Abdul Wahab – 1.0.0 WP-Optimize Premium – Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.3.2 WPLoyalty – WooCommerce Loyalty Points, Rewards and Referral: by Wployalty – 1.2.4 WP Rocket: by WP Media – 3.16 Yoast SEO Premium: by Team Yoast – 23.4 Dropin Plugins () advanced-cache.php: advanced-cache.php maintenance.php: maintenance.php Must Use Plugins (3) Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.4.19 ManageWP – Worker Loader: by GoDaddy – 1.0.0 WordPress automation by Installatron: by – Settings Legacy API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription) 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 enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: ? Logging Enabled: ? Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 30 days Level threshold: – Log directory size: 2 MB WC Pages Shop base: #13 – /shop/ Cart: #14 – /cart/ – Contains the [woocommerce_cart] shortcode Checkout: #15 – /checkout/ – Contains the [woocommerce_checkout] shortcode My account: #16 – /my-account/ Terms and conditions: ? Page not set Theme Name: Hello Elementor Child Version: 1.0.1 Author URL: https://elementor.com/ Child Theme: ? Parent Theme Name: Hello Elementor Parent Theme Version: 3.1.1 Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash WooCommerce Support: ? Templates Overrides: hello-elementor-child/woocommerce/checkout/form-checkout.php hello-elementor-child/woocommerce/checkout/payment.php hello-elementor-child/woocommerce/content-single-product.php hello-elementor-child/woocommerce/loop/add-to-cart.php version 9.0.0 is out of date. The core version is 9.2.0 hello-elementor-child/woocommerce/myaccount/dashboard.php hello-elementor-child/woocommerce/myaccount/form-login.php version 7.0.1 is out of date. The core version is 9.2.0 hello-elementor-child/woocommerce/single-product/rating.php hello-elementor-child/woocommerce/single-product-reviews.php Outdated Templates: ? <pre class=”wp-block-code”><code> Learn how to update | Clear system status theme info cache</code></pre> Subscriptions WCS_DEBUG: ? No Subscriptions Mode: ? Staging Subscriptions Live URL: https://primebrands.com Subscriptions-core Library Version: 7.5.0 Subscription Statuses: wc-on-hold: 3 wc-cancelled: 2 WooCommerce Account Connected: ? Yes Active Product Key: ? No Custom Retry Rules: ? No Custom Retry Rule Class: ? No Custom Raw Retry Rule: ? No Custom Retry Rule: ? No Retries Migration Status: ? Completed Report Cache Enabled: ? Yes Cache Update Failures: ? 0 failure Store Setup Country / State: United States (US) — Florida Subscriptions by Payment Gateway Square: wc-cancelled: 2 wc-on-hold: 3 Payment Gateway Support Cash on delivery: products Square: products card_types payment_form authorization charge charge-virtual capture_charge refunds voids customer_id tokenization add_payment_method token_editor subscriptions subscription_suspension subscription_cancellation subscription_reactivation subscription_amount_changes subscription_date_changes multiple_subscriptions subscription_payment_method_change_customer subscription_payment_method_change_admin Square Environment: Production Tokenization Enabled: ? Debug Mode: Save to Log 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 pattern-toolkit-full-composability product-custom-fields remote-inbox-notifications remote-free-extensions payment-gateway-suggestions printful shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page launch-your-store Disabled Features: experimental-blocks minified-js product-pre-publish-modal settings async-product-editor-category-field product-editor-template-system blueprint reactify-classic-payments-settings Daily Cron: ? Next scheduled: 2024-10-01 14:41:04 -04:00 Options: ? Notes: 119 Onboarding: skipped All Products for Woo Subscriptions Template Overrides: hello-elementor-child/woocommerce/cart/cart-item-subscription-options.php hello-elementor-child/woocommerce/single-product/product-subscription-options-prompt-radio.php hello-elementor-child/woocommerce/single-product/product-subscription-options.php Action Scheduler Canceled: 9 Oldest: 2024-09-09 08:11:49 -0400 Newest: 2024-09-13 03:54:25 -0400 Complete: 1,073 Oldest: 2024-08-31 09:32:57 -0400 Newest: 2024-10-01 09:20:57 -0400 Failed: 154 Oldest: 2023-04-05 10:43:21 -0400 Newest: 2024-10-01 09:19:26 -0400 Pending: 6 Oldest: 2024-10-01 09:25:36 -0400 Newest: 2024-10-04 14:58:35 -0400 Smart Coupons related settings ?* Number of coupons to show: 5 ?* Number of characters in auto-generated coupon code: ?* Valid order status for auto-generating coupon: Processing | Completed ?* Automatic deletion: ? No ?* Coupon emails: ? No ?* Printing coupons: ? Yes ?* Sell gift cards at less price?: ? No ?* Use gift card applied in first subscription order for subsequent renewals until credit reaches zero: ? Yes ?* Renewal orders should not generate coupons even when they include a product that issues coupons: ? No ?* Allow sending of coupons to others: ? No ?* Allow schedule sending of coupons?: ? No ?* Combine emails: ? No ?* Auto generated coupon email: ? No ?* Combined auto generated coupons email: ? No ?* Acknowledgement email: ? No ?* Include tax in the amount of the generated gift card: ? No ?* Deduct credit/gift before doing tax calculations: ? No ?* Gift Card discount is inclusive of tax: ? No ?* Enable taxes: ? No ?* Prices entered with tax: ? No ?* Display prices in the shop: ? Excl ?* Display prices during cart and checkout: ? Excl ?* Rounding: ? No ?* Display tax totals: Itemized ?* Enable the use of coupon codes: ? Yes ?* Calculate coupon discounts sequentially: ? No ?* Account endpoints > Coupons: wc-smart-coupons ?* Block-enabled Cart: ? No ?* Block-enabled Checkout: ? No ?* WooCommerce Account Connected: ? Yes Status report information Generated at: 2024-10-01 09:21:10 -04:00 `

Thread Starter dev1122
(@dev1122)

1 month, 3 weeks ago

@beautyofcode as you can see the version is updated in above report. Still i performed couple of orders and checkout processing time for me was 12-14 seconds in multiple orders.

I have installed the Query monitor as well and I have not monitored any slow queries or server logs errors on the system.

We are using Godaddy VPS server and we have only 1 website hosted here that is https://staging.primebrands.com. We have firewall activated only and verified the firewall logs with Godaddy team as well but there were no issues found.

We tried to place order by turning off the firewall for some time as well. Still the checkout time was 12 to 14 seconds. From our local cache cart and checkout pages are removed as well from being cached. So I don’t see any issues there.

This delay is causing a big problem for our customers and we want to enhance this. Can you help us in this regards?
I will be waiting for your reply.

Plugin Support Zubair Zahid (woo-hc)
(@doublezed2)

1 month, 2 weeks ago

Hello dev1122,

Thank you for your reply.

I was able to replicate the issue as well.

Could you deactivate all plugins except for WooCommerce and WooCommerce Square?
Additionally, switch to the Twenty Twenty-Four theme.

I will conduct a test transaction again and monitor the results.

Looking forward to your response. ??

Thread Starter dev1122
(@dev1122)

1 month, 2 weeks ago

Hi @doublezed2,

As per your recommendation I have disabled all the plugin on https://staging.primebrands.com except for WooCommerce and WooCommerce Square and both are updated to the latest versions as well.

Also I have changed the default theme of project from Hello Elementor to Twenty Twenty-Four. As you can see that by visiting the page as well.

Now in order to test please go to the following URL that will take you to product page and do the testing on checkout flow with only 2 plugins active and different theme as well.
Product URL: https://staging.primebrands.com/product/ultra-shroom/lions-mane-capsules/

I performed my tests in this form and checkout took almost 9 to 10 seconds to load.

If you need any other thing do let me know. I will be waiting for your reply.