Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 41
  1. #21
    Join Date
    Jun 2009
    Posts
    41
    Plugin Contributions
    0

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

  2. #22
    Join Date
    Jul 2006
    Location
    Washington State
    Posts
    77
    Plugin Contributions
    0

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

  3. #23
    Join Date
    Jun 2009
    Posts
    41
    Plugin Contributions
    0

    Default 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.
    Attached Images Attached Images  

  4. #24
    Join Date
    Jul 2006
    Location
    Washington State
    Posts
    77
    Plugin Contributions
    0

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

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

  5. #25
    Join Date
    Jun 2009
    Posts
    41
    Plugin Contributions
    0

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

  6. #26
    Join Date
    Jun 2009
    Posts
    41
    Plugin Contributions
    0

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

    thanks to all..

    i just figured it out my own way...

  7. #27
    Join Date
    Jul 2006
    Location
    Washington State
    Posts
    77
    Plugin Contributions
    0

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

    Quote Originally Posted by bhadz08 View Post
    thanks to all..

    i just figured it out my own way...
    Be nice if you posted your solution for others to use.

  8. #28
    Join Date
    Jun 2009
    Posts
    41
    Plugin Contributions
    0

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

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

  9. #29
    Join Date
    Jul 2006
    Location
    Washington State
    Posts
    77
    Plugin Contributions
    0

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

    Thank you bhadz08. A true zenner!

  10. #30
    Join Date
    Jun 2009
    Posts
    41
    Plugin Contributions
    0

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

    you are welcome...

    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'];
      } 
    Last edited by bhadz08; 22 Jun 2010 at 06:25 AM. Reason: lack of information

 

 
Page 3 of 5 FirstFirst 12345 LastLast

Similar Threads

  1. Add Product Image into orders emails
    By marknew in forum Managing Customers and Orders
    Replies: 1
    Last Post: 7 Oct 2010, 02:26 AM
  2. Order Invoice - Product Description
    By Failed_Attempt in forum Managing Customers and Orders
    Replies: 15
    Last Post: 8 Sep 2010, 04:41 PM
  3. Looking to add print invoice and shipp invoice from admin---> orders
    By r4fdud in forum Upgrading from 1.3.x to 1.3.9
    Replies: 0
    Last Post: 15 Mar 2009, 11:21 PM
  4. adding product description to emails problem
    By golowenow in forum Managing Customers and Orders
    Replies: 9
    Last Post: 24 Apr 2007, 02:54 AM
  5. Add Product Description to Orders
    By DiZZ in forum General Questions
    Replies: 1
    Last Post: 8 Nov 2006, 04:08 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR