• Resolved andre2015

    (@andre2015)


    Hi there! I’ve been trying to figure this out on both my live site an ddev site (where I can test more), but I’m not sure what is happening.

    When you go to ad something to the cart and then choose your shipping option (be sure it is over $150), you can then choose between the Flat rate $9.95 shipping, free shipping or local pickup.

    Switch between those and you can see the tax calculations (I just have provinces of Canada right now). However the GST and PST amounts switch between the 2 or 3 options and I’m not sure why? The amount is still correct but the amount switches.

    Has anyone else run into this issue before?

    I’ve set for products to not have taxes calculated initially and have taxes based on shipping addresses, then have inputted any and all standard tax rates where they belong. I’ve also set up a shipping zone for the whole of “Canada” that allows for the flat rate, local pickup and free shipping over $150.

    The other issue I’m finding is that even though I’ve defined a new shipping zone for JUST “British Columbia” for a BC Local pickup option, save and then update the address to a BC address the BC Local pickup option does not apply for some reason.

    So it seems I’m a bit confused as to why these shipping/tax options are not working the way they should be.

    Is anyone able to help.

    WooCommerce Status Report:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.meltmineralspa.com
    Site address (URL): https://www.meltmineralspa.com
    WC Version: 3.6.4
    Log Directory Writable: ✔
    WP Version: ❌ 5.2.5 - There is a newer version of WordPress available (5.3.2)
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.3.12-1+ubuntu18.04.1+deb.sury.org+1
    PHP Post Max Size: 100 MB
    PHP Time Limit: 3600
    PHP Max Input Vars: 1000
    cURL Version: 7.58.0
    OpenSSL/1.1.1d
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.27-30-log
    Max Upload Size: 50 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.6.4
    WC Database Prefix: mmsp_
    MaxMind GeoIP Database: ✔
    Total Database Size: 45.59MB
    Database Data Size: 34.88MB
    Database Index Size: 10.71MB
    mmsp_woocommerce_sessions: Data: 7.02MB + Index: 0.09MB
    mmsp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
    mmsp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
    mmsp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB
    mmsp_woocommerce_order_items: Data: 0.08MB + Index: 0.05MB
    mmsp_woocommerce_order_itemmeta: Data: 0.50MB + Index: 0.52MB
    mmsp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
    mmsp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
    mmsp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
    mmsp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
    mmsp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
    mmsp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
    mmsp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
    mmsp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
    mmsp_3_tcb_api_error_log: Data: 0.02MB + Index: 0.00MB
    mmsp_abandoned_cart_aelia_currency: Data: 0.02MB + Index: 0.00MB
    mmsp_ac_abandoned_cart_history: Data: 2.52MB + Index: 0.06MB
    mmsp_ac_email_templates: Data: 0.06MB + Index: 0.00MB
    mmsp_ac_guest_abandoned_cart_history: Data: 0.02MB + Index: 0.02MB
    mmsp_ac_link_clicked_email: Data: 0.02MB + Index: 0.00MB
    mmsp_ac_notifications: Data: 0.02MB + Index: 0.00MB
    mmsp_ac_notifications_meta: Data: 0.02MB + Index: 0.00MB
    mmsp_ac_opened_emails: Data: 0.02MB + Index: 0.00MB
    mmsp_ac_sent_history: Data: 0.02MB + Index: 0.02MB
    mmsp_ac_tiny_urls: Data: 0.02MB + Index: 0.02MB
    mmsp_aws_cache: Data: 0.02MB + Index: 0.00MB
    mmsp_aws_index: Data: 1.52MB + Index: 0.00MB
    mmsp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB
    mmsp_blogs: Data: 0.00MB + Index: 0.00MB
    mmsp_blog_versions: Data: 0.00MB + Index: 0.00MB
    mmsp_commentmeta: Data: 0.00MB + Index: 0.01MB
    mmsp_comments: Data: 0.20MB + Index: 0.09MB
    mmsp_csp3_subscribers: Data: 0.00MB + Index: 0.00MB
    mmsp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB
    mmsp_gf_entry: Data: 1.52MB + Index: 0.17MB
    mmsp_gf_entry_meta: Data: 2.52MB + Index: 4.55MB
    mmsp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB
    mmsp_gf_form: Data: 0.02MB + Index: 0.00MB
    mmsp_gf_form_meta: Data: 0.16MB + Index: 0.00MB
    mmsp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB
    mmsp_gf_form_view: Data: 0.20MB + Index: 0.19MB
    mmsp_itsec_lockouts: Data: 0.00MB + Index: 0.00MB
    mmsp_itsec_log: Data: 0.00MB + Index: 0.00MB
    mmsp_itsec_temp: Data: 0.00MB + Index: 0.00MB
    mmsp_links: Data: 0.00MB + Index: 0.00MB
    mmsp_masterslider_options: Data: 0.09MB + Index: 0.02MB
    mmsp_masterslider_sliders: Data: 1.52MB + Index: 0.03MB
    mmsp_metaseo_images: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_actions: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_chunks: Data: 0.16MB + Index: 0.00MB
    mmsp_nf3_fields: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_field_meta: Data: 0.41MB + Index: 0.00MB
    mmsp_nf3_forms: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_objects: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_relationships: Data: 0.02MB + Index: 0.00MB
    mmsp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB
    mmsp_ninja_shop_address: Data: 0.02MB + Index: 0.03MB
    mmsp_ninja_shop_line_items: Data: 0.02MB + Index: 0.02MB
    mmsp_ninja_shop_line_itemsmeta: Data: 0.02MB + Index: 0.00MB
    mmsp_ninja_shop_logs: Data: 0.02MB + Index: 0.03MB
    mmsp_ninja_shop_payment_tokens: Data: 0.02MB + Index: 0.00MB
    mmsp_ninja_shop_payment_tokensmeta: Data: 0.02MB + Index: 0.00MB
    mmsp_ninja_shop_refunds: Data: 0.02MB + Index: 0.02MB
    mmsp_ninja_shop_refundsmeta: Data: 0.02MB + Index: 0.00MB
    mmsp_ninja_shop_sessions: Data: 0.31MB + Index: 0.00MB
    mmsp_ninja_shop_transactions: Data: 0.02MB + Index: 0.05MB
    mmsp_nm_personalized: Data: 0.02MB + Index: 0.00MB
    mmsp_options: Data: 2.09MB + Index: 0.11MB
    mmsp_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB
    mmsp_pimwick_gift_card_activity: Data: 0.06MB + Index: 0.02MB
    mmsp_postmeta: Data: 9.67MB + Index: 1.66MB
    mmsp_posts: Data: 0.59MB + Index: 0.16MB
    mmsp_redirects: Data: 0.02MB + Index: 0.00MB
    mmsp_registration_log: Data: 0.00MB + Index: 0.00MB
    mmsp_rg_form: Data: 0.00MB + Index: 0.00MB
    mmsp_rg_form_meta: Data: 0.08MB + Index: 0.00MB
    mmsp_rg_form_view: Data: 0.20MB + Index: 0.09MB
    mmsp_rg_incomplete_submissions: Data: 0.00MB + Index: 0.00MB
    mmsp_rg_lead: Data: 0.43MB + Index: 0.05MB
    mmsp_rg_lead_detail: Data: 0.88MB + Index: 1.17MB
    mmsp_rg_lead_detail_long: Data: 0.00MB + Index: 0.00MB
    mmsp_rg_lead_meta: Data: 0.00MB + Index: 0.00MB
    mmsp_rg_lead_notes: Data: 0.00MB + Index: 0.00MB
    mmsp_signups: Data: 0.00MB + Index: 0.01MB
    mmsp_site: Data: 0.00MB + Index: 0.01MB
    mmsp_sitemeta: Data: 0.07MB + Index: 0.01MB
    mmsp_tcb_api_error_log: Data: 0.00MB + Index: 0.00MB
    mmsp_termmeta: Data: 0.04MB + Index: 0.03MB
    mmsp_terms: Data: 0.01MB + Index: 0.02MB
    mmsp_term_relationships: Data: 0.02MB + Index: 0.04MB
    mmsp_term_taxonomy: Data: 0.01MB + Index: 0.01MB
    mmsp_usermeta: Data: 0.15MB + Index: 0.04MB
    mmsp_users: Data: 0.00MB + Index: 0.01MB
    mmsp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB
    mmsp_wc_download_log: Data: 0.02MB + Index: 0.03MB
    mmsp_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB
    mmsp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
    mmsp_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB
    mmsp_wpms_links: Data: 0.02MB + Index: 0.00MB
    mmsp_zbscrm_api_keys: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_admlog: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_aka: Data: 0.02MB + Index: 0.02MB
    mmsp_zbs_contacts: Data: 0.02MB + Index: 0.02MB
    mmsp_zbs_customfields: Data: 0.02MB + Index: 0.02MB
    mmsp_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB
    mmsp_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB
    mmsp_zbs_externalsources: Data: 0.02MB + Index: 0.02MB
    mmsp_zbs_logs: Data: 0.02MB + Index: 0.02MB
    mmsp_zbs_meta: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_notifications: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_object_links: Data: 0.02MB + Index: 0.03MB
    mmsp_zbs_segments: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_settings: Data: 0.02MB + Index: 0.03MB
    mmsp_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_sys_email: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB
    mmsp_zbs_tags: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_tags_links: Data: 0.02MB + Index: 0.03MB
    mmsp_zbs_temphash: Data: 0.02MB + Index: 0.00MB
    mmsp_zbs_tracking: Data: 0.02MB + Index: 0.00MB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB
    wp_comments: Data: 0.02MB + Index: 0.08MB
    wp_links: Data: 0.02MB + Index: 0.02MB
    wp_options: Data: 0.02MB + Index: 0.02MB
    wp_postmeta: Data: 0.02MB + Index: 0.03MB
    wp_posts: Data: 0.02MB + Index: 0.06MB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB
    wp_terms: Data: 0.02MB + Index: 0.03MB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB
    wp_users: Data: 0.02MB + Index: 0.05MB
    
    ### Post Type Counts ###
    
    acf-field: 5
    acf-field-group: 2
    attachment: 623
    br_product_filter: 1
    carousels: 1
    envira: 2
    erm_menu: 12
    erm_menu_item: 33
    faq: 11
    it_ex_abandond_email: 1
    it_exchange_prod: 44
    it_exchange_tran: 1
    it_exchange_variant: 11
    it_exng_varnt_preset: 5
    jetpack_migration: 2
    nav_menu_item: 73
    page: 58
    portfolio: 1
    post: 15
    product: 120
    product_variation: 154
    redirect_rule: 25
    revision: 24
    sa_slider: 1
    scheduled-action: 12
    shop_coupon: 3
    shop_order: 284
    shop_order_refund: 1
    tcb_content_template: 1
    wc_order_email: 4
    wc_order_status: 11
    wcpcsu-custom-post: 1
    wcpcsu-custom-pro: 4
    woo_discount: 3
    wpephpcompat_jobs: 8
    zerobs_quo_template: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (39) ###
    
    Gravity Forms: by rocketgenius – 2.4.11
    Advanced Custom Fields: by Elliot Condon – 5.8.3
    Advanced Woo Search: by ILLID – 1.78
    All In One SEO Pack: by Michael Torbert – 3.2.4
    Arconix FAQ: by Tyche Softwares – 1.8.3
    Black Studio TinyMCE Widget: by Black Studio – 2.6.9
    Classic Editor: by WordPress Contributors – 1.5
    Coming Soon Page, Under Construction & Maintenance Mode by SeedProd: by SeedProd – 5.1.0
    Custom Facebook Feed: by Smash Balloon – 2.9.1
    Easy WP SMTP: by wpecommerce
    alexanderfoxc – 1.3.9.1
    
    Envira Gallery Lite: by Envira Gallery Team – 1.6.7
    Genesis Connect for WooCommerce: by StudioPress – 1.1.0
    Health Check & Troubleshooting: by The WordPress.org community – 1.4.0
    Instagram Feed: by Smash Balloon – 1.12.2
    Jetpack by WordPress.com: by Automattic – 7.6
    Mango Buttons: by Phil Baylog – 1.2.9
    Master Slider Pro: by averta – 3.2.14
    Max Mega Menu - Pro Addon: by megamenu.com – 1.9
    Max Mega Menu: by megamenu.com – 2.7.1.4
    PW WooCommerce Gift Cards Pro: by Pimwick
    LLC – 1.127
    
    Quick Restaurant Menu: by ThingsForRestaurants – 1.7.0
    WooCommerce Cart: by XootiX – 1.0.2 – Not tested with the active version of WooCommerce
    Simple 301 Redirects: by Scott Nellé – 1.07
    Thrive Architect: by <a href="http://www.thrivethemes.com">Thrive Themes</a> – 2.2.1
    Ultimate Before After Slider: by ForeverThemes – 1.3.0
    Woo Discount Rules: by Flycart Technologies LLP – 1.8.2
    WooCommerce Blocks: by Automattic – 2.3.0
    Abandoned Cart Pro for WooCommerce: by Tyche Softwares – 8.1.0
    Advanced AJAX Product Filters for WooCommerce: by BeRocket – 1.3.3.2
    WooCommerce Elavon Converge Gateway: by SkyVerge – 2.5.0
    WooCommerce Google Analytics Pro: by SkyVerge – 1.8.0
    WooCommerce Order Status Manager: by SkyVerge – 1.10.2
    WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.3.4
    PPOM for WooCommerce by N-MEDIA: by Najeeb Ahmad – 18.9
    WooCommerce Product Carousel, Slider & Grid Ultimate Pro: by Aazztech – 1.2.4 – Not tested with the active version of WooCommerce
    WooCommerce Services: by Automattic – 1.21.1 – 1.22.2 is available
    WooCommerce Table Rate Shipping: by WooCommerce – 3.0.15
    WooCommerce Variation Swatches and Photos: by Lucas Stark – 3.0.12
    WooCommerce: by Automattic – 3.6.4 – 3.8.1 is available
    
    ### Inactive Plugins (5) ###
    
    WooCommerce Extended Coupon Features FREE: by Soft79 – 3.1.0
    WooCommerce One Page Checkout: by Prospress Inc. – 1.6.0 – Not tested with the active version of WooCommerce
    WooCommerce Product Carousel, Slider and Grid Ultimate: by AazzTech – 1.4.0
    WooCommerce Store Credit: by WooCommerce – 2.4.6
    WOOCS - WooCommerce Currency Switcher: by realmag777 – 1.2.9.1
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (5) ###
    
    Force Strong Passwords - WPE Edition: by Jason Cosper – 1.6.4
    Health Check Troubleshooting Mode: by  – 1.6.0
    WP Engine Seamless Login Plugin: by WP Engine – 1.3.0
    WP Engine Security Auditor: by wpengine – 1.0.8
    WP Engine System: by WP Engine – 3.2.2
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: CAD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    pw gift card (pw-gift-card)
    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: ✔
    
    ### WC Pages ###
    
    Shop base: ❌ Page not set
    Cart: #1672 - /cart/
    Checkout: #1673 - /checkout-2/
    My account: ❌ Page visibility should be public
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Simply Pro
    Version: 1.0.0
    Author URL: http://www.bloomblogshop.com
    Child Theme: ✔
    Parent Theme Name: Genesis
    Parent Theme Version: 2.10.1
    Parent Theme Author URL: https://www.studiopress.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: simply-pro/woocommerce/emails/customer-completed-order.php
    simply-pro/woocommerce/emails/customer-processing-order.php
    
    ### Elavon Converge Credit Card ###
    
    Environment: Production
    Tokenization Enabled: –
    Debug Mode: Off
    
    ### Action Scheduler ###
    
    Complete: 10
    Oldest: 2019-12-04 12:15:42 -0800
    Newest: 2020-01-01 12:23:07 -0800
    
    Pending: 2
    Oldest: 2020-01-08 12:23:07 -0800
    Newest: 2020-01-08 12:23:07 -0800
    
    Canceled: 0
    Oldest: –
    Newest: –
    
    In-progress: 0
    Oldest: –
    Newest: –
    
    Failed: 0
    Oldest: –
    Newest: –
    
    

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hi Andre,

    Just did a quick test by adding an $80 product for shipping to ON. With shipping it charges me HST @ $10.40 but it seems to be slightly more than 13% as it should be $11.69, but when I choose Flat rate it goes back to 7% PST and 5% GST – which is correct.

    Hope this helps in your quest.

    Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    Hi @albertandbrown

    Could you confirm that tax rates are configured to calculate against shipping and which address is used to calculate taxes?

    https://docs.woocommerce.com/document/setting-up-taxes-in-woocommerce/#section-4

    Also, the tax rate listed at the top of the tax table is prioritized over any rates below. Please confirm that the specific tables are listed above those that are general.

    https://d.pr/i/oHwf9E

    Could you provide us with your specific setup so we can try to replicate the problem?

    Thanks,

    Hi John,
    Your message should be sent to andre2015 (@andre2015) who posted the problem, my reply was an attempt to help troubleshoot.

    Jesse Pearson (a11n)

    (@jessepearson)

    Automattic Happiness Engineer

    @andre2015 Can you take a look at the above reply and questions 🙂

    Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    @albertandbrown Oversight on my part 🙂

    @andre2015

    We haven’t heard back from you so we’re going to mark this support thread resolved. Please open a new thread should you find this tax issue persists with the most recent version of WooCommerce.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘GST & PST taxes flipping when different shipping options are selected’ is closed to new replies.