Random Tax Metadata Showing Up On Line Level Details After Checkout

Hi there!
I reviewed the system error report you shared, and it shows an error indicating changes have been made in the WooCommerce theme files. Could you confirm if you’ve modified any theme files? If so, please let us know exactly what changes were made, as this information will help us provide more accurate assistance.

If you haven’t made any changes to the theme files, please try deleting the WooCommerce plugin, reinstalling it, and see if it resolved the issue.
If reinstalling WooCommerce doesn’t resolve the issue, please deactivate the Code Snippets plugin, and share the System Status Report again?

Thank you

Thanks for the response. this is a new instalation, so no woocommerce files were changed. i mean i installed a new WP enviroment and then a installed WC from the plugin repository and then connected it to the original site DB .

i now also deactivated code snippets – however already tried this before and this plugin is not the source of the problem.

here is the updated status log:

———————-

WordPress Environment<br><br>WordPress address (URL): https://localhost/ravid2<br>Site address (URL): https://localhost/ravid2<br>WC Version: 9.3.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.8.1<br>Log Directory Writable: ?<br>WP Version: 6.6.2<br>WP Multisite: –<br>WP Memory Limit: 256 MB<br>WP Debug Mode: ?<br>WP Cron: ?<br>Language: en_US<br>External object cache: – Server Environment<br><br>Server Info: Apache/2.4.58 (Win64) PHP/8.2.13 mod_fcgid/2.3.10-dev<br>PHP Version: 8.2.13<br>PHP Post Max Size: 256 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 2500<br>cURL Version: 8.4.0<br>OpenSSL/3.1.3<br><br>SUHOSIN Installed: –<br>MySQL Version: 8.2.0<br>Max Upload Size: 256 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database<br><br>WC Database Version: 9.3.3<br>WC Database Prefix: ravid_<br>Total Database Size: 338.51MB<br>Database Data Size: 310.09MB<br>Database Index Size: 28.42MB<br>ravid_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>ravid_woocommerce_order_items: Data: 0.17MB + Index: 0.06MB + Engine InnoDB<br>ravid_woocommerce_order_itemmeta: Data: 1.52MB + Index: 3.03MB + Engine InnoDB<br>ravid_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>ravid_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_actionscheduler_actions: Data: 0.13MB + Index: 0.13MB + Engine InnoDB<br>ravid_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_actionscheduler_logs: Data: 0.11MB + Index: 0.09MB + Engine InnoDB<br>ravid_cf7_vdata: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_cf7_vdata_entry: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_check_email_error_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_check_email_log: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>ravid_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_comments: Data: 0.52MB + Index: 0.56MB + Engine InnoDB<br>ravid_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>ravid_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_e_submissions: Data: 1.52MB + Index: 1.36MB + Engine InnoDB<br>ravid_e_submissions_actions_log: Data: 0.28MB + Index: 0.44MB + Engine InnoDB<br>ravid_e_submissions_values: Data: 0.13MB + Index: 0.16MB + Engine InnoDB<br>ravid_ee_pmax_campaign: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_ee_product_feed: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_ee_product_sync_call: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_ee_product_sync_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_ee_products_sync_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_ee_tiktok_catalog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_fm_file_action_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_hustle_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_hustle_entries_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_hustle_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_hustle_modules_meta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>ravid_hustle_tracking: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>ravid_jet_post_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_jet_taxonomies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_litespeed_avatar: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>ravid_litespeed_crawler: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_litespeed_crawler_blacklist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_litespeed_url: Data: 0.14MB + Index: 0.19MB + Engine InnoDB<br>ravid_litespeed_url_file: Data: 1.52MB + Index: 1.55MB + Engine InnoDB<br>ravid_mystickyelement_contact_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_options: Data: 5.52MB + Index: 0.19MB + Engine InnoDB<br>ravid_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_pmxi_hash: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>ravid_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_pmxi_images: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>ravid_pmxi_imports: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>ravid_pmxi_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>ravid_pmxi_templates: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>ravid_popover_ip_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_postmeta: Data: 128.55MB + Index: 12.03MB + Engine InnoDB<br>ravid_posts: Data: 132.52MB + Index: 1.30MB + Engine InnoDB<br>ravid_redirection_404: Data: 1.52MB + Index: 0.38MB + Engine InnoDB<br>ravid_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>ravid_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_term_relationships: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>ravid_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>ravid_termmeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>ravid_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>ravid_usermeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB<br>ravid_users: Data: 0.09MB + Index: 0.05MB + Engine InnoDB<br>ravid_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB<br>ravid_wc_admin_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>ravid_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wc_customer_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>ravid_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_wc_order_product_lookup: Data: 0.14MB + Index: 0.19MB + Engine InnoDB<br>ravid_wc_order_stats: Data: 0.11MB + Index: 0.11MB + Engine InnoDB<br>ravid_wc_order_tax_lookup: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>ravid_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_wc_product_meta_lookup: Data: 0.05MB + Index: 0.11MB + Engine InnoDB<br>ravid_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_wfblockediplog: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>ravid_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_wfconfig: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>ravid_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wffilemods: Data: 12.55MB + Index: 0.00MB + Engine InnoDB<br>ravid_wfhits: Data: 1.52MB + Index: 0.20MB + Engine InnoDB<br>ravid_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_wfissues: Data: 0.05MB + Index: 0.06MB + Engine InnoDB<br>ravid_wfknownfilelist: Data: 8.52MB + Index: 0.00MB + Engine InnoDB<br>ravid_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wflogins: Data: 0.41MB + Index: 0.14MB + Engine InnoDB<br>ravid_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY<br>ravid_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>ravid_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB<br>ravid_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>ravid_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ravid_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>ravid_yoast_indexable: Data: 0.22MB + Index: 0.09MB + Engine InnoDB<br>ravid_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>ravid_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ravid_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>ravid_yoast_seo_links: Data: 0.17MB + Index: 0.05MB + Engine InnoDB<br>ravid_yoast_seo_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>rm_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_usermeta: Data: 0.47MB + Index: 0.45MB + Engine InnoDB<br>wp_users: Data: 0.05MB + Index: 0.05MB + Engine InnoDB Post Type Counts<br><br>acf-field: 58<br>acf-field-group: 16<br>attachment: 488<br>before_and_after: 13<br>custom_css: 2<br>distributors: 15<br>elementor_font: 4<br>elementor_library: 42<br>elementor_snippet: 2<br>elementskit_content: 9<br>elementskit_template: 1<br>emailkit: 1<br>itsec-dash-card: 10<br>itsec-dashboard: 2<br>jet-engine: 3<br>jet-smart-filters: 9<br>jet-woo-builder: 3<br>nav_menu_item: 71<br>oceanwp_library: 1<br>oembed_cache: 2<br>page: 22<br>pojo_forms: 1<br>pojo_gallery: 9<br>post: 49<br>product: 112<br>product_variation: 62<br>q_and_a: 155<br>q_n_a: 3<br>revision: 4142<br>shop_coupon: 28<br>shop_order: 1025<br>video: 10<br>wcps: 1<br>wp_navigation: 1<br>yith-wcet-etemplate: 1 Security<br><br>Secure connection (HTTPS): ?<br>Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.<br>Hide errors from visitors: ?Error messages should not be shown to visitors. Active Plugins (1)<br><br>WooCommerce: by Automattic – 9.3.3 Inactive Plugins (3)<br><br>Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.3<br>Code Snippets: by Code Snippets Pro – 3.6.5.1<br>Hello Dolly: by Matt Mullenweg – 1.7.2 Settings<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: ILS (?)<br>Currency Position: right_space<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 3 KB WC Pages<br><br>Shop base: #1699 - /%d7%a7%d7%98%d7%9c%d7%95%d7%92-%d7%9e%d7%95%d7%a6%d7%a8%d7%99%d7%9d/<br>Cart: #2948 - /%d7%a2%d7%92%d7%9c%d7%aa-%d7%94%d7%a7%d7%a0%d7%99%d7%95%d7%aa-%d7%a9%d7%9c%d7%99/ - Contains the [woocommerce_cart] shortcode<br>Checkout: #2946 - /%d7%aa%d7%a9%d7%9c%d7%95%d7%9d/ - Contains the [woocommerce_checkout] shortcode<br>My account: #2947 - /%d7%90%d7%99%d7%96%d7%95%d7%a8-%d7%90%d7%99%d7%a9%d7%99/<br>Terms and conditions: #2953 - /%d7%aa%d7%a7%d7%a0%d7%95%d7%9f-%d7%95%d7%9e%d7%93%d7%99%d7%a0%d7%99%d7%95%d7%aa-%d7%a4%d7%a8%d7%98%d7%99%d7%95%d7%aa/ Theme<br><br>Name: Twenty Twenty-Four<br>Version: 1.2<br>Author URL: https://www.ads-software.com<br>Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme<br>WooCommerce Support: ? Not declared Templates<br><br>Overrides: – Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>blueprint<br>reactify-classic-payments-settings<br><br>Daily Cron: ? Next scheduled: 2024-11-06 11:45:47 +02:00<br>Options: ?<br>Notes: 218<br>Onboarding: completed Action Scheduler<br><br>Complete: 258<br>Oldest: 2024-10-05 21:27:41 +0300<br>Newest: 2024-11-06 09:28:16 +0200<br><br>Pending: 8<br>Oldest: 2024-11-06 09:28:21 +0200<br>Newest: 2024-11-13 09:28:16 +0200<br><br>Failed: 36<br>Oldest: 2023-03-09 16:40:36 +0200<br>Newest: 2024-11-06 09:28:16 +0200 Status report information<br><br>Generated at: 2024-11-06 09:29:19 +02:00<br>

Hi @sagee77,

Thanks for giving us confirmation about the WooCommerce Files. I can see that you’re encountering unexpected tax metadata in your WooCommerce orders, which appears inconsistently across products and orders. This issue persists even after deactivating all plugins except WooCommerce and switching to the Twenty Twenty-Four theme.

To help resolve this, as a first step, I recommend checking for any potential database issues by performing a thorough database cleanup. Tools like WP-Optimize can assist in removing unnecessary data and optimizing your database.

Before proceeding, I strongly recommend creating a backup of your full site and database. This will ensure that, if anything goes wrong during the process, you can easily restore your site to a working state. For this, the All-in-One WP Migration plugin can help you back up your site quickly.

After that, I would also like you to regenerate WooCommerce data by navigate to WooCommerce > Status > Tools and execute the following:

• Regenerate Product Lookup Tables
• Recount Terms
• Clear WooCommerce Transients

After completing these steps, please check if the issue persists and let us know how it goes.

Thanks for the reply, I went over all suggestions. installed WP Optimize and used thier DB tools and then the Woocommerce DB tools you mentioned and the issue still happens.

https://ibb.co/SvTr08p
https://ibb.co/mh3QJYR
https://ibb.co/PZks8Dw
https://ibb.co/F7Sg4FM
https://ibb.co/H4bSHZx

• This reply was modified 1 week, 4 days ago by Sagee.

Hello Sagee,

Thank you for your reply.

This situation is quite unusual.

Could you please specify which fields contain the random tax metadata?
The screenshot does not clearly show if you are pointing to multiple fields or just a specific one.
It would be beneficial if you could copy those labels and provide them as text.
This way, I can translate them and further investigate the issue.

You mentioned, “I installed a new WP environment and then installed WC from the plugin repository and then connected it to the original site DB.”
Were these the steps you took to migrate a live site to the local host?

Did this issue also occur on the live site?
Once I have additional information, I will be better equipped to assist you further.

Looking forward to your response. ??

It is indeed very unusual and is driving me mad ….
the bug first started and was detected on the live production site. i then created a stage site where it repeated the same behaviour. there i tried all the usual thing, disabling plugins and themes etc.
once this did not work, instaleed it locally as a cloned website and it still continued and then i created a new WP site from a clean instalation (thinking maybe its something with the corrupted core WP file) and once installed configured it to the cloned website DB and the behaviour continues.

Here is a list of meta data that is attached to products in the orders.
Note that even what seems to be ordinary meta data like SKU and aviation id is not correct and also is not consist, so one order a product may have that meta field and other order not and other order a different value (for the same product).

I also thought maybe its something in the product metadata but went over the postmeta table and did not see anything like that and this also happened when I create a new test product and completed an order for it.

instance_id: 2
total_tax: 0
?????: ???? ??? – STONE CLEANER – 1-???? × 1, ???? ???? – FILAACTIVE1 × 1
?????: 250 ?”?
rate_id: 2
label: ??”?
tax_amount: 39.27
shipping_tax_amount: 0
Items: ???? ????? – ??? ??? ???? – 2.5 ???? × 1, ???? ???? ??? – STONE CLEANER – 250-?? × 1
SKU: 210808
Variation ID: 5109
instance_id: 2
total_tax: 0
?????: ???? ??? – STONE CLEANER – 1-???? × 1, ???? ???? – FILAACTIVE1 × 1
?????: 250 ?”?

Thanks for the time and help.

Hello Sagee,

Thank you for your reply.

I found this thread where a similar issue was reported.
I recommend you read it and confirm if something similar might have caused the issue.

Also, could you try this step?
This will clarify whether the issue is caused by post_id counter.

I dumped out the postmeta table and what became clear is that the post_id counter somehow reset back to an earlier number.

Let me know about your findings.
Once I have more information, I will be in a better position to assist you further.

Best regards.

Thanks.
I started fromthat thread. i tried to see if in my DB there were a reset of the post id but i assumed i will see this by going other meta data from the postmet, so if their was an old product with same id i would see some meta data for it but i have not seen any. so i can say i found there was a counter reset.
do you think about any other way to check if there was a post counter reset?

Hi @sagee77 ,

I started from that thread.

Understood and thank you for letting us know. It sounds like you’ve been thorough in your investigation, which is really helpful.

do you think about any other way to check if there was a post counter reset?

To check for a post ID counter reset, you could compare the post IDs of recent products/orders with older entries. If there’s an overlap, it could indicate a reset. You might also look into your database’s auto-increment values for the ‘post’ tables to see if they match the current highest post ID. If you find discrepancies, it could also point towards a reset issue.

If these steps don’t help, it might be worth inspecting the order meta for any unexpected entries. Here’s some steps to follow:

1. Go to WooCommerce > Orders and click on an order that you noticed had the Tax Metadata.
2. Scroll down Click on the ‘Custom Fields’ section to expand it.
3. Look through the list for any meta keys that look out of place or that don’t match the expected data for your orders.

Please keep us posted on what you find.

Hi. Thanks again for the time and effort in walking with me through this weird problem.
I think i have found the souce table of the problem. but not sure how to fix it and am open to ideas and thoughts.
It seems that the issue comes from the _order_itemmeta table. It seems that if i empty the whole table and use a clean table the strage meta data is not added to order items but when using the table with all old data it returns.
i have tried to see if the counter was reset and if new items are getting same id as old onces but does not seem like that.
Now that i think i now the problem location, still not sure how to fix it. i can really delete all the data since then all orders in teh admin interface will lose all old orders items data.

What do you think?

Hi, i think i may found the solution by cleaning all orphan rows in the itemmeta TB. Not sure yet, still checking but it seems like this is working. will update soon after additional testing

Hi there,

Thank you for the update! It’s great to hear that cleaning up orphan rows in the itemmeta table may be helping resolve the issue. This is an insightful step, as orphaned data in the database can sometimes cause unexpected behavior.

Please let us know how it goes after your additional testing. If the issue persists or you need further assistance, feel free to share more details, and we’ll do our best to guide you.

thank you

Hi, an update about the issue.
So far it seems that the problem was resolved. cleaning orphan rows in the woocommerce order itemmeta table seems to fix the issue.

Here is the SQL i used to clean the orphan records if anyone will need :

DELETE oim FROM ravid_woocommerce_order_itemmeta oim LEFT JOIN ravid_woocommerce_order_items oi ON oim.order_item_id = oi.order_item_id WHERE oi.order_item_id IS NULL;