Auto Cancel Order (Hold Stock) Doesn’t Work

  • Resolved ekajuan

    (@ekajuan)


    6 years, 5 months ago

    My site: [ redundant link removed ]
    Woocommerce 3.4.7 

    
### WordPress Environment ###

Home URL: https://bigdear.com
Site URL: https://bigdear.com
WC Version: 3.4.7
Log Directory Writable: ?
WP Version: 4.9.8
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ?
Language: id_ID
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 5.6.38 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 256 MB
PHP Time Limit: 6000
PHP Max Input Vars: 4000
cURL Version: 7.60.0
OpenSSL/1.0.2k

SUHOSIN Installed: –
MySQL Version: 5.6.41-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.4.7
WC Database Prefix: wpbig_
MaxMind GeoIP Database: ?
Total Database Size: 15.51MB
Database Data Size: 12.82MB
Database Index Size: 2.69MB
wpbig_woocommerce_sessions: Data: 0.24MB + Index: 0.02MB
wpbig_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.02MB
wpbig_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
wpbig_woocommerce_log: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_aiowps_events: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_aiowps_failed_logins: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_aiowps_global_meta: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_aiowps_login_activity: Data: 0.01MB + Index: 0.00MB
vp_backup_wpbig_aiowps_login_lockdown: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_aiowps_permanent_block: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_commentmeta: Data: 0.01MB + Index: 0.01MB
vp_backup_wpbig_comments: Data: 0.00MB + Index: 0.01MB
vp_backup_wpbig_links: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_options: Data: 0.77MB + Index: 0.12MB
vp_backup_wpbig_postmeta: Data: 0.03MB + Index: 0.04MB
vp_backup_wpbig_posts: Data: 0.34MB + Index: 0.02MB
vp_backup_wpbig_relevanssi: Data: 0.05MB + Index: 0.09MB
vp_backup_wpbig_relevanssi_log: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_relevanssi_stopwords: Data: 0.01MB + Index: 0.01MB
vp_backup_wpbig_termmeta: Data: 0.00MB + Index: 0.01MB
vp_backup_wpbig_terms: Data: 0.00MB + Index: 0.01MB
vp_backup_wpbig_term_relationships: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_term_taxonomy: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_usermeta: Data: 0.02MB + Index: 0.01MB
vp_backup_wpbig_users: Data: 0.00MB + Index: 0.01MB
vp_backup_wpbig_wc_download_log: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_wc_webhooks: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_log: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.01MB
vp_backup_wpbig_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_sessions: Data: 0.02MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_wpc_comments_subscription: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_wpc_phrases: Data: 0.00MB + Index: 0.01MB
vp_backup_wpbig_wpc_users_voted: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB
vp_backup_wpbig_zooperwoo_payments: Data: 0.00MB + Index: 0.00MB
wpbig_ahm_download_stats: Data: 0.00MB + Index: 0.00MB
wpbig_ahm_emails: Data: 0.00MB + Index: 0.00MB
wpbig_aiowps_events: Data: 0.00MB + Index: 0.00MB
wpbig_aiowps_failed_logins: Data: 0.01MB + Index: 0.00MB
wpbig_aiowps_global_meta: Data: 0.00MB + Index: 0.00MB
wpbig_aiowps_login_activity: Data: 0.02MB + Index: 0.01MB
wpbig_aiowps_login_lockdown: Data: 0.00MB + Index: 0.00MB
wpbig_aiowps_permanent_block: Data: 0.00MB + Index: 0.00MB
wpbig_commentmeta: Data: 0.01MB + Index: 0.01MB
wpbig_comments: Data: 0.01MB + Index: 0.01MB
wpbig_ewwwio_images: Data: 0.58MB + Index: 0.42MB
wpbig_ksp_layers: Data: 0.00MB + Index: 0.00MB
wpbig_ksp_sliders: Data: 0.00MB + Index: 0.00MB
wpbig_ksp_slides: Data: 0.00MB + Index: 0.00MB
wpbig_links: Data: 0.00MB + Index: 0.00MB
wpbig_options: Data: 1.26MB + Index: 0.18MB
wpbig_postmeta: Data: 1.54MB + Index: 0.58MB
wpbig_posts: Data: 7.20MB + Index: 0.15MB
wpbig_relevanssi: Data: 0.43MB + Index: 0.69MB
wpbig_relevanssi_log: Data: 0.00MB + Index: 0.00MB
wpbig_relevanssi_stopwords: Data: 0.01MB + Index: 0.01MB
wpbig_social_users: Data: 0.00MB + Index: 0.00MB
wpbig_termmeta: Data: 0.02MB + Index: 0.02MB
wpbig_terms: Data: 0.01MB + Index: 0.02MB
wpbig_term_relationships: Data: 0.03MB + Index: 0.06MB
wpbig_term_taxonomy: Data: 0.02MB + Index: 0.02MB
wpbig_usermeta: Data: 0.13MB + Index: 0.08MB
wpbig_users: Data: 0.01MB + Index: 0.01MB
wpbig_wc_download_log: Data: 0.00MB + Index: 0.00MB
wpbig_wc_webhooks: Data: 0.00MB + Index: 0.00MB
wpbig_wpc_comments_subscription: Data: 0.00MB + Index: 0.00MB
wpbig_wpc_phrases: Data: 0.00MB + Index: 0.01MB
wpbig_wpc_users_voted: Data: 0.00MB + Index: 0.00MB
wpbig_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB
wpbig_yoast_seo_links: Data: 0.01MB + Index: 0.00MB
wpbig_yoast_seo_meta: Data: 0.01MB + Index: 0.01MB
wpbig_zooperwoo_payments: Data: 0.00MB + Index: 0.00MB

### Post Type Counts ###

attachment: 236
jetpack_migration: 2
jp_img_sitemap: 3
jp_sitemap: 3
jp_sitemap_master: 3
nav_menu_item: 17
page: 12
post: 20
product: 89
product_variation: 238
question_answer: 3
revision: 628
shop_coupon: 1
shop_order: 12
shop_order_refund: 3
wpdmpro: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (36) ###

VaultPress: by Automattic – 1.9.6
Advanced Cron Manager: by BracketSpace – 2.3.4
Akismet Anti-Spam: by Automattic – 4.0.8
All In One WP Security: by Tips and Tricks HQ
Peter Petreski
Ruhul
Ivy – 4.3.7.2

English WordPress Admin: by khromov – 1.5.1
EWWW Image Optimizer: by Shane Bishop – 4.4.2
Facebook for WooCommerce: by Facebook – 1.9.6 – Not tested with the active version of WooCommerce
Heartbeat Control: by Jeff Matson – 1.2.5
Jetpack oleh WordPress.com: by Automattic – 6.6.1
Kadence Slider: by Kadence Themes – 2.2.8
Loco Translate: by Tim Whitlock – 2.1.5
My Custom Functions: by Space X-Chimp – 4.29
Nav Menu Roles: by Kathy Darling – 1.9.2
WooCommerce Product Filter: by Mihajlovic Nenad – 6.6.0
Really Simple SSL: by Rogier Lankhorst
Mark Wolters – 3.1.1

Relevanssi: by Mikko Saari – 4.1.0.1
SB WooCommerce Email Verification: by SB Themes – 1.3 – Not tested with the active version of WooCommerce
Tawk.to Live Chat: by Tawkto – 0.3.4
User Role Editor: by Vladimir Garagulya – 4.46
Pengalihan Pengguna: by John Blackbourn & contributors – 1.4.0
WooCommerce - Social Login: by WPWeb – 1.8.1 – Not tested with the active version of WooCommerce
WooCommerce AdWords Conversion Tracking: by Wolf+B?r Agency – 1.4.12
WooCommerce Indonesia Bank: by AgenWebsite – 1.0.2 – Not tested with the active version of WooCommerce
Booster for WooCommerce: by Algoritmika Ltd – 4.0.1
WooCommerce JNE Shipping ( Exclusive Version ): by AgenWebsite – 1.8.2
WooCommerce Konfirmasi Pembayaran: by AgenWebsite – 1.0.8
WooCommerce POS Shipping ( Exclusive Version ): by AgenWebsite – 4.0.7 – Not tested with the active version of WooCommerce
WooCommerce TIKI Shipping ( Exclusive Version ): by AgenWebsite – 4.0.4.1 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.4.7
WooDiscuz - WooCommerce Comments: by gVectors Team (A. Chakhoyan
G. Zakaryan
H. Martirosyan) – 2.2.1 – Not tested with the active version of WooCommerce

Yoast SEO: by Team Yoast – 9.0
WP Mail SMTP: by WPForms – 1.3.3
WP Maintenance Mode: by Designmodo – 2.2.1
WP-Optimize: by David Anderson
Ruhani Rabin
Team Updraft – 2.2.4

YITH Automatic Role Changer for WooCommerce: by YITHEMES – 1.1.6 – Not tested with the active version of WooCommerce
ZooperWoo: by Ridwan Arifandi – 0.4.4 – Not tested with the active version of WooCommerce

### Settings ###

API Enabled: ?
Force SSL: –
Currency: IDR (Rp)
Currency Position: left_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)

### WC Pages ###

Shop base: #7 - /
Cart: #8 - /cart/
Checkout: #9 - /checkout/
Akun: #10 - /akun/
Terms and conditions: ? Page not set

### Theme ###

Name: Virtue - Premium
Version: 4.8.0
Author URL: https://www.kadencethemes.com/
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Overrides: virtue_premium/woocommerce/archive-product.php
virtue_premium/woocommerce/content-product.php
virtue_premium/woocommerce/content-product_cat.php
virtue_premium/woocommerce/content-single-product.php
virtue_premium/woocommerce/loop/loop-end.php
virtue_premium/woocommerce/loop/loop-start.php
virtue_premium/woocommerce/loop/rating.php
virtue_premium/woocommerce/loop/sale-flash.php
virtue_premium/product-searchform.php
virtue_premium/woocommerce/single-product/add-to-cart/external.php
virtue_premium/woocommerce/single-product/add-to-cart/grouped.php
virtue_premium/woocommerce/single-product/add-to-cart/simple.php
virtue_premium/woocommerce/single-product/add-to-cart/variable.php
virtue_premium/woocommerce/single-product/product-image.php
virtue_premium/woocommerce/single-product/product-thumbnails.php
virtue_premium/woocommerce/single-product/related.php
virtue_premium/woocommerce/single-product/sale-flash.php
virtue_premium/woocommerce/single-product/up-sells.php
virtue_premium/woocommerce/single-product.php
virtue_premium/woocommerce/taxonomy-product_cat.php
virtue_premium/woocommerce/taxonomy-product_tag.php

    I’ve set the Hold Stock to 1440 (24hours).
    But none of the orders passing this limit get cancelled.

    I’ve installed a plugin to see the cron jobs.
    woocommerce_cancel_unpaid_orders is there. But even though I execute it manually, still the status of orders is ‘on hold.’

    • This topic was modified 6 years, 5 months ago by ekajuan.
    • This topic was modified 6 years, 5 months ago by Jan Dembowski.

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

Viewing 11 replies - 1 through 11 (of 11 total)
  • Shane Eckert

    (@shaneeckert)

    Automattic Happiness Engineer

    Hi!

    It does sound like Cron is not working.

    Can you try installing https://www.ads-software.com/plugins/wp-crontrol/ and checking the two pages that the plugin installs for Cron? This plugin has a rather nice feature where it will alert you (banner across the top of the Admin) of any errors with Cron. It sounds like even though you see the job, there is an issue.

    Cheers!

    Thread Starter ekajuan

    (@ekajuan)

    I have installed the plugin you suggested. But no error banner across the top of the Admin.

    Cron Manager:
    https://prntscr.com/l9j6bt

    Cron Event:
    https://prntscr.com/l9j6rb

    And if I run the woocommerce_cancel_unpaid_orders manuallya, it says:
    Successfully executed the cron event woocommerce_cancel_unpaid_orders.
    https://prntscr.com/l9j7kj

    Shane Eckert

    (@shaneeckert)

    Automattic Happiness Engineer

    Hi,

    Thanks for giving that a try.

    This kind of problem is usually caused by either a conflict with your theme or with another plugin.

    The best way to determine if the issue is being caused by a theme and/or plugin is to temporarily switch your theme to Storefront and disable all plugins except for WooCommerce. If you can install plugins, install Health Check. On the troubleshooting tab, you can click the button to disable all plugins and change the theme for you while you’re logged in to that session without affecting normal visitors to your site. Note that Health Check may not count Storefront as a default theme, so you can also use Twenty Seventeen as well.

    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 plugin is causing the problem, continue to the next step.5. Reactivate your other plugins one by one, testing after each, until you find the one causing conflict.

    Thread Starter ekajuan

    (@ekajuan)

    I still have the same problem.

    https://prntscr.com/l9z2k1
    As you can see there are only two active plugins. It’s woocomemrce and wp control.

    Anda I have changed the theme to Store Front.

    But still not working.

    Plugin Support Yuki K a11n.

    (@yukikatayama)

    Automattic Happiness Engineer

    Hi @ekajuan,

    Could you clear expired transients and server cache (from host)?

    Thread Starter ekajuan

    (@ekajuan)

    I have deleted all transients by using transient manager plugin.
    And purged server cache through cpanel.
    And then did the manual cron execution.

    Still the same.

    By the way in Health Check plugin recommended by Shane there’s an info:

    The loopback request to your site failed, this may prevent WP_Cron from working, along with theme and plugin editors.
    Error encountered: (0) cURL error 28: Operation timed out after 10001 milliseconds with 0 bytes received

    Does it has anything to do with the problem?

    https://prntscr.com/l9ztwg

    • This reply was modified 6 years, 5 months ago by ekajuan.
    • This reply was modified 6 years, 5 months ago by ekajuan.
    • This reply was modified 6 years, 5 months ago by ekajuan.
    • This reply was modified 6 years, 5 months ago by ekajuan.
    Shane Eckert

    (@shaneeckert)

    Automattic Happiness Engineer

    Hi!

    Yes, I would let your hosting provider know about that error. They may be able to either address it or give us some more insight.

    Thank you!

    Thread Starter ekajuan

    (@ekajuan)

    Hi, I would like to know, is this only works on changing the status form “Payment Pending” to “Cancelled”?

    What about “On Hold” to “Cancelled”?

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there!

    > I would like to know, is this only works on changing the status form “Payment Pending” to “Cancelled”?

    This works for pending to cancelled as it’s based on the hold stock option – as soon as that times out, the order should change status from pending. Otherwise, it’ll remain on pending indefinitely.

    > What about “On Hold” to “Cancelled”?

    This won’t happen automatically, as the idea is that when an order is set to on-hold, it needs to be changed from that status manually.

    Did you ever find out more from your host?

    Thread Starter ekajuan

    (@ekajuan)

    It works now.

    But if I may give a feedback.

    I use bank transfer to receive a payment. This method is different from other method of payment such as paypal. As it will never change status automatically to something else. So I have to change many orders manually.

    For paying customers, no problem. On hold to Processing to Completed.

    But here’s the problem. If someone order something, but never pay.

    If there were hundreds of orders like this, it would be a nightmare, as I have to check among all on hold orders, which ones that have passed the time limit.

    So my suggestion, there would be a setting like Hold Stock, but to change On Hold status to Cancelled after certain days.

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    I’m glad to hear it’s working!

    I hear what you’re saying about the bank transfer option and thanks for taking the time to give us feedback. It’s fine for stores with a smaller volume – but it’s just so much work as the store scales. That’s why we tend to recommend the automated methods such as Stripe and PayPal.

    We can’t change WooCommerce core to automatically cancel bank transfer orders which are on hold, as you may then be missing a payment from the customer. However, it’s up to you if you want to go through once a week or once a month to pro-actively cancel those orders.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Auto Cancel Order (Hold Stock) Doesn’t Work’ is closed to new replies.

Tags