[Skip to main content](#vessel-content) # Database schema for hikashop ## - **[langkatech](/forum/user/7030-langkatech "View langkatech's Profile")** - [![langkatech's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7030-langkatech "View langkatech's Profile") Topic Author - [ Offline](/forum/user/7030-langkatech) Less More - Posts: 90 - Thank you received: 1 - - - - 13 years 6 months ago [\#100218](#100218) by [langkatech](/forum/user/7030-langkatech "View langkatech's Profile") *[Database schema for hikashop](/forum/2-general-talk-about-hikashop/80681-database-schema-for-hikashop#100218 "I am having trouble getting the reports to give me information that I want. Is there a database schema or database map that shows where all the data is at and in what tables with key fields so I can...")* was created by *[langkatech](/forum/user/7030-langkatech "View langkatech's Profile")* I am having trouble getting the reports to give me information that I want. Is there a database schema or database map that shows where all the data is at and in what tables with key fields so I can write sql and generate my own reports? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNjgxLWRhdGFiYXNlLXNjaGVtYS1mb3ItaGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 13 years 6 months ago [\#100221](#100221) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Database schema for hikashop](/forum/2-general-talk-about-hikashop/80681-database-schema-for-hikashop#100221 "I am having trouble getting the reports to give me information that I want. Is there a database schema or database map that shows where all the data is at and in what tables with key fields so I can...")* Hi, Yes, in our documentation. [ www.hikashop.com/en/support/documentatio...ocumentation.html#db](http://www.hikashop.com/en/support/documentation/62-hikashop-developer-documentation.html#db) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNjgxLWRhdGFiYXNlLXNjaGVtYS1mb3ItaGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")** - [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") - [ Offline](/forum/user/11856-lionel75) Less More - Posts: 846 - Thank you received: 92 - - 13 years 6 months ago - 13 years 6 months ago [\#100234](#100234) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile") Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[Database schema for hikashop](/forum/2-general-talk-about-hikashop/80681-database-schema-for-hikashop#100234 "I am having trouble getting the reports to give me information that I want. Is there a database schema or database map that shows where all the data is at and in what tables with key fields so I can...")* you can use MYSQLworkbench it seem it is what hikashop use ! ? [ www.friendly-froggy.net/2010/01/21/faire...mysql-workbench-5-1/](http://www.friendly-froggy.net/2010/01/21/faire-un-schema-de-sa-base-de-donnee-mysql-mysql-workbench-5-1/) Last edit: 13 years 6 months ago by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNjgxLWRhdGFiYXNlLXNjaGVtYS1mb3ItaGlrYXNob3A/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.058 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)