ecart 4 email confirmation

Hi

I have developed a shopping cart by using ecart4, and integrated email confirmation through UE, now problem is
1.When I am trying to purchase more than one order, it is not showing only one product details in confirmation page, even in database, it is showing single insertion (record)

2. Can I trime order number(session id), I tried <?php echo rtrim(session_id()),1,4; ?> but unable to get result, my client dont want lengthy order number, so please suggests me how to resolve this

Please help me

Site got live today only

Please help

add the following code to the checkout success page after the closing </html> tag:

<?php

// Initialize the session.

// If you are using session_name("something"), don't forget it now!

session_start();



// Unset all of the session variables.

$_SESSION = array();



// If it's desired to kill the session, also delete the session cookie.

// Note: This will destroy the session, and not just the session data!

if (ini_get("session.use_cookies")) {

    $params = session_get_cookie_params();

    setcookie(session_name(), '', time() - 42000,

        $params["path"], $params["domain"],

        $params["secure"], $params["httponly"]

    );

}



// Finally, destroy the session.

session_destroy();

?>

you dont need to use the session_id() for the order number, you could use the orderID column from the rders table to generate the order number.

Hi

My previous message is not clear and has some mistake, actually I want to add repeat region on order confirmation email page( i.e, if vistor buys more than one product, it should display on order confirmation email page) Now it shows only one product even visitor purchase more than one product. Hope now I am clear with my requierment

2.
you said "you dont need to use the session_id() for the order number, you could use the orderID column from the rders table to generate the order number."

Please can you tell me how to make OrderID increamenta and unique with every order

Thanks

use an email friendly cart display in the email to show the entore cart contents. Insert -> WebAssist -> eCart -> Cart Display Manager. Set the display type to email friendly.


If you use the orderID column from the orders table, it is a primary key column that will be unique and will be set to auto increment.

Hi
Thanks a lot for your help, now it is showing multiple products and I need more information on order id
what code should I need to keep on checkout success page, and I want to send same orderid to purchaser on email confirmation page along with purchase date

thanks again

your confirm page should be storing the order information in the database using the eCart Store order Summary and Store Order details behaviors.

when the Store Order Summary Behaviors runs, it will create a session variable that contains the OrderID value from the primary key of the orders table.

Double click the store order summary behavior on the confirm page and make note of the session variables name.

You should be able to find the session variable listed in the session section of the bindings panel. This binding will give you the code to use to show the OrderID.

Hi,
I already kept session as order ID but my client dont want lengthy numbers, as advised by you we can keep columnid as OrderId, so please let me know how to integrate code which retrieve columnid value

And I want to add date as hidden field to capture purchase date
<input type="hidden" name="shipping" id="shipping" value="<?php echo (date('d-m-y')); ?>" />
but i cannot get result,please help me

thanks

the orderID column in the order table should be set as the primary key column, it should be set to auto increment. the database will handle setting the value for this column, you should bne storing the sessionID in that column.

Hi

Thanks for your reply, I will follow the steps you mentioned above, but you skipped date feature, my client want to add date when visitor make purchase(purchase date must insert into database table)

please help me

in the orders table, create an orderdate column, set it to be a timestamp and set the default value to CURRENT_TIMESTAMP