I wanted to submit a case study: I start from my need to be able to know the cost of downloaded products (with free download pro plugin).
Step1: I create a simple product "a1" with price 100.
in wp_postmeta, records are normally created, including the record with
post_id=<xxx>, meta_key="_price" and "meta_value=100.
Step2: I make a product download. records are correctly inserted in postmeta including the record with
in the records added now there is not a record with meta_key="_price" but I can know the download price by pointing to the product record through the somdn_product_id ( <xxx>)
Step3: Now suppose you vary the product by making it a variable product through an attribute with 2 variations.
records will be created for each variation in postmeta. in each of them a record with the price will be reported.
New postmeta records will also be added with post_id=<xxx>, meta_key="_price", and meta_value
about the prices of the changes created.
now I can no longer understand the price of the downloaded products in the product download when the product was of the simple type.
this is because in its record the prices of the variations have also been added.
I do not know if I have been clear and / or I have said inaccuracies. In case the problem was real I would suggest to add at least the price of the downloaded product in the records postmeta inserted at the time of download.
this would protect against any changes to the history of the product.