Support » Plugin: WooCommerce » Orders are showing attributes which shouldn’t be there

  • Resolved liamf91

    (@liamf91)


    When customers are ordering products and selecting their attributes they require. Once the order goes through, looking at the order in wp-admin shows extra attributes which should not be showing as these are not available to select when purchasing.

    Looking in the wp_woocommerce_attribute_taxonomies table in the database, this shows the 4 attributes which we have available on the website.

    It seems something is pushing specific data through to the order page. These also show when running “print invoice”, so these are visible to the customers.

    See the following link as an example of an order – https://ibb.co/Xz70NXP

    • This topic was modified 1 month, 3 weeks ago by liamf91.
Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Support Igor H woo-hc

    (@ihereira)

    Hi there,

    I understand that the attributes displayed in the order were not selected by the customer when making the purchase.

    I’d like to take a closer look, 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 have it, let us know.

    Thread Starter liamf91

    (@liamf91)

    Good day here is the report.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.zoealexanderuk.com
    Site address (URL): https://www.zoealexanderuk.com
    WC Version: 6.4.1
    REST API Version: ✔ 6.4.1
    WC Blocks Version: ✔ 7.2.2
    Action Scheduler Version: ✔ 3.4.0
    WC Admin Version: ✔ 3.3.2
    Log Directory Writable: ✔
    WP Version: 5.9.3
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: ✔
    WP Cron: ✔
    Language: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.28
    PHP Post Max Size: 80 MB
    PHP Time Limit: 60
    PHP Max Input Vars: 5000
    cURL Version: 7.64.0
    OpenSSL/1.1.1n
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.34-MariaDB
    Max Upload Size: 80 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.4.1
    WC Database Prefix: wp_
    Total Database Size: 117.22MB
    Database Data Size: 76.86MB
    Database Index Size: 40.36MB
    wp_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + 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: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.41MB + Index: 0.45MB + 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: 2.52MB + Index: 1.72MB + 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.52MB + Index: 1.84MB + Engine InnoDB
    wp_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 4.03MB + Index: 2.30MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 6.02MB + Index: 1.27MB + Engine InnoDB
    wp_postmeta: Data: 32.06MB + Index: 19.06MB + Engine InnoDB
    wp_posts: Data: 10.03MB + Index: 2.42MB + Engine InnoDB
    wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
    wp_terms: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
    wp_term_relationships: Data: 1.02MB + Index: 0.25MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
    wp_usermeta: Data: 2.50MB + Index: 2.55MB + Engine InnoDB
    wp_users: Data: 0.11MB + Index: 0.08MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.05MB + 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.20MB + Index: 0.16MB + 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: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.33MB + Index: 0.30MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.45MB + Index: 1.14MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.17MB + Index: 0.23MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + 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_wml_entries: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcwl: Data: 0.11MB + Index: 0.05MB + Engine InnoDB
    wp_yith_wcwl_lists: Data: 0.11MB + Index: 0.11MB + Engine InnoDB
    wp_yoast_indexable: Data: 8.45MB + Index: 4.36MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.20MB + Index: 0.38MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 1.47MB + Index: 0.55MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 1.45MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 7333
    custom_css: 1
    customize_changeset: 21
    nav_menu_item: 34
    oembed_cache: 6
    page: 116
    post: 36
    product: 343
    product_variation: 642
    revision: 280
    shop_coupon: 21
    shop_order: 2420
    shop_order_refund: 8
    wp_global_styles: 2
    wpcf7_contact_form: 6
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (28) ###
    
    Add From Server: by Dion Hulse – 3.4.5
    Akismet Anti-Spam: by Automattic – 4.2.3
    Contact Form 7: by Takayuki Miyoshi – 5.5.6
    Custom Order Numbers for WooCommerce: by Tyche Softwares – 1.3.4
    Customizer Export/Import: by The Beaver Builder Team – 0.9.4
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.5.2
    Import and export users and customers: by codection – 1.19.2.6
    Insert Headers and Footers: by WPBeginner – 1.6.2
    Nextend Social Login: by Nextendweb – 3.1.4
    Product Video Gallery for Woocommerce: by NikHiL Gadhiya – 1.3.3
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
    WooCommerce Weight Based Shipping: by weightbasedshipping.com – 5.3.21
    Advanced Order Export For WooCommerce: by AlgolPlus – 3.2.2
    Woocommerce CSV Import: by Allaerd Mensonides – 3.3.6
    Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.5
    WooCommerce Stripe Gateway: by WooCommerce – 6.3.0
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.9
    WooCommerce PayPal Payments: by WooCommerce – 1.8.0
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.27
    WooCommerce: by Automattic – 6.4.1
    WooSidebars: by WooCommerce – 1.4.6
    WordPress Importer: by wordpressdotorg – 0.7
    Yoast SEO: by Team Yoast – 18.8
    WP Mail Log: by WPVibes – 0.3
    WP Mail SMTP: by WPForms – 3.4.0
    WP Super Cache: by Automattic – 1.7.7
    WPForms Lite: by WPForms – 1.7.4.1
    YITH WooCommerce Wishlist: by YITH – 3.8.0
    
    ### Inactive Plugins (8) ###
    
    All-in-One WP Migration: by ServMask – 7.59
    Jetpack: by Automattic – 10.9
    Kraken Image Optimizer: by Karim Salman – 2.6.5
    Nextend Google Connect: by Roland Soos
    Jamie Bainbridge – 1.6.1
    
    Smush: by WPMU DEV – 3.9.9
    WooCommerce Helper: by WooCommerce – 1.7.2 – Network enabled
    WooCommerce Realex Gateway: by SkyVerge – 1.10.1
    WP All Export: by Soflyy – 1.3.4
    
    ### 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)
    
    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: #21146 - /shop/
    Basket: #63 - /cart/
    Checkout: #6 - /checkout/
    My account: #7 - /my-account/
    Terms and conditions: #570 - /terms-and-conditions/
    
    ### Theme ###
    
    Name: Flatsome Child
    Version: 3.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.15.4
    Parent Theme Author URL: http://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-cat.php
    flatsome/woocommerce/content-product.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
    flatsome/woocommerce/content-product_cat.php
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ✔
    Shop country code: GB
    WooCommerce currency supported: ✔
    PayPal card processing available in country: ✔
    Pay Later messaging available in country: ✔
    Webhook status: ✔
    Vault enabled: ✔
    Logging enabled: ✔
    Reference Transactions: –
    Used PayPal Checkout plugin: ✔
    
    ### Action Scheduler ###
    
    Complete: 6,273
    Oldest: 2022-04-12 09:36:23 +0100
    Newest: 2022-05-12 14:29:46 +0100
    
    Pending: 5
    Oldest: 2022-05-13 14:08:16 +0100
    Newest: 2022-05-19 11:59:22 +0100
    
    ### Status report information ###
    
    Generated at: 2022-05-12 14:48:15 +01:00
    
    Plugin Support Mashi (woo-hc)

    (@shaonback2)

    Hello @liamf91!

    Can you please share your WooCommerce error logs(if any)?

    Error Log can be found under WooCommerce > System Status > Logs (if available).

    Thread Starter liamf91

    (@liamf91)

    The only error logs recently are paypal payment logs. I would rather not share these due to the personal data within the logs.

    Regards
    Liam Fermoyle.

    Plugin Support Margaret S. woo-hc

    (@margaretwporg)

    Hi @liamf91

    The only error logs recently are paypal payment logs

    Thanks for the update.

    Once the order goes through, looking at the order in wp-admin shows extra attributes which should not be showing as these are not available to select when purchasing.

    These also show when running “print invoice”, so these are visible to the customers.

    Can you please try disabling the following plugins (one by one) and let us know if that made a difference?

    WP Super Cache: by Automattic – 1.7.7
    Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.5

    We’ll look forward to your response.

    Thread Starter liamf91

    (@liamf91)

    I have done that and checked the existing orders – these have not changed at all.

    Plugin Support Berg (woo-hc)

    (@hegenberg)

    Hi @liamf91

    Thanks for the update.

    The extra-attributes are possibly being set via custom code using the Insert Headers and Footers plugin, so I’d try disabling it, clearing any active caches, and making a new purchase for testing.

    If that doesn’t help, I’d suggest you install a string locator plugin to try to track down the piece of code that is generating these specific attributes:
    https://wordpress.org/plugins/string-locator/
    You can search for the extra attributes names as keywords.

    Regards

    Thread Starter liamf91

    (@liamf91)

    I’m afraid disabling the plugins have not helped.

    I have made a new purchase with a product which was purchase yet – this is still showing the error.

    I had installed the string locator before the purchase, and searched for the extra attribute names. This only shows a user-export.csv which we used to import users onto the site from our old site. not all of the extra attributes show in this .csv file so I don’t believe this is cause.

    Is there any other suggestions?

    Regards
    Liam Fermoyle.

    Plugin Support MayKato woo-hc

    (@maykato)

    Hi @liamf91

    At this point, I’d recommend creating a staging site and running a full conflict test to rule out any plugin/theme conflicts. You can (1) create a staging site, (2) deactivate all plugins except WooCommerce, (3) switch theme to Storefront, and then (4) place a test order to see if you can replicate the issue in the staging environment.

    Your hosting company may offer staging functionality. If they don’t, you can create a staging site using a plugin called WP Staging: https://wordpress.org/plugins/wp-staging/

    You can find a more detailed explanation on how to do a conflict test here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    Plugin Support Margaret S. woo-hc

    (@margaretwporg)

    We haven’t heard back from you in a while, so I’m marking this thread closed for now – we’ll be here if and/or when you are ready to continue.

    Thread Starter liamf91

    (@liamf91)

    Thank you. Being able to staging site is currently difficult due to our server restraints – we host the websites ourselves.

    If possible, could you please assist me by telling me the .php files which would be used to show the order details in admin. I would like to try and trace the find the function which is searching for attributes on an order.

    Regards
    Liam Fermoyle.

    Plugin Support Mirko P. woo-hc

    (@rainfallnixfig)

    Hi Liam,

    You can display your current template files in a WP admin tool bar using a plugin like Show Current Template. However, the order file you’re looking to override with hooks should be included in the directory includes > admin > meta-boxes.

    I hope this helps.

Viewing 12 replies - 1 through 12 (of 12 total)
  • You must be logged in to reply to this topic.