Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Query in Admin to display out of stock products


Recommended Posts

Hello wonderful people of the osCommerce forums!

 

My client would like a stock control system wherein he could look at all of the products on the website that are out of stock. I have not, so far, found any contribs for this at all, hence my post.

 

By executing the following SQL query in PMA (SELECT * FROM `products` WHERE `products_quantity` = 0), I have managed to list the products that are out of stock. However, I would like a way to display this in the Administrative 'side' of osCommerce in some sort of simplistic layout.

 

Any help whatsoever would be great!

 

Thanks,

J

Link to comment
Share on other sites

how about this one ?

Zero stock report

http://addons.oscommerce.com/info/7815

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

  • 3 weeks later...

Archived

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

×
×
  • Create New...