Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Inventory Report Stock Level


kukkuu

Recommended Posts

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

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).

 

 

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

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.

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

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?

 

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

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");

 

Cheers, Monika :D :thumbsup:

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...