Where can I find SKU Options selected for an ordered product?

Adam Steffes asked on November 12, 2014 22:39

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" ?

8.1

Correct Answer

Joshua Adams answered on November 13, 2014 21:08

Look for the parentguid on the orderitem table. The options will have a stored for the main product.

0 votesVote for this answer Unmark Correct answer