Serving Your Own Inventory Management System

Use your Raspberry Pi to set up an open-source inventory management system written in PHP with a MySQL database.

Using a Raspberry Pi for your own inventory management system.

Basic Inventory Management System Web Application

An open-source, inventory management system written in PHP with a MySQL/MariaDB database has no problem operating on a Raspberry Pi. Initially, you’ll only have local network access, but if you want to allow remote web access, you can.

In order to setup a web interface to access, view, and manage the content of your inventory management system you’ll need to set up a LAMP (Linux, Apache, MySQL/MariaDB, PHP) stack on your Raspberry Pi and configure it to work as a web server and set up a basic website which you can access on any device on the same network as your Pi. This is a link to a nice tutorial for setting-up a L.A.M.P. server on your Pi, the WordPress portion is optional, you can stop after installing PHP.

If you plan on having access to your Raspberry Pi through the Internet, you’ll need to configure your router and DDNS settings, or use a service such as dataplicity.io to wormhole to your pi through the web.

Next step is to use an open-source project found on GitHub to start your basic inventory management system. https://github.com/siamon123/warehouse-inventory-system

“OSWA-Inv is a web based Inventory System, that will allow you to keep tracking of the quantity buying and selling price of the products existing in your warehouse or business. When creating a new products, you can set a quantity, buying and selling price.”

Included Features:

  • User Management: Groups, Basic Profile, and Change Password
  • Categories: For organizing products
  • Products: Basic product information, title, quantity, pricing.
  • Sales: Sales transactions are individual by product.
  • Reports: Daily, Monthly, and Ranged Dates Sales/Profit Report

Install the Basic Inventory Management System Web Application

Please visit my website for the latest documentation.

Improvements

These are the improvements I’ve added for my own system

  • Delete confirmation popup before delete actions
  • Description column for products
  • Location column for products
  • View products by category
  • Add sales from list of products – remove selected from list.
  • Add/Edit/Delete Sales also updates product’s quantity available
  • Order Management for all sales – All sales must be associated with an order number
  • View Sales by Order calculate total
  • Delete Order – deletes all sales associated with order AND restores quantity/stock
  • Add/Edit/Delete Order also updates product’s quantity available
  • Inventory Management for all products – Log of increase/decrease stock
  • Add/Edit/Delete Inventory also updates product’s quantity available

Backup and Restore Your Inventory Management System

More stuff written by me:

Schematics

Source: Serving Your Own Inventory Management System

Scroll to Top
Scroll to Top
Read previous post:
CELLULAR PANIC BUTTON REVEALS AN NB-IOT FUTURE FOR PERSONAL SAFETY ALARMS
CELLULAR PANIC BUTTON REVEALS AN NB-IOT FUTURE FOR PERSONAL SAFETY ALARMS

Nordic Semiconductor announces that Dutch startup, Montr, is employing Nordic’s nRF9160 multi-protocol LTE-M/NB-IoT System-in-Package (SiP) in a small lithium battery-powered...

Close