Hi!
We re developing a script to update hikashop products, categories... , from an external prorgam. we are at the point to update values for a product variant.
I remarked in hikashop product table, that the product which is created as variant of another product doesnt have any connection with the characteristic. I mean there is no refference with the characteristic table. How are these connected? How does hikashop know that the specifiq variant is attached with the characteristic with id XXX
Thanks! I m lost
It uses the hikashop_variant table. That's the table which links characteristics and characteristics values on one hand, to the product and variants on the other hand.
In that table, for each product and for each characteristic you have:
- one entry linking a value of the characteristic with a variant of the product
- one entry linking the characteristic itself and the main product
- one entry linking the default value of the characteristic with the main product
So by loading all the entries in that table you know which value is the default one for each characteristic of the product and that way, you know which variant is the default one when the values of the variant match with the values of the links of the main product.
