hikashop db tables (field descriptions needed)

  • Posts: 6
  • Thank you received: 0
10 years 2 months ago #169560

I am PHP/MySQL developer and new to Joomla & Hika. I am working with a legacy mysql database.
My task: take existing data and import into the appropriate/corresponding hikashop tables.

I need descriptions of the fields in the Hikashop tables to help me map the data from the legacy db to hika db. Does such documentation exist? if so, where can i find it?

Thanks in advance for your help.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 2 months ago #169576

Hi,

We have a database structure diagram available in our developer documentation:
www.hikashop.com/support/support/documen...r-documentation.html
But there is no description for each field that I know of.

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

  • Posts: 6
  • Thank you received: 0
10 years 2 months ago #169636

Hi Nicolas,

Thanks for your reply. I have another question regarding the Products table. Fields such as product_published or product_hit (less evident names), how would I determine what kinds of data they store w/o field descriptions?

Mike

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 2 months ago #169643

Hi,

published - the product is published or not.
hit - the number of hits.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: senor_mike

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

  • Posts: 6
  • Thank you received: 0
10 years 2 months ago #169735

What do these fields store?
table: hikashop_category
fields:
category_left
category_right
category_depth
category_namekey

Thanks in advance,
Mike

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 2 months ago #169738

Hi,

It is a question that you can also ask in Joomla! forum ; because Joomla! also use b-tree.
en.wikipedia.org/wiki/B-tree

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.060 seconds
Powered by Kunena Forum