PAYMENTS RECEIVED BUT ORDERS ARE EMPTY
-
I have received some randon orders with no user inforntation, this orders were actually paid but no information was stored in woocommerce, thus I caanot send the product to the customer. I have some of this kind or empty orders. I checked in the payment gateway report and no user information were sent either
Attached is a screnshot.
https://snipboard.io/jDdQRf.jpg
The page I need help with: [log in to see the link]
-
Hey there, @joshuadarkdream! Thanks for contacting us. I’m happy to help you.
Were all orders with this issue paid for with Mercado Pago?
Have you had any orders after that? If so, were they correct?Can you please share a screenshot of the order notes?
Please remove any sensitive information before sharing it here. I recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.
Here’s an example of what we need:
https://snipboard.io/ga15Gu.jpg
Furthermore, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:
System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
Fatal error logs (if any) under WooCommerce > Status > Logs. Then you can use the selector to search for Fatal Errors.
You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.Looking forward to your reply.
Have a wonderful day!
WordPress Environment<br><br>WordPress address (URL): https://grupoformativoestudiantil.org<br>Site address (URL): https://grupoformativoestudiantil.org<br>WC Version: 9.2.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.8.1<br>Log Directory Writable: ?<br>WP Version: 6.6.1<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: es_MX<br>External object cache: – Server Environment<br><br>Server Info: LiteSpeed<br>PHP Version: 8.1.27<br>PHP Post Max Size: 256 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 5000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.11.8-MariaDB-cll-lve<br>Max Upload Size: 256 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database<br><br>WC Database Version: 9.1.4<br>WC Database Prefix: wp_<br>Tama?o total de la base de datos: 931.57MB<br>Tama?o de los datos de la base de datos: 451.29MB<br>Tama?o del índice de la base de datos: 480.28MB<br>wp_woocommerce_sessions: Datos: 0.25MB + índice: 0.02MB + Motor InnoDB<br>wp_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wp_woocommerce_order_items: Datos: 6.52MB + índice: 1.50MB + Motor InnoDB<br>wp_woocommerce_order_itemmeta: Datos: 48.58MB + índice: 42.02MB + Motor InnoDB<br>wp_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wp_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_actionscheduler_actions: Datos: 135.19MB + índice: 178.72MB + Motor InnoDB<br>wp_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_actionscheduler_logs: Datos: 102.16MB + índice: 79.20MB + Motor InnoDB<br>wp_addonlibrary_addons: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_addonlibrary_categories: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_aiowps_audit_log: Datos: 0.09MB + índice: 0.06MB + Motor InnoDB<br>wp_aiowps_debug_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_aiowps_events: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_aiowps_global_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_aiowps_logged_in_users: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wp_aiowps_login_lockdown: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_aiowps_message_store: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_aiowps_permanent_block: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_commentmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_comments: Datos: 12.52MB + índice: 10.09MB + Motor InnoDB<br>wp_e_events: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_litespeed_url: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_litespeed_url_file: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB<br>wp_nextend2_image_storage: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_nextend2_section_storage: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB<br>wp_nextend2_smartslider3_generators: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_nextend2_smartslider3_sliders: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB<br>wp_nextend2_smartslider3_sliders_xref: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_nextend2_smartslider3_slides: Datos: 0.05MB + índice: 0.11MB + Motor InnoDB<br>wp_options: Datos: 29.34MB + índice: 2.59MB + Motor InnoDB<br>wp_postmeta: Datos: 6.52MB + índice: 1.97MB + Motor InnoDB<br>wp_posts: Datos: 9.52MB + índice: 2.86MB + Motor InnoDB<br>wp_realvirtual_datosfiscales: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_snippets: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_termmeta: Datos: 0.06MB + índice: 0.06MB + Motor InnoDB<br>wp_terms: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_term_relationships: Datos: 0.06MB + índice: 0.05MB + Motor InnoDB<br>wp_term_taxonomy: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_tm_taskmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_tm_tasks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_usermeta: Datos: 0.06MB + índice: 0.03MB + Motor InnoDB<br>wp_users: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB<br>wp_wc_admin_notes: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB<br>wp_wc_admin_note_actions: Datos: 0.05MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wc_customer_lookup: Datos: 2.52MB + índice: 1.69MB + Motor InnoDB<br>wp_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_wc_orders: Datos: 8.52MB + índice: 9.83MB + Motor InnoDB<br>wp_wc_orders_meta: Datos: 68.61MB + índice: 131.31MB + Motor InnoDB<br>wp_wc_order_addresses: Datos: 7.52MB + índice: 7.97MB + Motor InnoDB<br>wp_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB<br>wp_wc_order_operational_data: Datos: 4.52MB + índice: 2.97MB + Motor InnoDB<br>wp_wc_order_product_lookup: Datos: 3.52MB + índice: 1.67MB + Motor InnoDB<br>wp_wc_order_stats: Datos: 2.52MB + índice: 3.34MB + Motor InnoDB<br>wp_wc_order_tax_lookup: Datos: 1.52MB + índice: 0.94MB + Motor InnoDB<br>wp_wc_product_attributes_lookup: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_product_download_directories: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_product_meta_lookup: Datos: 0.02MB + índice: 0.11MB + Motor InnoDB<br>wp_wc_rate_limits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB<br>wp_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB<br>wp_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB Post Type Counts<br><br>attachment: 951<br>custom_css: 1<br>elementor_library: 4<br>igmap: 2<br>nav_menu_item: 4<br>oec-template: 3<br>page: 68<br>popup: 4<br>popup_theme: 8<br>post: 5<br>product: 135<br>revision: 84<br>seedprod: 1<br>shop_order_placehold: 20574<br>wp_font_face: 33<br>wp_font_family: 12<br>wp_navigation: 1<br>wpcode: 3 Security<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (24)<br><br>WPBits Addons For Elementor: por WPBits – 1.5.1<br>All-in-One WP Migration: por ServMask – 7.86<br>Business Bloomer Only Allow 1 Product in the Cart: por Business Bloomer – 1.5.20230912<br>Classic Widgets: por Colaboradores de WordPress – 0.3<br>Code Snippets: por Code Snippets Pro – 3.6.5.1<br>Coming Soon Page, Maintenance Mode, Landing Pages & WordPress Website Builder by SeedProd: por SeedProd – 6.18.5<br>Yoast Duplicate Post: por Enrico Battocchi & Team Yoast – 4.5<br>Elementor: por Elementor.com – 3.23.4<br>MapGeo - Interactive Geo Maps: por MapGeo – 1.6.18<br>Ocean eComm Treasure Box: por OceanWP – 1.4.1<br>Ocean Extra: por OceanWP – 2.3.0<br>Skydropx: por Skydropx – 1.1.1<br>Popup Maker: por Popup Maker – 1.19.2<br>reSmush.it Image Optimizer: por reSmush.it – 1.0.3<br>Facturación - RVCFDI para WooCommerce: por Gustavo Arizmendi – 8.1.2<br>Simple Chat Button: por Rasoul Mousavian – 1.8.0<br>Smart Slider 3: por Nextend – 3.5.1.23<br>Unlimited Elements for Elementor: por Unlimited Elements – 1.5.120<br>UpdraftPlus - Backup/Restore: por UpdraftPlus.Com<br>DavidAnderson – 1.24.4<br><br>WooCommerce Cart PDF: por CloudCatch LLC – 2.9.4<br>Advanced Order Export For WooCommerce: por AlgolPlus – 3.5.3<br>Mercado Pago: por Mercado Pago – 7.6.4<br>WooCommerce: por Automattic – 9.2.3<br>WP STAGING WordPress Backup Plugin - Backup Duplicator & Migration: por WP-STAGING<br>WPStagingBackup – 3.8.4 Inactive Plugins (8)<br><br>All In One WP Security: por All In One WP Security & Firewall Team – 5.3.2<br>Hostinger AI: por Hostinger – 2.0.9<br>Hostinger Tools: por Hostinger – 3.0.8<br>LiteSpeed Cache: por LiteSpeed Technologies – 6.4.1<br>Ocean Modal Window: por OceanWP – 2.2.2<br>Ocean Posts Slider: por OceanWP – 2.0.7<br>Ocean Stick Anything: por OceanWP – 2.0.8<br>WP-Optimize - Clean, Compress, Cache: por David Anderson<br>Ruhani Rabin<br>Team Updraft – 3.5.0 Must Use Plugins (2)<br><br>Disable Auto Updates: por –<br>WP STAGING Optimizer: por WP STAGING – 1.5.7 Settings<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: MXN ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature enabled: ?<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: – Logging<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 días<br>Level threshold: –<br>Log directory size: 2 GB WC Pages<br><br>Base de la tienda: #16 - /tienda/<br>Carrito: #17 - /carrito/ - Contains the woocommerce/cart block<br>Finalizar compra: #18 - /finalizar-compra/ - Contains the woocommerce/checkout block<br>Mi cuenta: #19 - /mi-cuenta/<br>Términos y condiciones: #2522 - /terminos-y-condiciones/ Theme<br><br>Name: OceanWP Child Theme<br>Version: 1.0<br>Author URL: https://oceanwp.org/<br>Child Theme: ?<br>Parent Theme Name: OceanWP<br>Parent Theme Version: 3.5.8 – 3.5.9 está disponible<br>Parent Theme Author URL: https://oceanwp.org/about-oceanwp/<br>WooCommerce Support: ? Templates<br><br>Overrides: oceanwp/woocommerce/cart/mini-cart.php<br>oceanwp/woocommerce/content-single-product.php<br>oceanwp/woocommerce/loop/loop-start.php<br>oceanwp/woocommerce/single-product/product-image.php<br>oceanwp/woocommerce/single-product/title.php Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br><br>Daily Cron: ? Next scheduled: 2024-08-30 16:59:48 -06:00<br>Options: ?<br>Notes: 76<br>Onboarding: completed Action Scheduler<br><br>Completar: 436,251<br>Oldest: 2024-07-29 13:44:55 -0600<br>Newest: 2024-08-29 13:44:42 -0600<br><br>Fallida: 6<br>Oldest: 2024-06-16 16:10:23 -0600<br>Newest: 2024-07-23 12:52:03 -0600<br><br>En curso: 1<br>Oldest: –<br>Newest: –<br><br>Pendiente: 136<br>Oldest: 2024-08-29 13:43:12 -0600<br>Newest: 2024-08-29 16:31:56 -0600 Status report information<br><br>Generated at: 2024-08-29 13:45:03 -06:00<br>
I searched for fatal errors on specific the date of he empty order and didn’t find any. Would it be of any use the fatal error logs of other days?
Hi there – Thanks for sharing that status report! Just to be sure, did you see my colleague’s earlier questions? To recap they are:
- Were all orders with this issue paid for with Mercado Pago?
- Have you had any orders after that? If so, were they correct?
In addition, while working through the status report you shared, I wanted to follow up on the following:
- The plugin Code Snippets is installed – Can you share a screenshot of the snippets you have enabled on your store?
- Did you have classic or block checkout enabled at the time of the order?
- Is this something that you can replicate yourself while working through a test checkout?
- Were there any changes to the site at the time this started happening?
Thanks!
Hello sorry for the latency.
- Were all orders with this issue paid for with Mercado Pago? – yes all orders were paid with Mercado Pago
- Have you had any orders after that? If so, were they correct? – Yes Before and after we have had correct orders
This a screenshot of the snippets: https://snipboard.io/qJseNG.jpg
I am using the block checkout
We have not been able to replicate de issue, we have satging copy of our store to test but we have not been able to replicate it
No, since it is a productive site with thousands of orders we have not made any changes
As an example we have an interesting case:
A customer sent us a screenshot of the order confirmation she received after completing checkout. Her order apperas blank in woocommerce but somehow she received this email,. therfore her address was stored somewhere!Is there any part or wordpress where we can find this order information besides the Orders section of Woocommerce?? Now we have plenty of blank orders stacking up.
Below are screenchots of the case:
the cutomers received email: https://snipboard.io/kjUKpe.jpg
The woocommerce order: https://snipboard.io/ciz8ha.jpg
In addition: we have guest checkout enabled
- This reply was modified 2 months, 3 weeks ago by joshuadarkdream.
- This reply was modified 2 months, 3 weeks ago by joshuadarkdream.
Hello joshuadarkdream,
Thank you for your reply.
To clarify, were any of the correct orders that were created after the issue also paid via Mercado Pago?
Additionally, do you notice any patterns of repeat customers for these problematic orders?All orders should be visible in the WooCommerce Orders section. However, as an alternative, you can try exporting all orders into a CSV file and manually verifying the data to ensure no information is being overlooked. You may use this 3rd party plugin to export orders into a CSV file.
Could you also let us know how many blank orders have stacked up so far? Are all of these orders using the Mercado Pago payment method, or are there any with different payment gateways?
Once we have more information, we’ll be in a better position to investigate and identify the root cause.
Looking forward to your response!
Hello thanks for your reply.
I have done as you adviced and noticed that after filtering, the processed orders with no data or shipping data missing are quite a few, around 20. Though the mercado pago reports show they have a lot more blank orders. I guess that is also a Mercado pago plugin problem
All orders in our store are payed using Mercado Pago.
Update: While comparin Mercado pago reports, we found that a specific customer bought 4 products. This orders were 2 units of 2 different items (total 4). We have use a plugin to restrict each cart to one item That is why they had to be 4 orders. But we found out that the mercado pago report shows only 2 order numbres, each with 2 payments approved, instead of 4 orders and 4 payments.
How come we have to payments reference linked to the same order?? and how can we prevent this from happening again. We did not know this happened until customer contacted us sayin she had received inly 2 orders instead of 4
- This reply was modified 2 months, 3 weeks ago by joshuadarkdream.
Thank you for providing us with more details.
Based on the information you’ve shared, it seems there might be an issue with the synchronization between your WooCommerce store and Mercado Pago.
The fact that the customer was charged twice for the same order number indicates a possible problem with the payment processing. This could be due to a glitch in the Mercado Pago system or a problem with the plugin you’re using to integrate Mercado Pago with WooCommerce.
To prevent this from happening in the future, I recommend the following steps:
- Check if there are any known issues or updates available for your Mercado Pago plugin.
- Check your WooCommerce and server error logs around the time when the problematic orders were placed. This could provide clues as to what might be causing the issue.
If the problem persists, consider reaching out to the support team of your Mercado Pago plugin. They might be able to provide more specific guidance based on their knowledge of the plugin.
As for the missing order and customer information, I recommend that you ensure that all necessary fields are marked as required during checkout. This will prevent customers from placing orders without providing all the necessary information.
I hope this helps! Let us know if you have any more questions.
- You must be logged in to reply to this topic.