close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Generic OrderDetails Database?

Thread began 5/27/2009 12:57 pm by Peterson Design Studio - jefferis | Last modified 5/27/2009 2:25 pm by Ray Borduin | 1131 views | 5 replies |

Peterson Design Studio - jefferis

Generic OrderDetails Database?

Hi,
I installed the default Orders and Order details database on my server, but as i re-read through the getting started guide I find that many of the fields that would store the customer's name, address, shipping address and phone, e.g., are not available on either the orders or order detail database. When Setting up the records for the cart, this info will be lost. The guide seems to indicate that the shipping addresses, etc. are stored in the Order DB and not the Details DB...

Am I missing something, using older db samples, what?

Sign in to reply to this post

Ray BorduinWebAssist

The shipping information should be added to the orders table. The order details are for the rows in the cart, so since the shipping address is always the same for all of the items in the cart it doesn't make sense to add there.

You can create more columns in the orders table and store as much or as little information as you need by updating the Store Cart Summary in Database server behavior on the confirm page.

Sign in to reply to this post

Peterson Design Studio - jefferis

Originally Said By: Ray Borduin
  The shipping information should be added to the orders table. The order details are for the rows in the cart, so since the shipping address is always the same for all of the items in the cart it doesn't make sense to add there.

You can create more columns in the orders table and store as much or as little information as you need by updating the Store Cart Summary in Database server behavior on the confirm page.  



Of course... you have to add those fields into the DB in which to store the info :-)

I guess I was asking also if the generic sample db supplied with eCart normally has those fields... or the more limited one I have currently...

Sign in to reply to this post

Ray BorduinWebAssist

I thought the orders table contained those fields in the most recent sample, but it is possible they aren't there. I know they exisit in some samples, but I couldn't be sure without looking at the database you are working with.

Sign in to reply to this post

Peterson Design Studio - jefferis

Originally Said By: Ray Borduin
  I thought the orders table contained those fields in the most recent sample, but it is possible they aren't there. I know they exisit in some samples, but I couldn't be sure without looking at the database you are working with.  



I just downloaded the db again from my downloads and the orders table does not have them.

CREATE TABLE orders (
OrderID int(11) NOT NULL auto_increment primary key,
OrderReferenceID varchar(50) default NULL,
OrderUserID int(11) default NULL,
OrderShipping double default NULL,
OrderTax double default NULL,
OrderTotal double default NULL,
OrderDate datetime default NULL,
OrderStatus smallint(6) default NULL
) TYPE=MyISAM;


BTW, i have found that when using a table called 'users' with DW, you can run into non-functioning extensions. Apparently it is a reserved word with some applications... like Adobe Developer's Toolbox...

Sign in to reply to this post

Ray BorduinWebAssist

I will report to our documentation team that it appears these shipping columns should be added since they are referred to. You can just manually add what you need in the time being. Thank you for bringing this to our attention.

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...