Adding note about Manual Inventory quantity
O.k. so I'm sure someone out there has this as it has been addressed before and made into a module. The module is stock quantity report. This works as a quick view, but we have thousands of products to count for our corrective inventory procedure. This next route would save many hours for many people I'm sure!
I would like to place this on the collect_info.php page (product input page). I have configured a table at the top of the page that displays relevant information including "Stock on shelf:" x
The "x" needs to be the current admin stock plus that product that was just purchased sitting in status bin #1. Meaning it's bought, paid for and needs to come off the shelf, but is still on the shelf until it's picked the next day.
Here is the code associated to this, but i can't get it to work on the collect_info page, it displays 0:
$real = $db->Execute("SELECT SUM(op.products_quantity) AS qty
FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op
AND op.products_id='". $products->fields['products_id'] ."' ");?>
AND TO DISPLAY THE NUMBER...
<td class="main" align="center"><?php echo $products->fields['products_quantity'] + $real->fields[qty]; ?> </td>
Re: Running Manual Inventory - made easy!!!
It appears that the code to display the number is...
<td class="dataTableContent" align="center"><?php echo $products->fields['products_quantity'] + $real->fields[qty]; ?> </td>
stock purchased but not picked yet from shelf:
<td class="dataTableContent" align="center"><b><?php echo $real->fields[qty]; ?></b> </td>
stock that you see on the shelf (this is the one I want):
<td class="dataTableContent" align="center"><?php
echo ('<font color="#FF0000"><b>'.$level.'</b></font>');
By hokyk in forum Setting Up Categories, Products, Attributes
Last Post: 28 Jan 2011, 08:07 PM
By JohnA in forum General Questions
Last Post: 10 Nov 2008, 04:17 AM
By rfrenzob in forum General Questions
Last Post: 18 Oct 2008, 02:10 PM
By alja in forum General Questions
Last Post: 30 Jan 2008, 12:43 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC