Maintaining stock levels


The hosting service has a basic stock monitoring feature. A column called stock has been added to the products table, to record the stock level for each product. When an invoice is uploaded to the server, the corresponding stock levels are debited.

A new section Stock has also been added to the main menu, with the following options:

Option Function
Adjust stock levels Uploads a CSV file containing current stock levels.The stock values in the file overwrite the ones in the products table. Other rows are unaffected, and no other columns are changed.
List stock levels Displays the current stock level for each product.
Download stock levels Downloads a CSV file containing the stock levels for all the items in the products table. This file can be modified, and used as input to the Adjust stock levels option.

CSV File

The CSV file used for stock levels has the following format:

Name Contents
productId Unique id of product
stock Stock level
name Name of product (optional, for reference only)

Author: Philip Sheard

Philip Sheard has been working in IT for over 40 years, and on this project for the last 20. His current skills include Java, Android, Objective-C, iOS, PHP, MySQL, ASP.Net, SQL Server, HTML, CSS, Apache and WordPress.