Storage Boxx – Simple PHP Inventory Management System

 

TABLE OF CONTENTS

Download & License Requirements & Installation What Is Storage Boxx?
How To Use For The Developers

 

 

DOWNLOAD & LICENSE

Download Storage BoxxSource Forge

Storage Boxx is released under the MIT License. You are free to use it for your own personal and commercial projects, modify it as you see fit. On the condition that there the software is provided “as-is”. There are no warranties provided and “no strings attached”. Code Boxx and the authors are not liable for any claims, damages, or liabilities.

 

REQUIREMENTS & INSTALLATION

Storage Boxx has not been extensively tested, but it should work with any modern AMP (Apache MySQL PHP) servers. However, it does require:

  • Apache Mod Rewrite
  • PHP PDO Extension
  • Best to have at least PHP 7

As for the “installation”, sorry… There is no installer. But this should be simple enough for the developers:

  • Create a database and import the sql/database.sql file. The entire sql/ folder can be deleted thereafter.
  • In lib/Core.php, change the database settings (section D1) and host (section D2) to your own.
  • Only for you guys who are not deploying Storage Boxx in the base path – Also remember to update the base path in /.htaccess and /api/.htaccess accordingly. For example, http://site.com/inventory/
    • RewriteBase /inventory/ and RewriteBase /inventory/api/
    • RewriteRule . /inventory/index.php and RewriteRule /inventory/api/index.php
  • That’s all. The default user is “john@doe.com” and the password is “123456”. Remember to change it later.

 

 

WHAT IS STORAGE BOXX?

Storage Boxx is a simple PHP Inventory Management System. Yep, this is not the “super professional crazy bloated with a lot of features” kind of system. But it does cover the basics and should help the small businesses better keep track of their inventory stock.

 

HOW TO USE

STEP 1) REGISTER INVENTORY ITEMS

  • Go under the “Inventory” menu item.
  • Click on “Add”.
  • Register the item.
  • Print out the bar code if you want – It does speed things up and makes things easier to manage. Get yourself a USB barcode scanner if you do not already have one. It only costs like… 20 bucks these days.
  • Rinse-and-repeat. Register all your items.

 

 

STEP 2) UPDATE STOCK LEVELS

  • Next, go under the “In, Out, Take” section.
  • This should be self-explanatory. Fill in and update the stock levels whenever required.

 

STEP 3) CHECKING STOCK LEVELS

  • To check the stock levels, simply go under the “Inventory” section for a quick overview.
  • Or go under “Check” and scan a bar code to check the stock movement history.

 

 

FOR THE DEVELOPERS

As simple as Storage Boxx may be, going through the entire system is still going to take some time. So instead of “explaining line-by-line”, here is a condensed version of “how to quickly customize and upgrade Storage Boxx”.

 

THE DATABASE

There are only 3 tables in Storage Boxx.

  • stock – Inventory items.
  • stock_mvt – Keeps track of the stock movement.
  • users – Self-explanatory, the users.
Stock
Field Description
stock_sku The SKU of the item, primary key.
stock_name Name of the item.
stock_desc Description of the item.
stock_unit Unit of measurement.
stock_qty Current quantity in stock.

 

Stock Movement
Field Description
stock_sku The SKU of the item. Primary key.
mvt_date Date of movement entry. Primary key.
mvt_direction The direction of the movement.

  • I – Stock In (receive)
  • O – Stock Out (release)
  • T – Stock Take (audit)
mvt_user The user who made this movement entry.
mvt_qty Quantity moved.
mvt_notes Notes, if any.

 

Users
Field Description
user_id The user ID, primary key.
user_name
The user name.
user_email
The user’s email address.
user_password
The password. Encrypted.

 

FOLDER STRUCTURE

There are 5 folders in the system:

  • api The API endpoint. For AJAX calls, or if you want to open up in the future for mobile app/server-to-server calls.
  • lib Core library files.
  • pages HTML pages.
  • public Public images, CSS, Javascript, and whatever else.
  • sql Only contains database.sql. Import and delete.

 

 

HOW TO BUILD & CUSTOMIZE

Storage Boxx is built on top of Core Boxx – It is highly recommended to read up on all the basics before starting on Storage Boxx… Don’t worry, Core Boxx only has 2 files and 2 folders – The core library and API endpoint.

Here is a quick step-by-step guide should you want to customize or build your own components. For example, adding an additional “telephone number” field to the existing users:

  1. Database – Add the user telephone field to the user table. Captain Obvious, if you want to create your own component, add your own new tables.
  2. Library – Update all the functions in lib/Users.php to also include the telephone field. Captain Obvious again, create your own library for your own new module.
  3. API – Update all the handlers in api/users.php to also include the telephone field. Captain Obvious yet again, create your own API endpoint handler for your own new module.
  4. Pages – Update pages/users.php and public/users.js, add a new telephone field.

 

2 thoughts on “Storage Boxx – Simple PHP Inventory Management System”

Leave a Comment

Your email address will not be published. Required fields are marked *