Jump to content

miker42

Members
  • Content count

    5
  • Joined

  • Last visited

Everything posted by miker42

  1. In QTpro v4.25... After adding 3 and more attributes to some of my items, and then adding stock for these attributes, I found that some of these attributes were not showing up in stock (even though I just defined the stock quantities). I found there is a single quote misplaced in an SQL statement which was not allowing the 'order by' phrase to be executed. The affected file is: /includes/functions/general.php The code at line 136 $track_stock_query=tep_db_query("select products_options_id, products_options_track_stock from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id in ($options_list) and language_id= '" . (int)$languages_id . "order by products_options_id'"); should be changed to $track_stock_query=tep_db_query("select products_options_id, products_options_track_stock from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id in ($options_list) and language_id= '" . (int)$languages_id . "' order by products_options_id");
  2. Great, but I hate when I do stuff like a total noob. :blush: When I entered my third option name I forgot to select the "Track Stock" box. I am now tracking more than two attributes at a time. Thanks. Sorry, Obaida, I don't know anything about sequencing the attributes in the drop down box.
  3. I believe the page you are looking for is catalog/admin/categories.php, and I suspect the following is the code displaying the button. <a href="' . tep_href_link("stock.php", 'product_id=' . $pInfo->products_id) . '">' . tep_image_button('button_stock.gif', "Stock") . '</a>
  4. I have products with 3 attributes. When I go to add stock quantites for the attributes only 2 attributes are listed. I read through many posts and I have seen where others have casually mentioned having 3 attributes, but I have not read that anyone had a problem setting stock quantites for all 3. My question is, is QTPro designed to allow me to set stock levels for more than 2 attributes? In other words, do I have a bug in my installation, or is it working as designed? Thanks
  5. The Stock button is on the Categories / Products page. In Admin click Catalog, then Categories/Products. Navigate to your product. For your product you should see buttons Edit, Delete, Move, Copy to, and Stock.
×