Insert static cart with no login into db

I have a simple static cart with a couple of products that doesn't use a login, so no user id is captured. I am using Authorize.net to capture the funds.

What would be the easiest way to insert each item in the the cart into the a database (i'm using ecart 3 with asp, so an access db is what i would use)?

Also I'd want to grab the billing contact info, maybe in a different table? could I relate them using the session ID?

Just looking how to put the info of a static cart and purchas info into a db that doesn't use a login.

Thanks,
Doug

on the confirm page, you would need to add the eCart Store Order Summary behavior to store the billing information to an Orders table, and the eCart Store Order Details to store the cart line items to the OrderDetails table.

In the store oder summary behavior, set the Key Column to the primary Key column of the Orders table, and make note of the name of the session that will be created.

In the orderdetails table you should have an orderdetailID column that is used to create the relationship between order and orderdetails.

in the store order details behavior, set the key column to the orderdetailID column and bind that column to the session created by the store order summary behavior.

Thanks for getting back. i saw those two behaviors, but i'm guessing that if i don't have the purchaser logged in, i can't associate the order and it's details with the buyer, unless you have a suggestion or way around that. I'd prefer not to have them have to register/login in if possible, but i do need to know who bought what. Is this possible?

Thanks,
Doug

by storing the billing info in the orders table, you will know who purchased the order.

i did actually think of that, but it seemed like bad practice, but i think you're right. this is a one off app and that would work.

so essentially add all the fields I'm submitting to Authorize.net (except the CC Info for security), like First name, etc to the Orders table, and that should cover it.

I'll give it a shot right now and see what I get.

Thanks,
Doug

I added the Summary behavior leaving the autonumber OrderId blank with no issue.

If I try and leave the DetailID with the Order Details left blank, It errors with "You must set the column specified as the Cart ID"

If I put a any value in for DetailID, it accepts it, but I know this should be left blank. Any idea what's causing the error?

Thanks,
Doug

you are setting the key field to use the detailID column, you need to select the detailorderId column for the key field. the key key field is the column used to create the relationship between the orders and orderdetails tables.

yep, that worked beautifully. One more question. I noticed this thread here:

showthread.php?t=20540&highlight=insert+orderdetails

My form is an event registration form as well. There are two events/products with a limit of a quantity of two for either that can be purchased.

Event 1 has 2 add to cart buttons, but set to replace, so they can only add 2 of either, never both.
Event 2 has a limit of 2 as well, and can be added in addition to Event 1.

Is that thread suggesting I could actually capture the names for each event?

So if they added 2 of event one, i could grab the two names for it. and if they added 2 for event 2, i could grab those as well (four unique names, 2 each associated with a particular event, as an example?)

That would fantastic if possible, but I may have read that thread incorrectly. If it's possible, how would I accomplish that.

Thanks again,
Doug

"Is that thread suggesting I could actually capture the names for each event?"


Yes, it is.

"If it's possible, how would I accomplish that."

I explain how to accomplish it in post 2 of that thread.

That is very cool option.

I think my situation may not work with it, becasue, my static cart has the product id of 1 twice, and set to replace, with a dropdown qty limit of 2.

and product id 2 also set to replace with a qty limit of 2.

so they can only buy 1 variation of product id 1 in addition to product id 2 both with a qty limit of 2.

If I add the name column set to update, it allows them to add the same variation of a either product multiple times.

also, my quantity discount of => 2 * .375 no longer works. It only seems to work if 2 is added at the same time. Not if it occurs in the cart twice.

Dang.

If it were possible to:

1. limit it to one variation of either product
2. never allow it to be in the cart more than twice
3. insert the names (which i see i can)
4. Calculate the discount.

it lives here if you want to see it:

workshops.asp


Thanks,
Doug