Hi,

In the dnn database, how can I get the variant options choosen by the user ?

The only thing I could note is that the ProductName includes for each variant ", variant title = option value". I could parse the ProductName but it is not very reliable over time (variant title change?).

Thanks.

Hi Kevin,

I would like to plan automated post-purchase operations to get precisely what the customer has bought. Therefor I must get each variant option the user has choosen. Unfortunately, there is no datatable that list all variant ID (with its variantGroup ID) choosen for each order detail ID.

The only way I found to identify the choosen options is to parse ProductName in the OrderDetail datatable (which will not match if the variant group or option is changed between the customer purchase and the automated post-purchase operations). But maybe there is a other way to do it...

The datatable solution will be the most reliable one.

Thanks.

Hi Scott.

Parsing productName is a solution regarding to the actual implementation. But I did not think about changing orderDetail table, but changing Variant name (reformulation for example). In this case the variant options will not be parsable anymore for all existing orders. And I think the database triggers are a bit overkilled for such a scenario.

The only other possible solution will be to create a new variant instead of changing existing variants. With this approach, all ProductName data will still be parsable (but the drawback is that the same options (that is renamed) will be considered as 2 differents variants).

In all cases, the datatable that list all variant ID (with its variantGroup ID) choosen for each order detail ID would be the best solution.

Anyway, thanks for your answer.