Order Details Number of Product and Price Doesn’t Match
-
Hi everyone, we are recently facing a problem in the order details in woocommerce.
Let’s say my product A costs 4€ and the customer orders 1 quantity.
Viewing some order details, we are facing a problem in the report.
https://ibb.co/wBFNhgC (price as set in wcommerce)
Instead of 4,00€ x 1, in the order details we see 2,00€ x 2.
https://ibb.co/djf8Ntq (error in Order detail)
When there’s this error, the total price is always right, but the quantity and the price unit is wrong.
We also checked by phone with the customers and the right quantity was 1.On the final report, we finally see the right quantity.
https://ibb.co/pW20FRGWhat could cause this problem?
we haven’t installed anything on the site and everything was update a month before we faced the problem.Any helps, thanks
-
Hi @marco1995 ,
I understand that you are experiencing issues with the item pricing not displaying correctly on the order details page, where the total price is always correct, however, the quantity is incorrect.
You mentioned everything updating on your site a month prior to experiencing this issue, however, do you recall any changes being made to the site, such as theme or template changes/customizations or custom code being added to the site?
Also, please clarify the following:
- Does this happen with all products or only specific products?
- If the latter, are there any similarities with the orders that experience this issue?
- Does this happen when all payment methods/gateways are used or only specific payment methods/gateways?
Additionally, please can you share a copy of your sites System Status Report so that we can have a better understanding of your sites current environment.
You can find this via WooCommerce?→?Status. Select?
Get system report
?and then?Copy for support
.Once you have this, please share the results here.
Cheers!
Hy Roxy and thanks for your answer.
About this “theme or template changes/customizations or custom code being added to the site?”, we didn‘t made any change on theme, template or code.- Does this happen with all products or only specific products?
No, it happens only on some products - If the latter, are there any similarities with the orders that experience this issue?
No, it seems to appear in several orders without a pattern - Does this happen when all payment methods/gateways are used or only specific payment methods/gateways?
We have only one possible Payment Method, with Card.
Something strange i noticed is that on the products report appears some details unrelated to the order in question as:
https://ibb.co/6D6Zr55———–
### WordPress Environment ### WordPress address (URL): https://www.sushienoodles.it Site address (URL): https://www.sushienoodles.it WC Version: 7.7.0 REST API Version: ? 7.7.0 WC Blocks Version: ? 10.0.4 Action Scheduler Version: ? 3.5.4 Log Directory Writable: ? WP Version: 6.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: it_IT External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.33 PHP Post Max Size: 8 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.29.0 NSS/3.53.1 SUHOSIN Installed: – MySQL Version: 5.5.5-10.2.44-MariaDB Max Upload Size: 2 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 7.7.0 WC Database Prefix: sen_ Dimensione totale database: 691.45MB Dimensione dati database: 407.01MB Dimensione indice database: 284.44MB sen_woocommerce_sessions: Dati: 22.05MB + indice: 0.39MB + motore InnoDB sen_woocommerce_api_keys: Dati: 0.00MB + indice: 0.00MB + motore MyISAM sen_woocommerce_attribute_taxonomies: Dati: 0.00MB + indice: 0.00MB + motore MyISAM sen_woocommerce_downloadable_product_permissions: Dati: 0.00MB + indice: 0.00MB + motore MyISAM sen_woocommerce_order_items: Dati: 0.48MB + indice: 0.17MB + motore InnoDB sen_woocommerce_order_itemmeta: Dati: 166.87MB + indice: 63.79MB + motore MyISAM sen_woocommerce_tax_rates: Dati: 0.02MB + indice: 0.06MB + motore InnoDB sen_woocommerce_tax_rate_locations: Dati: 0.02MB + indice: 0.03MB + motore InnoDB sen_woocommerce_shipping_zones: Dati: 0.02MB + indice: 0.00MB + motore InnoDB sen_woocommerce_shipping_zone_locations: Dati: 0.02MB + indice: 0.03MB + motore InnoDB sen_woocommerce_shipping_zone_methods: Dati: 0.02MB + indice: 0.00MB + motore InnoDB sen_woocommerce_payment_tokens: Dati: 0.05MB + indice: 0.02MB + motore InnoDB sen_woocommerce_payment_tokenmeta: Dati: 0.09MB + indice: 0.11MB + motore InnoDB sen_woocommerce_log: Dati: 0.00MB + indice: 0.00MB + motore MyISAM sen_actionscheduler_actions: Dati: 0.06MB + indice: 0.13MB + motore InnoDB sen_actionscheduler_claims: Dati: 0.02MB + indice: 0.02MB + motore InnoDB sen_actionscheduler_groups: Dati: 0.02MB + indice: 0.02MB + motore InnoDB sen_actionscheduler_logs: Dati: 0.45MB + indice: 0.34MB + motore InnoDB sen_commentmeta: Dati: 0.03MB + indice: 0.03MB + motore InnoDB sen_comments: Dati: 17.52MB + indice: 19.08MB + motore InnoDB sen_links: Dati: 0.02MB + indice: 0.02MB + motore InnoDB sen_mailchimp_carts: Dati: 0.02MB + indice: 0.00MB + motore InnoDB sen_mailchimp_jobs: Dati: 0.02MB + indice: 0.00MB + motore InnoDB sen_options: Dati: 2.17MB + indice: 0.09MB + motore InnoDB sen_postmeta: Dati: 137.38MB + indice: 144.48MB + motore InnoDB sen_posts: Dati: 13.44MB + indice: 9.67MB + motore InnoDB sen_termmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB sen_terms: Dati: 0.02MB + indice: 0.03MB + motore InnoDB sen_term_relationships: Dati: 0.09MB + indice: 0.05MB + motore InnoDB sen_term_taxonomy: Dati: 0.02MB + indice: 0.03MB + motore InnoDB sen_usermeta: Dati: 14.50MB + indice: 13.02MB + motore InnoDB sen_users: Dati: 0.52MB + indice: 0.45MB + motore InnoDB sen_wc_admin_notes: Dati: 0.08MB + indice: 0.00MB + motore InnoDB sen_wc_admin_note_actions: Dati: 0.06MB + indice: 0.02MB + motore InnoDB sen_wc_category_lookup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB sen_wc_customer_lookup: Dati: 1.52MB + indice: 0.78MB + motore InnoDB sen_wc_download_log: Dati: 0.02MB + indice: 0.03MB + motore InnoDB sen_wc_order_coupon_lookup: Dati: 0.22MB + indice: 0.28MB + motore InnoDB sen_wc_order_product_lookup: Dati: 23.56MB + indice: 26.06MB + motore InnoDB sen_wc_order_stats: Dati: 4.52MB + indice: 4.55MB + motore InnoDB sen_wc_order_tax_lookup: Dati: 0.02MB + indice: 0.03MB + motore InnoDB sen_wc_product_attributes_lookup: Dati: 0.05MB + indice: 0.03MB + motore InnoDB sen_wc_product_download_directories: Dati: 0.02MB + indice: 0.02MB + motore InnoDB sen_wc_product_meta_lookup: Dati: 0.06MB + indice: 0.09MB + motore InnoDB sen_wc_rate_limits: Dati: 0.02MB + indice: 0.02MB + motore InnoDB sen_wc_reserved_stock: Dati: 0.02MB + indice: 0.00MB + motore InnoDB sen_wc_tax_rate_classes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB sen_wc_webhooks: Dati: 0.02MB + indice: 0.02MB + motore InnoDB sen_wdr_order_discounts: Dati: 0.09MB + indice: 0.00MB + motore InnoDB sen_wdr_order_item_discounts: Dati: 0.14MB + indice: 0.11MB + motore InnoDB sen_wdr_rules: Dati: 0.02MB + indice: 0.00MB + motore InnoDB sen_woocommerce_order_alert: Dati: 0.11MB + indice: 0.00MB + motore InnoDB sen_yoast_indexable: Dati: 0.31MB + indice: 0.16MB + motore InnoDB sen_yoast_indexable_hierarchy: Dati: 0.05MB + indice: 0.05MB + motore InnoDB sen_yoast_migrations: Dati: 0.02MB + indice: 0.02MB + motore InnoDB sen_yoast_primary_term: Dati: 0.06MB + indice: 0.03MB + motore InnoDB sen_yoast_seo_links: Dati: 0.02MB + indice: 0.03MB + motore InnoDB ### Post Type Counts ### acf-field: 128 acf-field-group: 15 attachment: 636 nav_menu_item: 22 oembed_cache: 1 page: 31 post: 44 product: 394 product_variation: 24 responsive_accordion: 2 revision: 19 sede: 3 shop_coupon: 62 shop_order: 22429 shop_order_refund: 2 wpcf7_contact_form: 2 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (14) ### Advanced Custom Fields PRO: by WP Engine – 6.1.6 Bulk Delete: by Sudar – 6.0.2 Classic Editor: by Contributori WordPress – 1.6.3 Contact Form 7: by Takayuki Miyoshi – 5.7.6 GTM4WP: by Thomas Geiger – 1.16.2 New Order Notification for Woocommerce: by Mr.Ebabi – 2.0.2 Woo Discount Rules PRO 2.0: by Flycart – 2.6.0 Woo Discount Rules: by Flycart – 2.6.0 Advanced Order Export For WooCommerce: by AlgolPlus – 3.4.0 WooCommerce Extended Coupon Features PRO: by Soft79 – 3.2.7 WooCommerce Composite Products: by SomewhereWarm – 5.0.2 WooCommerce Stripe Gateway: by WooCommerce – 7.4.0 WooCommerce: by Automattic – 7.7.0 Yoast SEO: by Team Yoast – 20.7 ### Inactive Plugins (1) ### WooCommerce Extended Coupon Features FREE: by Soft79 – 3.3.3 ### Dropin Plugins (2) ### advanced-cache.php: advanced-cache.php maintenance.php: maintenance.php ### Settings ### API Enabled: ? Force SSL: – Currency: EUR (€) Currency Position: right Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: composite (composite) 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: – HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – ### WC Pages ### Shop base: #611 - /menu/ Carrello: #477 - /cart/ Cassa: #478 - /checkout/ Il mio account: #479 - /my-account/ Termini e condizioni: #414 - /privacy/ ### Theme ### Name: sushi Version: 1.0 Author URL: Child Theme: ? – Se stai modificando WooCommerce o un tema genitore che non hai costruito personalmente ti consigliamo di utilizzare un tema child. Vedi: Come creare un tema child WooCommerce Support: ? ### Templates ### Overrides: sushi/woocommerce/archive-product.php sushi/woocommerce/cart/cart-item-data.php sushi/woocommerce/cart/cart-totals.php sushi/woocommerce/cart/cart.php versione 3.5.0 è obsoleta. La versione attuale è 7.4.0 sushi/woocommerce/cart/mini-cart.php versione 3.5.0 è obsoleta. La versione attuale è 5.2.0 sushi/woocommerce/checkout/form-billing.php sushi/woocommerce/checkout/form-checkout.php sushi/woocommerce/checkout/form-coupon.php versione 3.4.4 è obsoleta. La versione attuale è 7.0.1 sushi/woocommerce/checkout/review-order.php versione 3.3.0 è obsoleta. La versione attuale è 5.2.0 sushi/woocommerce/content-single-product.php sushi/woocommerce/loop/add-to-cart.php sushi/woocommerce/myaccount/dashboard.php versione 2.6.0 è obsoleta. La versione attuale è 4.4.0 sushi/woocommerce/myaccount/form-login.php versione 3.6.0 è obsoleta. La versione attuale è 7.0.1 sushi/woocommerce/myaccount/my-orders.php sushi/woocommerce/myaccount/orders.php versione 3.2.0 è obsoleta. La versione attuale è 7.0.1 sushi/woocommerce/order/order-details-item.php versione 3.0.0 è obsoleta. La versione attuale è 5.2.0 sushi/woocommerce/order/order-details.php versione 3.5.2 è obsoleta. La versione attuale è 7.7.0 sushi/woocommerce/single-product/add-to-cart/simple.php versione 3.4.0 è obsoleta. La versione attuale è 7.0.1 sushi/woocommerce/single-product/add-to-cart/variable.php versione 3.5.5 è obsoleta. La versione attuale è 6.1.0 sushi/woocommerce/single-product.php Outdated Templates: ? Scopri come aggiornare ### Composite Products ### Database Version: 5.0.2 Template Overrides: sushi/woocommerce/composited-product/js/selection.php sushi/woocommerce/single-product/component-options-title.php sushi/woocommerce/single-product/component-single-page-progressive.php sushi/woocommerce/single-product/composite-summary-content.php sushi/woocommerce/single-product/composite-summary.php ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen 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: product-block-editor minified-js new-product-management-experience product-variation-management settings Daily Cron: ? Next scheduled: 2023-05-16 14:22:22 +02:00 Options: ? Notes: 147 Onboarding: completed ### Action Scheduler ### Completato: 50 Oldest: 2023-04-15 18:51:33 +0200 Newest: 2023-05-16 09:25:26 +0200 Operazione non riuscita: 1 Oldest: 2023-05-15 09:24:43 +0200 Newest: 2023-05-15 09:24:43 +0200 In attesa: 6 Oldest: 2023-05-17 09:25:26 +0200 Newest: 2023-05-19 14:26:33 +0200 ### Status report information ### Generated at: 2023-05-16 11:28:51 +02:00
Hi @marco1995 ,
Thanks for clarifying!
Can you try temporarily enabling Cash on Delivery (COD) as a payment method and then place a test order for a product that is exhibiting this behavior, selecting COD as the payment method, and then see if the results are the same?
If so, I’d suggest performing a full conflict test to rule out any theme/plugin conflicts that may be causing the issue.
To test, you’ll first want to change the theme on your site to Storefront, then check to see if the issue is still present. If that resolves the issue, you’ll want to get in touch with your theme’s developer and see if they have an update or fix for you.
If changing the theme doesn’t help, you’ll want to deactivate all plugins except for WooCommerce and take a look. If that fixes the problem, re-enable the other plugins one by one (gradually), checking after each, to see where the issue is coming from.
If you don’t want to test on your live site, then create a staging site using a plugin called WP Staging.
Let us know how this goes!
Hi there, with COD orders we tried yet, but this error appear randomly and not in all orders.. so we cannot be shure about the payment method connected to this error.
We yet tried every suggestion, from plugin deactivation to theme change, but nothing seems work.
You don’t have any suggestion from the system report? any way to solve this error or possible cause?
Hi @marco1995
As mentioned by @beautyofcode above and for us to investigate this further, please try to switch to the default Storefront theme and only WooCommerce plugin is enabled. Then, try to replicate the issue by creating a test order purchasing the products on your sample screenshots above using Cash on Delivery (COD) and see if the issue has been resolved.
If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.
If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.
If this did not resolve the issue, please provide the fatal error logs (if any) under
WooCommerce > Status > Logs
.You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.
Let us know how it goes!
Hi @marco1995 ,
We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.
Cheers!
- The topic ‘Order Details Number of Product and Price Doesn’t Match’ is closed to new replies.