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..

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

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.

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

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..

thanks to all..

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

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:

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

Thank you bhadz08. A true zenner!:clap:

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'];
  } 


---