kukkuu Posted August 18, 2005 Share Posted August 18, 2005 I installed Inventory Report Stock Level contribution and liked that a lot. However, is there any inventory stock level contribution, which shows product list also example shirts with the different colors? Now I'm seeing only one model (and got those with the different sizes and colors). Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 18, 2005 Share Posted August 18, 2005 I installed Inventory Report Stock Level contribution and liked that a lot. However, is there any inventory stock level contribution, which shows product list also example shirts with the different colors? Now I'm seeing only one model (and got those with the different sizes and colors). <{POST_SNAPBACK}> for tracking stock with attributes, there is QTYPro. I think there is a mod offered by Iggy that consolidates it with 2 more mods which is great. Low Stock report is part of it, and you could modify it to show all products. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
kukkuu Posted August 19, 2005 Author Share Posted August 19, 2005 for tracking stock with attributes, there is QTYPro. I think there is a mod offered by Iggy that consolidates it with 2 more mods which is great. Low Stock report is part of it, and you could modify it to show all products. <{POST_SNAPBACK}> Big thanks for your answer Monika, I installed 'qtpro4.2_AttributeManagerSort'. Seems working fantastic, however I didn't find the code how to edit 'low stock report'. Can someone please show the link to instructions how to do this? Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted August 19, 2005 Share Posted August 19, 2005 Big thanks for your answer Monika, I installed 'qtpro4.2_AttributeManagerSort'. Seems working fantastic, however I didn't find the code how to edit 'low stock report'. Can someone please show the link to instructions how to do this? <{POST_SNAPBACK}> line 101 $products_stock_query=tep_db_query("SELECT products_stock_attributes, products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id=" . $products['products_id'] ." AND products_stock_quantity < '" . STOCK_REORDER_LEVEL ."' ORDER BY products_stock_attributes"); change to $products_stock_query=tep_db_query("SELECT products_stock_attributes, products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id=" . $products['products_id'] ." ORDER BY products_stock_attributes"); :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
kukkuu Posted August 19, 2005 Author Share Posted August 19, 2005 line 101 $products_stock_query=tep_db_query("SELECT products_stock_attributes, products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id=" . $products['products_id'] ." AND products_stock_quantity < '" . STOCK_REORDER_LEVEL ."' ORDER BY products_stock_attributes"); change to $products_stock_query=tep_db_query("SELECT products_stock_attributes, products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id=" . $products['products_id'] ." ORDER BY products_stock_attributes"); <{POST_SNAPBACK}> Cheers, Monika :D :thumbsup: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.