Add Product Description to Invoice/orders/emails ect;

I am a stamp dealer and am looking for the code changes needed to add the Products text description to invoices and orders and packing slips ect;. PRODUCTS_DESCRIPTION/PRODUCTS_DESCRIPTION_TEXT is the database table needed. Presently the Zencart only shows the NAME and MODEL and so forth. Would like to add DESCRIPTION after the NAME column on these. Text descriptions show pertinant information on condition of stamps flaws, types, ect;.:unsure:
Here is example:
Present::down:
NAME MODEL PRICE
Scott#34 - .50

Would like this::yes:
NAME DESCRIPTION MODEL PRICE
Scott#34 F/VF MINT - .50

Any help with getting the proper PHP pages to change this and the code to put into them would GREATLY be appreciated. Believe this may help many other merchants in the future as well.:smartass: This ZENCART is a masterpiece!
BEST!
John
http://golowesstamps.com
Cart not live....YET! Will be soon linked to "SALES" links.

Re: Add Product Description to Invoice/orders/emails ect;

Hi there
Have a look at invoice.php and orders.php

Re: Add Product Description to Invoice/orders/emails ect;

These are in the admin folder correct? Have looked but still do not understand what to do. I know I need to add a couple of lines of code to them but am not sure what/how. Advise greatly appreciated.:lookaroun

Re: Add Product Description to Invoice/orders/emails ect;

Went into the Admin section. Found 2 invoice.php files. One is
ADMIN/INVOICE.PHP
The other I found in
ADMIN/INCLUDES/LANGUAGES/ENGLISH/INVOICE.PHP
I added the following line in the "define" section of the ENGLISH file:

define('TABLE_HEADING_PRODUCTS_DESCRIPTION', 'Description');

Then added the following line to the td class list in the ADMIN file before the "Model" class:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_DESCRIPTION; ?></td>

This put "description" perfectly in the title row on the invoices.

I then researched into accessing the text data needed and to my dismay I see there is no PRODUCTS_DESCRIPTION table under the ORDERS_PRODUCTS section in the MySQL Database...thus I cannot call the description. It appears to be more complex than I thought to do this modification. The processes used when a customer orders a product need to be changed so that the database places the "TEXT" description into another table in the ORDERS_PRODUCTS CATEGORY of the MySQL database and then we can call it to be shown on invoices/orders/ect;

Any advise and/or help with this would be greatly appreciated.
Best regards.
John(golowenow):blink:

Re: Add Product Description to Invoice/orders/emails ect;

There are a few ways to do this.

First a comment: For shopowners who use the products-description field to show detailed, colorful, lengthy details about their products, this would be a bad idea. You don't want a 1/2 screen of information coming up under each product ... you'd annoy more customers than you'd please.
However, in the case of your stamp store, you likely only need a small amount of information and likely rely more on images than text. Thus, perhaps the products-description content could be sufficient.

Possible approaches:
1. Use READONLY attributes to describe the components. This is ideal if there are common things that can be attributed to these products. It's not ideal for one-off details.

2. Add a custom field to the product which is editable in the admin area when entering/editing products, and is optionally displayed in the shop. It would be primarily used for displaying order details on invoice/packing-slip etc.
You would have to modify the order class to populate the orders_products.details field from the products_description.details field when the order is placed. The order class also sends the order-confirmation email, so would have to accomodate this as well. The invoice/packing-slip would need to pull the info for display too.

3. Build information into the products_name. However, this is by default limited to 100 characters. This may not produce the desired visual. You could override the long name using per-product-metatags settings and set an override title for the product for more pleasant title display in browser and search engines.

4. You could extend the orders_products.products_name field to much longer and then tell the order class to append the description to the name, up to a maximum of XX characters total. You'd need to do some special coding to handle the insertion of a suitable line-break character (emails vs browser issues) or other separator notation, and pull the description from the database (ie: zen_get products_description($products_id), etc).

I think #4 is likely the least overall work but may produce some odd results in reports, etc.

Re: Add Product Description to Invoice/orders/emails ect;

Thank you DrByte for this information! The 4th option is the key. I am pretty confused as to how to do this though. There are several order classes so do not know which to edit. Am not to concerned with reports ect; because the descriptions will not be very long at all. most would be like

Scott #1113-34 VF MNH(1115 has a small crease)

Temember I only want to pull
PRODUCT_DESCRIPTION/PRODUCT_DESCRIPTION (TEXT)
No images ect;

I looked into the data base and the ORDER_PRODUCTS/PRODUCTS_NAME field is set at VARCHAR 64.
Would I change it to say 150?

I am not very good with PHP code. Most I copy and paste into apropriate areas. Could you please leave some examples I can insert and play aroud with? The breaking point issue really has me stumped. Also PRODUCT_DESCRIPTION($PRODUCT_ID).

Really appreciate your time in this DrByte. I rhink this thread will help others with similar issues like mine. I sell stamps individually, not in bulk and my site is designed to be the most honest and descriptive on the web. Most I sell have no faults thus a DESCRIPTION noted on invoices, ect; looks like this:

NAME:!970 Cayman Island 1113-34 FULL SET DESCRIPTION: Scott #1113-34 VF MNH

BUT some require additional Descriptive content that needs to be printed out on invoices ect; to guarantee the invoice is accurate to protect me when someone purchases a single or set WITH a fault.

I presently have PayPal shopping cart buttons that I put this into. It requires I type these descriptions twice(one for the page and one for the button) Zencart among MANY other things will solve that problem if I can get this one issue resolved.

Once again, thank you for your responses to my issue.:wink2:

Re: Add Product Description to Invoice/orders/emails ect;

OK, I am starting to get a grasp on this issue. I changed the Headings for "MODEL" to "DESCRIPTION" which positions everything perfectly. Before the "TAX" amount ect; were positioning under the headings in the wrong areas ie; tax was under model, price was under tax ect;.
In my case I do not use "MODEL" numbers so this field is not needed on invoices ect;.

I have created a new field in the ORDERS_PRODUCTS table called PRODUCTS_DESCRIPTION.

What I need to know is WHERE/HOW when one places an order and/or adds to the cart a product.....WHAT file copies the said products information from the PRODUCTS table to the ORDERS_PRODUCTS table.Also need to know the line numbers in that file that do this. I use HTML kit to edit pages.

I need to know the exact code to include transferring ONLY the PRODUCTS_DESCRIPTION("table")PRODUCTS_DESCRIPTION("field" text only) to ORDERS_PRODUCTS/(the new field)PRODUCTS_DESCRIPTION.

Then I can change in invoice.php ect; instead of calling the "MODEL" field....call the "DESCRIPTION" field instead.

Hopefully this description is more understandable of what I am trying to do. REALLY appreciate the help on this. Once I have this modification I can go live with Zencart at any time.

P.S. Please do not take any offense to Capitalization and colors as I am only trying to make things clear, hehe I am NOT yelling.:cool:

Re: Add Product Description to Invoice/orders/emails ect;

Tinkered with the order.php class page in the INCLUDES folder again and actually got the thing to change the row in the database but still no text being populated into the products_description field in orders_products table. I am so close I can taste it! Gave up again tonight though. I don't have a lot of time to do this as I work and drive about 13 hours a day. Hopefully tommorrow night there will be a response to this.:shocking: Thank you in advance for any help to my little dilema:blush:

Re: Add Product Description to Invoice/orders/emails ect;

OK I am totally confused. This seems to really be a simple process but I cannot figure out where the ORDER_PRODUCTS TABLE is being populated from...:down: Like stated above I created a new FIELD called PRODUCTS_DESCRIPTION in the ORDER_PRODUCTS TABLE. We need to populate it at the same time that the PRODUCT_ID, PRODUCT_MODEL, ect; ect; is being populated into the ORDER_PRODUCTS TABLE during either when the customer ADDS a product or in the CHECK-OUT phase. I do not know when nor where this population is being activated. Once this new field is populated from PRODUCTS_DESCRIPTION/PRODUCTS_DESCRIPTION<-----this is the TEXT ONLY fieldno images,ect;....we can call this new field into INVOICES/PACKING SLIPS/EMAILS very easily!

PLEASE PLEASE can anyone define where the code is that does this transfer of fields and present some lines of code to add to the new field? Judging by the number of views on this topic there are a lot of Zenners out there looking for answers on this. Thank you for any help on this:wacko:

Re: Add Product Description to Invoice/orders/emails ect;

Perhaps you may consider a friendly donation to the Zen Cart project for taking the time to come up with the answer for you:

includes/classes/order.php
line 692 has:

PHP Code:

      $sql_data_array = array('orders_id' => $zf_insert_id,                               'products_id' => zen_get_prid($this->products[$i]['id']),                               'products_model' => $this->products[$i]['model'],                               'products_name' => $this->products[$i]['name'],                               'products_price' => $this->products[$i]['price'],                               'final_price' => $this->products[$i]['final_price'],                               'onetime_charges' => $this->products[$i]['onetime_charges'],                               'products_tax' => $this->products[$i]['tax'],                               'products_quantity' => $this->products[$i]['qty'],                               'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'],                               'product_is_free' => $this->products[$i]['product_is_free'],                               'products_discount_type' => $this->products[$i]['products_discount_type'],                               'products_discount_type_from' => $this->products[$i]['products_discount_type_from'],                               'products_prid' => $this->products[$i]['id']);       zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

change that to:

PHP Code:

      $sql_data_array = array('orders_id' => $zf_insert_id,                               'products_id' => zen_get_prid($this->products[$i]['id']),                               'products_model' => $this->products[$i]['model'],                               'products_name' => $this->products[$i]['name'],                               'products_description' => zen_get_products_description($this->products[$i]['id']),                               'products_price' => $this->products[$i]['price'],                               'final_price' => $this->products[$i]['final_price'],                               'onetime_charges' => $this->products[$i]['onetime_charges'],                               'products_tax' => $this->products[$i]['tax'],                               'products_quantity' => $this->products[$i]['qty'],                               'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'],                               'product_is_free' => $this->products[$i]['product_is_free'],                               'products_discount_type' => $this->products[$i]['products_discount_type'],                               'products_discount_type_from' => $this->products[$i]['products_discount_type_from'],                               'products_prid' => $this->products[$i]['id']);       zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

And add an additional field in your orders_products table:

Code:

alter table orders_products add column products_description text NOT NULL;

Now you can use the contents of that field in your invoice/packing-slip in the Admin.

To include the info on your order-confirmation emails:
includes/classes/order.php
around line 718 you have:

PHP Code:

      $this->products_ordered_attributes = '';

change to:

PHP Code:

      $this->products_ordered_attributes .= "\n\t" . zen_get_products_description($this->products[$i]['id']);

Re: Add Product Description to Invoice/orders/emails ect;

THE CODE WORKS PERFECTLY!!!!:thumbsup: A donation was posted today. All I could give ATM. THANK YOU DrBYTE!! Made my day! Hopefully this will help other Zenners in the future.:smile:

Re: Add Product Description to Invoice/orders/emails ect;

Hi,
I want to do something similar but with the product order images in the order email. Does anyone know what additional field in the order_products table i would use
To add the description i use this -

alter table orders_products add column products_description text NOT NULL;

so to add the image must be something similar.

Help anyone?
Thanks,
M

Re: Add Product Description to Invoice/orders/emails ect;

Hello Marknew,
I was going to post what I did to add descriptions to emails ect; Perhaps this will help you find what you need to make it work for you. I made this mod up on the fly and by following it it should work as of this zencart version 1.3.7.

Zencart answer to adding description field

How to add a description to email invoices, invoices and packing slips.

First look at:
includes/classes/order.php
line 715(line numbers may change in future versions) has:

Code:

$sql_data_array = array('orders_id' => $zf_insert_id, 'products_id' => zen_get_prid($this->products[$i]['id']), 'products_model' => $this->products[$i]['model'], 'products_name' => $this->products[$i]['name'], 'products_price' => $this->products[$i]['price'], 'final_price' => $this->products[$i]['final_price'], 'onetime_charges' => $this->products[$i]['onetime_charges'], 'products_tax' => $this->products[$i]['tax'], 'products_quantity' => $this->products[$i]['qty'], 'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'], 'product_is_free' => $this->products[$i]['product_is_free'], 'products_discount_type' => $this->products[$i]['products_discount_type'], 'products_discount_type_from' => $this->products[$i]['products_discount_type_from'], 'products_prid' => $this->products[$i]['id']); zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

CHANGE THAT TO:

Code:

$sql_data_array = array('orders_id' => $zf_insert_id, 'products_id' => zen_get_prid($this->products[$i]['id']), 'products_model' => $this->products[$i]['model'], 'products_name' => $this->products[$i]['name'], 'products_description' => zen_get_products_description($this->products[$i]['id']), 'products_price' => $this->products[$i]['price'], 'final_price' => $this->products[$i]['final_price'], 'onetime_charges' => $this->products[$i]['onetime_charges'], 'products_tax' => $this->products[$i]['tax'], 'products_quantity' => $this->products[$i]['qty'], 'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'], 'product_is_free' => $this->products[$i]['product_is_free'], 'products_discount_type' => $this->products[$i]['products_discount_type'], 'products_discount_type_from' => $this->products[$i]['products_discount_type_from'], 'products_prid' => $this->products[$i]['id']); zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

NOW GO TO THE MySQL database and add an additional field in your orders_products table:

Code:

alter table orders_products add column products_description text NOT NULL;

Now you can use the contents of that field in your invoice/packing-slip in the Admin.

To include the info on your order-confirmation emails:
includes/classes/order.php
around line 740 (line number may change in future versions) you have:

Code:

$this->products_ordered_attributes = '';

CHANGE TO:

Code:

$this->products_ordered_attributes = "\n\t" . zen_get_products_description($this->products[$i]['id']);

go to about line 842 (line numbers may change in future versions) and change the following:

Code:

($this->products[$i]['model'] != '' ? ' (' . $this->products[$i]['model'] . ') ' : '') . ' = ' .

CHANGE TO:

Code:

($this->products[$i]['description'] != '' ? ' (' . $this->products[$i]['description'] . ') ' : '') . ' = ' .

GOTO line 849 and do the same change from "model" to "description".

The above code changes are the basics for adding a description.

NOW the key to adding the description to invoices and packing slips ect; is:

OPEN:
admin\includes\classes\order.php

On line 121 add "products_description," without the quotes to the line

Code:

$orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_model,ect;ect;.

THEN on line 153 add under the line

Code:

'model' => $orders_products->fields['products_model'],

ADD THIS LINE:

Code:

'description' => $orders_products->fields['products_description'],

This connects the description to all invoices, packing slips ect; REMEMBER ALL ARE CASE SENSITIVE.

Now to add the TITLE to the invoice page and position it correctly do the following:

OPEN ADMIN/INCLUDES/LANGUAGES/ENGLISH/INVOICE.PHP

ADD THIS LINE OF CODE to the "define" section right under

Code:

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

ADD:

Code:

define('TABLE_HEADING_PRODUCTS_DESCRIPTION', 'Description');

Close that page.
NOW OPEN ADMIN/INVOICE.PHP

ADD the following line of code above the TABLE_HEADING_MODEL line at about line 148

ADD:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_DESCRIPTION; ?></td>

NOW to make everything line up correctly delete the MODEL line of code, ie;

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

NOW on about line 171 and 172 find:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";

AND CHANGE IT TO:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['description'] . '</td>' . "\n";

THAT will insert the descriptions on invoices.
Now close the page. INVOICES are now set up.

NEXT OPEN ADMIN/ORDERS.PHP

FIND on line about 442:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

ADD above that line of code the following:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_DESCRIPTION; ?></td>

THEN delete the MODEL line of code.

THEN FIND on about line 464:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .

AND CHANGE TO:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['description'] . '</td>' . "\n" .

OPEN ADMIN/INCLUDES/LANGUAGES/ENGLISH/ORDERS.PHP

on about line 40 FIND:

Code:

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

ADD ABOVE IT this line of code:

Code:

define('TABLE_HEADING_PRODUCTS_DESCRIPTION', 'Description');

Close both pages. The description has now been added to the orders section of the cart.

OPEN ADMIN/INCLUDES/LANGUAGES/ENGLISH/PACKINGSLIP.PHP

On about line 24 FIND:

Code:

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

ADD the following line of code above it:

Code:

define('TABLE_HEADING_PRODUCTS_DESCRIPTION', 'Description');

Close the page.

NOW OPEN ADMIN/PACKINGSLIP.PHP

FIND on about line 145:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

ADD the following line of code above it:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_DESCRIPTION; ?></td>

THEN delete the MODEL line of code.

NEXT FIND on about line 160:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .

AND CHANGE TO:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['description'] . '</td>' . "\n" .

Close the page. Now all packing slips show the description.

END

Please be aware I am NOT guaranteeing this to work for everyone.
Hope it helps:clap:
JLowe

Re: Add Product Description to Invoice/orders/emails ect;

Hey, thanks for the quick reply. i can see the
products_description text NOT NULL;

is what i would be changing. Any idea what the images field would be called?
Thanks
M.

Re: Add Product Description to Invoice/orders/emails ect;

That would have to probably be answered by Dr. Byte. He helped me with this mod and probably has the answer. Believe you would probably need to change the products_description from text to another format which would add the text WITH the image. The fear is that if a customer orders a large number of items it can make the order confirmation email quite large. I am sure it is doable though. Good luck M! :smartalec:

Re: Add Product Description to Invoice/orders/emails ect;

Thanks golowenow, you've got got me close to working it out.
Dr. Byte are you there?
M

Re: Add Product Description to Invoice/orders/emails ect;

Mark,
I would post a new thread and reference this thread as this one is fairly old now and Dr. Byte may not see your posts here as many new issues are posted daily. Please allow him time to answer your question. He is a busy man...hehe.
Good luck!:smartalec:

Re: Add Product Description to Invoice/orders/emails ect;

Quote:

Originally Posted by golowenow

Hello Marknew,
I was going to post what I did to add descriptions to emails ect; Perhaps this will help you find what you need to make it work for you. I made this mod up on the fly and by following it it should work as of this zencart version 1.3.7.

Zencart answer to adding description field

How to add a description to email invoices, invoices and packing slips.

First look at:
includes/classes/order.php
line 715(line numbers may change in future versions) has:

Code:

$sql_data_array = array('orders_id' => $zf_insert_id, 'products_id' => zen_get_prid($this->products[$i]['id']), 'products_model' => $this->products[$i]['model'], 'products_name' => $this->products[$i]['name'], 'products_price' => $this->products[$i]['price'], 'final_price' => $this->products[$i]['final_price'], 'onetime_charges' => $this->products[$i]['onetime_charges'], 'products_tax' => $this->products[$i]['tax'], 'products_quantity' => $this->products[$i]['qty'], 'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'], 'product_is_free' => $this->products[$i]['product_is_free'], 'products_discount_type' => $this->products[$i]['products_discount_type'], 'products_discount_type_from' => $this->products[$i]['products_discount_type_from'], 'products_prid' => $this->products[$i]['id']); zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

CHANGE THAT TO:

Code:

$sql_data_array = array('orders_id' => $zf_insert_id, 'products_id' => zen_get_prid($this->products[$i]['id']), 'products_model' => $this->products[$i]['model'], 'products_name' => $this->products[$i]['name'], 'products_description' => zen_get_products_description($this->products[$i]['id']), 'products_price' => $this->products[$i]['price'], 'final_price' => $this->products[$i]['final_price'], 'onetime_charges' => $this->products[$i]['onetime_charges'], 'products_tax' => $this->products[$i]['tax'], 'products_quantity' => $this->products[$i]['qty'], 'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'], 'product_is_free' => $this->products[$i]['product_is_free'], 'products_discount_type' => $this->products[$i]['products_discount_type'], 'products_discount_type_from' => $this->products[$i]['products_discount_type_from'], 'products_prid' => $this->products[$i]['id']); zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

NOW GO TO THE MySQL database and add an additional field in your orders_products table:

Code:

alter table orders_products add column products_description text NOT NULL;

Now you can use the contents of that field in your invoice/packing-slip in the Admin.

To include the info on your order-confirmation emails:
includes/classes/order.php
around line 740 (line number may change in future versions) you have:

Code:

$this->products_ordered_attributes = '';

CHANGE TO:

Code:

$this->products_ordered_attributes = "\n\t" . zen_get_products_description($this->products[$i]['id']);

go to about line 842 (line numbers may change in future versions) and change the following:

Code:

($this->products[$i]['model'] != '' ? ' (' . $this->products[$i]['model'] . ') ' : '') . ' = ' .

CHANGE TO:

Code:

($this->products[$i]['description'] != '' ? ' (' . $this->products[$i]['description'] . ') ' : '') . ' = ' .

GOTO line 849 and do the same change from "model" to "description".

The above code changes are the basics for adding a description.

NOW the key to adding the description to invoices and packing slips ect; is:

OPEN:
admin\includes\classes\order.php

On line 121 add "products_description," without the quotes to the line

Code:

$orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_model,ect;ect;.

THEN on line 153 add under the line

Code:

'model' => $orders_products->fields['products_model'],

ADD THIS LINE:

Code:

'description' => $orders_products->fields['products_description'],

This connects the description to all invoices, packing slips ect; REMEMBER ALL ARE CASE SENSITIVE.

Now to add the TITLE to the invoice page and position it correctly do the following:

OPEN ADMIN/INCLUDES/LANGUAGES/ENGLISH/INVOICE.PHP

ADD THIS LINE OF CODE to the "define" section right under

Code:

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

ADD:

Code:

define('TABLE_HEADING_PRODUCTS_DESCRIPTION', 'Description');

Close that page.
NOW OPEN ADMIN/INVOICE.PHP

ADD the following line of code above the TABLE_HEADING_MODEL line at about line 148

ADD:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_DESCRIPTION; ?></td>

NOW to make everything line up correctly delete the MODEL line of code, ie;

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

NOW on about line 171 and 172 find:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";

AND CHANGE IT TO:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['description'] . '</td>' . "\n";

THAT will insert the descriptions on invoices.
Now close the page. INVOICES are now set up.

This does not work. Description is not displayed unfortunatly. i checked twice.

Basicly i would need to allow more than 64chars to the product name. Anybody?

Thanks.

Re: Add Product Description to Invoice/orders/emails ect;

qfreddie

this link my be helpfull to you.

http://www.zen-cart.com/forum/showth...042#post859042

Re: Add Product Description to Invoice/orders/emails ect;

Quote:

Originally Posted by golowenow

Hello Marknew,
I was going to post what I did to add descriptions to emails ect; Perhaps this will help you find what you need to make it work for you. I made this mod up on the fly and by following it it should work as of this zencart version 1.3.7.

Zencart answer to adding description field

How to add a description to email invoices, invoices and packing slips.

First look at:
includes/classes/order.php
line 715(line numbers may change in future versions) has:

Code:

$sql_data_array = array('orders_id' => $zf_insert_id, 'products_id' => zen_get_prid($this->products[$i]['id']), 'products_model' => $this->products[$i]['model'], 'products_name' => $this->products[$i]['name'], 'products_price' => $this->products[$i]['price'], 'final_price' => $this->products[$i]['final_price'], 'onetime_charges' => $this->products[$i]['onetime_charges'], 'products_tax' => $this->products[$i]['tax'], 'products_quantity' => $this->products[$i]['qty'], 'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'], 'product_is_free' => $this->products[$i]['product_is_free'], 'products_discount_type' => $this->products[$i]['products_discount_type'], 'products_discount_type_from' => $this->products[$i]['products_discount_type_from'], 'products_prid' => $this->products[$i]['id']); zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

CHANGE THAT TO:

Code:

$sql_data_array = array('orders_id' => $zf_insert_id, 'products_id' => zen_get_prid($this->products[$i]['id']), 'products_model' => $this->products[$i]['model'], 'products_name' => $this->products[$i]['name'], 'products_description' => zen_get_products_description($this->products[$i]['id']), 'products_price' => $this->products[$i]['price'], 'final_price' => $this->products[$i]['final_price'], 'onetime_charges' => $this->products[$i]['onetime_charges'], 'products_tax' => $this->products[$i]['tax'], 'products_quantity' => $this->products[$i]['qty'], 'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'], 'product_is_free' => $this->products[$i]['product_is_free'], 'products_discount_type' => $this->products[$i]['products_discount_type'], 'products_discount_type_from' => $this->products[$i]['products_discount_type_from'], 'products_prid' => $this->products[$i]['id']); zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

NOW GO TO THE MySQL database and add an additional field in your orders_products table:

Code:

alter table orders_products add column products_description text NOT NULL;

Now you can use the contents of that field in your invoice/packing-slip in the Admin.

To include the info on your order-confirmation emails:
includes/classes/order.php
around line 740 (line number may change in future versions) you have:

Code:

$this->products_ordered_attributes = '';

CHANGE TO:

Code:

$this->products_ordered_attributes = "\n\t" . zen_get_products_description($this->products[$i]['id']);

go to about line 842 (line numbers may change in future versions) and change the following:

Code:

($this->products[$i]['model'] != '' ? ' (' . $this->products[$i]['model'] . ') ' : '') . ' = ' .

CHANGE TO:

Code:

($this->products[$i]['description'] != '' ? ' (' . $this->products[$i]['description'] . ') ' : '') . ' = ' .

GOTO line 849 and do the same change from "model" to "description".

The above code changes are the basics for adding a description.

NOW the key to adding the description to invoices and packing slips ect; is:

OPEN:
admin\includes\classes\order.php

On line 121 add "products_description," without the quotes to the line

Code:

$orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_model,ect;ect;.

THEN on line 153 add under the line

Code:

'model' => $orders_products->fields['products_model'],

ADD THIS LINE:

Code:

'description' => $orders_products->fields['products_description'],

This connects the description to all invoices, packing slips ect; REMEMBER ALL ARE CASE SENSITIVE.

Now to add the TITLE to the invoice page and position it correctly do the following:

OPEN ADMIN/INCLUDES/LANGUAGES/ENGLISH/INVOICE.PHP

ADD THIS LINE OF CODE to the "define" section right under

Code:

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

ADD:

Code:

define('TABLE_HEADING_PRODUCTS_DESCRIPTION', 'Description');

Close that page.
NOW OPEN ADMIN/INVOICE.PHP

ADD the following line of code above the TABLE_HEADING_MODEL line at about line 148

ADD:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_DESCRIPTION; ?></td>

NOW to make everything line up correctly delete the MODEL line of code, ie;

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

NOW on about line 171 and 172 find:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";

AND CHANGE IT TO:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['description'] . '</td>' . "\n";

THAT will insert the descriptions on invoices.
Now close the page. INVOICES are now set up.

NEXT OPEN ADMIN/ORDERS.PHP

FIND on line about 442:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

ADD above that line of code the following:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_DESCRIPTION; ?></td>

THEN delete the MODEL line of code.

THEN FIND on about line 464:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .

AND CHANGE TO:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['description'] . '</td>' . "\n" .

OPEN ADMIN/INCLUDES/LANGUAGES/ENGLISH/ORDERS.PHP

on about line 40 FIND:

Code:

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

ADD ABOVE IT this line of code:

Code:

define('TABLE_HEADING_PRODUCTS_DESCRIPTION', 'Description');

Close both pages. The description has now been added to the orders section of the cart.

OPEN ADMIN/INCLUDES/LANGUAGES/ENGLISH/PACKINGSLIP.PHP

On about line 24 FIND:

Code:

define('TABLE_HEADING_PRODUCTS_MODEL', 'Model');

ADD the following line of code above it:

Code:

define('TABLE_HEADING_PRODUCTS_DESCRIPTION', 'Description');

Close the page.

NOW OPEN ADMIN/PACKINGSLIP.PHP

FIND on about line 145:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

ADD the following line of code above it:

Code:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_DESCRIPTION; ?></td>

THEN delete the MODEL line of code.

NEXT FIND on about line 160:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .

AND CHANGE TO:

Code:

echo ' </td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['description'] . '</td>' . "\n" .

Close the page. Now all packing slips show the description.

END

Please be aware I am NOT guaranteeing this to work for everyone.
Hope it helps:clap:
JLowe

ok.. i figured out adding product description.. tnx.

but i need one detail, a products url. this is added in new products were we can add products url at the bottom thus, i want to add this URL like the description.. how to get the data from the products_description table in column products_url and pass this to table orders_products.

any help is much appreciated..

thnks..

Re: Add Product Description to Invoice/orders/emails ect;

additional...

how did you get this "'products_description' => zen_get_products_description($this->products[$i]['id']),
"

i want to replace this with products_url but cant insert the data to the orders_products_table that have field name products_url.

thanks..

Re: Add Product Description to Invoice/orders/emails ect;

Hi,
Been a long time since seeing a post here. This was developed only to add the products description to emails, invoices and packing slips. It was made to replace the model number as many carts sell items that use descriptions of usually unique items that do not have model numbers. A for instance is....I sell collector stamps. There are no model numbers for those. But in my descriptions I note things like flaws and conditions of the stamps. So I developed this "mod" to add them to emails etc. It still works great with the newest Zencart by the way..:smile: As to adding URL's unless maybe the URL is written into the items description this will not work.
An idea may be to write the html code in your descriptions and thus when it produces an email the link would be created. Hope that helps you!
Regards.
J

1 Attachment(s)

Re: Add Product Description to Invoice/orders/emails ect;

thanks for the reply...

i dont think html in the description is a good idea.. coz it gives the user where the files are located. the purpose of this Product URL is an email that contains a link of the image for the printer to print. i also have 2 different order confirmations for the printer and for the customer. only lacking is the file of the product to be printed or made in the order confirmation. this way, it would make my orders automatic and dont have a hard time sending the product files for the printer and would be easy for the printer also.

so all i want is how to get the value in the field product_url of the table products_description and insert it in the orders_products table where i added a field products_url.

products_url are added during adding new products in the admin.

any help is appreciated.

Re: Add Product Description to Invoice/orders/emails ect;

ummm, why can't you just use downloadable products? The cart is designed for it.:clap:

Re: Add Product Description to Invoice/orders/emails ect;

i dont think download can be use for the purpose because download files are only available in the customers account..

thank you for some insights..

hope someone there has solutions..

Re: Add Product Description to Invoice/orders/emails ect;

thanks to all..

i just figured it out my own way... :smartalec:

Re: Add Product Description to Invoice/orders/emails ect;

Quote:

Originally Posted by bhadz08

thanks to all..

i just figured it out my own way... :smartalec:

Be nice if you posted your solution for others to use.:yes:

Re: Add Product Description to Invoice/orders/emails ect;

ok.. i can post as soon as i can arrange how to do it..

Re: Add Product Description to Invoice/orders/emails ect;

Thank you bhadz08. A true zenner!:clap:

Re: Add Product Description to Invoice/orders/emails ect;

you are welcome... :yes:

here is what i did:

step 1:

in includes/functions/functions_lookups.php, add the code at the bottom but before the '?>'

PHP Code:

/* * Return products url, based on specified language (or current lang if not specified) */ function zen_get_products_url($product_id, $language = '') { global $db; if (empty($language)) $language = $_SESSION['languages_id']; $product_query = "select products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language . "'"; $product = $db->Execute($product_query); return $product->fields['products_url']; }

Re: Add Product Description to Invoice/orders/emails ect;

cont'd:

step 2:

in includes/classes/order.php find

PHP Code:

  $sql_data_array = array('orders_id' => $zf_insert_id,                               'products_id' => zen_get_prid($this->products[$i]['id']),                               //'products_model' => $this->products[$i]['model'],                               'products_name' => $this->products[$i]['name'],                               'products_description' => zen_get_products_description($this->products[$i]['id']),                                                             'products_price' => $this->products[$i]['price'],                               'final_price' => $this->products[$i]['final_price'],                               'onetime_charges' => $this->products[$i]['onetime_charges'],                               'products_tax' => $this->products[$i]['tax'],                               'products_quantity' => $this->products[$i]['qty'],                               'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'],                               'product_is_free' => $this->products[$i]['product_is_free'],                               'products_discount_type' => $this->products[$i]['products_discount_type'],                               'products_discount_type_from' => $this->products[$i]['products_discount_type_from'],                               'products_prid' => $this->products[$i]['id']);       zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

to this:

PHP Code:

  $sql_data_array = array('orders_id' => $zf_insert_id,                               'products_id' => zen_get_prid($this->products[$i]['id']),                               //'products_model' => $this->products[$i]['model'],                               'products_name' => $this->products[$i]['name'],                               'products_description' => zen_get_products_description($this->products[$i]['id']),                               [COLOR="Red"][B]'products_url' => zen_get_products_url($this->products[$i]['id']),[/B][/COLOR]                               'products_price' => $this->products[$i]['price'],                               'final_price' => $this->products[$i]['final_price'],                               'onetime_charges' => $this->products[$i]['onetime_charges'],                               'products_tax' => $this->products[$i]['tax'],                               'products_quantity' => $this->products[$i]['qty'],                               'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'],                               'product_is_free' => $this->products[$i]['product_is_free'],                               'products_discount_type' => $this->products[$i]['products_discount_type'],                               'products_discount_type_from' => $this->products[$i]['products_discount_type_from'],                               'products_prid' => $this->products[$i]['id']);       zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

and find the line:

PHP Code:

$this->products_ordered_attributes = '';

and change to this :

PHP Code:

//-----------$this->products_ordered_attributes = '';       $this->products_ordered_attributes = "\n\n" . "Product Link: " . zen_get_products_url($this->products[$i]['id']) . "\n\n" . "Product Details: " ;

thats it. works perfect!! :smartalec:

Re: Add Product Description to Invoice/orders/emails ect;

please remove the unnecessary "... "

or this one. sorry for that:

PHP Code:

$sql_data_array = array('orders_id' => $zf_insert_id, 'products_id' => zen_get_prid($this->products[$i]['id']), //'products_model' => $this->products[$i]['model'], 'products_name' => $this->products[$i]['name'], 'products_description' => zen_get_products_description($this->products[$i]['id']), 'products_url' => zen_get_products_url($this->products[$i]['id']), 'products_price' => $this->products[$i]['price'], 'final_price' => $this->products[$i]['final_price'], 'onetime_charges' => $this->products[$i]['onetime_charges'], 'products_tax' => $this->products[$i]['tax'], 'products_quantity' => $this->products[$i]['qty'], 'products_priced_by_attribute' => $this->products[$i]['products_priced_by_attribute'], 'product_is_free' => $this->products[$i]['product_is_free'], 'products_discount_type' => $this->products[$i]['products_discount_type'], 'products_discount_type_from' => $this->products[$i]['products_discount_type_from'], 'products_prid' => $this->products[$i]['id']); zen_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

Re: Add Product Description to Invoice/orders/emails ect;

ok, i have this one up and running..

maybe someone knows how to make 2 different confirmation emails to admin and customer...

all i want for the admin is having the "Product URL" and for the customer would only be the standard format.

so this way i can automatically forward the confirmation to the printer.

any help is much appreciated..

Re: Add Product Description to Invoice/orders/emails ect;

golowenow,

I've been wanting to add the product description to our docs for months (everytime the packing lists printed with the meaningless 'model'). I recently found your most thorough walk-through (perfect, i might add) on doing this. Granted, Dr. Byte helped jump start it with the database mod, but your tutorial above was really good.

Thank you for taking the time to document this on-line for others.

Matt

Re: Add Product Description to Invoice/orders/emails ect;

your welcome.

Re: Add Product Description to Invoice/orders/emails ect;

I noted a formatting issue with the product description in my i pad emails where the product description will not wrap to the next line.

Eventually, the solution that I implemented was to rem out the and tags on lines 899 and 901, respectively, of the \includes\classes\order.php file. It fixed the i pad email formatting by allowing the description to wrap. I have not found any unwanted side effects anywhere else...so far.

Code:

//'' . ' '. nl2br($this->products_ordered_attributes) .'' . //'' .

Thought I'd put this out there for anyone else to use.

Matt

Re: Add Product Description to Invoice/orders/emails ect;

Hi everyone!
I have followed the steps written here below but i have no results:
After i have insert the code mentioned when I click on buy button I have back a blank page. I use Zen-Cart 1.3.9e italian version.
There's anyone that understand what I'm wrong??

Thanks in advanced.

Bye bye

Re: Add Product Description to Invoice/orders/emails ect;

Quote:

Originally Posted by mercurioservice

... I have back a blank page...

https://www.zen-cart.com/tutorials/index.php?article=82

Re: Add Product Description to Invoice/orders/emails ect;

Thanks for reply!!! I just made it and it's working!!
Now i have to insert the same field in online order that the customer can see after login. I see that the file maybe is tpl_account_history_info_default.php but i do know the code to insert to show the field 'products_description' .

Thanks in advanced

Re: Add Product Description to Invoice/orders/emails ect;

Is there an updated code for V151?

Re: Add Product Description to Invoice/orders/emails ect;

Recently upgraded to ZC v1.5.3. This mod seems to work fine. Also, we upgraded to the Edit Orders 4.1.4 plug-in. IMO, Edit Orders ("EO") is one of the most useful plug-ins available for ZenCart.

The new EO version behaves a bit differently than the prior version that we used. Anytime you "update" from the edit_orders page, it re-writes the entire lines from the orders_Products table for that order, so the product descriptions from this mod get deleted. Even if all you did was change the quantity on one line item, every line gets re-written and loses the product description saved by this mod.

I made the changes below to the edit_orders mod which seem to 1) save (i.e. fetches and re-writes) the product descriptions and 2) saves new product descriptions for any additional products added to the order via the edit order screen. I'm no programmer, so tread carefully and feedback any edits/ improvements for all to use. But it seems to work fine here.

In the file: admin13/includes/functions/extra_functions/edit_orders_functions.php; Near line 469; Change from:

Code:

'SELECT `p`.`products_id`, `p`.`master_categories_id`, `p`.`products_status`, ' .

TO:

Code:

'SELECT `p`.`products_id`, `p`.`master_categories_id`, `p`.`products_status`, `pd`.`products_description`, ' .

Then near line 486, after the line:

Code:

'model' => $query->fields['products_model'],

add the line:

Code:

'description' => $query->fields['products_description'],

Repeat this at/about line 768: find

Code:

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

and enter a new line below it:

Code:

'products_description' => $product['description'],