mshop_order_base_product_attr

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)
Spam and unrelated posts will be removed immediately!
cnoelker
Advanced
Posts: 140
Joined: 20 Feb 2016, 18:21

mshop_order_base_product_attr

Post by cnoelker » 15 Jul 2020, 12:06

Hi,
no problem with it, but I am curious:
Is there some reason why all values in the column 'value' of the table mshop_order_base_product_attr are surrounded by quotes?
E.g. the column contains:
"1234"
"size_xs"

Claudia

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

Re: mshop_order_base_product_attr

Post by aimeos » 15 Jul 2020, 12:30

The "value" column is JSON encoded.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

cnoelker
Advanced
Posts: 140
Joined: 20 Feb 2016, 18:21

Re: mshop_order_base_product_attr

Post by cnoelker » 15 Jul 2020, 12:43

Ah, then it makes sense. I always have one value inside it, only.

Thanks!
Claudia

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

Re: mshop_order_base_product_attr

Post by aimeos » 15 Jul 2020, 12:52

Can be also several values and it depends on the attribute type
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

cnoelker
Advanced
Posts: 140
Joined: 20 Feb 2016, 18:21

Re: mshop_order_base_product_attr

Post by cnoelker » 15 Jul 2020, 13:02

Which type has more than one value? I am currently seeing only custom and variant attributes in that table.

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

Re: mshop_order_base_product_attr

Post by aimeos » 15 Jul 2020, 13:10

Mainly service attribute or if you need to store lists or maps of custom values.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply