Product Order - How to add product option information to the order
I have tried several different configurations and the only suitable one seems to be using product options. It seems I have too many products to create individual products for 10 different attributes. Ended up with over 3 million products and my server didn't like a db that large (over 10GB)
So when I use product options with pricing attributes I get the dynamic pricing per option, but on the orders I have no way of knowing which option the customer chose.
Unless I am missing something simple.
-3 sizes assigned prices in a single option set using pricing attributes
-product_types referencing this option set using a Pricing Attributes field
-products with a Product Reference field
I can add content, and add new product to that content, which has a base price and an Attributes selector. Selecting the attribute adds the options set to the product and shows up as a list of options on the product display page. Making a selection modifies the product price. Adding to cart adds to cart using product title and sku, but nothing (besides the price) indicates which option was chosen)
I hope this makes sense.
Is there a way to append to the title or sku (or anything else that makes sense) information about the selected option?