• Resolved Noelle Steegs

    (@noellesteegs)


    Hi! Something changed about the order numbers on my client’s website. Before the change the last order was #25728. After the change the next order number is #9004111222007518. This may have appeared after updating to WordPress 5.6. I know there’s a plugin that helps set order numbers, but as it was always working fine we’d like to see whether it’s a bug perhaps? Thank you.

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

Viewing 11 replies - 1 through 11 (of 11 total)
  • Hello,

    There may be a conflict with WordPress 5.6 and a plugin.
    Can you disable and enable plugins one by one to determine which plugin is causing the problem? When you disable a plugin, place a test order to see if the order number is long.

    Please keep us posted, we will be happy to help!

    Thread Starter Noelle Steegs

    (@noellesteegs)

    Hi @maykato, thanks so much for your reply. I deactivated all plugins except for WooCommerce and Stripe and I switched to the default theme, but the issue persists. What other troubleshooting steps do you recommend? I have also contacted the host (Nexcess) to see whether there’s anything they can check on their side.

    Hello,

    Have you tried to deactivate/reactivate your plugins one by one?
    You can determine which plugin is causing the conflict by:

    Thread Starter Noelle Steegs

    (@noellesteegs)

    @maykato As stated, the issue persisted after deactivating all the plugins. So no need to reactivate one by one. ?? That’d only be the next step if after deactivating the plugins the issue is gone, but it’s not…

    Yes, we did have in mind to get an order number plugin if needed, so I’ll go ahead and test that.

    Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi @noellesteegs!

    Yes, we did have in mind to get an order number plugin if needed, so I’ll go ahead and test that.

    If you do, this is a great option: https://woocommerce.com/products/sequential-order-numbers-pro/

    As for the sudden change, there is nothing in core responsible for this as far as I can see. With that said, would you mind sending us a screenshot of what that looks like on your side? You can use the free Snipboard.io tool to do so.

    Additionally, please also send us your sites’ status report so we can take a closer look at your setup, thanks. You’ll find that under “WooCommerce > Status” page.

    Cheers!

    Thread Starter Noelle Steegs

    (@noellesteegs)

    Hey @rynald0s,

    Thanks so much for your reply. I did test Sequential Order Numbers Pro but unfortunately that isn’t a solution either as it requires us to set a starting number higher than the highest number that already exists. ??

    Here’s a screenshot of the wp_posts table. Note the last normal order number and then the long ones. The next auto-index value is 9,004,111,222,007,542.

    I am at a loss. If it’s not plugins, nor something the host did, nor PHP snippets I wrote, then what could it possibly be? I’d really like to resolve this and am happy to provide anything that’ll help you help me. ??

    Here’s the status report of the staging site as I ran lots of plugin updates there to see if that’d fix the issue.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://bb1f1de8aa.nxcli.net
    Site address (URL): https://bb1f1de8aa.nxcli.net
    WC Version: 4.8.0
    REST API Version: ? 4.8.0
    WC Blocks Version: ? 3.8.1
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 1.7.3
    Log Directory Writable: ?
    WP Version: 5.6
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: –
    WP Cron: –
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.13
    PHP Post Max Size: 2 GB
    PHP Time Limit: 600
    PHP Max Input Vars: 16384
    cURL Version: 7.29.0
    NSS/3.53.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.2.33-MariaDB
    Max Upload Size: 2 GB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 4.5.0
    WC Database Prefix: wp_
    Total Database Size: 113.44MB
    Database Data Size: 79.53MB
    Database Index Size: 33.91MB
    wp_woocommerce_sessions: Data: 5.52MB + Index: 0.14MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 1.52MB + Index: 0.19MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 4.52MB + Index: 5.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 1.30MB + Index: 0.52MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 1.34MB + Index: 0.30MB + Engine InnoDB
    wp_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_campaigns: Data: 0.00MB + Index: 0.00MB + Engine
    wp_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_direct_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_referralmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_affiliate_wp_referrals: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_sales: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_affiliate_wp_visits: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
    wp_brb_business: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_brb_review: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cartflows_visits: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_cartflows_visits_meta: Data: 10.52MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
    wp_comments: Data: 2.52MB + Index: 1.81MB + Engine InnoDB
    wp_email_customizer_plus_templates: Data: 0.30MB + Index: 0.00MB + Engine InnoDB
    wp_email_log: Data: 12.52MB + Index: 0.00MB + Engine InnoDB
    wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_entry: Data: 2.52MB + Index: 0.22MB + Engine InnoDB
    wp_gf_entry_meta: Data: 0.27MB + Index: 0.42MB + Engine InnoDB
    wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_meta: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailchimp_carts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_mailchimp_jobs: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 3.47MB + Index: 0.17MB + Engine InnoDB
    wp_postmeta: Data: 19.55MB + Index: 20.06MB + Engine InnoDB
    wp_posts: Data: 5.52MB + Index: 1.05MB + Engine InnoDB
    wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_simple_history: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_simple_history_contexts: Data: 0.19MB + Index: 0.16MB + Engine InnoDB
    wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_taxjar_record_queue: Data: 0.19MB + Index: 0.05MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.25MB + Index: 0.16MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wcs_payment_retries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.25MB + Index: 0.22MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.77MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.52MB + Index: 0.45MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpeditor_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpforms_entry_fields: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wpforms_entry_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpmerge_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.48MB + Index: 0.55MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 443
    brb_collection: 1
    cartflows_flow: 12
    cartflows_step: 24
    custom_css: 2
    divi_overlay: 1
    et_body_layout: 3
    et_pb_layout: 27
    et_template: 8
    et_theme_builder: 2
    jetpack_migration: 2
    jp_img_sitemap: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    jp_vid_sitemap: 1
    nav_menu_item: 12
    oembed_cache: 12
    page: 74
    post: 77
    product: 20
    product_variation: 94
    revision: 72
    shop_coupon: 9
    shop_order: 3448
    shop_order_refund: 1083
    wpforms: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (29) ###
    
    Gravity Forms: by Gravity Forms – 2.4.21
    AffiliateWP: by Sandhills Development
    LLC – 2.5.6
    
    AffiliateWP - Affiliate Area Tabs: by Sandhills Development
    LLC – 1.2.9
    
    AffiliateWP - Allowed Products: by Sandhills Development
    LLC – 1.1.3
    
    AffiliateWP - Custom Affiliate Slugs: by Sandhills Development
    LLC – 1.0.3
    
    Business Reviews Bundle: by RichPlugins  – 1.6.1
    CartFlows Pro: by CartFlows Inc – 1.5.12
    CartFlows: by CartFlows Inc – 1.5.22
    Child Theme Configurator: by Lilaea Media – 2.5.6
    Code Snippets: by Code Snippets Pro – 2.14.0
    Google Tag Manager for WordPress: by Thomas Geiger – 1.11.6
    Mailchimp for WooCommerce: by Mailchimp – 2.5.0
    Simple History: by P?r Thernstr?m – 2.38.0
    TaxJar - Sales Tax Automation for WooCommerce: by TaxJar – 3.2.4
    Video PopUp: by Alobaidi – 1.1.2
    Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.7
    WooCommerce Chained Products: by StoreApps – 2.9.9
    Clear Cart & Sessions for WooCommerce: by Puri.io – 1.4.9
    WooCommerce Email Customizer Plus: by Flycart – 1.2.3
    WooCommerce Stripe Gateway: by WooCommerce – 4.6.0
    WooCommerce Mailchimp Pro: by Saint Systems – 2.3.6
    WP WooCommerce Mailchimp: by Saint Systems – 2.3.12
    WooCommerce Sequential Order Numbers Pro: by SkyVerge – 1.17.0
    WooCommerce Smart Coupons: by StoreApps – 4.13.0 (update to version 4.14.0 is available)
    WooCommerce: by Automattic – 4.8.0
    Yoast SEO: by Team Yoast – 15.5
    WPMerge: by Revmakx – 1.2.6
    Yoast SEO: WooCommerce: by Team Yoast – 13.7
    YITH Custom Thank You Page for Woocommerce: by YITH – 1.3.2
    
    ### Inactive Plugins (3) ###
    
    AffiliateWP - Direct Link Tracking: by Sandhills Development
    LLC – 1.1.4
    
    Coming Soon Page, Maintenance Mode & Landing Pages by SeedProd: by SeedProd – 6.0.9.0
    WooCommerce URL Coupons: by SkyVerge – 2.12.0
    
    ### Dropin Plugins (1) ###
    
    fatal-error-handler.php: fatal-error-handler.php
    
    ### Must Use Plugins (2) ###
    
    ET Support Center :: Must-Use Plugins Autoloader: by Elegant Themes –
    Nexcess Managed Apps: by Nexcess – 1.15.3
    
    ### Settings ###
    
    API Enabled: ?
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)
    
    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: #145 - /shop/
    Cart: #146 - /cart/
    Checkout: #147 - /checkout/
    My account: #148 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Divi Child
    Version: 3.20.1.1555534789
    Author URL: https://www.elegantthemes.com
    Child Theme: ?
    Parent Theme Name: Divi
    Parent Theme Version: 4.7.7
    Parent Theme Author URL: https://www.elegantthemes.com
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 1,741
    Oldest: 2020-11-30 21:00:13 -0800
    Newest: 2021-01-07 06:32:23 -0800
    
    Failed: 1
    Oldest: 2020-03-17 21:24:57 -0700
    Newest: 2020-03-17 21:24:57 -0700
    
    Pending: 1
    Oldest: 2021-01-07 06:52:23 -0800
    Newest: 2021-01-07 06:52:23 -0800
    
    
    laceyrod

    (@laceyrod)

    Automattic Happiness Engineer

    Hi @noellesteegs

    Thanks for sending us your site’s System Status Report. This is definitely an odd case if you’ve deactivated everything and the problem remains.

    One thing I did notice that was standing out from your report is that your site’s database version is outdated. I’m wondering if updating this might help.

    Before you make any updates, I would recommend backing up your site first. Then, head to WooCommerce > Status > Tools (tab) > Update Database.

    Once this is done, can you also send us an updated System Status Report showing that all plugins have been deactivated (except for WC) with a default theme active? We’d like to revisit it at that point.

    Let us know how this goes!

    • This reply was modified 3 years, 10 months ago by laceyrod.
    Thread Starter Noelle Steegs

    (@noellesteegs)

    Hey @laceyrod,

    It seems that the update database process has changed since I last used it. I am used to getting a notification about it when it’s needed, and then being able to see its progress. This no longer seems to be the case.

    I started the update but there seems to be no way for me to see whether it’s complete. Or perhaps I am missing something?

    Thanks,
    No?lle

    Hey @noellesteegs! The process is described here:

    https://docs.woocommerce.com/document/how-to-update-woocommerce/#section-13

    Once you attempt the update, you can check the database version in WooCommerce > Status > System Status.

    Let us know how that goes and if it fixes the issue for you. If not, please send us a copy of the System Status report showing that all plugins have been deactivated (except for WooCommerce) with a default theme active.

    Thanks!

    @noellesteegs we haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread. Cheers!

    Thread Starter Noelle Steegs

    (@noellesteegs)

    Hi @zdenys, we actually ended up hiring a database engineer, who fixed the issue by updating the IDs in the posts plus the auto-increment value. Thanks for the assistance.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Sudden long order numbers’ is closed to new replies.