• 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).

Viewing 7 replies - 1 through 7 (of 7 total)
  • 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.

    Thread Starter Dean-Datalynk-UK

    (@datalynk)

    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.

    Thread Starter Dean-Datalynk-UK

    (@datalynk)

    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.

    Thread Starter Dean-Datalynk-UK

    (@datalynk)

    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 the Recalculate 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:

    Hope this helps!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Recalculate Tax adds tax to old orders instead of including as per the settings’ is closed to new replies.