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?

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.

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

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.

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

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.