Page 1 of 1

How is the short/long description text linked to Product

Posted: 14 Sep 2021, 09:38
by nevaf
Hi Aimeos community, does anyone know how the short/long description text is linked to a product?
In this overview https://aimeos.org/fileadmin/download/A ... abase.svgz you can't see the connection.
So please could anyone tell me in which table the relation between product and for example short description text is located?
I found the text in the table mshop_text but there is no prodid or parentid Field.
Thnx

Re: How is the short/long description text linked to Product

Posted: 14 Sep 2021, 16:46
by aimeos
mshop_product.id -> mshop_product_list.(parentid,domain,refid) -> mshop_text_id

Re: How is the short/long description text linked to Product

Posted: 14 Sep 2021, 16:50
by nevaf
Thank you.

Re: How is the short/long description text linked to Product

Posted: 18 Sep 2021, 23:03
by nevaf
Excuse, but with your information I cant get the id from the mshop_text table.
In the tabel mshop_product_list I can select all information you mentioned:
For example:
parentid 17
domain text
refid 323134

But now with this information how can I get the id from the table mshop_text?
Could you please write a bit more in detail?

Re: How is the short/long description text linked to Product

Posted: 19 Sep 2021, 07:12
by aimeos
The mshop_product_list.refid equals mshop_text.id if domain is "text"

Re: How is the short/long description text linked to Product

Posted: 19 Sep 2021, 09:16
by nevaf
by this way my sql select returns refid 323134 but I'cant find the id in the mshop_text table.
When I search the content field for the text itself I see the id 214.
And its strange but I can't find this id in the mshop_product_list in the refid field.
what am I doing wrong?