Packing Slip - Adding Manufacturer

[Pip]

I'm a complete novice who has only written in HTML before, but from reading the posts on this forum have managed to set up an online shop that is better than I imagined I could achieve. I do have one problem...

I would like to add the manufacturers name to my packing slip (as I have the same product made by different people). How can I do this? I have managed to add the shipping method and customer comments, but can't work out how to add in the manufacturer. I imagine I need to join in another table as this isn't in the same table as the other info that appears on this page. help!

I am using 1.3.5.

[Ajeh]

NOTE: it is strongly recommended that you upgrade to v1.3.6 ...

The Manufactuer's information is not stored with the product on the orders_products table ... however, you can pick up the manufactuers_name via a function call ...

There is a function in the:
/includes/functions/functions_lookups.php

/*
 * Return a product's manufacturer's name, from ID
 * TABLES: products, manufacturers
 */
  function zen_get_products_manufacturers_name($product_id) {
    global $db;

    $product_query = "select m.manufacturers_name
                      from " . TABLE_PRODUCTS . " p, " .
                            TABLE_MANUFACTURERS . " m
                      where p.products_id = '" . (int)$product_id . "'
                      and p.manufacturers_id = m.manufacturers_id";

    $product =$db->Execute($product_query);

    return ($product->RecordCount() > 0) ? $product->fields['manufacturers_name'] : "";
  } 

This could be added to the:
/admin/includes/functions/extra_functions

directory in your own file to use in the Admin ...