Recalculate Tax adds tax to old orders instead of including as per the settings
-
I have been scratching my head for days now with this issue.
My current tax settings apply 20% VAT to products and shipping within the EU and Zero rate outside of these area’s. My tax settings are set to calculate via customers shipping address, and all settings are set to add and show prices always inclusive.
Now it may be important to note, that I am trying to recalculate taxes on old orders that when placed (at the time of ordering) tax was disabled and not used. And so we are going through old orders to try and recalculate so that we can reconcile our accounts with QuickBooks after importing transactions.
So the problem in short is that when I hit the “Recalculate” button in the order admin, it recalculates and adds the tax as an additional 20% charge meaning the order is now 20% more than the customer originally paid.
N.B. we have tried a number of suggestions already
1) Added add_filter( ‘woocommerce_adjust_non_base_location_prices’, ‘__return_false’ ); to funtions.php file.
2) Altered _postmeta field “_prices_include_tax” from “no” to “yes” for the order ID and again tried to recalculate (still fails).
-
Hi,
If I understood correctly, the old orders are being edited. When edited them, the taxes are being added, and the result is, the final price is higher. I understand your tax configuration is price tax inclusive. It is like WooCommerce is understanding that you would like to add an extra fee, in this case the tax/vat, etc, making the price higher.
I understand this is a process, and it will need time, one about creating a copy of the product that is in the order, and adding that product to the order, replacing the old one? Is this recalculated properly? Or do you have the same issue that way?
If that does not help, please provide us a screenshot of your tax settings.
Let us know how that goes for you.
Hi @ihereira thank you for your help. I added the line to wp-config.php to allow us to recalculate the the tax on orders. This works as expected on orders it seems that were taken at a later date (after we enabled VAT at 20%) however on orders that are older (i.e. before we enabled tax and 20%VAT) it adds instead of recalculating as inclusive.
I haven’t tried removing and re-adding the product as we have over 2000 orders which need amending, and so looking for a more programmatic way of fixing the issue (even if I need to run an SQL script to make changes in the database).
Hi,
To take a closer look, 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”.?
Check if there is any error found under WooCommerce > System Status > Logs that might provide us more information about the issue.
Thank you.
WordPress Environment WordPress address (URL): https://mickjagger.whynowmusic.com Site address (URL): https://mickjagger.whynowmusic.com 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.0 - There is a newer version of WordPress available (6.2.1) WP Multisite: ? WP Memory Limit: 2 GB WP Debug Mode: ? WP Cron: ? Language: en_GB External object cache: – Server Environment Server Info: nginx/1.18.0 PHP Version: 8.0.27 PHP Post Max Size: 128 MB PHP Time Limit: 3000 PHP Max Input Vars: 5000 cURL Version: 7.68.0 OpenSSL/1.1.1f SUHOSIN Installed: – MySQL Version: 8.0.33-0ubuntu0.20.04.2 Max Upload Size: 15 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: riode_10_ Total Database Size: 83.38MB Database Data Size: 52.21MB Database Index Size: 31.17MB riode_10_woocommerce_sessions: Data: 1.02MB + Index: 0.05MB + Engine InnoDB riode_10_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB riode_10_woocommerce_order_items: Data: 0.30MB + Index: 0.17MB + Engine InnoDB riode_10_woocommerce_order_itemmeta: Data: 2.52MB + Index: 4.03MB + Engine InnoDB riode_10_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB riode_10_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_actionscheduler_actions: Data: 4.03MB + Index: 3.06MB + Engine InnoDB riode_10_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_actionscheduler_logs: Data: 2.20MB + Index: 1.80MB + Engine InnoDB riode_10_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_aioseo_cache: Data: 0.14MB + Index: 0.03MB + Engine InnoDB riode_10_aioseo_notifications: Data: 0.03MB + Index: 0.06MB + Engine InnoDB riode_10_aioseo_posts: Data: 0.08MB + Index: 0.02MB + Engine InnoDB riode_10_cartflows_ca_cart_abandonment: Data: 0.48MB + Index: 0.02MB + Engine InnoDB riode_10_cartflows_ca_email_history: Data: 0.06MB + Index: 0.03MB + Engine InnoDB riode_10_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_cli_csv_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_comments: Data: 4.52MB + Index: 5.88MB + Engine InnoDB riode_10_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB riode_10_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB riode_10_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_gdpr_cookie_post_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_gdpr_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB riode_10_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_import_detail_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_import_log_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_import_postID: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_mailchimp_carts: Data: 0.13MB + Index: 0.00MB + Engine InnoDB riode_10_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mc4wp_log: Data: 0.06MB + Index: 0.00MB + Engine InnoDB riode_10_mo_openid_linked_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_monsterinsights_pageinsights_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_monsterinsights_user_journey: Data: 3.52MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_customer_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_payment_id_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_paymentmethod_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_product_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_qbo_customers: Data: 0.17MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_qbo_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_real_time_sync_history: Data: 1.52MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_real_time_sync_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_sessions: Data: 0.22MB + Index: 0.13MB + Engine MyISAM riode_10_mw_wc_qbo_sync_shipping_product_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_tax_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_mw_wc_qbo_sync_variation_pairs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM riode_10_mw_wc_qbo_sync_wq_cf_map: Data: 0.00MB + Index: 0.00MB + Engine MyISAM riode_10_options: Data: 6.14MB + Index: 0.16MB + Engine InnoDB riode_10_postmeta: Data: 12.52MB + Index: 12.03MB + Engine InnoDB riode_10_posts: Data: 2.52MB + Index: 0.47MB + Engine InnoDB riode_10_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB riode_10_rank_math_analytics_objects: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_smackcsv_file_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_smackuci_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_ultimate_csv_importer_acf_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_ultimate_csv_importer_mappingtemplate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_ultimate_csv_importer_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_ultimate_csv_importer_shortcode_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_ultimate_post_entries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_vxc_mailchimp_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_vxc_mailchimp_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_vxc_qbooks_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_vxc_qbooks_log: Data: 0.11MB + Index: 0.02MB + Engine InnoDB riode_10_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB riode_10_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB riode_10_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_wc_customer_lookup: Data: 0.20MB + Index: 0.17MB + Engine InnoDB riode_10_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_wc_order_product_lookup: Data: 0.31MB + Index: 0.39MB + Engine InnoDB riode_10_wc_order_stats: Data: 0.25MB + Index: 0.23MB + Engine InnoDB riode_10_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_10_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB riode_10_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_10_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_woo_sales_country_region: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_woo_shippment_provider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB riode_10_xoo_wl_list: Data: 0.05MB + Index: 0.02MB + Engine InnoDB riode_10_xoo_wl_list_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB riode_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB riode_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB riode_sitemeta: Data: 5.52MB + Index: 0.03MB + Engine InnoDB riode_usermeta: Data: 1.52MB + Index: 0.50MB + Engine InnoDB riode_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB Post Type Counts acf-field: 48 acf-field-group: 4 artists: 2 astra-advanced-hook: 2 attachment: 141 custom_css: 2 elementor_library: 2 mc4wp-form: 1 nav_menu_item: 9 page: 9 post: 3 product: 12 product-feed: 3 revision: 93 shop_coupon: 4 shop_order: 1844 shop_order_refund: 59 vxc_qbooks: 2 wp_global_styles: 1 wpcode: 2 wpforms: 2 yaymail_template: 11 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (62) Advanced Custom Fields PRO: by WP Engine – 6.1.6 Advanced Database Cleaner: by Younes JFR. – 3.1.2 Astra Pro: by Brainstorm Force – 3.9.0 Astra Bulk Edit: by Brainstorm Force – 1.2.6 Import / Export Customizer Settings: by Brainstorm Force – 1.0.7 Starter Templates: by Brainstorm Force – 3.2.2 Astra Widgets: by Brainstorm Force – 1.2.12 Product Feed Manager for WooCommerce: by RexTheme – 7.2.33 Custom Fonts: by Brainstorm Force – 1.3.7 Customiser Search: by Brainstorm Force – 1.1.6 Duplicate Page: by mndpsingh287 – 4.5.2 Elementor Pro: by Elementor.com – 3.5.2 Elementor: by Elementor.com – 3.13.2 Enhanced AJAX Add to Cart for WooCommerce: by TheRiteSites – 2.3.0 Facebook for WooCommerce: by Facebook – 3.0.23 MonsterInsights - eCommerce Addon: by MonsterInsights Team – 8.3.10 GDPR Cookie Consent: by WPEkaClub – 2.2.5 MonsterInsights Pro: by MonsterInsights – 8.14.1 Google Listings and Ads: by WooCommerce – 2.4.5 LoginPress - Customizing the WordPress Login Screen.: by WPBrigade – 1.7.1 Mailchimp for WooCommerce: by Mailchimp – 2.8.3 MC4WP: Mailchimp for WordPress: by ibericode – 4.9.4 MC4WP: Mailchimp for WordPress Premium: by ibericode – 4.9.3 Social Login, Social Sharing by miniOrange: by miniOrange – 7.6.3 MonsterInsights - Dimensions Addon: by MonsterInsights Team – 2.0.6 MonsterInsights - Forms Tracking Addon: by MonsterInsights Team – 2.2.6 MonsterInsights - Google Optimize Addon: by MonsterInsights Team – 1.5.2 MonsterInsights - Media Addon: by MonsterInsights Team – 1.0.7 MonsterInsights - Page Insights Addon: by MonsterInsights Team – 1.5.3 MonsterInsights - Performance Addon: by MonsterInsights Team – 1.7.3 MonsterInsights - User Journey Addon: by MonsterInsights Team – 1.0.7 WooCommerce Sync for QuickBooks Online - by MyWorks Software: by MyWorks Software – 2.7.0 Page Links To: by Mark Jaquith – 3.3.6 Database Management tool - Adminer: by Pexle Chris – 2.1.0 Pinterest for WooCommerce: by WooCommerce – 1.2.2 (update to version 1.2.21 is available) Premium Addons for Elementor: by Leap13 – 4.9.55 Product Catalog Feed by PixelYourSite: by PixelYourSite – 2.1.1 Social Share for WooCommerce: by WPXtension – 1.1.7 Quick and Easy FAQs: by Inspiry Themes – 1.3.7 Rank Math SEO: by Rank Math – 1.0.114 Sidebar Manager: by Brainstorm Force – 1.1.7 SMTP2GO - Email Made Easy: by SMTP2GO – 1.5.2 Sold Out Badge for WooCommerce: by Charlie Etienne – 4.3.6 TikTok: by TikTok – 1.0.7 Spectra: by Brainstorm Force – 2.5.1 Waitlist woocommerce( Back in stock notifier ): by – 2.5.2 Advanced Shipment Tracking for WooCommerce: by zorem – 3.5.3 WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.24 WooCommerce Stripe Gateway: by WooCommerce – 7.4.0 WooCommerce Sales by Country: by MH Mithu – 1.5 WooCommerce: by Automattic – 7.7.0 WP Fastest Cache: by Emre Vona – 1.1.5 WPForms Lite: by WPForms – 1.8.1.2 YayMail - WooCommerce Email Customizer: by YayCommerce – 3.2.7.1 YITH Pre-Order for WooCommerce: by YITH – 2.12.0 YITH WooCommerce Brands Add-On: by YITH – 2.12.0 WPCode Lite: by WPCode – 2.0.11 WP Crontrol: by John Blackbourn & contributors – 1.15.2 Disable Emojis (GDPR friendly): by Ryan Hellyer – 1.7.4 Really Simple SSL: by Really Simple Plugins – 6.2.5 Astra Pro: by Brainstorm Force – 3.9.0 iThemeland WooCommerce Bulk Orders Editing Lite: by iThemelandco – 2.1.1 Inactive Plugins (48) ACF Autosize: by Yeah GbR – 2.0.15 Aelia Currency Switcher for WooCommerce: by Aelia – 4.14.3.220919 Aelia Foundation Classes for WooCommerce: by Aelia – 2.3.2.221012 All in One SEO: by All in One SEO Team – 4.3.7 Appmaker – Convert WooCommerce to Android & iOS Native Mobile Apps: by Appmaker – 1.36.12 Booster for WooCommerce: by Pluggabl LLC – 6.0.5 Booster Plus for WooCommerce: by Pluggabl LLC – 5.5.2 Contact Form Entries: by CRM Perks – 1.3.0 CURCY - Multi Currency for WooCommerce: by VillaTheme – 2.1.30 Debug This: by WPChill – 0.6.4 Enable Media Replace: by ShortPixel – 4.1.2 File Manager Advanced: by modalweb – 5.0.4 GDPR Data Request Form: by audrasjb – 1.6 Gettext override translations: by Ramon Fincken – 2.0.2 GTM4WP: by Thomas Geiger – 1.16.2 GTranslate: by Translate AI Multilingual Solutions – 3.0.3 Instant Articles for WP: by Automattic Dekode Facebook – 5.0.2 Integration for WooCommerce and MailChimp: by CRM Perks. – 1.0.4 Monetization Code plugin: by aerin Singh – 1.0 MonsterInsights - Ads Addon: by MonsterInsights Team – 1.8.1 MonsterInsights - EU Compliance: by MonsterInsights Team – 2.2.5 MonsterInsights - Facebook Instant Articles Addon: by MonsterInsights Team – 1.2.0 Multisite Language Switcher: by Dennis Ploetner – 2.5.8 OneSignal Push Notifications: by OneSignal – 2.4.0 OptinMonster: by OptinMonster Popup Builder Team – 2.13.2 Product Size Charts Plugin for WooCommerce: by theDotstore – 2.4.2.1 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 Restore Paypal Standard For WooCommerce: by Jose Mortellaro – 1.0.3 Sales Report By Country for WooCommerce: by zorem – 1.6.8 ShortPixel Image Optimizer: by ShortPixel - Convert WebP/AVIF & Optimize Images – 5.2.2 TaxoPress: by TaxoPress – 3.7.3 Ultimate Auction For WooCommerce: by Nitesh Singh – 2.3.0 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.23.4 User Switching: by John Blackbourn & contributors – 1.7.0 Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.20 WooCommerce Better Usability PRO: by Moises Heberle – 1.0.52 WooCommerce Multilingual & Multicurrency: by OnTheGoSystems – 5.1.3 WooCommerce PayPal Payments: by WooCommerce – 2.0.4 Wordfence Security: by Wordfence – 7.9.2 WordPress Importer: by wordpressdotorg – 0.8.1 WPC Variations Radio Buttons for WooCommerce: by WPClever – 3.3.3 WP Frontend Delete Account: by Sanjeev Aryal – 1.7.0 WP Mail SMTP: by WP Mail SMTP – 3.8.0 WP Ultimate CSV Importer: by Smackcoders – 7.9 YITH WooCommerce Ajax Product Filter: by YITH – 4.22.0 YITH WooCommerce Catalog Mode: by YITH – 2.22.0 YITH WooCommerce Product Slider Carousel: by YITH – 1.22.0 YITH WooCommerce Waitlist: by YITH – 2.2.0 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: – 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: ? Page ID is set but the page does not exist Basket: #12 - /basket/ Checkout: #13 - /checkout/ My account: #14 - /my-account/ Terms and conditions: ? Page not set Theme Name: Whynow AST Version: 1.0.0 Author URL: https://whynow.co.uk Child Theme: ? Parent Theme Name: Astra Parent Theme Version: 4.1.3 – 4.1.4 is available Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme WooCommerce Support: ? Templates Overrides: – 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-17 12:43:12 +01:00 Options: ? Notes: 96 Onboarding: skipped Action Scheduler Complete: 7,820 Oldest: 2023-04-16 13:01:12 +0100 Newest: 2023-05-17 12:49:50 +0100 Failed: 33 Oldest: 2023-01-28 17:21:24 +0000 Newest: 2023-05-10 01:32:37 +0100 Pending: 17 Oldest: 2023-05-17 12:51:04 +0100 Newest: 2023-05-23 18:04:35 +0100 Status report information Generated at: 2023-05-17 12:51:07 +01:00 `
Hi,
Thank you for sending the system status report.
WP Version: ? 6.0
Can you update the version of WordPress on your site? You can use this guide to update it. On the staging site, keep only WooCommerce as the active plugin, then please try again to recalculate taxes.
In order to do not affect the live site, you can use a staging site, we recommend asking your web host to see if they have staging facilities, otherwise you can use the WP Staging plugin for this task.
Important: Before making any critical change, be sure to create a backup.
Cheers.
Having done all of the above I still face the same problems.
Hi @datalynk
I understand that you are adding tax to old orders on your site which is tax-exclusive by using the
Recalculate
button when editing orders. However, instead of breaking down the product’s price to include the tax per line item, it is being added on top of it, correct?Kindly be informed that this is the default behavior. Even with the settings set to
inclusive of tax
, the orders on the back end show the tax broken out as its own line item. Since these older orders did not have any tax at all, clicking theRecalculate
button applies the current rules and adds a tax line with the taxes added. It doesn’t adjust the product price to?remove?the tax.?In your use case, I am quite unsure if this is possible thru custom coding but indeed, this would require manual labor to adjust the price of the items to remove the VAT amount, so that the added tax line works out to the same older total.
Unfortunately, custom coding is not something we can assist with directly. However, I’ll keep this thread open for a bit to see if anyone from the community can lend a hand.
If you have any other questions related to development or custom coding, don’t hesitate to reach out to some of the great resources we have available for support. The WooCommerce community is filled with talented open-source developers, and many of them are active on the channels listed below:
- WooCommerce Developer Resources Portal
- WooCommerce Advanced Facebook group
- WooCommerce Developer Slack Channel
- Hire a WooCommerce Expert
Hope this helps!
- The topic ‘Recalculate Tax adds tax to old orders instead of including as per the settings’ is closed to new replies.