[Skip to main content](#vessel-content) # what are the tables changes when add aproduct ## - **[saicharan.testing](/forum/user/32796-saicharan-testing "View saicharan.testing's Profile")** - [![saicharan.testing's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32796-saicharan-testing "View saicharan.testing's Profile") Topic Author - [ Offline](/forum/user/32796-saicharan-testing) Less More - Posts: 1 - Thank you received: 0 - - 12 years 5 months ago [\#157517](#157517) by [saicharan.testing](/forum/user/32796-saicharan-testing "View saicharan.testing's Profile") *[what are the tables changes when add aproduct](/forum/26-product-category-display/868521-what-are-the-tables-changes-when-add-aproduct#157517 "-- HikaShop version -- : 2.31 -- Joomla version -- : 2.5.4 Can anyone assist me, when i add a product in hikashop, what are the tables are going to effect in the database and what will happens when i have custom fields and options please guide me towards this situation. Thanks in Advance")* was created by *[saicharan.testing](/forum/user/32796-saicharan-testing "View saicharan.testing's Profile")* -- HikaShop version -- : 2.31 -- Joomla version -- : 2.5.4 Can anyone assist me, when i add a product in hikashop, what are the tables are going to effect in the database and what will happens when i have custom fields and options please guide me towards this situation. Thanks in Advance Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Njg1MjEtd2hhdC1hcmUtdGhlLXRhYmxlcy1jaGFuZ2VzLXdoZW4tYWRkLWFwcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")** - [![lousyfool's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28604.jpg)](/forum/user/28604-lousyfool "View lousyfool's Profile") - [ Offline](/forum/user/28604-lousyfool) Less More - Posts: 2143 - Thank you received: 747 - - [](http://www.inphase.one) - 12 years 5 months ago [\#157529](#157529) by [lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile") Replied by *[lousyfool](/forum/user/28604-lousyfool "View lousyfool's Profile")* on topic *[what are the tables changes when add aproduct](/forum/26-product-category-display/868521-what-are-the-tables-changes-when-add-aproduct#157529 "-- HikaShop version -- : 2.31 -- Joomla version -- : 2.5.4 Can anyone assist me, when i add a product in hikashop, what are the tables are going to effect in the database and what will happens when i have custom fields and options please guide me towards this situation. Thanks in Advance")* If you were up for dealing with the database, then it's very easy to find out what is where by simply looking, i.e. with phpMyAdmin. You'd see that all HikaShop tables are named (prefix)_hikashop_(table name), indeed. And that the tables are named logically after their content, i.e. "product". So, by only looking at the database, you can answer your question yourself. Just be careful with doing anything with or inside the database. You can imagine that it's also very simple to break your site. In any case: backup, backup, backup. --- Need help with customisations of layouts, style or other site development? [ PM me!](/component/uddeim/?task=new) (Don't forget to turn on [ "E-mail notification of new messages"](/component/uddeim/?task=settings)) The following user(s) said Thank You: [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile"), [saicharan.testing](/forum/user/32796-saicharan-testing "View saicharan.testing's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Njg1MjEtd2hhdC1hcmUtdGhlLXRhYmxlcy1jaGFuZ2VzLXdoZW4tYWRkLWFwcm9kdWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 5 months ago [\#157524](#157524) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[what are the tables changes when add aproduct](/forum/26-product-category-display/868521-what-are-the-tables-changes-when-add-aproduct#157524 "-- HikaShop version -- : 2.31 -- Joomla version -- : 2.5.4 Can anyone assist me, when i add a product in hikashop, what are the tables are going to effect in the database and what will happens when i have custom fields and options please guide me towards this situation. Thanks in Advance")* Hi, When you add a product in Hikashop : - Your product global information will be added on the #_hikashop_product table - Your product price will be specified through the #_hikashop_price table - Your product attached files will be stored through the #_hikashop_file table - ... Checking the database structure of Hikashop will probably help you : [ www.hikashop.com/hikashop\_database.png](http://www.hikashop.com/hikashop_database.png) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84Njg1MjEtd2hhdC1hcmUtdGhlLXRhYmxlcy1jaGFuZ2VzLXdoZW4tYWRkLWFwcm9kdWN0P3RtcGw9bWFya2Rvd24=) 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.193 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)