Where can I find info for customizing packing slip and invoice

[ebaobao]

Hello,
I've been looking through the forums and goole and can't find much info. Can anyone point me to the right direction where I can find info on customizing the packing slip and invoice. I would like to add additional data and columns to them. Thanks.

[ebaobao]

Hello,
This thread actually has a few more questions I want to ask about. Here is what I'm trying to do.

1. Create Custom Fields for a product say for example I want to create a field called "Location" where I can put a location specific to that product.

2. I want to make sure these custom fields are not viewable on product detail page.

3. However, I would like them to be printed on my packing slip and invoices.

This way, when the warehouse guys goes to pickup the merchandise, they know exactly where to go instead of searching like crazy.

What are some of the things out there that can help me start on this tasks. Thank you very much for any help. I've been looking everywhere and its hard finding a good solution.

[stevesh]

You're talking about a good bit of custom coding.

The 'Commercial Help Wanted' forum might be your best bet.

[ebaobao]

Hi Steve,
Thanks for the reply. I was able to get it to work. I hope this helps anyone out there.

[timstoel]

Could you post an example of your packingslip.php file? I am having difficulty getting this to work, but I am very close

Thanks!
Tim

[ebaobao]

Hello,
I was able to add customize fields to my products by following crazy_chris directions. However, i'm not sure what the code would be to pull the customize info that I was able to add into the "products" table.

I'm sure I would need some sort of ID that is passed onto the packingslip.php, and access the "products" table with the id and call the correct field.

But I'm knew to PHP and I'm not able to figure it out.

Any help would be much appreciated. Thanks!

[ebaobao]

some how I need to get the products ID from the packingslip.php and then call the "products" table and pull the customize fields where the ID matches the product ID. I can say how I want to do it, but I just don't know how to code it! WAAAH!!

[ebaobao]

I'm able to grab the product id with this code:

$order->products[$i]['id']

But now, I need the code on how to call the "products" database using this id and then display the specific column data I want.

Someone help me

[ebaobao]

Yes I figured it Out!!!

I was able to edit packingslip.php to do the following.

This is the code I use to pull out info from the database:
$product_info = $db->Execute("select products_unit_measure, products_location
from " . TABLE_PRODUCTS . "
where products_model = '" . $order->products[$i]['model'] . "'");

make sure its in the for loop so it gets the correct info for that specific product. then I display like this.

echo $product_info->fields[products_location];

this is so funny considering I don't even know any PHP, I just kinda look at the code in the page itself and tried to copy and stuff Man Zen Cart rocks when you know the insides, so awesome you can do so much customization!!!