Affiliate Product Tax malfunction
-
Hi. I’ve got WooCommerce set so that it shows prices (21% VAT) tax included. When I add an Affiliate Product with its final price, it is shown in frontend with a 21% price reduction (vat is discounted) thus not showing real price to customers.
-
Hi there,
I’d like to understand your setup a bit more. Is this the gist?
Product price = 100 Euros
VAT = 21%
Price should be shown as = 121 EurosHowever, the affiliate product is showing as only 100 Euros? Or is the affiliate product showing as 79 Euros?
Does the correct price appear in the cart or checkout? Or is it incorrect throughout?
Can you give us more details about your site’s setup and a link to the affiliate product that is not behaving as expected?
In addition, could you 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”. Once you’ve done that, paste it here in your response.
If you’re having trouble with Affiliate for WooCommerce, please contact us at WooCommerce.com > My Account > Tickets with these details as well as a link to this forum post in your message so we can keep track of the conversation.
Hello Nancy,
It’s the second way.
Product price = 100 Euros
VAT = 21%
Price should be shown as = 100 Euros (since I’ve got the option “Prices entered with tax” as “Yes, I will enter prices inclusive of tax)It works Ok with single or variation products, but the affiliate product is shown as 82 Euros if I set its price to 100€ -(100€ is supposed to be final price but WooCommerce keeps showing 82€ on the frontend)-.
Since it’s an affiliate product, there’s no cart nor checkout.When you clikc on it, you’re redirected to the URL the product relates to.
Here’s my system status:
### WordPress Environment ### WordPress address (URL): https://salteando.com Site address (URL): https://salteando.com WC Version: 4.4.1 REST API Version: ✔ 1.0.15 WC Blocks Version: ✔ 3.1.0 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.4.0 Log Directory Writable: ✔ WP Version: 5.5.1 WP Multisite: ✔ WP Memory Limit: 1 GB WP Debug Mode: – WP Cron: ✔ Language: es_ES External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.9 PHP Post Max Size: 100 MB PHP Time Limit: 300 PHP Max Input Vars: 3000 cURL Version: 7.62.0 OpenSSL/1.0.2k SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.23-MariaDB-cll-lve Max Upload Size: 1 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 4.4.1 WC Database Prefix: saltwps_ Tamaño total de la base de datos: 18.21MB Tamaño de los datos de la base de datos: 10.33MB Tamaño del índice de la base de datos: 7.88MB saltwps_woocommerce_sessions: Datos: 0.13MB + Índice: 0.02MB + Motor InnoDB saltwps_woocommerce_api_keys: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_woocommerce_attribute_taxonomies: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_woocommerce_downloadable_product_permissions: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB saltwps_woocommerce_order_items: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_woocommerce_order_itemmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_woocommerce_tax_rates: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB saltwps_woocommerce_tax_rate_locations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_woocommerce_shipping_zones: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB saltwps_woocommerce_shipping_zone_locations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_woocommerce_shipping_zone_methods: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB saltwps_woocommerce_payment_tokens: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_woocommerce_payment_tokenmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_woocommerce_log: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_actionscheduler_actions: Datos: 0.02MB + Índice: 0.11MB + Motor InnoDB saltwps_actionscheduler_claims: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_actionscheduler_groups: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_actionscheduler_logs: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_adsw_activities: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB saltwps_adsw_ali_meta: Datos: 0.06MB + Índice: 0.03MB + Motor InnoDB saltwps_adsw_comments_hash: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_adsw_search_analytics: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_adsw_task_upload_images: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_adsw_variations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_blogmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_blogs: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_commentmeta: Datos: 0.06MB + Índice: 0.03MB + Motor InnoDB saltwps_comments: Datos: 0.06MB + Índice: 0.09MB + Motor InnoDB saltwps_itsec_distributed_storage: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_itsec_fingerprints: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_itsec_geolocation_cache: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_itsec_lockouts: Datos: 0.19MB + Índice: 0.08MB + Motor InnoDB saltwps_itsec_logs: Datos: 1.52MB + Índice: 0.28MB + Motor InnoDB saltwps_itsec_mutexes: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_itsec_opaque_tokens: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_itsec_temp: Datos: 0.08MB + Índice: 0.09MB + Motor InnoDB saltwps_itsec_user_groups: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB saltwps_links: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_mipconnector_attribute_group_map: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_mipconnector_attribute_map: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_mipconnector_brand_map: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_mipconnector_brand_plugin_map: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_mipconnector_category_map: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_mipconnector_file_log: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB saltwps_mipconnector_image_url: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_import_process_attribute: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_import_process_attribute_group: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_import_process_brand: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_import_process_brand_plugin: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_import_process_category: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_import_process_product: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_import_process_tag: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_import_process_variation: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_order_log: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_product_image_url: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_product_map: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_mipconnector_product_url: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_mipconnector_tag_map: Datos: 0.02MB + Índice: 0.09MB + Motor InnoDB saltwps_mipconnector_variation_map: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_options: Datos: 1.36MB + Índice: 0.08MB + Motor InnoDB saltwps_postmeta: Datos: 1.52MB + Índice: 0.45MB + Motor InnoDB saltwps_posts: Datos: 1.52MB + Índice: 0.13MB + Motor InnoDB saltwps_registration_log: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_signups: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB saltwps_site: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_sitemeta: Datos: 0.27MB + Índice: 0.03MB + Motor InnoDB saltwps_social_users: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_termmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_terms: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_term_relationships: Datos: 0.06MB + Índice: 0.02MB + Motor InnoDB saltwps_term_taxonomy: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_usermeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_users: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_wc_admin_notes: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB saltwps_wc_admin_note_actions: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_wc_category_lookup: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB saltwps_wc_customer_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_wc_download_log: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_wc_order_coupon_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_wc_order_product_lookup: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB saltwps_wc_order_stats: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_wc_order_tax_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_wc_product_meta_lookup: Datos: 0.02MB + Índice: 0.09MB + Motor InnoDB saltwps_wc_reserved_stock: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB saltwps_wc_tax_rate_classes: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_wc_webhooks: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_wps_hit: Datos: 0.02MB + Índice: 0.14MB + Motor InnoDB saltwps_wps_index: Datos: 1.39MB + Índice: 3.33MB + Motor InnoDB saltwps_wps_key: Datos: 0.06MB + Índice: 0.02MB + Motor InnoDB saltwps_wps_object_term: Datos: 0.09MB + Índice: 0.25MB + Motor InnoDB saltwps_wps_object_type: Datos: 0.02MB + Índice: 0.08MB + Motor InnoDB saltwps_wps_query: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_wps_uri: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_wps_user_agent: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_yith_wcwl: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_yith_wcwl_lists: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_yoast_indexable: Datos: 0.20MB + Índice: 0.14MB + Motor InnoDB saltwps_yoast_indexable_hierarchy: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB saltwps_yoast_migrations: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_yoast_primary_term: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB saltwps_yoast_seo_links: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB saltwps_yoast_seo_meta: Datos: 0.06MB + Índice: 0.00MB + Motor InnoDB ### Post Type Counts ### attachment: 121 custom_css: 3 customize_changeset: 80 et_body_layout: 11 et_footer_layout: 3 et_header_layout: 6 et_pb_layout: 9 et_pb_layout_stashed: 8 et_template: 33 et_theme_builder: 8 jetpack_migration: 2 layout: 2 nav_menu_item: 13 page: 16 post: 1 product: 39 product_variation: 84 revision: 133 shop_order: 4 shop_order_refund: 1 wpcf7_contact_form: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (11) ### AliDropship Social Tools: por Denis Zharov – 1.0.6 AliDropship Woo Plugin: por Vitaly Kukin & Yaroslav Nevskiy & Pavel Shishkin & Denis Zharov – 1.6.9 – Versión instalada no está probada con la versión activa de WooCommerce 4.4.1 Contact Form 7: por Takayuki Miyoshi – 5.2.2 Jetpack by WordPress.com: por Automattic – 8.9 WooCommerce PayPal Checkout Gateway: por WooCommerce – 2.0.3 – Versión instalada no está probada con la versión activa de WooCommerce 4.4.1 WooCommerce Stripe Gateway: por WooCommerce – 4.5.2 – Versión instalada no está probada con la versión activa de WooCommerce 4.4.1 WooCommerce Product Search: por itthinx – 3.1.1 WooCommerce Services: por Automattic – 1.24.2 – Versión instalada no está probada con la versión activa de WooCommerce 4.4.1 WooCommerce: por Automattic – 4.4.1 Easy WP SMTP: por wpecommerce alexanderfoxc – 1.4.1 iThemes Security: por iThemes – 7.8.0 ### Inactive Plugins (17) ### AliDropship Woo Product Video: por Bogdan Gorchakov – 0.2 BigBuy Dropshipping Connector for WooCommerce: por BigBuy – 1.2.2 – Versión instalada no está probada con la versión activa de WooCommerce 4.4.1 Cache Enabler: por KeyCDN – 1.4.7 Classic Editor: por WordPress Contributors – 1.6 External Media without Import: por Zhixiang Zhu – 1.1.2 GDPR Banner: por Worcester Web Studio – 1.4.3 Google Analytics Dashboard for WP (GADWP): por ExactMetrics – 6.2.2 Metric Converter: por Vitaly Kukin – 1.5.4 Nextend Social Login: por Nextendweb – 3.0.25 Regenerate Thumbnails: por Alex Mills (Viper007Bond) – 3.1.3 Themify - WooCommerce Product Filter: por Themify – 1.3.1 TinyMCE Advanced: por Andrew Ozz – 5.5.0 WooCommerce Menu Cart: por Jeremiah Prummer Ewout Fernhout – 2.9.4.1 WPC Show Single Variations for WooCommerce: por WPClever.net – 1.1.0 – Versión instalada no está probada con la versión activa de WooCommerce 4.4.1 WPO Tweaks & Optimizations: por Fernando Tellado – 0.9.25 YITH WooCommerce Wishlist: por YITH – 3.0.13 Yoast SEO: por Team Yoast – 14.9 ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right 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: – ### WC Pages ### Base de la tienda: #2836 - /tienda/ Carrito: #2837 - /tu-carrito-de-compras/ Finalizar compra: #2838 - /pago/ Mi cuenta: #2832 - /mi-cuenta/ Términos y condiciones: #2845 - /terminos-y-condiciones/ ### Theme ### Name: DavinciWoo Child Version: 1.2.4 Author URL: https://yellowduck.me/ Child Theme: ✔ Parent Theme Name: DavinciWoo Parent Theme Version: 1.2.4 – 1.2.5 está disponible Parent Theme Author URL: https://yellowduck.me/ WooCommerce Support: ✔ ### Templates ### Overrides: davinciwoo/woocommerce/archive-product.php davinciwoo/woocommerce/cart/cart-empty.php davinciwoo/woocommerce/cart/cart-shipping.php davinciwoo/woocommerce/cart/cart-totals.php La version 3.8.0 de davinciwoo/woocommerce/cart/cart.php está obsoleta. La versión del núcleo es la 4.4.0 La version 3.0.0 de davinciwoo/woocommerce/cart/cross-sells.php está obsoleta. La versión del núcleo es la 4.4.0 davinciwoo/woocommerce/cart/mini-cart.php davinciwoo/woocommerce/cart/proceed-to-checkout-button.php davinciwoo/woocommerce/cart/shipping-calculator.php davinciwoo/woocommerce/checkout/cart-errors.php davinciwoo/woocommerce/checkout/form-billing.php davinciwoo/woocommerce/checkout/form-checkout.php davinciwoo/woocommerce/checkout/form-coupon.php davinciwoo/woocommerce/checkout/form-login.php davinciwoo/woocommerce/checkout/form-shipping.php davinciwoo/woocommerce/checkout/payment-method.php davinciwoo/woocommerce/checkout/payment.php davinciwoo/woocommerce/checkout/review-order.php davinciwoo/woocommerce/content-product.php davinciwoo/woocommerce/content-product_cat.php davinciwoo/woocommerce/content-single-product.php davinciwoo/woocommerce/content-widget-product.php davinciwoo/woocommerce/content-widget-reviews.php davinciwoo/woocommerce/global/form-login.php davinciwoo/woocommerce/global/quantity-input.php davinciwoo/woocommerce/global/wrapper-end.php davinciwoo/woocommerce/global/wrapper-start.php davinciwoo/woocommerce/loop/loop-end.php davinciwoo/woocommerce/loop/loop-start.php davinciwoo/woocommerce/loop/orderby.php davinciwoo/woocommerce/loop/pagination.php davinciwoo/woocommerce/loop/rating.php davinciwoo/woocommerce/myaccount/form-edit-account.php davinciwoo/woocommerce/myaccount/form-edit-address.php davinciwoo/woocommerce/myaccount/form-login.php davinciwoo/woocommerce/myaccount/form-lost-password.php davinciwoo/woocommerce/myaccount/form-reset-password.php davinciwoo/woocommerce/myaccount/lost-password-confirmation.php davinciwoo/woocommerce/myaccount/my-account.php davinciwoo/woocommerce/myaccount/my-address.php davinciwoo/woocommerce/myaccount/orders.php davinciwoo/woocommerce/notices/success.php davinciwoo/woocommerce/order/order-details-customer.php davinciwoo/woocommerce/product-searchform.php davinciwoo/woocommerce/single-product/add-to-cart/simple.php davinciwoo/woocommerce/single-product/add-to-cart/variable.php davinciwoo/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php davinciwoo/woocommerce/single-product/meta.php davinciwoo/woocommerce/single-product/product-attributes.php davinciwoo/woocommerce/single-product/product-image.php davinciwoo/woocommerce/single-product/product-thumbnails.php davinciwoo/woocommerce/single-product/rating.php davinciwoo/woocommerce/single-product/related.php davinciwoo/woocommerce/single-product/tabs/additional-information.php davinciwoo/woocommerce/single-product/tabs/description.php davinciwoo/woocommerce/single-product/tabs/tabs.php davinciwoo/woocommerce/single-product/up-sells.php davinciwoo/woocommerce/single-product-reviews.php davinciwoo/woocommerce/single-product.php Outdated Templates: ❌ Aprende cómo actualizar ### Action Scheduler ### Completo: 39 Oldest: 2020-08-24 18:35:17 -0500 Newest: 2020-09-01 17:15:01 -0500I’m not using Affiliate for WooCommerce, just adding some external products I don’t sell but which give me affiliate revenue.
Thank you
Hi there,
€82 is €100 minus the included tax so it is displaying your affiliate products without tax.Can you please check the Tax class and Tax Status set on your affiliate products?
I tried replicating this on my staging site and cannot do so which indicates that the issue is likely to be something to do with how yo have set up the product.
I hope that helps you to figure it out.
Feel free to get back to us if you have further questions.Hello. Yes, I’ve double checked it. I’ve only one standard tax set on woocommerce (VAT 21%). I already set the external product to have this tax applied as I do with regular products, but woocommerce keeps discounting tax when showing price on the frontend (and that does not happen with regular products and same configuration). If I set an external product to be 200€ it keeps showing 165,29€ on customer’s side (If I do the same with a regular product it shows 200€ as it is intended to, and it shows 165’29€ + 34,71(21%tax) as intended too on checkout).
Not that it is a very big problem since I can set external products price to be 21% higher so it shows the correct price to customers (and since it’s external product it won’t really affect tax calculation on my woocommerce), but it’s confusing not having real product price on the backend.
Thanks for following up.
This may be caused by either a conflict with your theme or with another plugin.
The best way to determine this is to:- Temporarily switch your theme to Storefront
- Disable all plugins except for WooCommerce
- Repeat the action that is causing the problem
If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.
If that does not help, can you send links to a regular product as well as an external product? As for the different products, can you also include details about how you’re differentiating them?
Thank you,
After doing the conflict test I realized it was also happening with single products too. With only WooCommerce plugin active and Storefront theme I had both single and affiliate products showing prices with tax discounted on the frontend. I started switching the ‘prices entered with tax (tax incl./tax excl.)’ and ‘how I want them to be shown on store (tax incl./tax excl.)’ options and realized variation products did not change at all while the other products price display wasn’t working as expected when switching the options.
I don’t really know where the problem was, but I decided to remove the two default additional tax classes which came with WooCommerce installation (Reduced Rate and Zero Rate) and that solved the problem. I don’t really know how they where affecting the displaying of prices on the frontend (because none of those taxes where applied to any product), but that solved the problem. So I’ll mark this problem solved for me.
Thank you all for guiding me on this troubleshooting.
Hi there,
Many thanks for sharing your investigations with us and great that you found the fix.
Generally when you change the settings regarding pricing inc/excl tax the prices do not change on the site. It relates instead to whether the price you entered includes tax or not.
I am also unsure about how disabling tax rates fixed the issue unless there was an issue with database entries for the rates that was reset when you deleted them and saved the settings.Nice work 🙂
The topic ‘Affiliate Product Tax malfunction’ is closed to new replies.