VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: d0ublezer0 on September 11, 2019, 14:29:39 PM

Title: Where multivariants stored?
Post by: d0ublezer0 on September 11, 2019, 14:29:39 PM
I use Variant Matrix (https://virtuemart.net/news/468-virtuemart-3-0-6-with-completely-redesigned-multi-variants)
I cannot find, where mulivariant values stored in mysql base
Created a full SQL dump, tried to search by text, but unsuccesful
Help please
Title: Re: Where multivariants stored?
Post by: gap on November 13, 2021, 18:36:51 PM
virtuemart_product_customfields table - customfield_params field
Title: Re: Where multivariants stored?
Post by: diri on November 14, 2021, 11:39:30 AM
Don't search text. This is stored once only.

Search related IDs instead. It's somewhat cumbersome because of very strong normalization.

hth, diri