Support » Plugin: WooCommerce » Duplicated order ID causes wrong Payment status

  • Resolved mgz069

    (@mgz069)


    Hi,

    The problem is that we receive e.g. 20 payments but 3 of them are marked as “failed” or “cancelled”.

    But in the gateway’s panel they are clearly marked as paid.

    We tried everything to solve this, but no luck.

    Apparently more users have this issue with various payment gateways.

    I can’t find a direct option to stop woocommerce from duplicating order ids.

    The error is this

    Order ID: (60181) failed due to “Duplicate Order Id”. Order status changed from Pending payment to Failed.

    Can you help us fix this?

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    Can you confirm if the order IDs are indeed duplicated? For example, do you see two orders with the 60181 ID?

    Additionally, can you confirm if you are using any plugins that might be customizing or editing the way order IDs are generated? For example, a type of plugins that do this are the ones that add sequential order numbers.

    Please share a copy of your system status report. You can find it under WooCommerce > Status > Get system report > Copy for support.

    Thread Starter mgz069

    (@mgz069)

    Hi @fhaps

    No, we never saw two orders with the same ID.

    No, we don’t use any kind of plugins that alter order IDs.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://trendscyprus.com
    Site address (URL): https://trendscyprus.com
    WC Version: 4.2.0
    REST API Version: ✔ 1.0.8
    WC Blocks Version: ✔ 2.5.16
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 1.3.0
    Log Directory Writable: ✔
    WP Version: 5.4.2
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: ✔
    WP Cron: –
    Language: en_US
    External object cache: ✔
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.29 (Unix) mod_hive/6.27 OpenSSL/1.0.1e-fips mod_fastcgi/2.4.6
    PHP Version: 7.3.16
    PHP Post Max Size: 128 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 7.59.0
    OpenSSL/1.0.2r
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.36-82.1-log
    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.2.0
    WC Database Prefix: wp_
    Total Database Size: 318.20MB
    Database Data Size: 243.55MB
    Database Index Size: 74.65MB
    wp_woocommerce_sessions: Data: 35.72MB + Index: 0.61MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 2.58MB + Index: 1.25MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 46.14MB + Index: 14.27MB + 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.00MB + 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: 6.02MB + Index: 4.81MB + 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: 5.02MB + Index: 4.03MB + Engine InnoDB
    wp_apsl_users_social_profile_details: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_aws_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_aws_index: Data: 0.86MB + Index: 0.00MB + Engine MyISAM
    wp_commentmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_comments: Data: 5.89MB + Index: 1.77MB + Engine MyISAM
    wp_edn_subscriber: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ff_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ff_comments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ff_image_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ff_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ff_posts: Data: 0.10MB + Index: 0.01MB + Engine MyISAM
    wp_ff_post_media: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ff_snapshots: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ff_streams: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ff_streams_sources: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_jcc_data: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_nextend2_image_storage: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wp_nextend2_section_storage: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_nextend2_smartslider3_generators: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_nextend2_smartslider3_sliders: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_nextend2_smartslider3_sliders_xref: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_nextend2_smartslider3_slides: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_odb_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_options: Data: 27.01MB + Index: 2.66MB + Engine MyISAM
    wp_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_pmxi_images: Data: 0.15MB + Index: 0.04MB + Engine MyISAM
    wp_pmxi_imports: Data: 0.62MB + Index: 0.00MB + Engine MyISAM
    wp_pmxi_posts: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
    wp_pmxi_templates: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
    wp_postmeta: Data: 61.02MB + Index: 23.67MB + Engine MyISAM
    wp_posts: Data: 11.78MB + Index: 2.04MB + Engine MyISAM
    wp_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_siq_sync: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
    wp_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_termmeta: Data: 0.15MB + Index: 0.11MB + Engine MyISAM
    wp_terms: Data: 0.06MB + Index: 0.14MB + Engine MyISAM
    wp_term_relationships: Data: 0.16MB + Index: 0.35MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.07MB + Index: 0.06MB + Engine MyISAM
    wp_tinvwl_analytics: Data: 0.96MB + Index: 1.08MB + Engine MyISAM
    wp_tinvwl_items: Data: 0.70MB + Index: 0.27MB + Engine MyISAM
    wp_tinvwl_lists: Data: 0.29MB + Index: 0.10MB + Engine MyISAM
    wp_usermeta: Data: 11.80MB + Index: 4.74MB + Engine MyISAM
    wp_users: Data: 0.46MB + Index: 0.44MB + Engine MyISAM
    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: 1.52MB + Index: 0.56MB + Engine InnoDB
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 4.45MB + Index: 5.91MB + Engine InnoDB
    wp_wc_order_stats: Data: 1.50MB + Index: 0.81MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.36MB + Index: 0.67MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfConfig: Data: 2.26MB + Index: 0.01MB + Engine MyISAM
    wp_wfCrawlers: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfFileMods: Data: 4.22MB + Index: 0.83MB + Engine MyISAM
    wp_wfHits: Data: 0.89MB + Index: 0.16MB + Engine MyISAM
    wp_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfIssues: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wfKnownFileList: Data: 2.28MB + Index: 0.25MB + Engine MyISAM
    wp_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfLocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_wfLogins: Data: 0.75MB + Index: 0.12MB + Engine MyISAM
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfNotifications: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wp_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfReverseCache: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfStatus: Data: 0.13MB + Index: 0.06MB + Engine MyISAM
    wp_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_indexable: Data: 4.52MB + Index: 2.45MB + 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.06MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 2.39MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    acf-field: 55
    acf-field-group: 7
    amn_exact-metrics: 1
    amn_wpforms-lite: 1
    attachment: 7039
    cctor_coupon: 2
    custom_css: 2
    customize_changeset: 1
    elementor_library: 2
    is_search_form: 1
    jetpack_migration: 2
    nav_menu_item: 188
    o-discount: 3
    o-list: 1
    oceanwp_library: 2
    page: 17
    post: 24
    postman_sent_mail: 250
    product: 1100
    product_variation: 1811
    revision: 376
    sfbap1_social_feed: 1
    sg_optimizer_job: 4
    shop_coupon: 811
    shop_order: 7838
    shop_order_refund: 37
    woo_discount: 11
    woo_discount_cart: 8
    wpcd_coupons: 1
    wplp-news-widget: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (26) ###
    
    Advanced Custom Fields PRO: by Elliot Condon – 5.8.12
    Amount Left for Free Shipping for WooCommerce: by Algoritmika Ltd – 1.5.2 – Installed version not tested with active version of WooCommerce 4.2.0
    Classic Editor: by WordPress Contributors – 1.5
    GDPR Cookie Consent: by WebToffee – 1.8.8
    Facebook for WooCommerce: by Facebook – 1.11.4 – Installed version not tested with active version of WooCommerce 4.2.0
    Site Kit by Google: by Google – 1.11.1
    Heartbeat Control by WP Rocket: by WP Rocket – 2.0
    Official Facebook Pixel: by Facebook – 2.1.0
    Perfect WooCommerce Brands: by QuadLayers – 1.8.3 – Installed version not tested with active version of WooCommerce 4.2.0
    Post SMTP: by Yehuda Hassine – 2.0.12
    SearchIQ: by searchiq – 3.5
    SG Optimizer: by SiteGround – 5.5.8
    TI WooCommerce Wishlist Plugin: by TemplateInvaders – 1.17.1 – Installed version not tested with active version of WooCommerce 4.2.0
    WC Hide Shipping Methods: by Rynaldo Stoltz – 1.4
    Woo Discount Rules PRO 2.0: by Flycart Technologies LLP – 1.9.10
    Woo Discount Rules: by Flycart Technologies LLP – 1.9.12 – Installed version not tested with active version of WooCommerce 4.2.0
    Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.4 – Installed version not tested with active version of WooCommerce 4.2.0
    Variation Swatches for WooCommerce: by Emran Ahmed – 1.0.84 – Installed version not tested with active version of WooCommerce 4.2.0
    WooCommerce Admin: by WooCommerce – 1.3.0 – Installed version not tested with active version of WooCommerce 4.2.0
    JCC Payment Gateway for WC: by JCC – 1.1.1 – Installed version not tested with active version of WooCommerce 4.2.0
    WooCommerce: by Automattic – 4.2.0 (update to version 4.3.0 is available)
    Wordfence Security: by Wordfence – 7.4.9
    Yoast SEO: by Team Yoast – 14.5
    WP All Import Pro: by Soflyy – 4.6.0
    WP Debugging: by Andy Fragen – 2.7.2
    WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.2.2 – Installed version not tested with active version of WooCommerce 4.2.0
    
    ### Inactive Plugins (2) ###
    
    JCC Payment Gateway Redirect: by B.S.E. Business Solution Enteprises LTD – 1.0.7 – Installed version not tested with active version of WooCommerce 4.2.0
    Woocommerce Signup Discount: by Magnigenie – 2.0 – Installed version not tested with active version of WooCommerce 4.2.0
    
    ### Dropin Plugins (1) ###
    
    object-cache.php: Memcached
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: ✔
    Currency: EUR (€)
    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: #332 - /shop/
    Cart: #333 - /cart/
    Checkout: #7 - /checkout/
    My account: #8 - /my-account/
    Terms and conditions: #10250 - /privacy-policy/
    
    ### Theme ###
    
    Name: Trends Cyprus
    Version: 1.0
    Author URL: 
    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: trends_cyprus/woocommerce/archive-product.php version - is out of date. The core version is 3.4.0
    trends_cyprus/woocommerce/cart/cart-empty.php
    trends_cyprus/woocommerce/cart/cart-item-data.php
    trends_cyprus/woocommerce/cart/cart-shipping.php
    trends_cyprus/woocommerce/cart/cart-totals.php version - is out of date. The core version is 2.3.6
    trends_cyprus/woocommerce/cart/cart.php version - is out of date. The core version is 3.8.0
    trends_cyprus/woocommerce/cart/cross-sells.php
    trends_cyprus/woocommerce/cart/mini-cart.php
    trends_cyprus/woocommerce/cart/proceed-to-checkout-button.php
    trends_cyprus/woocommerce/cart/shipping-calculator.php
    trends_cyprus/woocommerce/checkout/cart-errors.php
    trends_cyprus/woocommerce/checkout/form-billing.php
    trends_cyprus/woocommerce/checkout/form-checkout.php version - is out of date. The core version is 3.5.0
    trends_cyprus/woocommerce/checkout/form-coupon.php
    trends_cyprus/woocommerce/checkout/form-login.php
    trends_cyprus/woocommerce/checkout/form-pay.php
    trends_cyprus/woocommerce/checkout/form-shipping.php
    trends_cyprus/woocommerce/checkout/order-receipt.php
    trends_cyprus/woocommerce/checkout/payment-method.php version - is out of date. The core version is 3.5.0
    trends_cyprus/woocommerce/checkout/payment.php
    trends_cyprus/woocommerce/checkout/review-order.php version - is out of date. The core version is 3.8.0
    trends_cyprus/woocommerce/checkout/terms.php version - is out of date. The core version is 3.4.0
    trends_cyprus/woocommerce/checkout/thankyou.php
    trends_cyprus/woocommerce/content-product.php version - is out of date. The core version is 3.6.0
    trends_cyprus/woocommerce/content-single-product.php version - is out of date. The core version is 3.6.0
    trends_cyprus/woocommerce/emails/admin-new-order.php
    trends_cyprus/woocommerce/loop/add-to-cart.php
    trends_cyprus/woocommerce/loop/price.php version - is out of date. The core version is 1.6.4
    trends_cyprus/woocommerce/loop/rating.php version - is out of date. The core version is 3.6.0
    trends_cyprus/woocommerce/loop/sale-flash.php version - is out of date. The core version is 1.6.4
    trends_cyprus/woocommerce/myaccount/dashboard.php version - is out of date. The core version is 2.6.0
    trends_cyprus/woocommerce/myaccount/downloads.php
    trends_cyprus/woocommerce/myaccount/form-add-payment-method.php
    trends_cyprus/woocommerce/myaccount/form-edit-account.php
    trends_cyprus/woocommerce/myaccount/form-edit-address.php
    trends_cyprus/woocommerce/myaccount/form-login.php version 3.6.0 is out of date. The core version is 4.1.0
    trends_cyprus/woocommerce/myaccount/form-lost-password.php
    trends_cyprus/woocommerce/myaccount/form-reset-password.php
    trends_cyprus/woocommerce/myaccount/lost-password-confirmation.php
    trends_cyprus/woocommerce/myaccount/my-account.php
    trends_cyprus/woocommerce/myaccount/my-address.php
    trends_cyprus/woocommerce/myaccount/my-downloads.php
    trends_cyprus/woocommerce/myaccount/my-orders.php
    trends_cyprus/woocommerce/myaccount/navigation.php version - is out of date. The core version is 2.6.0
    trends_cyprus/woocommerce/myaccount/orders.php
    trends_cyprus/woocommerce/myaccount/payment-methods.php
    trends_cyprus/woocommerce/myaccount/view-order.php
    trends_cyprus/woocommerce/single-product/add-to-cart/external.php
    trends_cyprus/woocommerce/single-product/add-to-cart/grouped.php
    trends_cyprus/woocommerce/single-product/add-to-cart/simple.php version - is out of date. The core version is 3.4.0
    trends_cyprus/woocommerce/single-product/add-to-cart/variable.php version - is out of date. The core version is 3.5.5
    trends_cyprus/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
    trends_cyprus/woocommerce/single-product/add-to-cart/variation.php
    trends_cyprus/woocommerce/single-product/meta.php version - is out of date. The core version is 3.0.0
    trends_cyprus/woocommerce/single-product/photoswipe.php
    trends_cyprus/woocommerce/single-product/price.php version - is out of date. The core version is 3.0.0
    trends_cyprus/woocommerce/single-product/product-attributes.php
    trends_cyprus/woocommerce/single-product/product-image.php
    trends_cyprus/woocommerce/single-product/product-thumbnails.php
    trends_cyprus/woocommerce/single-product/rating.php
    trends_cyprus/woocommerce/single-product/related.php version - is out of date. The core version is 3.9.0
    trends_cyprus/woocommerce/single-product/review-meta.php version - is out of date. The core version is 3.4.0
    trends_cyprus/woocommerce/single-product/review-rating.php
    trends_cyprus/woocommerce/single-product/review.php version - is out of date. The core version is 2.6.0
    trends_cyprus/woocommerce/single-product/sale-flash.php version - is out of date. The core version is 1.6.4
    trends_cyprus/woocommerce/single-product/share.php
    trends_cyprus/woocommerce/single-product/short-description.php
    trends_cyprus/woocommerce/single-product/stock.php version - is out of date. The core version is 3.0.0
    trends_cyprus/woocommerce/single-product/tabs/additional-information.php
    trends_cyprus/woocommerce/single-product/tabs/description.php
    trends_cyprus/woocommerce/single-product/tabs/tabs.php version - is out of date. The core version is 3.8.0
    trends_cyprus/woocommerce/single-product/title.php
    trends_cyprus/woocommerce/single-product/up-sells.php
    trends_cyprus/woocommerce/single-product-reviews.php version - is out of date. The core version is 3.6.0
    trends_cyprus/woocommerce/single-product.php version - is out of date. The core version is 1.6.4
    
    Outdated Templates: ❌
    					
    					
    						Learn how to update
    
    ### TI WooCommerce Wishlist Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 9,260
    Oldest: 2020-06-12 13:46:25 +0000
    Newest: 2020-07-13 13:39:13 +0000
    
    Failed: 222
    Oldest: 2020-04-18 15:56:02 +0000
    Newest: 2020-06-04 11:29:43 +0000
    
    Pending: 2
    Oldest: 2020-07-13 13:41:15 +0000
    Newest: 2020-07-13 13:47:24 +0000
    
    
    Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    @mgz069 Can you confirm if this is the only payment gateway you are using on the site?

    JCC Payment Gateway for WC: by JCC

    I’d recommend reaching out to the developer for advice on this error, particularly since it seems to be detecting a “duplicate” order ID despite no duplicates existing on your site.

    Thread Starter mgz069

    (@mgz069)

    @fhaps we also have PayPal but does not have any issues.

    We are in communication with the developers at the moment and they are investigating to see if the fault is on their end or not, because the rest of the users seem to have no issue with JCC.

    By the way is worth checking out the status change flow below:

    Order ID: (60484) failed due to “Duplicate Order Id”. Order status changed from Processing to Failed.

    July 13, 2020 at 3:45 pm Delete note

    JCC payment gateway response payload.
    Array
    (
    [acquirer_id] => 402971
    [order_id] => 60484
    [response_code] => 2
    [reason_code] => 150
    [reason_code_description] => Duplicate Order Id
    [reference_number] =>
    [padded_card_number] => 5391XXXXXXXX5866
    [response_signature] => IfbO39etjKqCu5a2OBen/p2a/XE=
    [authorization_code] => IfbO39etjKqCu5a2OBen/p2a/XE=
    [production_merchant_id] => 0025286071
    )

    July 13, 2020 at 3:45 pm Delete note

    Payment via JCC Payment Gateway is successful (Order ID: 60484)

    July 13, 2020 at 3:45 pm Delete note

    JCC payment gateway response payload.
    Array
    (
    [acquirer_id] => 402971
    [order_id] => 60484
    [response_code] => 1
    [reason_code] => 1
    [reason_code_description] => Approved
    [reference_number] => 019515891200
    [padded_card_number] => 5391XXXXXXXX5866
    [response_signature] => n/DbhbeMsX04jTSPPFZfnY8FWGA=
    [authorization_code] => n/DbhbeMsX04jTSPPFZfnY8FWGA=
    [production_merchant_id] => 0025286071
    )

    July 13, 2020 at 3:45 pm Delete note

    Payment via JCC Payment Gateway is successful (Order ID: 60484)

    July 13, 2020 at 3:44 pm Delete note

    Order status changed from Failed to Processing.

    July 13, 2020 at 3:44 pm Delete note

    Stock levels reduced: SteamPod 3.0 + Smoothing Cream για λεπτά μαλλιά 150ml + Smoothing Serum 50ml (5291235004740) 19→18

    July 13, 2020 at 3:44 pm Delete note

    JCC payment gateway response payload.
    Array
    (
    [acquirer_id] => 402971
    [order_id] => 60484
    [response_code] => 1
    [reason_code] => 1
    [reason_code_description] => Approved
    [reference_number] => 019515891200
    [padded_card_number] => 5391XXXXXXXX5866
    [response_signature] => n/DbhbeMsX04jTSPPFZfnY8FWGA=
    [authorization_code] => n/DbhbeMsX04jTSPPFZfnY8FWGA=
    [production_merchant_id] => 0025286071
    )

    July 13, 2020 at 3:44 pm Delete note

    JCC payment gateway response payload.
    Array
    (
    [acquirer_id] => 402971
    [order_id] => 60484
    [response_code] => 2
    [reason_code] => 41
    [reason_code_description] => Session Expired
    [reference_number] =>
    [padded_card_number] =>
    [response_signature] => TKThso0KL4pZkQIKsS0+nuydYbc=
    [authorization_code] => TKThso0KL4pZkQIKsS0+nuydYbc=
    [production_merchant_id] => 0025286071
    )

    July 13, 2020 at 3:38 pm Delete note

    Order ID: (60484) failed due to “Connection was expired due to timeout in the checkout”. Order status changed from Pending payment to Failed.

    July 13, 2020 at 3:36 pm Delete note

    JCC payment gateway response payload.
    Array
    (
    [acquirer_id] => 402971
    [order_id] => 60484
    [response_code] => 2
    [reason_code] => 6
    [reason_code_description] => Connection was expired due to timeout in the checkout
    [reference_number] =>
    [padded_card_number] =>
    [response_signature] => ChMKDlamWZNXMw115tfZSV2dFAQ=
    [authorization_code] => ChMKDlamWZNXMw115tfZSV2dFAQ=
    [production_merchant_id] => 0025286071
    )

    July 13, 2020 at 3:36 pm Delete note

    Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    @mgz069 Hopefully they are able to track down the issue.

    Given that the problem lays with the gateway plugin, and other payment methods are not experiencing the same issue, we are unable to provide much assistance in this forum which is intended for support of the core WooCommerce plugin.

    Thread Starter mgz069

    (@mgz069)

    @fhaps yes but have in mind that our other website (foxfashioncyprus.com) uses the same gateway/plug-in but does not have such an issue.

    It’s when we narrowed it down to “duplicated order id” that we assumed that WooCommerce might have a wrong configuration on our e-shop.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Duplicated order ID causes wrong Payment status’ is closed to new replies.