Jump to content

Johnson

Members
  • Content count

    5,103
  • Joined

  • Last visited

Everything posted by Johnson

  1. Johnson

    HELP! EP field list error

    You have answered your own question - yes, they must all match :D
  2. Johnson

    [contribution] GroupDiscount

    Make sure that the *group* is in the query/array that populates the fields containing the customer info, otherwise it will default. I have not used this contribution, but often see this problem. HTH Matti
  3. Johnson

    Master Products - MS2

    Why? are you offended? Then I would ask you to consider the fact that the English language has many instances of the same words having both positive/negative interpretations - this is just one instance. Really, I think that people who cannot cope with diversity need counselling, rather than imposing their own dominance on the remainder of society - they believe that we should be slaves to their own narrow mindedness :blink: Matti
  4. Johnson

    Master Products - MS2

    There is always a way :D Full attributes handling for both Master and Slaves will be a key feature in version 2 of Master Products. I hope to have this out shortly after Christmas :P Matti
  5. Johnson

    Master Products - MS2

    Yes - it sure does :P Matti
  6. Johnson

    Master Products - MS2

    Ok - make sure that products_master and products_master_status are in the $product_query HTH Matti
  7. Johnson

    Master Products - MS2

    I cannot duplicate this - are you using an admin/categories.php from the download, or did you copy changes over? Matti
  8. Johnson

    Master Products - MS2

    Did you actually check the products table in the database to confirm that products_listing_status is not updating? The radio buttons will show if it is updating - if you click edit again after changing it should be selected on the option you chose.... :D Be sure to click the 'update' button after 'preview' :P Matti
  9. Johnson

    Master Products - MS2

    You must run the master.sql file included in the download on your database - please backup. Matti This is defiantly where I messed up. How do I go about running this file on my database? Do I just upload it to any directory and then open the URL to it? Sorry I'm in the learning stages. If someone could please explain further i would appreciate it. Use phpmyadmin - if you have cPanel on your hosting account, go to MySQL databases - there should be a link there to phpmyadmin (down the bottom of the page) - click on this - this usually will open a new window> select your database>depending on your phpmyadmin version, either click on the SQL tab, or simply scroll down the page to the SQL queries dialog>use the browse button to browse to the master.sql file on your local hard drive>click 'go' :D Please backup always before making changes to your database :blink: Matti
  10. Johnson

    Master Products - MS2

    This simplest way to do this is to use the 'copy' button - then assign another Master to the copied product. Matti Managing stock becomes an issue then... Ok - I can see this would be a very useful feature - I shall include it in the next release. I have commenced work on version 2, so any further input is much appreciated. Matti
  11. Johnson

    Master Products - MS2

    You must run the master.sql file included in the download on your database - please backup. Matti
  12. Johnson

    Master Products - MS2

    Version 1 only has the option to hide Slave products in the categories/ product_listing display. To hide products elsewhere that have 'Hide Product' selected in admin: For the new products box, in catalog/includes/modules/new_products.php change the $new_products_query to: //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 To hide them in the 'What's New' box, in catalog/includes/boxes/whats_new.php change the $random_product query to: //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 To hide them on the catalog/products_new.php page, update $products_new_query_raw to: //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 (Products do not need a Master to be hidden with the above) The next version of Master Products will probably have a series of check boxes for selecting which pages the individual Slave products will show, including specials, which are not covered above - some users will wish to show Slaves in new products, but not product listing etc. I highly recommend using a program such as Beyond Compare for tracking installation issues. HTH Matti
  13. Johnson

    Master Products - MS2

    This simplest way to do this is to use the 'copy' button - then assign another Master to the copied product. Matti
  14. Johnson

    installing "net terms"

    The contribution is rather old and not compatible with the version you are running - the only places I can see are around lines 154 and 170. Hope you can get it going ok! HTH Matti
  15. Johnson

    Master Products - MS2

    This works nicely if you add p.products_quantity to the $master_sql query in master_products.php: ? ? ?$master_sql = "select ?" . $select_column_list . " p.products_id, ?p.manufacturers_id, p.products_tax_class_id, s.specials_new_products_price, s.status, p.products_quantity, p.products_price from ". TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_master = '" . $thisquery['products_master'] . "' and p.products_status = '1' and pd.language_id = '" . (int)$languages_id . "'"; For those who didn't quite get that, the '20' in Matt's code is the upper limit the drop menu will display - change to the desired setting. Good one :D
  16. Johnson

    Master Products - MS2

    Thankyou Burt I've been toying in my mind with what to do with the quantity select - basing it on stock becomes a problem if there is a great deal of stock - I definitely intend to add admin control of the select range - perhaps a stock option if it is not too difficult. Some people prefer a simple text field, so this needs to be an option also. Global settings are simple, but some also prefer control per product.... this also is a consideration..... Attributes are the no.1 priority at the moment - this will multiply the usefulness of Master Products immensly... almost there, busy, busy.... Also in the works: - (Admin) easy identification of Master and Slave products - the abilty to select a Master and have Slaves listed with it . More control for Master products so they are purchasable - this will include a quantity select on product_info.php for the Master, maintaining a single Buy Now button. An option on the admin product edit page whether a slave will have its own product_info page or not.... I think perhaps a series of check boxes as to which pages a Slave will show on... products_new, specials etc. Feedback/ideas are greatly appreciated. Matti
  17. Johnson

    Template Selling Shopping Cart

    osCommerce supports downloadable products - you will find it in admin>configuration>download Matti
  18. Johnson

    Wishlist 2.0 Support Thread

    Try this: echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_wishlist.gif', IMAGE_BUTTON_ADD_WISHLIST); ?></form> </td> Matti
  19. Johnson

    Master Products - MS2

    Yes - you must use the 'copy to' button on the admin>category/product listing page and select the 'duplicate' option - you may duplicate to the same category or another, then 'edit' to assign a different Master Product to the duplicate. You can toggle the description on/off in admin>configuration>Slave Products>Display Slave Product Description - set this to '0' to hide the description. You can control the length of the description using the 'Length of Truncated Product Description' option. Matti
  20. http://www.oscommerce.com/community/contributions,1208 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce WISHLIST V1.3 Changes to Wishlist for osC Version 2.2-MS1 by JOHNSON Copyright © 2003 Matti Ressler - mattifinn@optusnet.com.au version 2.2-MS1 Released under the GNU General Public License Here's what it took to get Wishlist working for me in Version 2.2-MS1.... the first is an entire change of the mod to product_info.php, the second only a slight change to the 'add' in application_top.php.... all other changes remain the same other than the missing curly bracket in column_right.php... Enjoy!.....Matti
  21. Johnson

    Master Products - MS2

    In catalog/includes/new_products.php change the db queries to: ?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 products_status = '1' and products_master = '0' 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 products_master= '0' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); ?} I have simply added: and products_master = '0' You could also use: and products_listing_status = '1' This latter will allow you to control which slaves show and which do not via the product edit page 'listing status' - perhaps the better option. You can do the same in catalog/includes/boxes/whats_new.php and elsewhere :D Take a look at the catalog/products_new.php included with the package for more ideas on how to control display. Admin control of these and other parameters will feature in later versions of Master Products. The next release will display product attributes in the slave listing. I also intend to include an option whether or not individual slave products will link to their own product_info page (more info). HTH Matti
  22. Johnson

    member approval and login view prices..

    I have never looked at the login to view prices contribution, however, I show a simple way to do this here: Hide Prices HTH Matti
  23. Johnson

    Wishlist 2.0 Support Thread

    I did post here regarding this - a fix for the actual URL - but I believe that the mail is not html - I do not have time to look into this further :( Matti
  24. Johnson

    Master Products - MS2

    I am sure you would look very nice :lol: Matti
  25. Johnson

    Master Products - MS2

    Updated files have been uploaded to Contributions B) Matti
×