Which tables are used for new categories and products?

[djpaul]

Hello!

I am writing a program in c# to insert/update/delete products which i recieve from a supplier.

So far it is almost working but I see that some small things aren't wright and maybe I am seeing some table over my head..

 

For insrting categories I use these tables:

- ps_category

- ps_category_group

- ps_category_lang

 

Everything in there goes well, only the nleft and nright function is still a little problem.

I see how it works, though... But that maybe later..

 

If I insert a product I use these tables:

- ps_product

- ps_product_lang

- ps_search_word

- ps_search_index

- ps_image

- ps_image_lang

- ps_ps_category_product

 

Are those all the table for the product? (standard with view images..)

[vekia]

I think that is ok

[venom2506]

Hello, sorry to bump this topic, but I have a similar question;

first of all, is the list for the products still correct? Also, what are the tables that store the features, please? Would it be possible to list what they store exactly? For instance, I can't understand what is stored in PS_image_lang.

 

edit: nevermind, found the database doc.

Edited February 12, 2014 by venom2506 (see edit history)

[vekia]

PS_image_lang stores information about uploaded pictures LEGEND field

what is LEGEND?

 

in simple words it's a "product title"

this is why you have got there a lot of fields 

 

first column id_image - it's a id of image

second column id_kang - id of language

third column legend - it's just a "translation" for legend field