• Resolved CMBOU

    (@babilibo)


    Hello,

    I have two products in my shop which must have the standard tax class for province A and the reduced class for province B.
    Province A: Standard rate (GST 5% + QST 9.9750%)
    Province B: Reduce rate (HST 5%)

    So, I created a new tax class “Other rate” for these two products in particular.
    Province A: Other rate (GST 5% + QST 9.9750%)
    Province B: Other rate (HST 5%)

    My problem is that now on the invoice from province A, both taxes appear twice. If a customer buys one of his two products in “other rate” class and “standard class” products, the taxes of his products of different class do not add up in a single GST and QST. I would like to find a way to make the system understand that there are only two taxes…

    EXAMPLE:
    Product (“other rate”) $5.99
    Product (“Standard rate”) $10.99
    Subtotal: $16.98
    Delivery (“standard rate”) $7.99

    GST $0.95
    QST $1.90
    GST $0.30
    QST $0.60

    Total: $28.72

    WHAT I WANT:
    Product (“other rate”) $5.99
    Product (“Standard rate”) $10.99
    Subtotal: $16.98
    Delivery (“standard rate”) $7.99

    GST $1.25
    QST $2.50

    Total: $28.72

    All your solutions are welcome, thank you in advance for your help ??

Viewing 15 replies - 1 through 15 (of 18 total)
  • Hi @babilibo

    Thanks for reaching out!

    Just to be sure that I replicate your scenario on my test site, could you please provide us with clear screenshots of the Tax Settings, Tax Classes and the Product Page for us to check this further?

    I’d recommend using https://snipboard.io or https://skitch.com/. You can share the direct link to the image as a response to this topic.

    Thread Starter CMBOU

    (@babilibo)

    Hello xue28

    Here are the screenshots:
    Tax Settings: https://snipboard.io/mSwPpY.jpg

    Tax Classes:
    https://snipboard.io/41mNM0.jpg (standard rate)
    https://snipboard.io/knd9ZK.jpg (other rate)

    and I also have a reduced tax class: https://snipboard.io/SrxwO8.jpg

    Product: https://snipboard.io/eodha8.jpg

    Hello,

    Thanks for the info.

    Please note, we are not tax experts (A local tax expert can help you to configure your taxes according to the law in your country).

    My recommendation is testing on a staging environment first. Your web host can help to configure a staging site for you, or you can use WP Staging for quickly spinning up a new test site.

    On my testing site, I did this configuration:


    Link to image: https://snipboard.io/N6YodH.jpg

    And this is the result:

    Link to image: https://snipboard.io/Wi04Us.jpg

    It changes when I select other provinces, let us know if there are any questions ??

    • This reply was modified 2 years, 4 months ago by Igor H.
    • This reply was modified 2 years, 4 months ago by Igor H.
    Thread Starter CMBOU

    (@babilibo)

    Hello Igor H.

    I understand that you are not tax experts and this is not my question.

    My problem is that I have different products that are reduced in different places and others not (then it’s not always the same product). If I only had one tax class to apply to my site, I wouldn’t have this problem…

    I’m not sure I understand what I should do in this specific case to avoid having 2 taxes doubled (a tax for product A (“standard rate” GST AND TVQ) + product B (“Other rate” GST AND TVQ ) on my invoice and get my products at the right rate from province to province?

    I tested what I thought worked, but it’s the best I managed to do… I don’t understand what more I could do on a staging site?

    Thread Starter CMBOU

    (@babilibo)

    Is there a way in the product to put different classes for each of the provinces? Because from what I read the only way is to create the new class in the tax settings… If I’m wrong and you have another way to do it I’m open to any solution ??

    Thread Starter CMBOU

    (@babilibo)

    For reference, here is a screenshot of my order page https://snipboard.io/9Mw2dK.jpg

    Hi,

    Thanks for the info.

    To take a closer look, please provide your website URL, and 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”.?

    Thank you.

    Thread Starter CMBOU

    (@babilibo)

    Hello,

    Note that I deactivated the second province on my site due to the conflict caused on my invoice as mentioned above…

    Here is the system information:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.babilibou.ca
    Site address (URL): https://www.babilibou.ca
    WC Version: 7.0.1
    REST API Version: ? 7.0.1
    WC Blocks Version: ? 8.5.2
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.1
    WP Multisite: –
    WP Memory Limit: 512 Mo
    WP Debug Mode: –
    WP Cron: ?
    Language: fr_CA
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.32
    PHP Post Max Size: 300 Mo
    PHP Time Limit: 600
    PHP Max Input Vars: 30000
    cURL Version: 7.71.0
    OpenSSL/1.1.1p
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.36-MariaDB
    Max Upload Size: 300 Mo
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 4.9.2
    WC Database Prefix: wp_
    Taille totale de la base de données: 116.38MB
    Taille de la base de données: 102.59MB
    Taille des index de la base de données: 13.79MB
    wp_woocommerce_sessions: Données?: 0.27MB + Index?: 0.02MB + Moteur InnoDB
    wp_woocommerce_api_keys: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_woocommerce_attribute_taxonomies: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_woocommerce_downloadable_product_permissions: Données?: 0.02MB + Index?: 0.06MB + Moteur InnoDB
    wp_woocommerce_order_items: Données?: 0.09MB + Index?: 0.05MB + Moteur InnoDB
    wp_woocommerce_order_itemmeta: Données?: 2.52MB + Index?: 0.61MB + Moteur InnoDB
    wp_woocommerce_tax_rates: Données?: 0.02MB + Index?: 0.06MB + Moteur InnoDB
    wp_woocommerce_tax_rate_locations: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_woocommerce_shipping_zones: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_woocommerce_shipping_zone_locations: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_woocommerce_shipping_zone_methods: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_woocommerce_payment_tokens: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_woocommerce_payment_tokenmeta: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_woocommerce_log: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    ftlp_limitlogin_attempts_logs: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_actionscheduler_actions: Données?: 0.45MB + Index?: 0.42MB + Moteur InnoDB
    wp_actionscheduler_claims: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_actionscheduler_groups: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_actionscheduler_logs: Données?: 0.27MB + Index?: 0.19MB + Moteur InnoDB
    wp_aepc_custom_audiences: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_aepc_logs: Données?: 0.05MB + Index?: 0.00MB + Moteur InnoDB
    wp_cartflows_ca_cart_abandonment: Données?: 1.52MB + Index?: 0.02MB + Moteur InnoDB
    wp_cartflows_ca_email_history: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_cartflows_ca_email_templates: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_cartflows_ca_email_templates_meta: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_commentmeta: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_comments: Données?: 0.16MB + Index?: 0.09MB + Moteur InnoDB
    wp_ewp_automation_queue: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_ewp_automation_queue_activity: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_ewp_automation_woocommerce_carts: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_ewp_subscribers: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_ewwwio_images: Données?: 1.52MB + Index?: 0.47MB + Moteur InnoDB
    wp_ewwwio_queue: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_e_events: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_frm_fields: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_frm_forms: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_frm_items: Données?: 0.02MB + Index?: 0.08MB + Moteur InnoDB
    wp_frm_item_metas: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_giftvouchers_activity: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_giftvouchers_list: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_giftvouchers_setting: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_giftvouchers_template: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_glsr_assigned_posts: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_glsr_assigned_terms: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_glsr_assigned_users: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_glsr_ratings: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_gpf_feeds: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_hustle_entries: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_hustle_entries_meta: Données?: 0.05MB + Index?: 0.05MB + Moteur InnoDB
    wp_hustle_modules: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_hustle_modules_meta: Données?: 1.52MB + Index?: 0.03MB + Moteur InnoDB
    wp_hustle_tracking: Données?: 0.05MB + Index?: 0.08MB + Moteur InnoDB
    wp_links: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_mailchimp_carts: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_mailchimp_jobs: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_ms_snippets: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_nextend2_image_storage: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_nextend2_section_storage: Données?: 0.06MB + Index?: 0.06MB + Moteur InnoDB
    wp_nextend2_smartslider3_generators: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_nextend2_smartslider3_sliders: Données?: 0.08MB + Index?: 0.03MB + Moteur InnoDB
    wp_nextend2_smartslider3_sliders_xref: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_nextend2_smartslider3_slides: Données?: 0.48MB + Index?: 0.11MB + Moteur InnoDB
    wp_nm_personalized: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_options: Données?: 6.36MB + Index?: 0.28MB + Moteur InnoDB
    wp_pimwick_gift_card: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_pimwick_gift_card_activity: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_postmeta: Données?: 22.52MB + Index?: 3.03MB + Moteur InnoDB
    wp_posts: Données?: 13.52MB + Index?: 0.27MB + Moteur InnoDB
    wp_pts_tables: Données?: 0.47MB + Index?: 0.00MB + Moteur InnoDB
    wp_redirection_404: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_redirection_groups: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_redirection_items: Données?: 0.02MB + Index?: 0.09MB + Moteur InnoDB
    wp_redirection_logs: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_reviewx_criterias: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_reviewx_process_jobs: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_reviewx_reminder_email: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_shortpixel_folders: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_shortpixel_meta: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_smush_dir_images: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_snippets: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_stock_log: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_termmeta: Données?: 0.05MB + Index?: 0.03MB + Moteur InnoDB
    wp_terms: Données?: 0.05MB + Index?: 0.03MB + Moteur InnoDB
    wp_term_relationships: Données?: 0.09MB + Index?: 0.06MB + Moteur InnoDB
    wp_term_taxonomy: Données?: 0.05MB + Index?: 0.03MB + Moteur InnoDB
    wp_tm_taskmeta: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_tm_tasks: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_trp_dictionary_fr_ca_en_ca: Données?: 1.52MB + Index?: 0.52MB + Moteur InnoDB
    wp_trp_gettext_en_ca: Données?: 1.52MB + Index?: 0.52MB + Moteur InnoDB
    wp_trp_gettext_fr_ca: Données?: 1.52MB + Index?: 0.64MB + Moteur InnoDB
    wp_trp_original_meta: Données?: 0.14MB + Index?: 0.19MB + Moteur InnoDB
    wp_trp_original_strings: Données?: 1.52MB + Index?: 0.30MB + Moteur InnoDB
    wp_UPCP_Catalogues: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Catalogue_Items: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Categories: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Custom_Fields: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Fields_Meta: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Items: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Item_Images: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_SubCategories: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Tagged_Items: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Tags: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Tag_Groups: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_UPCP_Videos: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_usermeta: Données?: 0.25MB + Index?: 0.09MB + Moteur InnoDB
    wp_users: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_user_registration_sessions: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_vtprd_purchase_log: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_vtprd_purchase_log_product: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_vtprd_purchase_log_product_rule: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_vtprd_transient_cart_data: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wccs_conditions: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wccs_condition_meta: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wcpdf_invoice_number: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wcpdf_packing_slip_number: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wcusage_activity: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wcusage_clicks: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wcusage_register: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wc_admin_notes: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wc_admin_note_actions: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wc_category_lookup: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wc_customer_lookup: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wc_download_log: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wc_mewz_wcas_match_rows: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_wc_mewz_wcas_match_sets: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wc_order_coupon_lookup: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wc_order_product_lookup: Données?: 0.09MB + Index?: 0.06MB + Moteur InnoDB
    wp_wc_order_stats: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_wc_order_tax_lookup: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wc_product_attributes_lookup: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wc_product_download_directories: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wc_product_meta_lookup: Données?: 0.08MB + Index?: 0.13MB + Moteur InnoDB
    wp_wc_rate_limits: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wc_reserved_stock: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wc_tax_rate_classes: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wc_webhooks: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wdp_orders: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_wdp_order_items: Données?: 0.02MB + Index?: 0.06MB + Moteur InnoDB
    wp_wdp_rules: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wdr_order_discounts: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wdr_order_item_discounts: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_wdr_rules: Données?: 0.14MB + Index?: 0.00MB + Moteur InnoDB
    wp_wfblockediplog: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wfblocks7: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_wfconfig: Données?: 0.48MB + Index?: 0.00MB + Moteur InnoDB
    wp_wfcrawlers: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wffilechanges: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wffilemods: Données?: 23.56MB + Index?: 0.00MB + Moteur InnoDB
    wp_wfhits: Données?: 1.28MB + Index?: 0.17MB + Moteur InnoDB
    wp_wfhoover: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wfissues: Données?: 0.02MB + Index?: 0.06MB + Moteur InnoDB
    wp_wfknownfilelist: Données?: 11.52MB + Index?: 0.00MB + Moteur InnoDB
    wp_wflivetraffichuman: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wflocs: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wflogins: Données?: 0.30MB + Index?: 0.11MB + Moteur InnoDB
    wp_wfls_2fa_secrets: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wfls_settings: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wfnotifications: Données?: 0.08MB + Index?: 0.00MB + Moteur InnoDB
    wp_wfpendingissues: Données?: 0.02MB + Index?: 0.06MB + Moteur InnoDB
    wp_wfreversecache: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_wfsnipcache: Données?: 0.02MB + Index?: 0.05MB + Moteur InnoDB
    wp_wfstatus: Données?: 0.13MB + Index?: 0.11MB + Moteur InnoDB
    wp_wftrafficrates: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_woocommerce_bundled_itemmeta: Données?: 1.52MB + Index?: 1.89MB + Moteur InnoDB
    wp_woocommerce_bundled_items: Données?: 0.06MB + Index?: 0.09MB + Moteur InnoDB
    wp_woo_shippment_provider: Données?: 0.09MB + Index?: 0.00MB + Moteur InnoDB
    wp_woo_wallet_transactions: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_woo_wallet_transaction_meta: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wp2lwtsr_reviewmeta: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_wp2lwtsr_reviews: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wpc_comments_subscription: Données?: 0.00MB + Index?: 0.00MB + Moteur MyISAM
    wp_wpc_phrases: Données?: 0.00MB + Index?: 0.01MB + Moteur MyISAM
    wp_wpc_users_voted: Données?: 0.00MB + Index?: 0.00MB + Moteur MyISAM
    wp_wpfb_gettwitter_forms: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_wpforms_tasks_meta: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_yith_wcwl: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_yith_wcwl_lists: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_yoast_indexable: Données?: 1.52MB + Index?: 0.34MB + Moteur InnoDB
    wp_yoast_indexable_hierarchy: Données?: 0.06MB + Index?: 0.08MB + Moteur InnoDB
    wp_yoast_migrations: Données?: 0.02MB + Index?: 0.02MB + Moteur InnoDB
    wp_yoast_primary_term: Données?: 0.02MB + Index?: 0.03MB + Moteur InnoDB
    wp_yoast_seo_links: Données?: 0.19MB + Index?: 0.13MB + Moteur InnoDB
    wp_za_add_ons: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_za_categories_to_groups: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_za_groups: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_za_headers: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_za_products_to_groups: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_za_types: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    wp_za_values: Données?: 0.02MB + Index?: 0.00MB + Moteur InnoDB
    
    ### Post Type Counts ###
    
    acoplw_badges: 1
    al_product: 2
    attachment: 525
    awdp_pt_rules: 1
    br_product_tab: 2
    br_tabs_location: 1
    cartflows_flow: 1
    cartflows_step: 2
    custom_css: 2
    custom-css-js: 2
    customize_changeset: 1
    elementor_library: 17
    frm_form_actions: 2
    frm_styles: 1
    giftcard: 4
    language_switcher: 4
    mewz_attribute_stock: 12
    nav_menu_item: 8
    oceanwp_library: 1
    oembed_cache: 15
    page: 60
    polylang_mo: 2
    post: 1
    product: 120
    product_variation: 89
    product-feed: 1
    question: 1
    question_answer: 5
    revision: 603
    shop_coupon: 17
    shop_order: 106
    shop_order_refund: 1
    user_registration: 1
    voucher_template: 1
    vtprd-rule: 1
    wafs: 1
    wc_dynamic_pricing: 1
    wof_lite_wheel: 2
    woo_discount: 3
    woo_discount_cart: 1
    wp_global_styles: 1
    wpdesk-coupons: 5
    wpforms: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (41) ###
    
    CartFlows: par CartFlows Inc – 1.11.2
    Simple Custom CSS and JS: par SilkyPress.com – 3.41
    Elementor: par Elementor.com – 3.8.0
    Email Templates: par wpexpertsio – 1.3.2.1
    Erident Custom Login and Dashboard: par David Vongries – 4.2
    Essential Addons for Elementor: par WPDeveloper – 5.4.2
    Facebook Chat Plugin - Live Chat Plugin for WordPress: par Meta – 2.5
    Jetpack: par Automattic – 11.5.1
    Limit Login Attempts Reloaded: par Limit Login Attempts Reloaded – 2.25.8
    Loco Translate: par Tim Whitlock – 2.6.3
    Ocean Extra: par OceanWP – 2.0.5
    PixelYourSite: par PixelYourSite – 9.2.1
    Product Bundles - Bulk Discounts: par SomewhereWarm – 1.3.9
    Product Bundles - Min/Max Items: par SomewhereWarm – 1.4.3
    Product Bundles - Variation Bundles: par franticpsyx – 1.1.3
    Product Tabs Manager for WooCommerce: par BeRocket – 1.1.5.6
    Really Simple SSL: par Really Simple Plugins – 6.0.3
    Redirection: par John Godley – 5.3.4
    Regenerate Thumbnails: par Alex Mills (Viper007Bond) – 3.1.5
    Side Cart WooCommerce: par XootiX – 2.1
    Smart Slider 3: par Nextend – 3.5.1.11
    UpdraftPlus - Backup/Restore: par UpdraftPlus.Com
    DavidAnderson – 1.22.23
    
    Suivi avancé des envois pour WooCommerce: par zorem – 3.4.7
    WooCommerce Cart Abandonment Recovery: par CartFlows Inc – 1.2.19
    Coupon Affiliates for WooCommerce: par RelyWP – 5.2.0.1
    Woo Discount Rules PRO 2.0: par Flycart – 2.5.1
    Woo Discount Rules: par Flycart – 2.5.0
    Photo Reviews for WooCommerce: par VillaTheme – 1.2.3
    Payment Plugins for Stripe WooCommerce: par Payment Plugins
    [email protected] – 3.3.31
    
    TeraWallet: par WCBeginner – 1.3.24
    WooCommerce Extended Coupon Features FREE: par Soft79 – 3.2.9
    PDF Invoices & Packing Slips for WooCommerce: par WP Overnight – 3.2.3
    WooCommerce Product Bundles: par SomewhereWarm – 6.3.5
    WooCommerce Shipping & Tax: par WooCommerce – 1.26.3
    WooCommerce: par Automattic – 7.0.1
    Wordfence Security: par Wordfence – 7.7.1
    Hustle: par WPMU DEV – 7.6.0
    Yoast SEO: par L’équipe Yoast – 19.9
    WP-Optimize - Clean, Compress, Cache: par David Anderson
    Ruhani Rabin
    Team Updraft – 3.2.9
    
    WPForms Lite: par WPForms – 1.7.7.2
    WPS Hide Login: par WPServeur
    NicolasKulka
    wpformation – 1.9.6
    
    ### Inactive Plugins (2) ###
    
    Polylang: par WP SYNTEX – 3.2.8
    TranslatePress - Multilingual: par Cozmoslabs
    Razvan Mocanu
    Madalin Ungureanu
    Cristophor Hurduban – 2.4.0
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (3) ###
    
    installatron_hide_status_test.php: par  –
    p3-profiler.php: par  –
    rsssl_rest_api_optimizer.php: par  –
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: CAD ($)
    Currency Position: right
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    composite (composite)
    external (external)
    gift-card (gift-card)
    grouped (grouped)
    pw gift card (pw-gift-card)
    simple (simple)
    variable (variable)
    wgm_gift_card (wgm_gift_card)
    wooco (wooco)
    woosb (woosb)
    
    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: –
    
    ### WC Pages ###
    
    Base boutique: #333 - /boutique-de-couches-lavables/
    Panier: #334 - /panier/
    Commande: #335 - /checkout/
    Mon compte: #8438 - /mon-compte-babilibou/
    Conditions générales de vente et d’utilisation: #802 - /termes-conditions/
    
    ### Theme ###
    
    Name: OceanWP
    Version: 3.3.5
    Author URL: https://oceanwp.org/about-oceanwp/
    Child Theme: ? – Si vous modifiez WooCommerce sur un thème parent que vous n’vez pas construit personnellement
    nous vous recommandons d’utiliser un thème enfant. Voir: Comment créer un thème enfant
    
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: oceanwp/woocommerce/cart/mini-cart.php
    oceanwp/woocommerce/content-single-product.php
    oceanwp/woocommerce/loop/loop-start.php
    oceanwp/woocommerce/single-product/title.php
    
    ### Product Bundles ###
    
    Database Version: 6.3.5
    Loopback Test: ?
    Template Overrides: –
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-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: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2022-11-03 18:30:00 -04:00
    Options: ?
    Notes: 30
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Terminer: 1?030
    Oldest: 2022-10-03 17:05:04 -0400
    Newest: 2022-11-03 12:12:37 -0400
    
    En attente: 9
    Oldest: 2022-11-03 13:12:37 -0400
    Newest: 2022-11-08 17:46:39 -0500
    
    ### Status report information ###
    
    Generated at: 2022-11-03 12:55:43 -04:00
    
    Saif

    (@babylon1999)

    Hello @babilibo,

    I did some testing and I’m able to understand what you mean here. Correct me if I’m wrong, but you want when a user chooses two products that have the same tax name, the price of the two taxes are concatenated under one name.

    The tax name functionality wasn’t designed with this use case in mind but rather to render what the tax is called in the country you’re selling for like VAT, Tax, or translate the string in another language.

    I can advise switching your tax to show as a total instead, but I’m not sure if it’s a solution you’ll be happy with.


    Link to image: https://i.imgur.com/iIeYQQH.png

    You’ll need a custom snippet to achieve what you’re trying to do which is not within our scope of support here in the forums.

    I’m going to leave it open for a bit to see if anyone is able to chime in to help you out.

    You can also visit the WooCommerce Facebook group or the #developers channel of the WooCommerce Community Slack. We’re lucky to have a great community of open-source developers for WooCommerce, and many of our developers hang out there, as well.

    Cheers!

    Thread Starter CMBOU

    (@babilibo)

    Hello Saif H.

    What I don’t understand is that my products in standard and reduced tax class work together… The totals on my invoice for province 1 are merged into a single GST and QST (even when I have products in standard class and reduced class in my order)!

    Standard rate
    5% GST + 9.9750% QST (province 1)
    13% HST (province 2)

    Reduced rate
    5% GST (province 1)
    5% HST (province 2)

    But when I create a special tax class for my 2 products that are at a reduced rate in ONE province only (standard rate in province 1 and reduced rate in province 2)

    = “other rate” (New class)
    5% GST + 9.9750% QST (province 1)
    5% HST (province 2)

    This tax class becomes independent of the other classes instead of mixing with them…
    I don’t know if that means anything, but it’s when I add the QST tax (second taxe) from my province 1 that the 2 taxes on my bill become 2xTPS/2xQST. If I would only have the 5% GST tax for province 1 the total taxes would add up to the other tax class to be only 1xGST/QST.

    But I need it’s 2 products to be in standard class for province 1, which means GST and QST.

    Then my invoice must be detailed with the two taxes so I could not make a single total tax… I don’t know if it’s understandable, but I hope so…

    My solution may not be to create a new tax class, I don’t now. I’m going to try my luck on facebook groups…

    Thanks for your help ??

    Hi @babilibo

    I was not able to replicate your issue on my test site as I am only getting one tax class appear on my end as seen here:

    Image Link: https://snipboard.io/EVl46t.jpg

    Maybe, my configuration is wrong or I am missing something. I already added the tax classes based on your screenshot above and have one variable product under the Other Rate tax class.

    If you could please provide a screenshot of what should be the output here as well as the products to be tested, that would help us further investigate your issue.

    Thanks!

    Thread Starter CMBOU

    (@babilibo)

    Hello xue28

    in your example photo, you used HST ((TVH) province 2).
    My problem is with province 1 which has two taxes (GST and QST).

    province 1
    STANDARD rate = 5% GST (TPS) + 9.9750% QST (TVQ) https://snipboard.io/41mNM0.jpg

    REDUCED rate = 5% GST (TPS)
    https://snipboard.io/SrxwO8.jpg

    “OTHER RATE” (New class) = 5% GST (TPS) + 9.9750% QST (TVQ)
    https://snipboard.io/knd9ZK.jpg

    Standard and reduced rate products are ok. But if I add an “other rate” product and a standard/reduced rate product to my basket, that’s where I have a problem. (that my GST and QST appear twice each)

    In this example: https://snipboard.io/9Mw2dK.jpg
    the product at $5.99 = “other rate” (5% GST (TPS) + 9.9750% QST (QST))
    the product at $10.99 and delivery (livraison) 7,99$ = Standard rate = 5% GST (TPS) + 9.9750% QST (QST)

    Thanks for your help

    Saif

    (@babylon1999)

    Hello @babilibo,

    Thank you for explaining it further, seems like this is a priority thing.

    Can you please try the following setup as shown in the screenshots below with the priority and compound checked?


    Link to image: https://i.imgur.com/cBaYUkd.png


    Link to image: https://i.imgur.com/zpyQ1Be.png


    Link to image: https://i.imgur.com/F32nMTH.png

    The taxes should group under one name which I believe is what you’re looking for.

    Please try it and let us know how it goes. ??

    Thread Starter CMBOU

    (@babilibo)

    Hello Saif H.

    I reproduced the same configuration as in the photos, but my problem is still present…
    My taxes are always duplicated on my cart…

    And with this configuration the problem is that the first tax on my invoice must be the GST(TPS) and that it must not be added to the amount already taxed from my QST(TVQ)…

    Thanks for your help

    Saif

    (@babylon1999)

    Hello @babilibo,

    I reproduced the same configuration as in the photos, but my problem is still present…
    My taxes are always duplicated on my cart…

    I tried replicating your setup, but the taxes are concatenated.

    Could you please check if there are any tax-related error logs in WooCommerce > Status > Logs?

    And with this configuration the problem is that the first tax on my invoice must be the GST(TPS) and that it must not be added to the amount already taxed from my QST(TVQ)…

    Just to make sure I understand this correctly, you want the GST to render first and for its tax value not to be counted in QST.

    In that case, just switch the priorities to have all the GSTs have 1 and QSTs 2. Also, remove and uncheck the compound option.

    The end result should look like this, which I assume is what you’re looking for. I kept the product prices to 100 to make it easier for you to do the calculation.


    Link to image: https://i.imgur.com/mYfIsR2.png

    Look forward to hearing back from you.

    • This reply was modified 2 years, 4 months ago by Saif. Reason: I meant to ask for the error logs. ??
Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘Multiple tax rates and classes in the same product. Invoice problem’ is closed to new replies.