Real stock quantity

[loutka]

...compare products in stock and products ordered (in orders, which are not marked as delivered), so gives clear view how many products should be delivered.


This contribution is copy of working version in my cart.

Some modification may be needed to work with your Zen-Cart.

If in doubt or have any questions -> loutka.zen################################

[gezuvor]

I like this mod, great job!

One file was missing for a clean installation, which I added to the contribution. I also changed the layout slightly to make it more useful for me and uploaded it as v1.1.

Thanks loutka!

[loutka]

Thank you for update!

Good to hear these words...

[dinix]

Hello

This contribution is verry good, but dont work well in zen 1.3.8a.
The problem is end i chouse "sort by" the produts dont change

can you help me

Tanks

[loutka]

Dou you use any prefix in your DB?

This module works in connection with Delivery Control module...

[dinix]

tanks for answer.
no i don't use any prefix in my DB.
wat can i do?

[paulm]

The problem is end i chouse "sort by" the produts dont change

I found a small error in stats_stock.php that makes the "sort by" only work with register globals enabled. You can fix it by adding a line (at line 27of admin/stats_stock.php).

Change:

  require('includes/application_top.php');
	$maxDisplay = 100;
	
	
	
	
	if ($sort=='nameA') {
	$sOrder = 'pd.products_name ASC, p.products_id';
	}

To:

  require('includes/application_top.php');
  $maxDisplay = 100;
  
  
  $sort = $_GET['sort'];
  
  if ($sort=='nameA') {
  $sOrder = 'pd.products_name ASC, p.products_id';
  }

[loutka]

Thank you...

[dinix]

Tanks Paulm, tanks men, resolve the problem.
Tell my it's possible to install a serch botton so i can see exactly the stock off one product??
tanks

[gezuvor]

Thank you...

I have corrected the sorting issue discovered by paulm and uploaded the corrected version as 1.2

Here is the direct link: Stock Quantity Report