How is the short/long description text linked to Product

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
nevaf
Posts: 5
Joined: 14 Sep 2021, 09:30

How is the short/long description text linked to Product

Post by nevaf » 14 Sep 2021, 09:38

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

User avatar
aimeos
Administrator
Posts: 5643
Joined: 01 Jan 1970, 00:00

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

Post by aimeos » 14 Sep 2021, 16:46

mshop_product.id -> mshop_product_list.(parentid,domain,refid) -> mshop_text_id
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

nevaf
Posts: 5
Joined: 14 Sep 2021, 09:30

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

Post by nevaf » 14 Sep 2021, 16:50

Thank you.

nevaf
Posts: 5
Joined: 14 Sep 2021, 09:30

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

Post by nevaf » 18 Sep 2021, 23:03

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?

User avatar
aimeos
Administrator
Posts: 5643
Joined: 01 Jan 1970, 00:00

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

Post by aimeos » 19 Sep 2021, 07:12

The mshop_product_list.refid equals mshop_text.id if domain is "text"
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

nevaf
Posts: 5
Joined: 14 Sep 2021, 09:30

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

Post by nevaf » 19 Sep 2021, 09:16

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?

Post Reply