Lock Stock

About Lock Stock

Lock Stock consists of a robust database that can be accessed via a web interface on any modern, web enabled device.

Our Stock Management Philosophy

Based on our experience, we believe that a robust stock management system should:

Lock Stock has been designed with these principles in mind.

Effective stock management is a balancing act. Lock Stock can allow users to track the movement of every staple within a busy office environment if desired but, fast as it is, we cannot imagine an environment where stopping to record the use of each staple as it is used would be practical. Before putting any stock management system in place it is important to consider what you hope to achieve and whether it is going to be practical in the long term to maintain the data structures that you create.

Our stock management experience has focused on medication, retail goods, office and janitorial supplies. In these environments we value a system that can provide answers to such questions as:

Lock Stock puts the answers at your fingertips.

The database that Lock Stock uses makes it relatively simple to update cost prices from supplier provided spreadsheets, text files and web resources but some technical knowledge is required to take advantage. As required, where suppliers provide suitable resources, we intend to add plugins to allow bulk updating of pricing information. At RSPCA Sheffield our two largest suppliers readily supplied the necessary resources and the plugins were simple to construct. Where this is not possible we advise checking the prices on your invoices against the prices on Lock Stock and updating them when they differ.

How to use Lock Stock?

Lock Stock can be used simply as a tool to make stock taking easy. You can create records of the products that you wish to stock take and use Lock Stock's fast, efficient interface to record the stock levels observed. This will provide periodic snapshots of your inventory but little else.

If it is practical to record the movements of your products, such as arrivals from suppliers, customer/staff sales, disposal etc then Lock Stock allows you to check for available stock from any web enabled device.

If it is practical to record and maintain the cost prices of the products that you stock then Lock Stock also becomes an accurate record of the value of stock you hold and the value of stock being lost to mismanagement/theft.

If you are able to record and maintain the retail prices of the products that you stock then the system also becomes a tool for reporting profit over time, providing valuable feedback on you performance. Lock Stock includes tools that make updating your retail prices relatively simple.


Try out our online demo (Google account required).

To find out more contact [email protected].