Hi,
I want to use SQL query to check if User 50 paid for Product 10 with Option 1(value = Red).
I check your database but still get confused how to check this correctly.
For example, in Product 10, i add an Option 1, Value = Red | Blue
When User 50 place an order, i see this product and option in database(table: #__eshop_orderoptions )
But when i edit Option 1 in option view, and change value Red to New Red, but the order still show Option 1: Red
So does this mean when the order place, it only record the current value of Option, and it will not be changed after that even the option value changed in option view?
Why don't you use option id and link to #__eshop_optionvaluedetails table, so the name will be the same in whole the system?