close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Suggestions for storing advanced options of orders in database

Thread began 2/10/2010 10:59 pm by rejuvesite | Last modified 3/23/2010 2:30 pm by Eric Mittman | 1044 views | 7 replies |

rejuvesite

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!

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

rejuvesite

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!

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

rejuvesite

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!

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

nancy268153

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

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...