Adding Field to Checkout

As far as I can see there is no Zen Cart or Super Orders item called 'frequent_code' and there's certainly nothing in the Zen Cart orders table, so this must be something that you have added.

How and where have you added the data item? How do you populate it? Where do you store the data? Have you put in place a mechanism for retrieving it into the $order->info array?

i make the changes that are in the first post, In orders database table i add a new column called "store the data", After a test sale, i can see the data included in the "order_frequent_code" db with phpmyadmin, but i don´t know how to retrieving it to show in admin.

thanks

You'll need to edit your /admin/includes/classes/orders.php file. You'll see in this file that there is a SELECT statement which grabs the relevant data from the ORDERS table. Add your frequent_code to this select statement.

Next you'll see where the orders->info array gets populated, and you need to follow the same principles here, to add your frequent_code to this array.

Once you've added it to the array, as long as the object is initiated, it will then be available to you.

Good luck

Absolute

The instructions were great and worked like a charm. I've added new fields and the info is going into the database.

Now I need for it to be output to the confirmation page. How do I do that?

Hello, I'm trying to add a text box on the shipping page and have followed the instructions in this thread.

The trouble is, whilst it works perfectly on my local test site, when I upload the modified files to the remote site the text from the additional box doesn't go into the database. Any ideas? I get no error message or anything, and all the other functionality seems to be working fine... its driving me crazy!!! any help is greatly appreciated...

I'm trying to use the box to gather a date from the customer for when they would like the delivery... so any other solution appreciated. Thanks

I've got a date being recorded, but need to know how to make it show in the email sent to the customer and store owner.

Hello Absolute,

Reading through this whole thread i think you can help me here.
On the check out shipping page, there are a bunch of options, but I want to have only one shipping option to show for a certain product (they can only be ship ground). Can you help?

Let me jsut check - you offer a number of shipping methods normally, however, if they select a certain item, then you only want to offer one method - correct?

If so, you need to alter your shipping methods, to check for the presence of the item in the basket. If it is there, then you need to diable the other shipping methods.

If this is what you need, just say, and I'm sure we can find you some code......

Absolute

This was really helpful to get me started on a date picker mod that i needed for a client.

It took me about 4 hours, but I finally got it to work.
You also need to make sure you update your classes > order.php file in the Admin folder in order to make it work as Absolute #25 mentioned above, read carefully.

Thank you.

I have read through this thread, and I think I'v followed the instructions accurately, but the data entered in my new field is not showing up in the DB. Here is the code in excruciating detail (using 1.3.7):

Here's the mysql code to add the column:

ALTER TABLE zhanken_orders ADD order_other_dist VARCHAR( 128 ) NOT NULL COMMENT 'my mod' AFTER paypal_ipn_id ;

Edited order.php as indicated (won't post the whole thing), replacing 'order_frequent_code' with 'order_other_dist', and 'frequent_code' with 'other_dist'

and from checkout_shipping/header_php.php

$free_shipping = false;
if ( ($pass == true) && ($_SESSION['cart']->show_total() >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER) ) {
$free_shipping = true;
if (isset($_SESSION['other_dist'])) {
$other_dist = $_SESSION['other_dist'];
}
}
} else {
$free_shipping = false;
}

require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));

if (isset($_SESSION['comments'])) {
$comments = $_SESSION['comments'];
if (zen_not_null($_POST['other_dist'])) {
$_SESSION['other_dist'] = zen_db_prepare_input($_POST['other_dist']);
}
$other_dist = $_SESSION['other_dist'];
}

// process the selected shipping method
if ( isset($_POST['action']) && ($_POST['action'] == 'process') ) {
if (zen_not_null($_POST['comments'])) {
$_SESSION['comments'] = zen_db_prepare_input($_POST['comments']);
}

The test sale completes successfully, but the order_other_dist field is empty. Please help the FNG if you can...

I think this could be as simple as changing the name of your field from this:

<fieldset class="shipping">
<legend>Please enter the name of your preferred wholesaler/distributor:</legend>
<?php echo zen_draw_textarea_field('comments'); ?>
</fieldset>

To

<fieldset class="shipping">
<legend>Please enter the name of your preferred wholesaler/distributor:</legend>
<?php echo zen_draw_textarea_field('other_dist'); ?>
</fieldset>

Also this last bit is a little wrong

if (isset($_SESSION['comments'])) {
$comments = $_SESSION['comments'];
if (zen_not_null($_POST['other_dist'])) {
$_SESSION['other_dist'] = zen_db_prepare_input($_POST['other_dist']);
}
$other_dist = $_SESSION['other_dist'];
}


// process the selected shipping method
if ( isset($_POST['action']) && ($_POST['action'] == 'process') ) {
if (zen_not_null($_POST['comments'])) {
$_SESSION['comments'] = zen_db_prepare_input($_POST['comments']);
}

Change to

if (isset($_SESSION['comments'])) {
  $comments = $_SESSION['comments'];
}
if (isset($_SESSION['other_dist'])) {
  $other_dist = $_SESSION['other_dist'];
}

// process the selected shipping method
if ( isset($_POST['action']) && ($_POST['action'] == 'process') ) {
  if (zen_not_null($_POST['comments'])) {
    $_SESSION['comments'] = zen_db_prepare_input($_POST['comments']);
  }
  if (zen_not_null($_POST['other_dist'])) {
    $_SESSION['other_dist'] = zen_db_prepare_input($_POST['other_dist']);
  }
}

That should solve all your problems, but let us know how you get on.

Absolute

You, sir, are a golden god! It was the last part.

I had the field name right on the server...just copied from the wrong file in my frantic post.

Heading for the donate button after I hit submit...

Great thanks!

You can keep that kind of praise coming! Glad to know I was able to help you find the solution. - Absolute

Hi All,
I've read through this thread very carefully and still ca't get it to work :-(

Quite simply I need to add 3 extra text boxes to my checkout_payment_default.php (I've already altered the standard comments box). The text fields need to allow visitors to add:- Their accommodation name

• The resort
• Their arrival date
• vacation duration.This then needs to be transfered to the checkout_confirmation_default.php AND into the confirmation mail to both admin and the customer.

I have added the following code to my checkout_payment_default.php:

<fieldset>
<legend><?php echo TABLE_HEADING_COMMENTS; ?></legend>
<?php echo TABLE_EXCURSION_COMMENTS; ?>
<ul>
<li><?php echo TABLE_EXCURSION_ACCOM; ?><?php echo zen_draw_input_field('accommodation'); ?></li>
<li><?php echo TABLE_EXCURSION_RESORT; ?><?php echo zen_draw_input_field('resort'); ?></li>
<li><?php echo TABLE_EXCURSION_ARRIVAL; ?><?php echo zen_draw_input_field('arrivaldate'); ?></li>
<li><?php echo TABLE_EXCURSION_DURATION; ?><?php echo zen_draw_input_field('duration'); ?></li>
</ul>
</fieldset>

Which is what I need the visitors to add details to, however the text boxes are not inline and it looks awful !

I then added the following code to my checkout_confirmation_default.php:

<h2 id="checkoutConfirmDefaultHeadingComments"><?php echo HEADING_ORDER_COMMENTS; ?></h2>
<div class="buttonRow forward"><?php echo '<a href="' . zen_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL') . '">' . zen_image_button(BUTTON_IMAGE_EDIT_SMALL, BUTTON_EDIT_SMALL_ALT) . '</a>'; ?></div>
<div><?php echo TABLE_EXCURSION_ACCOM; ?><?php echo (empty($order->info['accommodation']) ? NO_COMMENTS_TEXT : nl2br(zen_output_string_protected($order->info['accommodation'])) . zen_draw_hidden_field('accommodation', $order->info['accommodation'])); ?></div>
<div><?php echo TABLE_EXCURSION_RESORT; ?><?php echo (empty($order->info['resort']) ? NO_COMMENTS_TEXT : nl2br(zen_output_string_protected($order->info['resort'])) . zen_draw_hidden_field('resort', $order->info['resort'])); ?></div>
<div><?php echo TABLE_EXCURSION_ARRIVAL; ?><?php echo (empty($order->info['arrivaldate']) ? NO_COMMENTS_TEXT : nl2br(zen_output_string_protected($order->info['arrivaldate'])) . zen_draw_hidden_field('arrivaldate', $order->info['arrivaldate'])); ?></div>
<div><?php echo TABLE_EXCURSION_DURATION; ?><?php echo (empty($order->info['duration']) ? NO_COMMENTS_TEXT : nl2br(zen_output_string_protected($order->info['duration'])) . zen_draw_hidden_field('duration', $order->info['duration'])); ?></div>
<br class="clearBoth" />

But all I get is "none" in this comments boxes when the page appears.

I;m sure it something I've missed, but any help would be most appreciated with this problem. I also need to make these boxes "required".
Many thanks,
Pete

shoreham1, have you fixed your problem, because i need something almost just like what you need for my wife's linen rental shopping cart?

could someone help me? i need basically the same exact thing as shorham1, of course the field names will be different.

bump. anyone there that can help?

@Shoreham1

There's no evidence in your post of the steps that you have taken to read the data collected on the payments page, store it anyway or extend the orders class to encompass it so that you can retrieve it on the confirmation page. I recommend re-reading post #2 where all these steps are included.

@BackSpacer

There is no easy answer for adding fields to the checkout. It's a complex change requiring requiring significant Zen Cart, PHP and database skills, and a slightly different solution each time. Each time I do it, I find myself having to re-familiarise myself with the cart and orders class code, so there's a big investment in time needed by anybody responding to questions about it. Before investing my personal time responding, I would want to see that you've at least read what has already been written, in particular at the top of this thread where Absolute has carefully explained one approach in detail. How did you get on with that? Does that solution work for you?

Thanks Kuroi,

I have read in detail this thread and other similar ones, but none of them have helped. They got me started, but they really didn't detail how to show the details in the backend and how to make the fields play nice with the database. I finally gave up on it and re-installed a fresh copy of zen cart to try again. I have thought about trying to mod the ship date or order delivery date mod if i can. If someone can help me out, I would gladly paypal them some money, as long as its reasonable of course. I need four required fields sometime during checkout that will be on all invoices that are emailed to customer and admin and also show them on the orders in the backend. I really don't even need a shipping screen or options because all items are delivered free. My wife has a linen rental business at topsail island, NC. I paid someone a few years ago to mod the osc shopping cart that she uses now and it works fine, but I would like to try zen cart. It seems very similar, yet has more features. If someone is interested in trying to help me out, you can do a test c.o.d. order at her website at https://www.meandmomrentals.com. we are a very small home based business, so if you place a test order, we would know its a test and not real. if you input your real email address you would also see the info that is passed back to you. any takers for this job?

thanks,
Jamie

Well I just picked up on this thread of course I am totally lost at this point since the thread seems to be a bit up and down. I have a need for an extra field and a pull down on the check out page. We from time to time promote the local schools by allowing our clients to donate part of their purchase price to a school of their choice. We allow this on 5 of our products that are in a kit format. Need to have the mechanics in place for them to select which school they wish to donate to. Of course this will need to be reflected on the reports and need to be able to toggle this on and off, since this is a special fundraser deal. Now you are as confused about my needs as I am about parts of this post. If anyone can decipher my needs is it possible?