Customising 'order comments' text input box

[BlindSide]

May I take the liberty of trying to pick your brains concerning adding fields to the database?

Sure

do you know which table I should be dealing with when it comes to adding fields?

Well technically speaking, you can add fields to any table you want. However let's look at your intent. You want to collect additional information when people place orders. Assuming that information is order-specific and not product-specific, you'll probably want to add your fields to the `orders` table.

Alternatively, customer comments are stored as part of the first order status entry in `orders_status_history`, created at the time the order is created. If your data is somehow tied to updating order status, this is another good possibility.

However you're missing what may be the best option, and that's to simply create your own table from scratch. You don't have to worry about mucking things up when it comes time to upgrade, and you have total freedom to do it however you want. Again, going back to your idea, you would tie your data to the relevant order using the `order_id` (which you would store as a key in your table).

It's unrelated to your project, but have a look at the Super Orders addon. This is a module I built some time ago (and currently managed by others who were awesome enough to pick it up), utilizing several completely custom tables.

I don't know how much of a developer you are, but if you're going to do this yourself, you have to think of Zen Cart in less strict terms. It's not a finished building, but a framework that can be modified to suit your needs.

[blackmafia]

You've assumed correctly that it's order specific, but it I don't think it needs to be tied to updating the order status. The main thing is having the info sent in the new order notification email and as long as that happens then the info doesn't even need to be saved in the database.

I did find reference to the customer comments in the database now you mention the correct table. I think I was expecting to find it in a table with a customer_something title.

I did think maybe a new table would be best, but for some reason I had it in my head that I would have to keep the new fields in the same location as the comments. But it looks like a new table is the way to go then. Must admit it never even occurred to me that upgrades could mess things up.

Anyway, I think you've probably given me enough of a pointer there for me to go and have a play around now So Thank You very much for your help, it is very much appreciated.

Btw, I'm not in the developer class. I'm just a poorly paid guy who finds buying the manual and having a go works out more economical than paying top whack for a guru.

[BlindSide]

Happy to help! As one of those top whack-charging gurus (though I'd hardly consider myself a "guru"), I am always thrilled to see newbies take a shot at it! Most times you can indeed save yourself some money by doing it yourself. If nothing else, you gain a better understanding of the system you work with, which makes you more equipped to layout a project should the time come where you need to hire someone.

[blackmafia]

Well I have really surprised myself as I have successfully managed to create the individual form fields and have the entered info pass across from 'checkout_shipping.php' to checkout_payment.php' and then show up on the 'checkout_confirmation.php' page.

I did create a separate table in the database but then couldn't figure out how I was going to get the info from the form to the database. I decided to expand the 'orders_status_history' table. My thoughts were going along the lines that somewhere amongst all the files, the necessary code was already written to put info into that table and get it out again, so all I would need to do is go through all the files looking for anything to do with 'Comments" and do a bit of a copy and paste operation, editing 'Comments' to put my own field names in.

I certainly did not find it very easy, and chances are I've not even done it properly, but it works the way it is so I'm happy with that.

Anyway, I have another problem now which has cost me a new computer and a new window.

I am really baffled how to get the info sent in the New Order order confirmation email. I have edited the email_template_checkout.html and email_order_status.html files in the emails folder and also in the admin folder I have edited 'invoice.php and orders.php and also admin/includes/languages/english/orders.php and packingslip.php but none of these efforts are getting me anywhere.

Can anyone help and tell me what I'm missing please?

[blackmafia]

I've done it and it all works!

But all I have to do now is try to straighten up my form and adjust some of the labels.


If anyone else needs help let me know and I'll try and give you some instructions. But wait at least a couple of weeks while I get the rest of my store sorted out. (Or messed up )

And thanks for your help Frank, couldn't have done it without your pointers.

[BlindSide]

Bravo! All you needed was a push in the right direction.