Order Item ID’s change on payment confirmation

  • Resolved mariusmo

    (@mariusmo)


    4 years, 8 months ago

    Hello, this is something we’ve noticed happening to some of our customers.

    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.

    Any reason this might be happening or any particular cause for this?

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

    (@wpnomad)

    Hi @mariusmo ,

    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.

    I’m not sure I follow what order item ID you’re referring to here. Are you referring to the order items (the products in an order)?

    If so, the products/items in an order are defined by the product’s ID itself. Even if you remove the product from an order, and add it back – the ID won’t change.

    Could you please give us more insight on what ID is changing on your site? A screenshot of the ID would help. You can use https://snipboard.io to send us a screenshot link.

    Thread Starter mariusmo

    (@mariusmo)

    Hello
    Apologies, what I meant to say was Line_item ID’s, not order ID’s.

    I have created an order to show a comparison of how it looks when we sync the data.
    https://snipboard.io/nti87u.jpg

    Plugin Support wpnomad a11n

    (@wpnomad)

    Hi @mariusmo ,

    Thank you for clarifying that and for the screenshot.

    If I understand correctly, the left side data in your screenshot is the JSON data before the payment was confirmed, and the right side shows the data after the payment was confirmed. On the left side, the line item id is 12444, while on the right side it is 12445. Is that right?

    Also, can you please let us know what payment gateway you’re using on the site?

    Apart from that, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status.
    Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

    Do let us know so we can help further.

    Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    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.

    Thread Starter mariusmo

    (@mariusmo)

    Can I re-open this thread, or do I need to start a new one for the same query?
    We should be getting an update from our customer soon.

    • This reply was modified 4 years, 6 months ago by mariusmo.
    Thread Starter mariusmo

    (@mariusmo)

    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

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