OSCommerce Product Manager

OSCommerce Product Manager for Windows
Tasklist

FS#248 - Basic inventory monitoring functions.

Attached to Project: OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Friday, 26 August 2005, 19:34 GMT
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Monday, 19 September 2005, 08:26 GMT
Task Type New feature
Category Backend / Core
Status Assigned
Assigned To Mario A. Valdez-Ramirez (mvaldez)
Operating System All
Severity Medium
Priority High
Reported Version any
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
Votes 0
Private No

Details

For eaxmple:
Total stock value (per product, category, manufacturer, etc).
Stock history (per product).
In and out history (per product).
Max and min stock (per product).
Stock forecast (per product).

The application would need to record the data in a regular basis.
This task depends upon

Comment by Mario A. Valdez-Ramirez (mvaldez) - Friday, 26 August 2005, 19:37 GMT

Also:
Zero-stock days (per product).
Stock outs (per product).

Comment by Mario A. Valdez-Ramirez (mvaldez) - Monday, 19 September 2005, 08:26 GMT

Total stock value of selected products:
Get the selected products, their normal price and their quantities, multiply them. The result is the stock value.

Get section of stock history:
Ask the server-side script the quantities of all products. Store locally the values per product ID and a timestamp. Do this manually or automatically (scheduled).

Graph stock history per product:
Query the local database of stock values for a given product using a given time lapse. Draw a graph.

Man and min stock:
Query the local database of stock values for a given product, looking for the highest and lowest value using a given time lapse. Display the values and dates.

Total stock value history per product:
Query the local database of stock values for a given product using a given time lapse, and multiply them by its price. Draw a graph.

Zero stock days per product:
Query the local database of zero stock values for a given product using a given time lapse. Calculate the total time. Display the value.


Loading...