Where can I find the selected "Product Options" ordered by a user for a SKU by looking at the Order or OrderItem in the database?
OrderItem has SKU. In the database the table COM_OptionCategory lists the options I'm looking to connect to. SKUOptionCategory appears to connect SKUs to OptionCategories.
Where is the join between COM_SKUOptionCategory_"OrderItemSKU" ?
Look for the parentguid on the orderitem table. The options will have a stored for the main product.
Please, sign in to be able to submit a new answer.