• Resolved stefangociu

    (@stefangociu)


    Hello. Today I’ve noticed that in all WooCommerce orders there are more products than initially purchased, even in completed orders. Different products have been added in each order, it’s like Woocommerce decided to populate every order with more products, sub total them all out and then at the end the grand total is the original order value! This applies to all orders.

    Also for orders that were made using a coupon, the coupon appears twice in the order page (first with 20% as it was created and second with 10$ fixed amount). This is the same coupon that simultaneously has two different values.

    I have deactivated all plugins to see if there is a conflict and nothing, the problem persists. I have even rolled back a backup and still nothing.

    Even more, this issue appeared both in our staging and production websites, even though no modifications were made or any sync between the two. I have added below the WooCommerce system report. This is really strange and out of nowhere. Any help would be greatly appreciated.

    Thank you.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.erosscia.com
    Site address (URL): https://www.erosscia.com
    WC Version: 7.0.0
    REST API Version: ? 7.0.0
    WC Blocks Version: ? 8.5.1
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0.3
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.30
    PHP Post Max Size: 64 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 1000
    cURL Version: 7.71.0
    OpenSSL/1.1.1p
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.39-cll-lve
    Max Upload Size: 32 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 7.0.0
    WC Database Prefix: wo_
    Total Database Size: 264.93MB
    Database Data Size: 244.74MB
    Database Index Size: 20.19MB
    wo_woocommerce_sessions: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_order_items: Data: 0.25MB + Index: 0.17MB + Engine MyISAM
    wo_woocommerce_order_itemmeta: Data: 2.33MB + Index: 1.81MB + Engine MyISAM
    wo_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_woocommerce_tax_rate_locations: Data: 0.05MB + Index: 0.06MB + Engine MyISAM
    wo_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_actionscheduler_actions: Data: 4.40MB + Index: 1.72MB + Engine MyISAM
    wo_actionscheduler_claims: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_actionscheduler_logs: Data: 2.42MB + Index: 2.34MB + Engine MyISAM
    wo_captured_wc_fields_pro: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wo_captured_wc_fields_pro_coupons: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_captured_wc_fields_pro_products: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_commentmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wo_comments: Data: 0.54MB + Index: 0.25MB + Engine MyISAM
    wo_ee_product_sync_call: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_ee_product_sync_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_elfsight_age_verification_widgets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wo_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wo_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_mailchimp_carts: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wo_mailchimp_jobs: Data: 0.16MB + Index: 0.01MB + Engine MyISAM
    wo_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_chunks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_field_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_form_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_object_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wo_options: Data: 46.15MB + Index: 3.68MB + Engine MyISAM
    wo_postmeta: Data: 88.86MB + Index: 1.94MB + Engine MyISAM
    wo_posts: Data: 25.14MB + Index: 0.48MB + Engine MyISAM
    wo_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wo_sbi_feed_caches: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wo_sbi_instagram_feeds_posts: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wo_sbi_instagram_feed_locator: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_sbi_instagram_posts: Data: 0.40MB + Index: 0.00MB + Engine MyISAM
    wo_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wo_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wo_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_terms: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
    wo_term_relationships: Data: 0.02MB + Index: 0.05MB + Engine MyISAM
    wo_term_taxonomy: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wo_tm_taskmeta: Data: 0.07MB + Index: 0.01MB + Engine MyISAM
    wo_tm_tasks: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wo_uap_cpm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_uap_dashboard_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_usermeta: Data: 0.13MB + Index: 0.03MB + Engine MyISAM
    wo_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_uspswebservice_shipments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_uspswebservice_tracking: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wo_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wo_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wc_customer_lookup: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
    wo_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wc_order_bundle_lookup: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wo_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_wc_order_product_lookup: Data: 0.25MB + Index: 0.24MB + Engine MyISAM
    wo_wc_order_stats: Data: 0.04MB + Index: 0.03MB + Engine MyISAM
    wo_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wo_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wo_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wo_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wfblockediplog: Data: 0.08MB + Index: 0.07MB + Engine MyISAM
    wo_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wfconfig: Data: 5.83MB + Index: 0.02MB + Engine MyISAM
    wo_wfcrawlers: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wo_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wffilemods: Data: 35.12MB + Index: 4.06MB + Engine MyISAM
    wo_wfhits: Data: 1.19MB + Index: 0.16MB + Engine MyISAM
    wo_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wfissues: Data: 0.36MB + Index: 0.04MB + Engine MyISAM
    wo_wfknownfilelist: Data: 25.58MB + Index: 1.26MB + Engine MyISAM
    wo_wflivetraffichuman: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wo_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wflogins: Data: 0.37MB + Index: 0.08MB + Engine MyISAM
    wo_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wo_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_wfnotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wo_wfpendingissues: Data: 0.30MB + Index: 0.04MB + Engine MyISAM
    wo_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wfstatus: Data: 1.09MB + Index: 0.42MB + Engine MyISAM
    wo_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wonderplugin_popup: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wo_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wo_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wo_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_wpgdprc_access_requests: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wpgdprc_consents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wpgdprc_delete_requests: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wpgdprc_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_WP_SEO_404_links: Data: 0.19MB + Index: 0.16MB + Engine MyISAM
    wo_WP_SEO_Cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_WP_SEO_Redirection: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_WP_SEO_Redirection_LOG: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wo_wt_iew_action_history: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wo_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wo_yoast_indexable: Data: 0.53MB + Index: 0.22MB + Engine MyISAM
    wo_yoast_indexable_hierarchy: Data: 0.03MB + Index: 0.07MB + Engine MyISAM
    wo_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wo_yoast_primary_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wo_yoast_seo_links: Data: 0.17MB + Index: 0.05MB + Engine MyISAM
    wo_yoast_seo_meta: Data: 0.06MB + Index: 0.07MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    acf-field: 45
    acf-field-group: 4
    attachment: 400
    cartflows_flow: 1
    cartflows_step: 2
    custom_css: 3
    customize_changeset: 54
    elementor_library: 10
    es_template: 2
    jetpack_migration: 2
    jp_img_sitemap: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    kpp_pinterest: 1
    mc4wp-form: 1
    nav_menu_item: 38
    nf_sub: 90
    oembed_cache: 20
    page: 24
    popup_theme: 6
    post: 38
    postman_sent_mail: 6
    product: 10
    product_variation: 9
    revision: 2799
    shop_coupon: 369
    shop_order: 390
    shop_order_refund: 74
    wcb: 346
    woolentor-template: 1
    wp_global_styles: 1
    wpforms: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (43) ###
    
    PI Button: by AccessPress Themes – 3.3.5
    Age Gate: by Phil Baker – 2.21.2
    Antispam Bee: by pluginkollektiv – 2.11.1
    Buy Now Button for WooCommerce: by Ido Navarro – 1.0.1
    CartFlows: by CartFlows Inc – 1.11.2
    Duplicate Page: by mndpsingh287 – 4.4.9
    GTM4WP: by Thomas Geiger – 1.16.1
    PayPal Express Checkout Payment Gateway for WooCommerce: by WebToffee – 1.3.9
    Elementor: by Elementor.com – 3.7.8
    DHL Express Live Rates: by Octolize – 2.1.3
    UPS Live Rates and Access Points: by Octolize – 1.20.0
    Smash Balloon Instagram Feed: by Smash Balloon – 6.0.8
    Jetpack: by Automattic – 11.4
    Kirki Customizer Framework: by David Vongries – 4.0.24
    Mailchimp for WooCommerce: by Mailchimp – 2.7.5
    MC4WP: Mailchimp for WordPress: by ibericode – 4.8.10
    Make Column Clickable Elementor: by Fernando Acosta – 1.4.0
    Microsoft Clarity: by Microsoft – 0.7.5
    Order Export & Order Import for WooCommerce: by WebToffee – 2.2.7
    Post Types Order: by Nsp Code – 1.9.9.1
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
    Royal Elementor Addons: by WP Royal – 1.3.50
    Ultimate Social Media PLUS: by social share pro – 3.5.5
    Import Export WordPress Users and WooCommerce Customers: by WebToffee – 2.3.4
    White Label CMS: by www.videousermanuals.com – 2.3
    CartBounty Pro - Save and recover abandoned carts for WooCommerce: by Streamline.lv – 7.1
    Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.11
    WooCommerce PayPal Pro (Classic and PayFlow Editions) Gateway: by WooCommerce – 4.5.1
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.15
    PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.2.1
    WooCommerce Product Bundles: by WooCommerce – 6.17.2
    WooCommerce Shipping & Tax: by WooCommerce – 1.26.3
    WooCommerce US Postal Service Webservice Method: by Jamez Picard – 1.4.12
    WooCommerce: by Automattic – 7.0.0
    WooLentor - WooCommerce Elementor Addons + Builder: by HasThemes – 2.4.6
    Wordfence Security: by Wordfence – 7.7.1
    Yoast SEO: by Team Yoast – 19.8
    WP Fastest Cache: by Emre Vona – 1.0.6
    WP Mail SMTP: by WPForms – 3.6.1
    WP Migrate: by Delicious Brains – 2.4.1
    WPForms Lite: by WPForms – 1.7.7.2
    WPS Hide Login: by WPServeur
    NicolasKulka
    wpformation – 1.9.6
    
    Sequential Order Numbers for WooCommerce: by WebToffee – 1.4.8
    
    ### Inactive Plugins (3) ###
    
    Essential Addons for Elementor: by WPDeveloper – 5.3.2
    Site Kit by Google: by Google – 1.85.0
    WordPress Importer: by wordpressdotorg – 0.8
    
    ### Must Use Plugins (4) ###
    
    Elementor Safe Mode: by Elementor.com – 1.0.0
    p3-profiler.php: by  –
    WordPress automation by Installatron: by  –
    WP Migrate Compatibility: by Delicious Brains – 1.3
    
    ### Settings ###
    
    API Enabled: ?
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    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: ?
    Enforce Approved Product Download Directories: –
    
    ### WC Pages ###
    
    Shop base: #328 - /shop/
    Cart: #329 - /cart/
    Checkout: #330 - /checkout/
    My account: #331 - /my-account/
    Terms and conditions: #448 - /terms-conditions/
    
    ### Theme ###
    
    Name: Airi Child
    Version: 1.0
    Author URL: https://athemes.com
    Child Theme: ?
    Parent Theme Name: Airi
    Parent Theme Version: 1.0.16
    Parent Theme Author URL: https://athemes.com
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: /home/erosscia/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/cart/cart.php
    /home/erosscia/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/cart/mini-cart.php
    airi/woocommerce/loop/add-to-cart.php
    /home/erosscia/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/error.php
    /home/erosscia/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/notice.php
    /home/erosscia/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/success.php
    
    ### Product Bundles ###
    
    Database Version: 6.17.2
    Loopback Test: ?
    Template Overrides: –
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2022-10-26 01:59:42 -07:00
    Options: ?
    Notes: 27
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Canceled: 9
    Oldest: 2022-10-05 03:45:14 -0700
    Newest: 2022-10-05 04:08:45 -0700
    
    Complete: 13,580
    Oldest: 2022-10-07 07:13:35 -0700
    Newest: 2022-10-25 01:38:51 -0700
    
    Failed: 276
    Oldest: –
    Newest: –
    
    Pending: 11
    Oldest: 2022-10-25 02:38:51 -0700
    Newest: 2022-10-31 15:11:40 -0700
    
    ### Status report information ###
    
    Generated at: 2022-10-25 02:24:06 -07:00
    

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter stefangociu

    (@stefangociu)

    Update: I have made an export of all orders and I have noticed that there are 24 “line_items” columns that containt the duplicated products 5 or 6 times. The question is: how were these extra columns added and where do they come from?

    The “coupon_items” columns also has duplicates. Some of them appear 5 or 6 times. What can cause this behaviour?

    Example: code:7y0q4u|amount:20.00;code:7y0q4u|amount:20.00

    Hi @stefangociu

    Thanks for reaching out!

    I understand that different products are added to each order even the completed ones. Furthermore, the coupon appears twice on the order page.

    This is quite a strange behavior. Could you please provide the fatal error logs (if any) under WooCommerce > Status > Logs.

    You also mentioned that the issue happened on your staging site. Can you please confirm if the staging site has a fresh install of WooCommerce and used the default Storefront theme only?

    Let us know how it goes!

    Thread Starter stefangociu

    (@stefangociu)

    Hello @xue28, thank you for getting back to me. So, after a day of going through the tables and trying to debug this, I can give you a more detailed view of the problem.

    Before every push to production, I export the orders from the live site and import them into staging, so I won’t lose the new orders in production. I do this using the “Order Export & Order Import for WooCommerce” from WebToffee and everything worked great until yesterday.

    Before I am doing the import, I delete the old orders so I will have an empty orders database in WooCommerce. The problem is this: after the import it seems that some fields still remain somewhere in the database, because the “line_item” fields get duplicated (which gives me duplicate products in all orders), the “shipping_method” column has the same item 5 or 6 times (instead of “Shipping” it is “Shipping, Shipping, Shipping, Shipping, Shipping, Shipping”) so the shipping appears 6 times in my Woocommerce orders. The “shipping_items” column also has duplicate items and the “coupon_items” column is the same.

    I have disabled the import export plugin and tried to do an import export with the legacy wordpress from Tools, but with the same result. I even rolleback WooCommerce to 6.9.0. as I wanted to see if 7.0.0. poses some incompatibility issues, but nothing changed. I will mention that no WP/WooCommerce/plugin updates were made in the meantime, this popped out of nowhere. Also I haven’t found any fatal errors or errors in the logs, everything works fine excepting the duplicate fields.

    I have uploaded a screenshot at the link below to get a better image of what is happening.

    https://paste.pics/25d7d2858faac64cfa26271874cb7b28

    Any guidance would be appreciated as I am super frustrated on this and I can’t figure out what is causing it.

    Thank you for your help,
    Stefan.

    Saif

    (@babylon1999)

    Hello @stefangociu,

    My assumption is something went wrong with the plugin you used for importing. I understand how frustrating this can be, it’s not an easy thing to debug but since you’ve mentioned having a staging environment you can try the following:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Re-try importing some demo products

    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 of how to do a conflict test here.

    Let us know your findings!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Woocommerce populates every order with more products’ is closed to new replies.