Jump to content

inkan

Members
  • Content count

    19
  • Joined

  • Last visited

1 Follower

About inkan

  • Birthday 02/18/1965

Profile Information

  • Real Name
    Inkan Renfors
  • Location
    Sweden
  • Interests
    Computers, Friends, Barbeque, Red wine, MC (just bought one), Sailing (just sold one) and enjoying family and other good things in life.
  • Website
  1. inkan

    Master Products - MS2

    Mark, it is only listed once for me. Look into your code if someting is inserted twice in product_info.php - or if you inserted something new without commenting away the old code. /Inkan
  2. inkan

    Master Products - MS2

    Hi! I added version 1.1.15 and after that installed rev 4 found above and "Master Product Slave Attributes". Depending on your needs, you might not need all addons for Master Products. Good Luck!!! /Inkan
  3. inkan

    Master Products - MS2

    Hi Matti, and thanks for replying! Sorry, but I forgot to mention in my previous post that in my case, besides using products with master-slave relationships, there are also "normal" products that only comes in one version, and is nor a master or a slave. The "normal" products price are set at usual. Using your query would not catch the special products price for the "normal" products, only the slaves, right? To clarify the product structure, here is an example: Product #1 --------------------- Master #1: Face Tonic, Product description, no price Slave #1: Face Tonic, 118 ml bottle, Price 1 Slave #2: Face Tonic, 118 ml spray bottle, Price 2 Slave #3: Face Tonic, 118 ml spray bottle, Price 3 Product #2 --------------------- Night cream, product description, 118 ml can, price /Inkan
  4. inkan

    Master Products - MS2

    Tip for getting the Specials box to function with Master Products: I use Master Products v1.1.5 and the Add-On Rev 4. The way I use it, the Master Products price is set to "0" and the slaves are where the actual price is set. Using it this way, the file /catalog/includes/boxes/specials.php needs to be just slightly modified to work. If not modified, no special prices will be shown in the specials box. Change this row in /catalog/includes/boxes/specials.php: if ($random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) { to this: if ($random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and p.products_price != '0' and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) { The only thing that has change, is that and p.products_price != '0' is added at the end of the query. This is not within the fixes for MP as for what I have seen. If my thinking is wrong here, please feel free to correct me. I am not a MySQL-pro... :-" /Inkan
  5. inkan

    Actual Attribute Price V1.0

    I am not sure of that, maybe someone can reply to you in the official thread for that contrib: http://forums.oscommerce.com/index.php?sho...c=67284&st=1240 I have the need for selling a product that comes in bottles and cans of different sizes. If that is what you mean by "quantity" I think that it works, but you will have to add each different quantity as a slave product. That is - if I understood the functions of the contrib right. I have started to install it, but it?s a lot of changes and I haven?t got them all working yet (I get some blank pages, have to look for the errors). Look into what it does and don?t before you add the "Master Products" contrib, because it is a lot of changes to do - and uninstalling it will be a lot of work if you change your mind. I will post again when I have more to say about it, it has been too much other activities around here in the last couple of days, haven?t got the time for computers. /Inkan :'(
  6. inkan

    Actual Attribute Price V1.0

    Mark, I hope you solve it somehow, but I think that the Actual Attribute Price thinking might be the wrong angle to some shops. For me, I started to think of it as different products that needed to be grouped as one - instead of one product in different versions. I gave up on the Actual Attribute Price contrib after three days (and nights) of trying to get it to work (for my needs), and are now installing the "Master Products" attribute - where you can create a "Master" product and add "slave" products beneath it. I am not sure that it works for me either/yet, but both the threads about it and the description and coding itself seems much more comforting than the "AAP" contib. That contrib is actually at least two different contribs that are not advanced in function, some versions is actually a step backwards - and lost of "sorry I forgot.." and "I forgot another thing.." updates. I am not saying that it?s not the right thing for you, but think twice - maybe the stock problem is one sign that you should think of it as different products - grouped together as one. Sorry that I could?t help ! /Inkan
  7. Hi! My shop needs a way to list the amount of orders sorted be city, and by month. Anyone knows a contibute that could to this, or a way / a hint if it might be possible to modify this one: Customer Statistics countries and cities to do what my shop needs? Intersting contrib anyway, I would be surprised and happy if anyone could help me out here! :o :D /Inkan in Sweden
  8. inkan

    Actual Attribute Price V1.0

    Like many others as I understand, I have become hesitant about installing this contribution after reading many unanswered questions in this forum, and trying to figure out where to start in the long list of versions and fixes. Are there anyone that uses this with OSC2.2 and it really works? It should be nice to know. Also, I join "umanu" asking again what "Advanced Mode" and "Simple mode" stands for. I have opened and read some of the zip-files, but they seem to be more about how to install than the feature in itself, so it?s hard to see what I might gain by taking the risk starting to install this. How many files are involved? Any db changes for the contrib? Does it work well with other contribs, any examples that works fine? BTW - I am working in the area of usability, and it is strange to demand from a customer to do math to figure out what a product costs - so this attrib should have been a basic demand for not scare customers away from a webshop. I hope that I will solve this, maybe with some help from you out there! THanks in advance! /Inkan in Sweden
  9. inkan

    Enable/Disable categories contribution

    I have found the file now, the changes should be done in /catalog/includes/modules/upcoming_products.php row 12: $expected_query = tep_db_query("select p.products_id, pd.products_name, products_date_available as date_expected from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by " . EXPECTED_PRODUCTS_FIELD . " " . EXPECTED_PRODUCTS_SORT . " limit " . MAX_DISPLAY_UPCOMING_PRODUCTS); This query should be corrected so that products don?t show up multiple times. This is the listing on the first page (this months new products), so it is a little annoying. Thanks in advance for any suggestions! /Inkan in Sweden
  10. inkan

    Enable/Disable categories contribution

    Hi! I just installed this great feature, and noticed a small bug. When listing products by choosing manufacturer from the start page in the drop down Manufacturers box, the products that are "linked" between sub categories are shown multiple times. I think this is the same problem that was corrected earlier by inserting "distinct" etc in the SQL query in /catalog/products_new.php. I think something similar would solve this, as I recall, it should be done in the /catalog/boxes/manufacture_info.php file (but I am not 100% sure). Maybe someone with better MySQL query knowledge could help here? Maybe this query (row 14 - 16) can be modified so that one product only show up once? $manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '" . (int)$languages_id . "'), " . TABLE_PRODUCTS . " p where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id"); if (tep_db_num_rows($manufacturer_query)) { $manufacturer = tep_db_fetch_array($manufacturer_query); Besides this minor bug, I am really impressed by the feature, working with disabled categories really helps to be able to prepare new products in advance. Thanks everyone who has contributed with the code!!! /Inkan in Sweden
×