Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Low Level Stock Report


gaspower

Recommended Posts

Hello,

I have installed low stock level contribution, and it works fine, list all items and highlights items on low level. Was wondering if someone can help me change a few things. One, is it possible to only have it show items that are low level, verse showing all items. Also can it also print a report for ordering, listed by manufacures it items listed below for ordering.

 

Thanks JR

Link to comment
Share on other sites

  • 2 weeks later...

You might consider (instead of ONLY showing low-stock items) re-arranging the order so that only items that are low on stock appear at the very top of the list.

 

I did this by...

 

In admin/stats_low_stock.php (line 64-ish):

 

" order by pd.products_name ASC");

 

to

 

" order by p.products_quantity ASC");

 

If you want a specific type of query (i.e. "show items that only have a stock # of 10 or less"), let me know and I can try to help with that. I can't help out with your second question (printing out a report).

 

Good luck!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...