Support » Plugin: Limit Orders for WooCommerce » Orders have exceeded the limit

  • Resolved Cosmic Jamie

    (@cosmicjamie)


    Hi there,
    We installed this plugin for a client of ours a day or two ago.

    We set the limit to 100 orders per day, however the orders have exceeded now. We’re currently at 122.

    Is this a known issue?

    Many thanks,
    Jamie

Viewing 15 replies - 1 through 15 (of 15 total)
  • Plugin Author Brian Watson

    (@bswatson)

    Hey @cosmicjamie,

    We have seen another report that described the behavior you are seeing, but haven’t gotten additional debug info to help track it down.

    If you have the latest version of the plugin, could you go to the WooCommerce Status Report and copy the output here so we can get a look at the settings and possibly any plugins that might also be installed?

    Thanks!

    Thread Starter Cosmic Jamie

    (@cosmicjamie)

    By all means:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.fresh-cornish-fish.co.uk
    Site address (URL): https://www.fresh-cornish-fish.co.uk
    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: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.3.16
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.69.1
    OpenSSL/1.1.1f
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.47-log
    Max Upload Size: 2 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_
    Total Database Size: 35.59MB
    Database Data Size: 23.45MB
    Database Index Size: 12.14MB
    wp_woocommerce_sessions: Data: 1.62MB + Index: 0.04MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.69MB + Index: 0.34MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 4.09MB + Index: 2.91MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_actions: Data: 0.35MB + Index: 0.17MB + Engine MyISAM
    wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_actionscheduler_logs: Data: 0.23MB + Index: 0.17MB + Engine MyISAM
    wp_cart_notices: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_comments: Data: 1.80MB + Index: 0.70MB + Engine MyISAM
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_litespeed_img_optm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_litespeed_optimizer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_options: Data: 1.11MB + Index: 0.88MB + Engine MyISAM
    wp_postmeta: Data: 11.79MB + Index: 6.06MB + Engine MyISAM
    wp_posts: Data: 1.28MB + Index: 0.41MB + Engine MyISAM
    wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_usermeta: Data: 0.17MB + Index: 0.11MB + Engine MyISAM
    wp_users: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wc_admin_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_customer_lookup: Data: 0.06MB + Index: 0.05MB + Engine MyISAM
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_product_lookup: Data: 0.14MB + Index: 0.12MB + Engine MyISAM
    wp_wc_order_stats: Data: 0.06MB + Index: 0.04MB + Engine MyISAM
    wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_meta_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yoast_seo_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yoast_seo_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    attachment: 138
    nav_menu_item: 19
    page: 17
    post: 32
    product: 59
    product_variation: 113
    revision: 206
    shop_order: 3334
    shop_order_refund: 19
    vtmin-rule: 1
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (14) ###
    
    ManageWP - Worker: by GoDaddy – 4.9.6
    Add Featured Image Column: by Robin Cornett – 1.1.5
    Akismet Anti-Spam: by Automattic – 4.1.4
    Classic Editor: by WordPress Contributors – 1.5
    Contact Form 7: by Takayuki Miyoshi – 5.1.7
    Cosmic Support: by Cosmic – 1.0.0
    FV Clone Screen Options: by  – 0.4
    Limit Orders for WooCommerce: by Nexcess – 1.1.1
    LiteSpeed Cache: by LiteSpeed Technologies – 2.9.9.2
    WooCommerce Cart Notices: by SkyVerge – 1.11.3
    WooCommerce WorldPay Gateway: by Andrew Benbow – 4.1.3
    WooCommerce: by Automattic – 4.0.1
    Yoast SEO: by Team Yoast – 13.5
    Smush: by WPMU DEV – 3.6.1
    
    ### Inactive Plugins (1) ###
    
    White Label CMS: by www.videousermanuals.com – 2.1.3
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (1) ###
    
    ManageWP - Worker Loader: by GoDaddy –
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: GBP (£)
    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: #4 - /shop/
    Basket: #5 - /basket/
    Checkout: #6 - /checkout/
    My account: #7 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Fresh Cornish Fish
    Version: 1.0.4
    Author URL: https://cosmic.org.uk/
    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: fcf/woocommerce/archive-product.php
    fcf/woocommerce/cart/cart-item-data.php
    fcf/woocommerce/cart/cart-totals.php
    fcf/woocommerce/cart/cart.php
    fcf/woocommerce/cart/mini-cart.php
    fcf/woocommerce/checkout/form-checkout.php
    fcf/woocommerce/checkout/payment.php
    fcf/woocommerce/content-product.php
    fcf/woocommerce/content-single-product.php
    fcf/woocommerce/content-widget-product.php
    fcf/woocommerce/global/quantity-input.php
    fcf/woocommerce/loop/loop-start.php
    fcf/woocommerce/loop/orderby.php
    fcf/woocommerce/loop/pagination.php
    fcf/woocommerce/loop/result-count.php
    fcf/woocommerce/notices/error.php
    fcf/woocommerce/notices/notice.php
    fcf/woocommerce/notices/success.php
    fcf/woocommerce/single-product/add-to-cart/variable.php
    fcf/woocommerce/single-product/price.php
    fcf/woocommerce/single-product/related.php
    fcf/woocommerce/single-product.php
    
    ### Limit Orders ###
    
    Enabled: ✔
    Limit: 100
    Submitted orders: 8
    Remaining orders: 92
    Interval: daily
    Interval start: 2020-04-17T00:00:00+01:00
    Interval resets: 2020-04-18T00:00:00+01:00
    
    ### Action Scheduler ###
    
    Complete: 1,415
    Oldest: 2020-03-20 08:16:54 +0000
    Newest: 2020-04-17 13:45:57 +0100
    
    
    Plugin Author Brian Watson

    (@bswatson)

    Appreciate the info!

    We’ll see if we can replicate it locally and have a fix out as soon as possible. If you could also drop another round of the report details when the order count goes over the limit, that may also help pin down whether we’re having a problem with the limit calculation or the conditional that determines when to hide the add to cart button.

    Will let you know as soon as we have some info, and thanks again for the bug report!

    Thread Starter Cosmic Jamie

    (@cosmicjamie)

    Hi Brian,
    Sorry if I’m misunderstanding you here – the order count has already exceeded the limit. If I go into reports and show only orders for today, it currently sits at 122.

    Plugin Author Brian Watson

    (@bswatson)

    Interesting. So it looks like our calculation of what a day means may not be the same as the WooCommerce report.

    Based on the status report, the day is set to start at UTC + 1, and since then there have only been 8 orders.

    Limit: 100
    Submitted orders: 8
    Remaining orders: 92
    Interval: daily
    Interval start: 2020-04-17T00:00:00+01:00
    Interval resets: 2020-04-18T00:00:00+01:00

    Based on your orders, does that appear correct or are we missing orders since midnight?

    Thread Starter Cosmic Jamie

    (@cosmicjamie)

    Hi Brian,
    According to the Orders section of WooCommerce, there are 128 orders since 10:52 this morning.

    Oddly though, the Reports section of WooCommerce shows only 122 orders placed for the 17th April.

    Plugin Author Brian Watson

    (@bswatson)

    @cosmicjamie,

    I think those numbers aren’t so far off that they can’t be reconciled. The Orders section may include refunds and cancelled orders. So if there’s 122 orders + 6 refunds, it would show 128 total in the Order section.

    Just to confirm I’m looking at the right report, I’m assuming this is the new WC Admin repoort in Analytics -> Orders, and not the Sales by Date from the WooCommerce Reports section, correct?

    Again, we really appreciate all of the info and feedback so we can make sure to get to the bottom of this.

    Thread Starter Cosmic Jamie

    (@cosmicjamie)

    No problem.

    I had been getting this data from WooCommerce > Reports > Sales by Date.

    I have now gone in via Analytics > Orders > Date Range (Today) and the resulting figure is 122 orders for the day.

    Apologies for any confusion!

    Plugin Author Brian Watson

    (@bswatson)

    I believe we’ve tracked the source of this to a default limit on one of the queries. We’re writing the automated test now to confirm it and the fix and should have a new release out later today.

    Thread Starter Cosmic Jamie

    (@cosmicjamie)

    Perfect – thanks for the speedy responses Brian, much appreciated.

    Plugin Author Steve Grunwell

    (@stevegrunwell)

    Hey @cosmicjamie,

    As Brian mentioned, we have a new release ready that should address a bug that this report just uncovered. The release is rolling out now and should be available momentarily.

    Thread Starter Cosmic Jamie

    (@cosmicjamie)

    Brilliant, thanks Steve.

    Will keep an eye on it over the next week and let you know if I spot anything untoward.

    Again, many thanks for your speedy help!

    Plugin Author Brian Watson

    (@bswatson)

    Wanted to check in and see if things are working as expected now. Let us know if you continue to see any issues.

    Thanks!

    Thread Starter Cosmic Jamie

    (@cosmicjamie)

    Hi Brian,
    Have had no reports of errors from the client yet, so all is looking good so far! Will let you know if I hear otherwise.

    Cheers,
    Jamie

    Plugin Author Brian Watson

    (@bswatson)

    Great to hear!

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Orders have exceeded the limit’ is closed to new replies.