Suggestions for storing advanced options of orders in database

Howdy,

Love PS3 by the way!

I'm selling photography and have Advanced Options of "Size" (dimensions of a print). The Size option shows up just fine in the Cart and Confirmation pages, however I do not see it in the Order Details page of the Admin nor in the receipt email sent to the user. So I have no clue what size they chose.

I suppose I could write a SQL query to find the Size they chose for me, but wondering if there's an easier way of storing the Option so it'll show up in the Order Details page, and so I can include the Size in the customer's receipt email.

Thanks!

You may need to add in a new column to your order details table to hold the size value. You would then need to modify the store order details server behavior using eCart, IN this server behavior you would just associate the size column from the cart with your new column in your order details table.

Once you do this you will be recording the size along with the other order information. You can add in bindings for the new column to the admin backend or the order history to get back the size.

Ahhh OK all I had to do was...

1) Add a field to the database table ps3_orderdetails called DetailOptions
2) Edit the Store Details in Database behavior on confirm.php to bind the eCart Column "Options" to ps3_orderdetails.DetailOptions
3) Edit Admin > orders_Detail.php and make it display the DetailOptions

Kinda seems like this'd be an out of the box capability. I mean, so we can see what options a customer selected? Or perhaps I am going at this all wrong.

Easy fix though, thanks Eric!

By default the options that were selected by the user are stored in the DetailName column in the order details table so you will always have access to selected options, this will just make it a little easier to get at.

OK I went back and it indeed is already storing the options in the eCart "Options" column but I don't believe that column was bound to anything in the database when the Store Details in Database kicks off. Dunno if I'm wrong. Anyway, all's working great. Love PS3!

The product options are stored in the DetailName field in the table. So what you see when you view the cart with the options listed under the name is what is stored for that item in the db under this DetailName field.

I'm having a similar problem with PS2. I have created 2 test items (each with size and colour choices). I have also successfully submitted several test orders through Paypal express sandbox.
When I go into my orders I can see the item ordered is either test item 1 or test item 2 but there is no indication of what colour or size has been ordered. I notice this is the same in the PS3 demo. What do most merchant refer to when they are ready to fill the orders if not this page? am I missing something?
BTW these options are showing up just fine in the confirmation email.
My problem seems to be:
I don't think I can use the above fix (correct me if I am wrong) because the DetailName column in the orderdetails table in my database is not showing these options either (except in one order which I cannot figure out???) Unfortunately it was NOT the latest test order :-(
I am attaching the screenshot of this data. Databases give me a headache! Can anyone help me with this? thanks so much, Nancy

In PowerStore 2 the options chosen should be stored in the order details along with the items name.

There is currently a problem in PowerStore v3 where the product options are not being stored correctly. I have opened a ticket for you on this issue so that it can be looked into further and hopefully a workaround can be implemented that will help you get past this issue.