Jump to content

talon177

Members
  • Content count

    403
  • Joined

  • Last visited

Everything posted by talon177

  1. talon177

    Master Products - MS2

    Thanks for the reply Johnson, i tried your product_info file along with the master_products modifications on a brand new oscommerce v2.2 MS2 with master products 1.1.2 and the outcome is still the same When you click on cart contents, the slave product shows thumbnail = 30 name = 30 and buy now = 28 (Master PRoduct) Also the same goes for the shopping cart box on the top right the slave product added shows products_id = 28. Thanks again, hope I can get this fixed soon, cause my slave products are only 10 word descriptions, and the master product has all the description.
  2. talon177

    Master Products - MS2

    This mod is awesome, after looking over it a second time, i noticed a few things to fix, but am stuck on a couple. Shopping Cart Box on the top left: Does anyone know how to make the slave products link back to the master product instead of its own? For example if master product id = 28, when adding slave product id 29 to your shopping cart, the shopping cart box displays product id = 29, while if you look at the actual shopping cart when u click on cart contents it shows product id = 28. Manufactuers Select Box: When selecting on a manufactuer such as Matrox, and product is a slave and is shown in the product listing display, the thumbnail and product name links show the slave id while the buy now shows the master id. Anyone know how to make the thumbnail and text show master id instead of slave id? For example slave product id = 30 and master id = 28 it'll show Thumbnail = 30, product name = 30, buy now = 28 Thanks.
  3. talon177

    Master Products - MS2

    In catalog/advanced_search_result.php change: ?$where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; to: ?$where_str = " where p.products_status = '1' and p.products_master = '0' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; This only works if the Master has the search term - a better solution is to have the result return the Master if the search term is found within the Slave - something I shall get around to I am sure. Matti Works great! it even searches for keywords that are in the slave and only shows the master!!! Excuse my languaged but damn i love this contribution, now the only thing I wish it could also do is input a seperate product description in the master product or products that aren't linked to master products. Such as how maxidvd did it on his site MaxiDvd's Site Thanks!
  4. talon177

    Master Products - MS2

    As stated on Page 7 by Johnson, you can hide the New products by: //Products_master if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_listing_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_listing_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } //Products_master EOF //Products_master if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' and products_listing_status = '1' order by products_date_added desc limit " . MAX_RANDOM_SELECT_NEW)) { //Products_master EOF //Products_master $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_master, p.products_master_status, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; //Products_master EOF To hide them from the manufactuers: Change the setting of Products Manufacturer to none on the product description page of the slave, as mentioned by someone in the previous pages. For Quick Find/Advanced Search: I'm still wondering the same, is there anyways when someone types in a keyword that belongs to the master or slave to only show the master product? Thanks.
  5. talon177

    Master Products - MS2

    And then changed the table display based on $products['products_master_status'] down around lines 1455 (in my copy - your mileage may vary): Now, my products list displays as: Black Leather Studded Belt - Master Black Leather Studded Belt Black Leather Studded Belt (Mind you - if I had just entered all my content with a slightly different name for the slave items, I wouldn't have needed to go to this trouble. But I didn't, so I did. So there. :) ) HOWEVER... Something odd has happened that I don't believe is related to the code I changed. Now, when I click on a product for a quick overview in the box to the right of the list, I get two sets of "Edit/Delete/Move/Copy To" buttons. The top set of buttons appears to relate to the master item - the "Edit" button, for example - while the bottom buttons appear to relate to a standard (slave) item. (See image below:) I really have no idea what's going on. I removed my edits above from the script and the extra buttons were still there. Any ideas? Thanks, this works great and doesn't have the double edit's on the left.
  6. talon177

    Master Products - MS2

    In /catalog/index.php, replace, // show the products of a specified manufacturer ? ?if (isset($HTTP_GET_VARS['manufacturers_id'])) { ? ? ?if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($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 = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$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 = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; ? ? ?} ? ?} else { // show the products in a given categorie ? ? ?if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory ? ? ? ?$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 = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; ? ? ?} else { // We show them all //Master Products ? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_master, p.products_master_status, 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_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; //Master Products EOF ? ? ?} ? ?} with, // show the products of a specified manufacturer ? ?if (isset($HTTP_GET_VARS['manufacturers_id'])) { ? ? ?if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($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_master, p.products_master_status, 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 = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$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_master, p.products_master_status, 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 = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; ? ? ?} ? ?} else { // show the products in a given categorie ? ? ?if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory ? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_master, p.products_master_status, 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 = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; ? ? ?} else { // We show them all //Master Products ? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_master, p.products_master_status, 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_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; //Master Products EOF ? ? ?} ? ?} Also, I've noticed the same problem in the search results. I've managed to fix by making the following change. In /catalog/advanced_search_result.php (around line 238), replace, ?$select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, 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 "; with, ?$select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_master, p.products_master_status, 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 "; What I've basically done is just add products_master and products_master_status to the sql queries. VJ Thanks, that worked great!
  7. talon177

    Master Products - MS2

    I was also wondering about the search engine, is there anyway to make it so that slaves won't be displayed in the search engine, but only the master itself. For example if the master item was called rims and the slaves was rim 17", rim 18", rim 19" blue So when you do a search for "rims", "rims blue" "rims 19" u would see "rims" (The master link) only? Thanks.
  8. talon177

    Master Products - MS2

    Not sure which of the two above you are referring to - if it is adding the slave to the basket then you most likely have a problem on product_info.php - post this file. Your product listing description suggestion for Master products is a good one - I shall include this in the new release. Matti Thanks Johnson, for everything. I must say i love this script so much! I finally got my script fixed after hacking it for an hour. Can't wait till v2 comes out!
  9. talon177

    Master Products - MS2

    I was wondering if anyone has a solution for this? I've read the past 24 pages and it seems I can't find a solution and a few others are having this same problem. Thanks.
  10. talon177

    Master Products - MS2

    Hi, first off i must say this is a great script, but I was wondering is there anyway to put a product description section under the master product? So that when people checkout the product listings page, they can get a description for the slave items carried inside the master product? That way they won't see just the product name. Also is it possible to make it so that when people do a search for an item, they don't see all the slave products in the search? As of now if you put a small product description in the slave item which is meant for the master product, people can search it and if they click on that item they'll see the small description. Instead of the master product. Thanks.
  11. Is there a update for all the fixes listed in the previous post? Also I was wondering since everything is referenced to the templates folder, do we now delete the files in the root catalog folder?
  12. Nm, i deleted it and reinstalled it and now it works. Thanks.
  13. Hi, i just installed this mod and everything seems to be fine but my images all have a X on them, am I suppose to move them somewhere else?
  14. Hi again, while i was testing a dummy account i noticed that if you choose to checkout with paypal ipn, and never really finish the checkout. Inside the My Account you see the status of Previous Orders, and it'll say "PayPal Processing", but when you click on view you see the order history although u never really bought the item, is there a way to have it so the buyer can complete the process from there? Or something that'll remove this history since they never completed the transactaion? Thanks.
  15. Hi, I was wondering if you install the PayPal IPN module, would you no longer need the regular paypal module installed? Since if you try to checkout it'll ask you wheather you want to use PayPal or PayPal IPN to checkout.? Thanks.
×