Orders go missing
-
Hello,
I am using WooCommerce, and I got a call from a client, that he waits for his order but it does not came. As I wanted to check the order, I could not find his order, neither his name or any data.
Sadly, this is not the first time – and I can imagine how many clients are waiting for their orders that I do not know of.
He got the order email, but I do not see his order on the backend, so I searched for the order log in MyPhP and could not find it either. It does not happen to all my clients, there is only one or two calls like this every month.It is really frustrating because I don’t want them to rate my shop bad because of a bug I cannot figure out.
We use Paylike as a built-in paying service after checkout – I tought of that causing the problem somehow, but this last client did not pay via Paylike.
Do You have any idea how could I solve this problem or what should I check, or how can I see the orders that may have gone missing?Thank You in advance!
The page I need help with: [log in to see the link]
-
Hello @reginaplichta,
I can imagine how frustrating this situation is for you. The first thing that comes to my mind is the data retention settings inWooCommerce > Settings > Accounts and Privacy
.You will notice there are two fields for failed/cancelled orders. This means that if a customer attempts to place an order and the payment webhook fails to update the order status for any reason, the order will be deleted, provided that you have set a retention period.
If that’s not the case, did the customer provide proof of payment? Can an ID be found in the order email? Additionally, did you “site admin” receive the order email notification as well, and what payment method did the customer use?
Could you please share a copy of your site’s 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.Look forward to hearing back from you.
Hello,
sorry for the late answer. I checked the “Accounts and Privacy” section but I did not see any fields there because it was set not to save these kind of orders. I now set it for 15 days so we can see those orders maybe.
Site admin does not get order emails, but customers do in some occasions – but sometimes they do not get it either, we only see the sent amount of money that arrived on our Paylike account. We have SMTP working on our page and it detected no problems.
Here you have the System Status:` ### WordPress Environment ### WordPress address (URL): https://gemino.hu Site address (URL): https://gemino.hu WC Version: 7.8.2 REST API Version: ? 7.8.2 WC Blocks Version: ? 10.2.4 Action Scheduler Version: ? 3.5.4 Log Directory Writable: ? WP Version: 6.2.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: hu_HU External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.33 PHP Post Max Size: 256 MB PHP Time Limit: 180 PHP Max Input Vars: 1000 cURL Version: 7.87.0 OpenSSL/1.1.1p SUHOSIN Installed: – MySQL Version: 5.5.5-10.5.19-MariaDB-cll-lve Max Upload Size: 64 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 7.8.2 WC Database Prefix: wpiv_ Teljes adatbázis mérete: 142.38MB Adatbázis adatok mérete: 107.77MB Adatbázis index mérete: 34.61MB wpiv_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB wpiv_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpiv_woocommerce_order_items: Data: 0.09MB + Index: 0.02MB + Engine InnoDB wpiv_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.42MB + Engine InnoDB wpiv_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpiv_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_actionscheduler_actions: Data: 1.02MB + Index: 0.84MB + Engine InnoDB wpiv_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_actionscheduler_logs: Data: 0.38MB + Index: 0.31MB + Engine InnoDB wpiv_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_cff_facebook_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_comments: Data: 0.25MB + Index: 0.25MB + Engine InnoDB wpiv_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_duplicator_pro_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_enable_wp_debug_from_admin_dashboard__errors_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wpiv_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wpiv_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_options: Data: 10.22MB + Index: 1.39MB + Engine InnoDB wpiv_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxe_google_cats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_postmeta: Data: 59.56MB + Index: 22.03MB + Engine InnoDB wpiv_posts: Data: 25.52MB + Index: 4.94MB + Engine InnoDB wpiv_revslider_css: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_termmeta: Data: 1.13MB + Index: 0.16MB + Engine InnoDB wpiv_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB wpiv_term_relationships: Data: 0.39MB + Index: 0.30MB + Engine InnoDB wpiv_term_taxonomy: Data: 0.08MB + Index: 0.06MB + Engine InnoDB wpiv_usermeta: Data: 0.16MB + Index: 0.09MB + Engine InnoDB wpiv_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpiv_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wpiv_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB wpiv_wc_category_lookup: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wpiv_wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wpiv_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpiv_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDB wpiv_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_wc_product_meta_lookup: Data: 1.52MB + Index: 0.92MB + Engine InnoDB wpiv_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpiv_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpiv_wpml_mails: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wpiv_yoast_indexable: Data: 2.52MB + Index: 0.84MB + Engine InnoDB wpiv_yoast_indexable_hierarchy: Data: 0.14MB + Index: 0.22MB + Engine InnoDB wpiv_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpiv_yoast_primary_term: Data: 0.14MB + Index: 0.19MB + Engine InnoDB wpiv_yoast_seo_links: Data: 0.09MB + Index: 0.03MB + Engine InnoDB ### Post Type Counts ### attachment: 7721 cms_block: 11 cookielawinfo: 6 ct_afc: 1 custom_css: 1 elementor_library: 17 et_body_layout: 1 et_footer_layout: 1 et_pb_layout: 1 et_template: 2 et_theme_builder: 1 mc4wp-form: 1 nav_menu_item: 55 page: 23 polylang_mo: 2 portfolio: 9 post: 2 product: 1493 product_variation: 2008 revision: 4964 shop_order: 368 wc_product_table: 1 woodmart_sidebar: 2 woodmart_slide: 3 wpcf7_contact_form: 4 wpt_product_table: 2 yith_wcan_preset: 2 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (29) ### Advanced Floating Content: írta Code Tides – 1.2.4 Akismet Anti-Spam: Spam Protection: írta Automattic - Anti Spam Team – 5.2 Klasszikus szerkeszt?: írta WordPress-k?zrem?k?d?k – 1.6.3 Classic Widgets: írta WordPress-k?zrem?k?d?k – 0.3 Contact Form 7: írta Takayuki Miyoshi – 5.7.7 Yoast Duplicate Post: írta Enrico Battocchi & Team Yoast – 4.5 GTM4WP: írta Thomas Geiger – 1.16.2 Elementor Pro: írta Elementor.com – 3.5.2 Elementor: írta Elementor.com – 3.14.1 Facebook Chat Plugin – él? cseveg?b?vítmény a WordPresshez: írta Meta – 2.5 Fish and Ships: írta wpcentrics – 1.4.15 Site Kit by Google: írta Google – 1.104.0 Loco Translate: írta Tim Whitlock – 2.6.4 Non-Purchasable WooCommerce Products: írta Guy Primavera – 1.4 WooCommerce Paylike Gateway: írta Derikon Development – 3.3.3 Product GTIN (EAN, UPC, ISBN) for WooCommerce: írta Emanuela Castorina – 1.1.1 Fixed Widget: írta Thomas Maier Max Bond – 6.2.3 Slider Revolution: írta ThemePunch – 6.3.9 HuCommerce | Magyar WooCommerce kiegészítések: írta HuCommerce.hu – 2022.4.1 Tracking Code Manager: írta Data443 – 2.0.16 Converter for Media: írta matt plugins – 5.9.3 Product Feed PRO for WooCommerce: írta AdTribes.io – 12.7.8 Woo Set Price Note (Units, Offers, Editions): írta Sh Shanker – 2.0.2 WooCommerce Checkout Field Editor: írta WooCommerce – 1.5.35 WooCommerce Table Rate Shipping: írta WooCommerce – 3.0.28 WooCommerce: írta Automattic – 7.8.2 Woodmart Core: írta – 1.0.29 WP Fastest Cache: írta Emre Vona – 1.1.7 WP Mail SMTP: írta WP Mail SMTP – 3.8.0 ### Inactive Plugins (0) ### ### Dropin Plugins (1) ### maintenance.php: maintenance.php ### Settings ### API Enabled: – Force SSL: – Currency: HUF (Ft) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 0 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: WC_Order_Data_Store_CPT HPOS data sync enabled: – ### WC Pages ### Webshop f?oldal: #20343 - /webaruhaz/ Kosár: #13 - /kosar/ Pénztár: #14 - /penztar/ Fiókom: #15 - /fiokom/ általános Szerz?dési Feltételek: #20284 - /altalanos-szerzodesi-feltetelek/ ### Theme ### Name: Woodmart Version: 6.2.3 (update to version 7.2.4 is available) Author URL: https://themeforest.net/user/xtemos Child Theme: ? – Amennyiben a WooCommerce-t egy olyan szül?sablonban módosítunk amelyet nem saját magunk készítettünk akkor javasoljuk a származtatott sablon használatát. Hogyan készítsünk származtatott sablonokat WooCommerce Support: ? ### Templates ### Overrides: woodmart/woocommerce/archive-product.php woodmart/woocommerce/cart/cart-item-data.php woodmart/woocommerce/cart/cart.php verzió 4.4.0 elavult. Az új verzió: 7.8.0 woodmart/woocommerce/cart/cross-sells.php woodmart/woocommerce/cart/mini-cart.php verzió 5.2.0 elavult. Az új verzió: 7.8.0 woodmart/woocommerce/checkout/form-checkout.php woodmart/woocommerce/checkout/thankyou.php woodmart/woocommerce/content-product-cat.php woodmart/woocommerce/content-product.php woodmart/woocommerce/content-single-product.php woodmart/woocommerce/content-widget-product.php woodmart/woocommerce/global/breadcrumb.php woodmart/woocommerce/global/form-login.php verzió 3.6.0 elavult. Az új verzió: 7.0.1 woodmart/woocommerce/global/quantity-input.php verzió 4.0.0 elavult. Az új verzió: 7.8.0 woodmart/woocommerce/loop/add-to-cart.php woodmart/woocommerce/loop/loop-end.php woodmart/woocommerce/loop/loop-start.php woodmart/woocommerce/loop/no-products-found.php verzió 2.0.0 elavult. Az új verzió: 7.8.0 woodmart/woocommerce/loop/orderby.php woodmart/woocommerce/loop/pagination.php woodmart/woocommerce/loop/sale-flash.php woodmart/woocommerce/myaccount/form-login.php verzió 4.1.0 elavult. Az új verzió: 7.0.1 woodmart/woocommerce/product-searchform.php verzió 3.3.0 elavult. Az új verzió: 7.0.1 woodmart/woocommerce/single-product/add-to-cart/grouped.php verzió 4.8.0 elavult. Az új verzió: 7.0.1 woodmart/woocommerce/single-product/add-to-cart/variable.php verzió 3.5.5 elavult. Az új verzió: 6.1.0 woodmart/woocommerce/single-product/meta.php woodmart/woocommerce/single-product/product-image.php verzió 3.5.1 elavult. Az új verzió: 7.8.0 woodmart/woocommerce/single-product/product-thumbnails.php woodmart/woocommerce/single-product/rating.php woodmart/woocommerce/single-product/related.php woodmart/woocommerce/single-product/sale-flash.php woodmart/woocommerce/single-product/tabs/tabs.php woodmart/woocommerce/single-product/title.php woodmart/woocommerce/single-product/up-sells.php woodmart/woocommerce/single-product.php Outdated Templates: ? Hogyan kell frissíteni ### Admin ### Enabled Features: activity-panels analytics product-block-editor coupons 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 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: core-profiler minified-js new-product-management-experience product-variation-management settings async-product-editor-category-field Daily Cron: ? Next scheduled: 2023-07-11 17:14:09 +00:00 Options: ? Notes: 140 Onboarding: completed ### Action Scheduler ### Teljesítve: 1?930 Oldest: 2023-06-10 15:29:59 +0000 Newest: 2023-07-11 14:51:20 +0000 Sikertelen: 16 Oldest: 2022-02-23 10:09:10 +0000 Newest: 2023-06-08 14:03:22 +0000 Függ?ben: 2 Oldest: 2023-07-11 20:30:37 +0000 Newest: 2023-07-17 14:08:32 +0000 ### Status report information ### Generated at: 2023-07-11 14:53:42 +00:00 `
I hope you can help, thank you in advance.
Hi @reginaplichta ,
It seems that this has been marked as resolved. Have you managed to get this sorted, or do you still need help resolving this?
We’ll be happy to assist further should the issue persist.
Looking forward to your response!
Hi Roxy,
I still need help, I attached the log your colleauge has asked for.
Sadly yesterday I encountered another order missing.
Thank you for your help in advance!Hi @reginaplichta ??
Thank you for reaching back, elaborating further on this.
I still need help, I attached the log your colleauge has asked for.
Sadly yesterday I encountered another order missing.I went ahead with visiting the site at https://gemino.hu/, and it appears to have the following payment methods active currently:
- Direct bank transfer (WooCommerce core functionality)
- Cash on delivery payment (WooCommerce core functionality)
- Bank card payment (Paylike)
Furthermore, when an order is received, it is registered in various places, like:
- https://gemino.hu/wp-admin/edit.php?post_type=shop_order
- Email server log
- Paylike payment gateway log (if that method was selected)
Could you make sure the
New Order
emails are activated, and delivered as expected, please? For context:When placing a test order, does it register in both the
WooCommerce > Orders
screen, and with aNew Order
email, or otherwise?Furthermore, the WP Mail SMTP plugin that is installed on the site, has email logging among its features. What does it reveal, regarding the last missing order? Also, with which payment method was it placed?
We will be standing by for your response.
- The topic ‘Orders go missing’ is closed to new replies.