Line Item ID’s change on payment confirmation

  • Resolved mariusmo

    (@mariusmo)


    4 years, 6 months ago

    Hello, this has been happening to more and more users.

    When an order is placed, each order item in it get’s it’s own ID.
    But when the payment is confirmed, the order item ID’s change. As if they we’re deleted from that order and added again.

    This becomes a serious problem if a payment confirmation is delayed.
    The order is placed with it’s current ID’s, get synced into an order management system. After a while a payment is confirmed and the orders item ID’s change.
    This at least in our system add order item duplicates.

    The img link here shows how the order data looks before and after payment is confirmed – https://snipboard.io/nti87u.jpg

    Also as per previous post request I am putting in the date from users account:
    The customer has confirmed that they are using WooCommerce integrations with Stripe to take payments.

    This is the result of the WP data you requested.

    ### WordPress Environment ###

    WordPress address (URL): https://ezshopper.co.uk
    Site address (URL): https://ezshopper.co.uk
    WC Version: 4.4.0
    REST API Version: ? 1.0.15
    WC Blocks Version: ? 3.1.0
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 1.4.0
    Log Directory Writable: ?
    WP Version: 5.5
    WP Multisite: –
    WP Memory Limit: 368 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_GB
    External object cache: –

    ### Server Environment ###

    Server Info: LiteSpeed

    PHP Version: 7.4.9

    PHP Post Max Size: 512 MB

    PHP Time Limit: 600

    PHP Max Input Vars: 8000

    cURL Version: 7.62.0

    OpenSSL/1.0.2k

    SUHOSIN Installed: –

    MySQL Version: 5.5.5-10.3.23-MariaDB-log-cll-lve

    Max Upload Size: 512 MB

    Default Timezone is UTC: ?

    fsockopen/cURL: ?

    SoapClient: ?

    DOMDocument: ?

    GZip: ?

    Multibyte String: ?

    Remote Post: ?

    Remote Get: ?

    ### Database ###

    WC Database Version: 4.4.0

    WC Database Prefix: wp_

    Total Database Size: 10.66MB

    Database Data Size: 8.70MB

    Database Index Size: 1.96MB

    wp_woocommerce_sessions: Data: 2.82MB + Index: 0.17MB + Engine MyISAM

    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + 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: 0.04MB + Index: 0.03MB + Engine MyISAM

    wp_woocommerce_order_itemmeta: Data: 0.23MB + Index: 0.18MB + Engine MyISAM

    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + 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.01MB + 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.68MB + Index: 0.21MB + 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.33MB + Index: 0.25MB + Engine MyISAM

    wp_adtribes_my_conversions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

    wp_cartflows_ca_cart_abandonment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

    wp_cartflows_ca_email_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

    wp_cartflows_ca_email_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

    wp_cartflows_ca_email_templates_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

    wp_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

    wp_comments: Data: 0.08MB + Index: 0.05MB + Engine MyISAM

    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

    wp_mailchimp_carts: Data: 0.01MB + Index: 0.00MB + Engine MyISAM

    wp_mailchimp_jobs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM

    wp_options: Data: 1.70MB + Index: 0.11MB + Engine MyISAM

    wp_postmeta: Data: 1.46MB + Index: 0.62MB + Engine MyISAM

    wp_posts: Data: 1.16MB + Index: 0.08MB + Engine MyISAM

    wp_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

    wp_termmeta: Data: 0.02MB + Index: 0.02MB + 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.03MB + Index: 0.01MB + Engine MyISAM

    wp_users: Data: 0.00MB + 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.01MB + Index: 0.01MB + 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.02MB + Index: 0.03MB + Engine MyISAM

    wp_wc_order_stats: Data: 0.01MB + Index: 0.02MB + Engine MyISAM

    wp_wc_order_tax_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM

    wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

    wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + 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_yith_wcwl: Data: 0.02MB + Index: 0.01MB + Engine MyISAM

    wp_yith_wcwl_lists: Data: 0.03MB + Index: 0.03MB + Engine MyISAM

    ### Post Type Counts ###

    attachment: 102

    blocks: 8

    customize_changeset: 15

    featured_item: 8

    nav_menu_item: 17

    oembed_cache: 3

    page: 17

    post: 5

    product: 16

    revision: 148

    seopress_404: 5

    seopress_bot: 1

    seopress_schemas: 1

    shop_coupon: 4

    shop_order: 189

    shop_order_refund: 2

    wpcf7_contact_form: 6

    ### Security ###

    Secure connection (HTTPS): ?

    Hide errors from visitors: ?

    ### Active Plugins (24) ###

    Contact Form 7: by Takayuki Miyoshi – 5.2.1

    GDPR Cookie Consent: by WebToffee – 1.9.0

    ELEX WooCommerce Google Shopping (Google Product Feed) – Basic: by ELEXtensions – 1.1.1 – Installed version not tested with active version of WooCommerce 4.4.0

    Estimate delivery date for Woocommerce Pro: by PI Websolution – 4.7.3.3 – Installed version not tested with active version of WooCommerce 4.4.0

    Facebook for WooCommerce: by Facebook – 2.0.1 – Installed version not tested with active version of WooCommerce 4.4.0

    The Official Facebook Chat Plugin: by Facebook – 1.7

    FraudLabs Pro for WooCommerce: by FraudLabs Pro – 2.14.7 – Installed version not tested with active version of WooCommerce 4.4.0

    Google Ads for WooCommerce: by Kliken – 1.0.4 – Installed version not tested with active version of WooCommerce 4.4.0

    Limit log in attempts reloaded: by WPChef – 2.15.1

    Mailchimp for WooCommerce: by Mailchimp – 2.4.5 – Installed version not tested with active version of WooCommerce 4.4.0

    NitroPack: by NitroPack LLC – 1.3.17

    Really Simple SSL: by Really Simple Plugins – 3.3.4

    Retainful – Abandoned Cart Recovery Emails and Next Order Coupons: by Retainful – 2.2.9

    UpdraftPlus – Backup/Restore: by UpdraftPlus.Com

    DavidAnderson – 1.16.26

    Checkout Field Editor for WooCommerce: by ThemeHigh – 1.4.3 – Installed version not tested with active version of WooCommerce 4.4.0

    Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.4 – Installed version not tested with active version of WooCommerce 4.4.0

    WPC Product Bundles for WooCommerce: by WPClever.net – 5.3.0 – Installed version not tested with active version of WooCommerce 4.4.0

    WooCommerce Stripe Gateway: by WooCommerce – 4.5.1 – Installed version not tested with active version of WooCommerce 4.4.0

    WooCommerce Google Analytics Integration: by WooCommerce – 1.4.22 – Installed version not tested with active version of WooCommerce 4.4.0

    WooCommerce: by Automattic – 4.4.0

    WooSidebars: by WooCommerce – 1.4.5

    WP Responsive Table: by Processby – 1.2.5

    SEOPress PRO: by SEOPress – 3.8.9

    SEOPress: by SEOPress – 3.8.9.1

    ### Inactive Plugins (1) ###

    Akismet Anti-Spam: by Automattic – 4.1.6

    ### Dropin Plugins (1) ###

    advanced-cache.php: advanced-cache.php

    ### 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)

    woosb (woosb)

    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: #65 – /shop/

    Basket: #64 – /cart/

    Checkout: #63 – /checkout/

    My account: #62 – /my-account/

    Terms and conditions: #397 – /tcs/

    ### Theme ###

    Name: Flatsome Child

    Version: 3.0

    Author URL:

    Child Theme: ?

    Parent Theme Name: Flatsome

    Parent Theme Version: 3.12.2

    Parent Theme Author URL: https://www.uxthemes.com/

    WooCommerce Support: ?

    ### Templates ###

    Overrides: flatsome/woocommerce/archive-product.php

    flatsome/woocommerce/cart/cart-empty.php

    flatsome/woocommerce/cart/cart-shipping.php

    flatsome/woocommerce/cart/cart.php

    flatsome/woocommerce/checkout/form-checkout.php

    flatsome/woocommerce/checkout/form-coupon.php

    flatsome/woocommerce/checkout/terms.php

    flatsome/woocommerce/checkout/thankyou.php

    flatsome/woocommerce/content-product.php

    flatsome/woocommerce/content-product_cat.php

    flatsome/woocommerce/content-single-product.php

    flatsome/woocommerce/content-widget-product.php

    flatsome/woocommerce/global/breadcrumb.php

    flatsome/woocommerce/global/quantity-input.php

    flatsome/woocommerce/global/wrapper-end.php

    flatsome/woocommerce/global/wrapper-start.php

    flatsome/woocommerce/loop/loop-end.php

    flatsome/woocommerce/loop/loop-start.php

    flatsome/woocommerce/loop/pagination.php

    flatsome/woocommerce/loop/result-count.php

    flatsome/woocommerce/loop/sale-flash.php

    flatsome/woocommerce/myaccount/form-login.php

    flatsome/woocommerce/myaccount/navigation.php

    flatsome/woocommerce/notices/error.php

    flatsome/woocommerce/notices/notice.php

    flatsome/woocommerce/notices/success.php

    flatsome/woocommerce/product-searchform.php

    flatsome/woocommerce/single-product/photoswipe.php

    flatsome/woocommerce/single-product/price.php

    flatsome/woocommerce/single-product/product-image.php

    flatsome/woocommerce/single-product/product-thumbnails.php

    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php

    ### Action Scheduler ###

    Complete: 1,981
    Oldest: 2020-07-19 22:53:55 +0100
    Newest: 2020-08-19 18:13:48 +0100

    Pending: 3
    Oldest: 2020-08-19 18:28:48 +0100
    Newest: 2020-08-24 01:03:45 +0100

    ———————–
    The original post is here, failed to reply in time – https://www.ads-software.com/support/topic/order-item-ids-change-on-payment-confirmation/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Zach W

    (@dynamiczach)

    Automattic Happiness Engineer

    Thanks for that information, and sorry to hear about the issue!

    We don’t have any reports of any line item ID or product ID issues with our Stripe plugin, and looking at your System Status, my guess is this is something else causing the problem.

    Can you try this:

    Setup the Cash On Delivery method and try a test order, then check the line item IDs. Then, change the order’s status to Completed and check to see if the line item IDs have changed.

    If they have, the issue isn’t with Stripe, and is usually caused by either a conflict with your theme or with another plugin.
    ?
    The best way to determine this is to:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • 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 plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

    Thread Starter mariusmo

    (@mariusmo)

    This does not repeat with test orders, it only appears to happen or customers that take actual payments.

    We checked with various users and the payment system that they use are different:
    “Orbisius PayPal Micropayments for WooCommerce”
    “WooCommerce Stripe Payment Gateway 4.5.0” (two people use this one)
    “Paysera”

    And the point of failure is always during the payment confirmation from the providers, where there is a waiting gap.

    It appears as if the order items have been removed and added again to the same order, that’s at least the only way we managed to get a similar result from our own testing.

    Zach W

    (@dynamiczach)

    Automattic Happiness Engineer

    Thanks for the additional information!

    It looks like the line item IDs change when any of the three payment gateway options you mentioned are used, correct? But they don’t change when you place a test order with the Cash on Delivery method?

    If that’s the case, this kind of problem is usually caused by either a conflict with your theme or with another plugin.
    ?
    The best way to determine this is to:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • 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 plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

    The only similar issue I could find is this one:

    https://github.com/woocommerce/woocommerce/issues/23335

    But that was addressed in version 3.7.0.

    Thread Starter mariusmo

    (@mariusmo)

    We found out what the issue is.
    This related with WooCommerce and how it handles failed payment attempts.

    If a payment is unsuccessful for whatever reason, during the next attempt all line_items are deleted not only from the order, but from the database itself and replaced with new ones.

    If for whatever reason orders like that are synced into our software, we end up saving the old line ID’s. And when the order is finally confirmed the payment management system removes all old ID’s and updates the order with new ones, effectively adding more items to the already synced order because the app doesn’t know what happened to the old items, because they are not there anymore.

    Zach W

    (@dynamiczach)

    Automattic Happiness Engineer

    Howdy!

    Thanks for following up with this.

    Please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

    Please include a link to this forum thread, so that we can keep track of what’s already been done.

    We will be able to help you further there.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Line Item ID’s change on payment confirmation’ is closed to new replies.