Results 1 to 3 of 3

adding multiple manufacturers to products

This is a discussion on adding multiple manufacturers to products within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; Is there a way to have more than one manufacturer attached to a product? I've changed the "manufacturer" to "Authors", ...

      
  1. #1
    Lurker
    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0


    Default adding multiple manufacturers to products

    Is there a way to have more than one manufacturer attached to a product?

    I've changed the "manufacturer" to "Authors", but several of our products are collaborations and I would like it so that the product page will display all its contributors, and for the product to appear in the search for each of its authors.

    Any suggestions?

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    Default

    Hi,

    You could always put the names of all the authors on the product page in the description.
    Michael Sasek
    osCMax Developer


    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Lurker
    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0


    Default

    Well, here's what I've got thus far...
    I've added a 2nd manufacturer id to my products and now when you go to the product page both manufacturers are listed in the right column. The only issue I'm having now is getting the all the products to show up on each manufacturer's search page. I'm pretty sure that my solution lies in altering the defult.php code. I can change it to display products for either the 1st id or the 2nd, but not both at the sametime - which is what I want.

    here's the line of code... (starting appx at line 172)
    Code:
    // show the products of a specified manufacturer
    * *if (isset($HTTP_GET_VARS['manufacturers_id'])) {
    * * *if (isset($HTTP_GET_VARS['filter_id'])) {
    // We are asked to show only a specific category
    * * * *$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . $HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . $languages_id . "' and p2c.categories_id = '" . $HTTP_GET_VARS['filter_id'] . "'";
    * * *} else {
    // We show them all
    * * * *$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . $HTTP_GET_VARS['manufacturers_id'] . "'";
    * * *}
    Is there a way to include more information into the $listing_sql variable? I get the code to display product for the 2nd id by changing the...
    Code:
    p.manufacturers_id = m.manufacturers_id
    to
    Code:
    p.manufacturers2_id = m.manufacturers_id
    Any help one can offer would be appreciated!

Similar Threads

  1. New products page.... Multiple columns
    By jdlev77 in forum osCommerce 2.2 Discussion
    Replies: 4
    Last Post: 08-27-2005, 08:47 PM
  2. Temporarily inactivate multiple manufacturers?
    By A2ZBob in forum osCommerce 2.2 Modification Help
    Replies: 1
    Last Post: 12-10-2004, 09:18 AM
  3. Multiple Catagories and Adding Fields
    By Lalla in forum osCommerce 2.2 Modification Help
    Replies: 5
    Last Post: 02-20-2004, 04:19 AM
  4. Modify Manufacturers Box to only show Manufacturers that are
    By elemar in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 12-09-2003, 01:16 AM
  5. Contribution for adding multiple products
    By jacven in forum osCommerce 2.2 Modification Help
    Replies: 3
    Last Post: 10-22-2003, 08:23 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
  •