[Skip to main content](#vessel-content) # Tax rate for product from database ## - **[insane](/forum/user/12316-insane "View insane's Profile")** - [![insane's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12316-insane "View insane's Profile") Topic Author - [ Offline](/forum/user/12316-insane) Less More - Posts: 1 - Thank you received: 0 - - 13 years 10 months ago [\#81671](#81671) by [insane](/forum/user/12316-insane "View insane's Profile") *[Tax rate for product from database](/forum/2-general-talk-about-hikashop/76678-tax-rate-for-product-from-database#81671 "Hello, I am creating hikashop sync. tool with accounting program and one of synced items are orders. When I create order I have to set right tax amount so customer would receive appropriate tax rates. Is there any way to fetch tax namekey used for customer in orders directly from database? Problem getting it from database is that there could be different taxation rules for same tax category so I would have to decide which to use according to customer zone and other thing's. I am wondering if there is simplier way achieve this? Thank's in advance. Robertas.")* was created by *[insane](/forum/user/12316-insane "View insane's Profile")* Hello, I am creating hikashop sync. tool with accounting program and one of synced items are orders. When I create order I have to set right tax amount so customer would receive appropriate tax rates. Is there any way to fetch tax namekey used for customer in orders directly from database? Problem getting it from database is that there could be different taxation rules for same tax category so I would have to decide which to use according to customer zone and other thing's. I am wondering if there is simplier way achieve this? Thank's in advance. Robertas. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2Njc4LXRheC1yYXRlLWZvci1wcm9kdWN0LWZyb20tZGF0YWJhc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 10 months ago [\#81921](#81921) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Tax rate for product from database](/forum/2-general-talk-about-hikashop/76678-tax-rate-for-product-from-database#81921 "Hello, I am creating hikashop sync. tool with accounting program and one of synced items are orders. When I create order I have to set right tax amount so customer would receive appropriate tax rates. Is there any way to fetch tax namekey used for customer in orders directly from database? Problem getting it from database is that there could be different taxation rules for same tax category so I would have to decide which to use according to customer zone and other thing's. I am wondering if there is simplier way achieve this? Thank's in advance. Robertas.")* Hi, hikashop_tax and hikashop_taxation contain tax rules. After that, the tax categories are in the hikashop_category table with a special category_type. In orders, the tax is stored as a serialized PHP object in the column "order_tax_info". Because it could have several taxes, the best solution was to serialize the information. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2Njc4LXRheC1yYXRlLWZvci1wcm9kdWN0LWZyb20tZGF0YWJhc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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.092 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)