Multiple tax rates and classes in the same product. Invoice problem
-
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.99GST $0.95
QST $1.90
GST $0.30
QST $0.60Total: $28.72
WHAT I WANT:
Product (“other rate”) $5.99
Product (“Standard rate”) $10.99
Subtotal: $16.98
Delivery (“standard rate”) $7.99GST $1.25
QST $2.50Total: $28.72
All your solutions are welcome, thank you in advance for your help ??
-
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.
Hello xue28
Here are the screenshots:
Tax Settings: https://snipboard.io/mSwPpY.jpgTax 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.jpgAnd this is the result:
Link to image: https://snipboard.io/Wi04Us.jpgIt changes when I select other provinces, let us know if there are any questions ??
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?
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 ??
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.
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
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.pngYou’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!
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!
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.jpgREDUCED rate = 5% GST (TPS)
https://snipboard.io/SrxwO8.jpg“OTHER RATE” (New class) = 5% GST (TPS) + 9.9750% QST (TVQ)
https://snipboard.io/knd9ZK.jpgStandard 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
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.pngThe 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. ??
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
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.pngLook 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. ??
-
This reply was modified 2 years, 4 months ago by
- The topic ‘Multiple tax rates and classes in the same product. Invoice problem’ is closed to new replies.