[resolved] Product_id in database is deleted when adding variants

-- HikaShop version -- : 4.2.3
-- Joomla version -- : 3.9.16

Hi,
it seems the product_id may be deleted from database (table hikashop_product) when creating variants for the first time.

I used to work with a "basic" product (no variants) which had the product_id 5622.
It was already used in some orders (example for me in order 5608)

Then I created some variants on this product, which resulted (in the product table) to the deletion of this line, and the creation of multiple lines with new ids (for example product_id 6015)

My problem is as following :
When querying the database and JOINing tables order_product and product, there is no match anymore because product_id '5622' is not anymore in table product.

It's like I have a "mystery" product in these orders and I can't display its name in my SQL extract.

=> could you find a way to improve it and maybe have a logical deletion instead of a hard one ?
or maybe I missed something when creating the variants...

thanks
JB

Thanks a lot.
I will try that

Apparently, my issue was not related to variants : my brother probably hard deleted the main product before creating a new one. No way to keep the link in that case
sorry for the misunderstanding

thanks anyway