what are the tables changes when add aproduct

  • Posts: 1
  • Thank you received: 0
11 years 3 months ago #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

Please Log in or Create an account to join the conversation.

  • Posts: 2143
  • Thank you received: 747
11 years 3 months ago #157529

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!
(Don't forget to turn on "E-mail notification of new messages" )
The following user(s) said Thank You: Mohamed Thelji, saicharan.testing

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
11 years 3 months ago #157524

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.079 seconds
Powered by Kunena Forum