custom field value for variants

Hi,

HikaShop already automatically use dynamically the value of the main product for the variant display on the product page on the frontend if the value of the custom field is left empty in the variant.
Is that what you're talking about ?
Or are you talking about something else ?
Could you explain your use case ? What are you trying to do with that custom product field ?

Hi,

The inheritance I mentioned is only a display-time fallback: when the variant's custom field is empty, HikaShop reads the main product's value on the fly to show it on the frontend. It never writes that value to the variant's own row, so if you read the database directly you'll still find the field empty on the variants.

Product custom fields are stored as columns of the hikashop_product table, and variants are rows of that same table (with product_parent_id pointing to the main product). So the column already exists on your variant rows, it's just not filled.

Two solutions:

1) A one-time (or scheduled) SQL query copying the value from the parent to the empty variants. Replace seller_percent with the real column name of your field (its "Column name" in the field configuration, not the label):

UPDATE `#__hikashop_product` AS v
JOIN `#__hikashop_product` AS p ON p.product_id = v.product_parent_id
SET v.seller_percent = p.seller_percent
WHERE v.product_type = 'variant'
  AND (v.seller_percent IS NULL OR v.seller_percent = '');