Email received (Order) but Order not showing up
-
Hi,
I have trouble with one order that don’t show up anywhere on woo commerce or the back end of my website, however, the customer received the confirmation email with the item he purchased and the discount code he use, etc…
I can’t find this order in woo commerce system…
Do you know why?
Thank you,
Simon
The page I need help with: [log in to see the link]
-
Hello @mmmediterranean!
I believe you are facing the issue with only one order. Right?
Did you receive an email about that order?—
For better assistance, please share your WooCommerce error logs and System Status on this thread so we can take a look at your configuration and check the issue further:
System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).
Yes, it seem to be one order only, yes we did receive the email.
—
Log:
2022-03-28T23:22:31+00:00 INFO Mail sent to [email protected] for successful subscription – 642867
2022-03-28T23:22:31+00:00 INFO Subscriber [email protected] successfully subscribed – 642867System statuts:
### WordPress Environment ### WordPress address (URL): https://mmmediterranean.com Site address (URL): https://mmmediterranean.com WC Version: 6.4.1 REST API Version: ? 6.4.1 WC Blocks Version: ? 7.2.2 Action Scheduler Version: ? 3.4.0 WC Admin Version: ? 3.3.2 Log Directory Writable: ? WP Version: 5.9.3 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: nginx/1.21.3 PHP Version: 7.4.25 PHP Post Max Size: 128 MB PHP Time Limit: 300 PHP Max Input Vars: 10000 cURL Version: 7.68.0 OpenSSL/1.1.1f SUHOSIN Installed: – MySQL Version: 5.5.5-10.5.12-MariaDB-1:10.5.12+maria~focal Max Upload Size: 128 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 6.4.1 WC Database Prefix: ad0_ Total Database Size: 300.31MB Database Data Size: 197.46MB Database Index Size: 102.85MB ad0_woocommerce_sessions: Data: 24.06MB + Index: 2.02MB + Engine InnoDB ad0_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ad0_woocommerce_order_items: Data: 1.52MB + Index: 0.36MB + Engine InnoDB ad0_woocommerce_order_itemmeta: Data: 13.52MB + Index: 8.03MB + Engine InnoDB ad0_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ad0_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_actionscheduler_actions: Data: 14.02MB + Index: 8.36MB + Engine InnoDB ad0_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_actionscheduler_logs: Data: 5.03MB + Index: 4.03MB + Engine InnoDB ad0_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_aiowps_debug_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_aiowps_failed_logins: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_aiowps_login_activity: Data: 0.06MB + Index: 0.00MB + Engine InnoDB ad0_aiowps_login_lockdown: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_aiowps_permanent_block: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_check_email_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_commentmeta: Data: 0.27MB + Index: 0.20MB + Engine InnoDB ad0_comments: Data: 5.52MB + Index: 4.75MB + Engine InnoDB ad0_et_bloom_stats: Data: 2.52MB + Index: 0.00MB + Engine InnoDB ad0_et_social_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_mailchimp_carts: Data: 0.50MB + Index: 0.00MB + Engine InnoDB ad0_mailchimp_jobs: Data: 0.11MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_customers: Data: 1.52MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_customers_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_data_pairs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_items: Data: 2.52MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_account: Data: 0.17MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_class: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_customertype: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_inventorysite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_paymentmethod: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_salesrep: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_salestaxcode: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_shipmethod: Data: 0.09MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_list_term: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_log: Data: 0.36MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_map_paymentmethod: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_map_promo_code: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_map_shipping_product: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_map_tax: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_map_wq_cf: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_product_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_variation_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_mw_wc_qbo_desk_qbd_vendors: Data: 1.52MB + Index: 0.00MB + Engine InnoDB ad0_options: Data: 31.38MB + Index: 14.34MB + Engine InnoDB ad0_postmeta: Data: 61.56MB + Index: 40.88MB + Engine InnoDB ad0_posts: Data: 16.27MB + Index: 8.33MB + Engine InnoDB ad0_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB ad0_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_term_relationships: Data: 0.08MB + Index: 0.05MB + Engine InnoDB ad0_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB ad0_usermeta: Data: 1.41MB + Index: 0.66MB + Engine InnoDB ad0_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB ad0_vtprd_purchase_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_vtprd_purchase_log_product: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_vtprd_purchase_log_product_rule: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_vtprd_transient_cart_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_wc_customer_lookup: Data: 0.19MB + Index: 0.14MB + Engine InnoDB ad0_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_wc_order_coupon_lookup: Data: 0.11MB + Index: 0.14MB + Engine InnoDB ad0_wc_order_product_lookup: Data: 1.52MB + Index: 1.27MB + Engine InnoDB ad0_wc_order_stats: Data: 0.31MB + Index: 0.27MB + Engine InnoDB ad0_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB ad0_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ad0_wpml_mails: Data: 0.38MB + Index: 0.00MB + Engine InnoDB ad0_yoast_indexable: Data: 5.42MB + Index: 6.72MB + Engine InnoDB ad0_yoast_indexable_hierarchy: Data: 0.19MB + Index: 0.22MB + Engine InnoDB ad0_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ad0_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ad0_yoast_seo_links: Data: 0.09MB + Index: 0.03MB + Engine InnoDB ad0_yoast_seo_meta: Data: 0.31MB + Index: 0.00MB + Engine InnoDB quickbooks_config: Data: 0.02MB + Index: 0.00MB + Engine InnoDB quickbooks_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB quickbooks_oauth: Data: 0.02MB + Index: 0.00MB + Engine InnoDB quickbooks_queue: Data: 0.06MB + Index: 0.06MB + Engine InnoDB quickbooks_recur: Data: 0.02MB + Index: 0.03MB + Engine InnoDB quickbooks_ticket: Data: 1.52MB + Index: 0.52MB + Engine InnoDB quickbooks_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Data: 1.52MB + Index: 0.03MB + Engine InnoDB wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ### Post Type Counts ### attachment: 814 awdp_pt_rules: 1 custom_css: 3 cwginstocknotifier: 290 et_body_layout: 4 et_footer_layout: 1 et_header_layout: 1 et_pb_layout: 24 et_template: 6 et_theme_builder: 1 ig_message: 4 nav_menu_item: 163 oembed_cache: 18797 page: 26 post: 37 product: 109 product_variation: 134 revision: 196 seedprod: 3 shop_coupon: 846 shop_order: 3078 shop_order_refund: 43 wcbd_archive_layout: 12 woo_discount: 2 woo_discount_cart: 1 wphash_ntf_bar: 1 wphb_minify_group: 393 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (30) ### WooCommerce Pixel Manager: by SweetCode – 1.16.12 All In One WP Security: by All In One WP Security & Firewall Team – 4.4.12 WooCommerce Authorize.net Premium: by Indatos Technologies – 15.0 Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 2.7 Bloom: by Elegant Themes – 1.3.12 Bridge Connector: by – 1.0.0 Child Theme Configurator: by Lilaea Media – 2.5.9 Customer Reviews for WooCommerce: by CusRev – 4.38 Facebook for WooCommerce: by Facebook – 2.6.13 Flexible Shipping: by WP Desk – 4.11.6 Mailchimp for WooCommerce: by Mailchimp – 2.6.2 WooCommerce Sync for QuickBooks Desktop - by MyWorks Software: by MyWorks Software – 1.7.1 Really Simple SSL: by Really Simple Plugins – 5.3.1 Retainful - Abandoned Cart Recovery Emails and Next Order Coupons: by Retainful – 2.6.12 Sold Out Badge for WooCommerce: by Charlie Etienne – 4.3.1 Swap Google Fonts Display: by FlyingPress – 1.1.0 WooCommerce Builder For Divi: by Abdelfatah Aboelghit | DiviKingdom.Com – 4.1.0 Product Feed PRO for WooCommerce: by AdTribes.io – 11.5.3 Additional Variation Images Gallery for WooCommerce - Pro: by Emran Ahmed – 1.3.1 Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.3.1 WooCommerce Google Analytics Integration: by WooCommerce – 1.5.8 Booster for WooCommerce: by Pluggabl LLC – 5.5.7 WooCommerce Menu Cart: by WP Overnight – 2.11.0 WooCommerce Shipping & Tax: by WooCommerce – 1.25.26 WooCommerce - ShipStation Integration: by WooCommerce – 4.1.48 WooCommerce: by Automattic – 6.4.1 Yoast SEO: by Team Yoast – 18.6 Hummingbird Pro: by WPMU DEV – 3.3.2 Smush Pro: by WPMU DEV – 3.9.8 WPMU DEV Dashboard: by WPMU DEV – 4.11.12 ### Inactive Plugins (0) ### ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Must Use Plugins (2) ### Kinsta Must-use Plugins: by Kinsta Team – 2.3.7 SSO: by Garth Mortensen Mike Hansen – 0.3 ### Settings ### 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) 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: ? ### WC Pages ### Shop base: #1583 - /shop/ Cart: #1584 - /cart/ Checkout: #1585 - /checkout/ My account: #1586 - /my-account/ Terms and conditions: #1402 - /terms-conditions/ ### Theme ### Name: Divi Child Version: 4.6.6.1602840438 Author URL: https://www.elegantthemes.com Child Theme: ? Parent Theme Name: Divi Parent Theme Version: 4.17.3 Parent Theme Author URL: https://www.elegantthemes.com WooCommerce Support: ? ### Templates ### Overrides: /www/mmmediterraneancom_893/public/wp-content/plugins/woo-variation-gallery/templates/product-images.php /www/mmmediterraneancom_893/public/wp-content/plugins/woo-variation-gallery/templates/product-thumbnails.php ### Action Scheduler ### Complete: 18,285 Oldest: 2022-03-28 05:34:26 -0400 Newest: 2022-04-28 05:28:43 -0400 Failed: 105 Oldest: 2019-11-14 09:43:49 -0500 Newest: 2022-04-27 11:33:05 -0400 Pending: 5 Oldest: 2022-04-28 05:33:43 -0400 Newest: 2022-05-04 04:57:04 -0400 ### Status report information ### Generated at: 2022-04-28 05:32:59 -04:00
Hello,
Thanks for sending the system status report.
This type of issue could be caused by a conflict, you can perform a conflict test:
- Temporarily switch your theme to Storefront
- Clear the site cache, here is a guide
- Disable all plugins except for WooCommerce
- Go to your orders, and look for the order again
If the issue is not present after running these actions it means there was conflict and you can then reactivate the theme and plugins (one by one) until the cause of the problem is found You can find a more detailed explanation on how to do a conflict test here.
I hope this helps.
We haven’t heard back from you in a while (At this point I think you have been able to find a solution), so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.
Thanks.
- The topic ‘Email received (Order) but Order not showing up’ is closed to new replies.