Cost of Goods reverting to 0.00 on Legacy System #61292
Description
Prerequisites
- I have carried out troubleshooting steps and I believe I have found a bug.
- I have searched for similar bugs in both open and closed issues and cannot find a duplicate.
Describe the bug
When using the legacy system when updating the order, the final cost remains as 0.00. Using the HPOS the system will save and keep the final cost as it should be.
I have gone through the WordPress support page and have test/confirmed with others and was instructed to post a bug report on github.
Expected behavior
When saving/completing an order, the final cost on the order should equal to the cost listed for the products.
Actual behavior
The product will reset to 0.00.
Steps to reproduce
Set your systems database order to the legacy system
Add items with Cost of Goods
Completed/Save the order and see the final cost of goods on the order reverts to $0.00 vs what it should be.
WordPress Environment
System Status Report
### WordPress Environment ###
WordPress address (URL): [Redacted]
Site address (URL): [Redacted]
WC Version: 10.2.2
Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
Action Scheduler Version: ✔ 3.9.3
Log Directory Writable: ✔
WP Version: 6.8.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: ✔
### Server Environment ###
Server Info: Apache/2.4.62 (Ubuntu)
Server Architecture: Linux 6.11.0-29-generic x86_64
PHP Version: 8.3.11
PHP Post Max Size: 8 MB
PHP Time Limit: 180
PHP Max Input Vars: 5000
cURL Version: 8.9.1
OpenSSL/3.3.1
SUHOSIN Installed: –
MySQL Version: 8.0.43-0ubuntu0.24.04.2
Max Upload Size: 2 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔
### Database ###
[REDACTED]
### Post Type Counts ###
attachment: 149
elementor_library: 1
flamingo_contact: 133
flamingo_inbound: 95
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
jp_vid_sitemap: 1
mailpoet_page: 1
nav_menu_item: 23
page: 28
pi_dpmw_rules: 3
post: 14
product: 43
product_variation: 2432
revision: 215
rm_content_editor: 1
shop_coupon: 2
shop_order: 223
template: 3
user_registration: 2
wc_conditional_fee: 3
wpforms: 5
wp_global_styles: 2
wp_navigation: 1
### Security ###
Secure connection (HTTPS): ✔
Hide errors from visitors: ✔
### Active Plugins (36) ###
Admin Menu Editor: by Janis Elsts – 1.14.1
Admin and Site Enhancements (ASE): by wpase.com – 8.0.1
The SEO Framework: by The SEO Framework Team – 5.1.2
BeCustom: by Muffin Group – 1.2.3
Code Snippets: by Code Snippets Pro – 3.7.0
Colorlib Login Customizer: by Colorlib – 1.3.4
Creative Mail by Newfold Digital: by Newfold Digital – 1.6.9
Disable payment method / Partial payment for WooCommerce: by PI Websolution – 1.1.9.29
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5
FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.2.92
Widgets for Reviews & Recommendations: by Trustindex.io – 13.2
Google for WooCommerce: by WooCommerce – 3.4.3
Site Kit by Google: by Google – 1.163.0
Loginizer: by Softaculous – 2.0.3
Manage Notification E-mails: by Virgial Berveling – 1.8.6
Members: by MemberPress – 3.2.18
Slider Revolution: by ThemePunch – 6.7.37
Simple CAPTCHA Alternative with Cloudflare Turnstile: by Elliot Sowersby
RelyWP – 1.33.1
SQLite Object Cache: by Oliver Jones – 1.5.7
The SEO Framework - Extension Manager: by The SEO Framework Team – 2.7.1
UpdraftPlus - Backup/Restore: by TeamUpdraft
DavidAnderson – 1.25.8
VPN Guard: by VPNDeals – 1.0.4
WooCommerce.com Update Manager: by Automattic – 1.0.3
WooCommerce Stripe Gateway: by Stripe – 9.9.2
Booster for WooCommerce: by Pluggabl LLC – 7.3.1
WooPayments: by WooCommerce – 10.0.0
WooCommerce PayPal Payments: by PayPal – 3.1.2
PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 4.7.0
WooCommerce: by Automattic – 10.2.2
WP 2FA - Two-factor authentication for WordPress: by Melapress – 3.0.0
WP Edit Username: by Sajjad Hossain Sagor – 2.0.4
WP File Manager: by mndpsingh287 – 8.0.2
Widgets for Google Reviews: by Trustindex.io – 13.2
WP Activity Log: by Melapress – 5.5.1
WPForms Lite: by WPForms – 1.9.8.1
WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.17.2
### Inactive Plugins (7) ###
Login & Register Customizer – Popup | Slider | Inline | WooCommerce: by XootiX – 2.9.6
MultiPOS - Point of Sale for WooCommerce: by DevDiggers – 5.1.2
Smush: by WPMU DEV – 3.22.1
WooCommerce Manual Payment: by bfl – 2.8.6
Wordfence Security: by Wordfence – 8.1.0
WP Child Theme Generator: by WEN Solutions – 1.1.4
WPFront Notification Bar: by Syam Mohan – 3.5.1
### Dropin Plugins () ###
object-cache.php: SQLite Object Cache (Drop-in)
### Settings ###
Legacy API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)
variable-subscription (variable-subscription)
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 enabled: ✔
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: –
Enabled Features: analytics
marketplace
order_attribution
site_visibility_badge
email_improvements
blueprint
point_of_sale
custom_order_tables
cost_of_goods_sold
### Logging ###
Enabled: ✔
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 59 KB
### WC Pages ###
Shop base: ❌ Page ID is set
but the page does not exist
Cart: #2179 - /cart/ - Contains the woocommerce/cart block
Checkout: #2180 - /checkout/ - Contains the woocommerce/checkout block
My account: #2181 - /my-account/ - Contains the [woocommerce_my_account] shortcode
Terms and conditions: #780 - /terms-conditions/
### Theme ###
Name: Betheme Child
Version: 2.0
Author URL: https://muffingroup.com
Child Theme: ✔
Parent Theme Name: Betheme
Parent Theme Version: 28.1.9
Parent Theme Author URL: https://muffingroup.com/
Theme type: Classic theme
WooCommerce Support: ✔
### Templates ###
Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
Overrides: betheme/woocommerce/archive-product.php
betheme/woocommerce/cart/cart-totals.php
betheme/woocommerce/cart/cart.php
betheme/woocommerce/cart/cross-sells.php
betheme/woocommerce/cart/mini-cart.php
betheme/woocommerce/cart/proceed-to-checkout-button.php
betheme/woocommerce/checkout/form-checkout.php
betheme/woocommerce/content-product.php
betheme/woocommerce/content-single-product.php
betheme/woocommerce/global/form-login.php
betheme/woocommerce/loop/loop-end.php
betheme/woocommerce/loop/loop-start.php
betheme/woocommerce/loop/no-products-found.php
betheme/woocommerce/loop/pagination.php
betheme/woocommerce/myaccount/downloads.php
betheme/woocommerce/notices/error.php
betheme/woocommerce/notices/success.php
betheme/woocommerce/single-product/add-to-cart/external.php
betheme/woocommerce/single-product/meta.php
betheme/woocommerce/single-product/product-image.php
betheme/woocommerce/single-product/related.php
betheme/woocommerce/single-product/sale-flash.php
betheme/woocommerce/single-product/tabs/description.php
betheme/woocommerce/single-product/tabs/tabs.php
betheme/woocommerce/single-product/title.php
betheme/woocommerce/single-product/up-sells.php
betheme/woocommerce/single-product-reviews.php
### WooPayments ###
Version: 10.0.0
Connected to WPCOM: Yes
WPCOM Blog ID: 210030536
Account ID: acct_1Nx6zyFshNispv5B
Payment Gateway: Disabled
Test Mode: Disabled
Enabled APMs: card
WooPay: Disabled
WooPay Incompatible Extensions: No
Apple Pay / Google Pay: Disabled
Fraud Protection Level: advanced
Enabled Fraud Filters: AVS Verification,Address Mismatch
Multi-currency: Disabled
Auth and Capture: Disabled
Documents: Disabled
Logging: Disabled
### WooCommerce Stripe Payment Gateway ###
Version: 9.9.2
Account ID: acct_1N5v8QIXY0c1d2Z4
Account Email: [email protected]
Test Mode Enabled: ✔
No
OAuth Connected: ✔
Yes
Sync Enabled: ✔
Yes
Legacy Checkout Experience: ✔
No
Optimized Checkout Enabled: No
Enabled Payment Methods: cashapp
Express Checkout: Disabled
Auth and Capture: ✔
Yes
Logging: No
### WooCommerce PayPal Payments ###
Onboarded: ✔
Branded only: –
New UI active: ✔
Shop country code: US
WooCommerce currency supported: ✔
Advanced Card Processing available in country: ✔
Pay Later messaging available in country: ✔
Webhook status: –
PayPal Vault enabled: –
ACDC Vault enabled: –
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –
Subscriptions Mode: Disabled
PayPal Shipping Callback: –
Apple Pay: –
Google Pay: –
Fastlane: –
### Admin ###
Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
onboarding
onboarding-tasks
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store
Disabled Features: product-data-views
experimental-blocks
experimental-iapi-mini-cart
experimental-iapi-runtime
coming-soon-newsletter-template
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
use-wp-horizon
experimental-wc-rest-api
Daily Cron: ✔ Next scheduled: 2025-10-07 00:57:26 -04:00
Options: ✔
Notes: 199
Onboarding: completed
### Google for WooCommerce ###
Products API Pull: ❌ Disabled
Products MC Push: ❌ Disabled
Coupons API Pull: ❌ Disabled
Coupons MC Push: ❌ Disabled
Shipping API Pull: ❌ Disabled
Shipping MC Push: ❌ Disabled
Settings API Pull: ❌ Disabled
Settings MC Push: ❌ Disabled
### Action Scheduler ###
Complete: 8,900
Oldest: 2025-09-05 18:34:34 -0400
Newest: 2025-10-06 15:55:56 -0400
Pending: 18
Oldest: 2025-10-06 19:54:10 -0400
Newest: 2025-12-10 03:34:08 -0500
### Status report information ###
Generated at: 2025-10-06 17:26:52 -04:00
Isolating the problem
- I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
- This bug happens with a default WordPress theme active, or Storefront.
- I can reproduce this bug consistently using the steps above.