Adding location to the invoice

Post by ncc50446@hotmail.com » Fri Mar 19, 2010 4:02 am

Hey,
What I need to do is to input the location of the item into invoice. Not for the customer to see, but for the admins. But I can't seem to figure out where I would add that in. I'm sure I can figure out how to display it on the invoice for admins, but I can't seem to figure out how to input it into the database.
Thanks for any help

Post by ncc50446@hotmail.com » Sun Mar 21, 2010 9:03 am

Post by i2Paq » Sun Mar 21, 2010 6:01 pm

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.

Post by ncc50446@hotmail.com » Mon Mar 22, 2010 6:07 am

I just need it in the database. I just wont call it, and then it wont show. But I'm not sure how to get it into the order_product table. Just need a small hint as to which files I need to edit.
I assume I need to edit
catalog/controller/checkout/confirm.php
and
catalog/model/checkout/order.php
But I'm not sure.

Thanks for any further help

Post by ncc50446@hotmail.com » Tue Mar 23, 2010 6:36 am

Can a mod please move this to the 'Development' forum. Maybe this is just the wrong forum and would do better there.
Thank you, I really need to figure this out

Post by Qphoria » Tue Mar 23, 2010 6:58 am

Post by ncc50446@hotmail.com » Tue Mar 23, 2010 3:41 pm

Yes, thats what I'm looking at doing So I want to input it into the order_product table, but I can't seem to figure out which files to edit...I'm a little lost lol I thought would just be two files, but I seem to be missing something somewhere...So hoping someone could at least point me in the right direction
And sorry, I was just hoping to get it placed in the right forum (Unless it already is lol)

Post by Qphoria » Thu Mar 25, 2010 9:20 am

'model'    => $product['model'],

'location' => $product['location'],

$option_data = array();

$query = $this->db->query("SELECT location FROM " . DB_PREFIX . "product WHERE product_id = '" . $product['product_id'] . "'");
$product['location'] = $query->row['location'];

<?php echo $product['model']; ?>

<?php echo $product['model']; ?> (<?php echo $product['location']; ?>)

Post by ncc50446@hotmail.com » Fri Mar 26, 2010 2:31 am

Awesome! Thank you very much! I will add it tonight
Taking a look, I see what you did...You didn't add it to the database, just pulled it from the database. Guess that would make it easier wouldn't it?
Sadly however, nothing is ever easy...I need it to go to the database...
But...You did give me an idea. I just move that code from the admin, to the /catalog/controller/checkout/confirm.php. I select the info from the products table, and input it into the order_product table.
I'll try it out tonight and get back to you on how it went.
Thanks again Qphoria!