Pending payment status and inventory
-
Hi,
I am experiencing 2 issues when an order is in “pending payment” status.1) Stock inventory of the products ordered are still available in the website. So other customers may intend to Buy. In case qty=1, customer can add it to cart, and at checkout receives Notification “stock unavailable”. This is not good because product was shown as “available” when adding to cart.
I would expect that inventory is reduced while an order is in “payment pending”.2) The time configured to release stock (box set in minutes) is not being taken into consideration. I have 60minutes configured, but stock is never released. So if customer never pays, this product will be forever in this status: it is shown as available but could not be bought because of error at checkout.
3) Also, is there a way I can receive mailing Notification when an order is placed in status “payment pending”?
I found a similar issue reported in 2016. Has this issue been fixed? Is there any workarround?
Thanks!!
The page I need help with: [log in to see the link]
-
Hi there! The hold stock setting should, in theory, accomplish the first two items. Given your description of #2, however, I’m wondering if something is preventing the hold stock setting from working properly.
Can you post your system status report? You can find that by going to WooCommerce > Status in your dashboard, then clicking “Get system report,” then “Copy for support.”
As for #3, there is no default setting for receiving a notification about pending payment orders. You would need an automation plugin like AutomateWoo to achieve such functionality.
Hi!
Thanks for your reply.
Status copied!### WordPress Environment ### WordPress address (URL): https://lasmanolas.com Site address (URL): https://lasmanolas.com WC Version: 4.0.1 REST API Version: ? 1.0.7 WC Blocks Version: ? 2.5.14 Action Scheduler Version: ? 3.1.4 WC Admin Version: ? 1.0.3 Log Directory Writable: ? WP Version: 5.4 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: es_ES External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.1.33 - Recomendamos usar la versión 7.2 o superior de PHP para un mayor rendimiento y seguridad. Cómo actualizar tu versión de PHP PHP Post Max Size: 128 MB PHP Time Limit: 600 PHP Max Input Vars: 2000 cURL Version: 7.62.0 OpenSSL/1.0.2k SUHOSIN Installed: – MySQL Version: 10.1.44-MariaDB-cll-lve Max Upload Size: 128 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 4.0.1 WC Database Prefix: wp_lsman_uy_ Tama?o total de la base de datos: 125.01MB Tama?o de los datos de la base de datos: 75.68MB Tama?o del índice de la base de datos: 49.33MB wp_lsman_uy_woocommerce_sessions: Datos: 3.02MB + índice: 0.05MB + Motor InnoDB wp_lsman_uy_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_lsman_uy_woocommerce_order_items: Datos: 0.08MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_woocommerce_order_itemmeta: Datos: 0.41MB + índice: 0.39MB + Motor InnoDB wp_lsman_uy_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_lsman_uy_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_actionscheduler_actions: Datos: 0.16MB + índice: 0.17MB + Motor InnoDB wp_lsman_uy_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_actionscheduler_logs: Datos: 0.13MB + índice: 0.13MB + Motor InnoDB wp_lsman_uy_categorymeta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_commentmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_comments: Datos: 0.19MB + índice: 0.09MB + Motor InnoDB wp_lsman_uy_failed_jobs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_icl_content_status: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_icl_core_status: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_icl_flags: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_icl_languages: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_icl_languages_translations: Datos: 0.19MB + índice: 0.11MB + Motor InnoDB wp_lsman_uy_icl_locale_map: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_icl_message_status: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_icl_node: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_icl_reminders: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_icl_strings: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_lsman_uy_icl_string_positions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_icl_string_status: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_icl_string_translations: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_icl_translate: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_icl_translate_job: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_icl_translations: Datos: 0.06MB + índice: 0.13MB + Motor InnoDB wp_lsman_uy_icl_translation_batches: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_icl_translation_status: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_mailchimp_carts: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_mailchimp_jobs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_member_catmeta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_actions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_action_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_chunks: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_fields: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_field_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_forms: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_form_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_objects: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_object_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_relationships: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_nf3_upgrades: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_options: Datos: 5.03MB + índice: 0.17MB + Motor InnoDB wp_lsman_uy_portfolio_catmeta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_postmeta: Datos: 15.08MB + índice: 6.58MB + Motor InnoDB wp_lsman_uy_posts: Datos: 3.30MB + índice: 0.61MB + Motor InnoDB wp_lsman_uy_product_catmeta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_queue: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_css: Datos: 0.13MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_css_bkp: Datos: 0.13MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_layer_animations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_layer_animations_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_navigations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_navigations_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_sliders: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_sliders_bkp: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_slides: Datos: 1.39MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_slides_bkp: Datos: 1.52MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_static_slides: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_revslider_static_slides_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_termmeta: Datos: 0.11MB + índice: 0.14MB + Motor InnoDB wp_lsman_uy_terms: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_term_relationships: Datos: 0.08MB + índice: 0.05MB + Motor InnoDB wp_lsman_uy_term_taxonomy: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_usermeta: Datos: 1.52MB + índice: 0.53MB + Motor InnoDB wp_lsman_uy_users: Datos: 0.05MB + índice: 0.05MB + Motor InnoDB wp_lsman_uy_wc_admin_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wc_admin_note_actions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wc_customer_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_wc_order_product_lookup: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_lsman_uy_wc_order_stats: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB wp_lsman_uy_wc_order_tax_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_lsman_uy_wc_product_meta_lookup: Datos: 0.09MB + índice: 0.13MB + Motor InnoDB wp_lsman_uy_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_wfblockediplog: Datos: 0.16MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wfblocks7: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB wp_lsman_uy_wfconfig: Datos: 2.25MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wfcrawlers: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wffilechanges: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wffilemods: Datos: 3.52MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wfhits: Datos: 2.02MB + índice: 1.17MB + Motor InnoDB wp_lsman_uy_wfhoover: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_wfissues: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_lsman_uy_wfknownfilelist: Datos: 1.52MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wflivetraffichuman: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_wflocs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wflogins: Datos: 0.41MB + índice: 0.14MB + Motor InnoDB wp_lsman_uy_wfls_2fa_secrets: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_wfls_settings: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wfnotifications: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wfpendingissues: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_lsman_uy_wfreversecache: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wfsnipcache: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB wp_lsman_uy_wfstatus: Datos: 0.11MB + índice: 0.09MB + Motor InnoDB wp_lsman_uy_wftrafficrates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_wsal_metadata: Datos: 25.56MB + índice: 33.19MB + Motor InnoDB wp_lsman_uy_wsal_occurrences: Datos: 2.52MB + índice: 4.03MB + Motor InnoDB wp_lsman_uy_wsal_options: Datos: 3.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_yikes_easy_mc_forms: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_lsman_uy_yoast_seo_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_lsman_uy_yoast_seo_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB ### Post Type Counts ### attachment: 1304 block: 1 customize_changeset: 2 nav_menu_item: 67 nf_sub: 16 page: 25 post: 7 product: 139 product_variation: 439 revision: 278 shop_coupon: 12 shop_order: 746 shop_order_refund: 2 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (20) ### Absolutely Glamorous Custom Admin: por Cusmin – 6.5.4 Akismet Anti-Spam: por Automattic – 4.1.4 VVAme chat: por Creame – 3.2.3 Google Tag Manager for WordPress: por Thomas Geiger – 1.11.4 Dynamic Featured Image: por Ankit Pokhrel – 3.7.0 WPBakery Page Builder: por Michael M - WPBakery.com – 6.1 Loco Translate: por Tim Whitlock – 2.3.3 Mailchimp for WooCommerce: por Mailchimp – 2.3.6 Maintenance: por WP Maintenance – 3.85 Ninja Forms: por Saturday Drive – 3.4.24.1 Porto Theme - Functionality: por P-Themes – 1.5.4 Slider Revolution: por ThemePunch – 6.1.8 Checkout Field Editor for WooCommerce: por ThemeHigh – 1.4.2 Mercado Pago payments for WooCommerce: por Mercado Pago – 4.1.1 – No probado con la versión activa de WooCommerce WooCommerce Variation Swatches and Photos: por Lucas Stark – 3.0.6 – No probado con la versión activa de WooCommerce WooCommerce: por Automattic – 4.0.1 Wordfence Security: por Wordfence – 7.4.6 Yoast SEO: por Equipo Yoast – 13.5 WP Security Audit Log: por WP White Security – 4.0.3 Easy Forms for MailChimp: por YIKES Inc. – 6.6.4 ### Inactive Plugins (3) ### All In One SEO Pack: por All in One SEO Team – 3.4.2 Envato Market: por Envato – 2.0.1 Google XML Sitemaps: por Arne Brachhold – 4.1.0 ### Settings ### API Enabled: – Force SSL: – Currency: UYU ($) 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 ### Base de la tienda: #207 - /productos/ Carrito: #208 - /cart/ Finalizar compra: #209 - /checkout/ Mi cuenta: #210 - /my-account/ Términos y condiciones: ? Página sin definir ### Theme ### Name: Las Manolas Version: 1.1 Author URL: https://www.portotheme.com/ Child Theme: ? Parent Theme Name: Porto Parent Theme Version: 5.2.2 Parent Theme Author URL: https://www.portotheme.com/ WooCommerce Support: ? ### Templates ### Overrides: porto/woocommerce/archive-product.php porto/woocommerce/cart/cart-shipping.php porto/woocommerce/cart/cart-totals.php porto/woocommerce/cart/cart.php porto/woocommerce/cart/cross-sells.php porto/woocommerce/cart/mini-cart.php porto/woocommerce/cart/proceed-to-checkout-button.php porto/woocommerce/cart/shipping-calculator.php porto/woocommerce/checkout/form-billing.php porto/woocommerce/checkout/form-checkout.php porto/woocommerce/checkout/form-coupon.php las-manolas/woocommerce/checkout/form-login.php porto/woocommerce/checkout/form-pay.php porto/woocommerce/checkout/payment.php porto/woocommerce/checkout/review-order.php porto/woocommerce/content-product.php porto/woocommerce/content-product_cat.php porto/woocommerce/content-single-product.php porto/woocommerce/content-widget-product.php porto/woocommerce/global/form-login.php porto/woocommerce/global/quantity-input.php porto/woocommerce/global/wrapper-start.php porto/woocommerce/loop/add-to-cart.php porto/woocommerce/loop/loop-end.php porto/woocommerce/loop/loop-start.php porto/woocommerce/loop/no-products-found.php porto/woocommerce/loop/orderby.php porto/woocommerce/loop/pagination.php porto/woocommerce/loop/rating.php porto/woocommerce/loop/sale-flash.php porto/woocommerce/myaccount/downloads.php porto/woocommerce/myaccount/form-add-payment-method.php porto/woocommerce/myaccount/form-edit-account.php porto/woocommerce/myaccount/form-edit-address.php porto/woocommerce/myaccount/form-login.php porto/woocommerce/myaccount/form-lost-password.php porto/woocommerce/myaccount/form-reset-password.php porto/woocommerce/myaccount/lost-password-confirmation.php porto/woocommerce/myaccount/my-account.php porto/woocommerce/myaccount/my-address.php porto/woocommerce/myaccount/my-downloads.php porto/woocommerce/myaccount/my-orders.php porto/woocommerce/myaccount/orders.php porto/woocommerce/myaccount/payment-methods.php porto/woocommerce/myaccount/view-order.php porto/woocommerce/order/form-tracking.php porto/woocommerce/order/tracking.php porto/woocommerce/single-product/add-to-cart/simple.php porto/woocommerce/single-product/add-to-cart/variable.php porto/woocommerce/single-product/meta.php porto/woocommerce/single-product/product-attributes.php porto/woocommerce/single-product/product-image.php porto/woocommerce/single-product/product-thumbnails.php porto/woocommerce/single-product/rating.php porto/woocommerce/single-product/related.php porto/woocommerce/single-product/review-meta.php porto/woocommerce/single-product/review-rating.php porto/woocommerce/single-product/review.php porto/woocommerce/single-product/sale-flash.php porto/woocommerce/single-product/short-description.php porto/woocommerce/single-product/tabs/tabs.php porto/woocommerce/single-product/title.php porto/woocommerce/single-product/up-sells.php porto/woocommerce/single-product-reviews.php ### Action Scheduler ### Completo: 484 Oldest: 2020-04-13 03:04:06 +0000 Newest: 2020-04-24 18:11:26 +0000
Thanks for your response. Nothing in your system status report jumps out as something that should have any effect on the hold stock setting.
I’d recommend conflict testing, using the Health Check and Troubleshooting (https://www.ads-software.com/plugins/health-check/) plugin. This means testing to see if the issue is being caused by a code conflict between plugins or your theme. The Troubleshooting Mode of the Health Check plugin will allow you to simulate how your site would look and behave with plugins disabled and a default theme without actually changing the site.
These are the steps you should take:
1. Back up your site. Many hosting providers offer a way to do this, and there is the Jetpack (https://www.jetpack.com) plugin if your host does not provide this option.
2. Update all your plugins and your theme to their latest versions and see if the problem fixes itself.
3. If the problem remains, go to Appearance > Themes in your dashboard, search for the Storefront theme, and install it (but do not activate it yet).
4. Turn on Troubleshooting Mode in the Health Check plugin by going to Tools > Site Health > Troubleshooting and clicking “Enable Troubleshooting Mode.” Then, while in Troubleshooting Mode:
4. Switch your theme to Storefront.
5. Disable all plugins except for WooCommerce.
6. Repeat the action that is causing the problem.If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which one is causing the problem, reactivate them one by one, testing after each, until you find the one causing conflict. Switching the hold stock setting to one minute for testing purposes would make this testing easier.
We haven’t heard back from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any further questions!
- The topic ‘Pending payment status and inventory’ is closed to new replies.