[Skip to main content](#vessel-content) # Tax rules listing - erroneous Tax Category ## - **[jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")** - [![jameswadsworth's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/556-jameswadsworth "View jameswadsworth's Profile") Topic Author - [ Offline](/forum/user/556-jameswadsworth) Less More - Posts: 274 - Thank you received: 5 - - - - [](http://www.deanimaconsulting.com) - 15 years 10 months ago [\#4367](#4367) by [jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile") *[Tax rules listing - erroneous Tax Category](/forum/3-bug-report/4367-tax-rules-listing-erroneous-tax-category#4367 "If a tax rule is set up and the tax category is set to 'None', when the tax rule is viewed on the listings page a product category is shown. However the if the tax rule is edited and the tax category...")* was created by *[jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")* If a tax rule is set up and the tax category is set to 'None', when the tax rule is viewed on the listings page a product category is shown. However the if the tax rule is edited and the tax category is set the tax category shows correctly. However reset the tax category back to 'None' a product category is shown. (In the database table hikashop taxation the category_namekey field is blank ). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MzY3LXRheC1ydWxlcy1saXN0aW5nLWVycm9uZW91cy10YXgtY2F0ZWdvcnk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 10 months ago [\#4368](#4368) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Tax rules listing - erroneous Tax Category](/forum/3-bug-report/4367-tax-rules-listing-erroneous-tax-category#4368 "If a tax rule is set up and the tax category is set to 'None', when the tax rule is viewed on the listings page a product category is shown. However the if the tax rule is edited and the tax category...")* I cannot reproduce that on our end. When I create a tax rule without a tax category, nothing is displayed for that tax rule in the tax category column on the tax rules listing. The only explanation I would see is that you have in the table hikashop_category a category with nothing in the column category_namekey which should not happen normally. You could try to change the line Code: $query = ' FROM '.hikashop::table('taxation').' AS a LEFT JOIN '.hikashop::table('tax').' AS b ON a.tax_namekey=b.tax_namekey LEFT JOIN '.hikashop::table('category').' AS c ON a.category_namekey=c.category_namekey LEFT JOIN '.hikashop::table('zone').' AS d ON a.zone_namekey=d.zone_namekey'.$filters.$order; to Code: $query = ' FROM '.hikashop::table('taxation').' AS a LEFT JOIN '.hikashop::table('tax').' AS b ON a.tax_namekey=b.tax_namekey LEFT JOIN '.hikashop::table('category').' AS c ON a.category_namekey=c.category_namekey AND a.category_namekey!=\'\' AND c.category_type=\'tax\' LEFT JOIN '.hikashop::table('zone').' AS d ON a.zone_namekey=d.zone_namekey AND a.zone_namekey!=\'\''.$filters.$order; in the file administrator/components/com_hikashop/views/taxation/view.html.php Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MzY3LXRheC1ydWxlcy1saXN0aW5nLWVycm9uZW91cy10YXgtY2F0ZWdvcnk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")** - [![jameswadsworth's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/556-jameswadsworth "View jameswadsworth's Profile") Topic Author - [ Offline](/forum/user/556-jameswadsworth) Less More - Posts: 274 - Thank you received: 5 - - - - [](http://www.deanimaconsulting.com) - 15 years 10 months ago [\#4397](#4397) by [jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile") Replied by *[jameswadsworth](/forum/user/556-jameswadsworth "View jameswadsworth's Profile")* on topic *[Re: Tax rules listing - erroneous Tax Category](/forum/3-bug-report/4367-tax-rules-listing-erroneous-tax-category#4397 "If a tax rule is set up and the tax category is set to 'None', when the tax rule is viewed on the listings page a product category is shown. However the if the tax rule is edited and the tax category...")* Hi Nicolas, you are right with your first hypothesis: > The only explanation I would see is that you have in the table hikashop\_category a category with nothing in the column category\_namekey which should not happen normally. We had imported some categories from a CSV file and the first line had not been inserted correctly. Thanks, James Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MzY3LXRheC1ydWxlcy1saXN0aW5nLWVycm9uZW91cy10YXgtY2F0ZWdvcnk/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.056 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)