amirsanni / mini-inventory-and-sales-management-system

An Inventory and Sales Management System written in PHP (codeIgniter) with support for MySQL and Sqlite3 databases

Mini-Inventory-and-Sales-Management-System

An Inventory and Sales Management System written in PHP (codeIgniter) with support for MySQL and Sqlite3 databases

Features

• Products Management
• Transaction Management
• Viewing and Printing of Transactions Within Specific Dates
• Barcode Scanning of Products for product and transaction management
• Custom Analytics
• User Management
• Monthly/Yearly Earnings Overview
• VAT
• Discount

Getting Started

• mod_rewrite must be enabled
• PHP >= 5.4 is recommended
• Browser with support for most ES6 features is recommended
• If you edit the folder name, you will need to do the following:
  • Open .htaccess in the root folder and change the line with "mini-inventory-and-sales-management-system" to your new folder name. Leave it blank if app is directly inside your www or html directory.
  • Open "application/config/config.php" and do the same.
  • Open "public/js/main.js" and do the same.

Demo

View demo here: https://1410inc.xyz/mini-inventory-and-sales-management-system/

To log in:

• Email: [email protected]
• Password: demopass

New Version

A new version is under development and can be checked at https://inventory.1410inc.xyz/

You can create an account for testing purpose.

mini-inventory-and-sales-management-system's Issues

Total Earned Today invalid

Total Earned Today: displays wrong total of price earned today. Thats because if we have multiple items in transaction it multiples the total amount with number of items and displays that amount.
For example. if there is only 1 item in transaction it will add same total price in total earned today.
but if we have 2 items in transaction it will add ( total price of transaction x 2) in the total earned today
similarly if we have 3 items in transaction it will add ( total price of transaction x 3) in the total earned today
Please fix this error.
the error is only in top right total earned today: (_____)

Transaction search missing customer details

When searching transactions by transactions ids, there is an undefined variable error in customer details area

Log in problem

Hi, I would like to know the equivalent hashed password in the database cause I cannot logged in. I am running the app in the localhost.

Items with 0 quantity left should not show up in the select dropdown during transactions

Discount Value function not working

I have changed the transaction.js file in public folder and transaction and transreceipt file in application\views\transactions folder. Accordingly to changed you made. But Discount Value is not working.
i check it on your demo website its perfectly working and the discount % and discount value are interlinked with each other. where as on my side its not working anyway, can you please check? what could be problem?

Same item occurring twice in transaction items' list

An item should not be selected twice during transactions. Once an item has been selected and there is a need to include one or more quantities of the same item, the quantity of the selected item should be increased instead of adding the same item twice.

This should be enforced even if the item is been scanned with a barcode scanner.

So instead of this:

We should have this:

I request you to add the feature of credit, bad debts and adding partners with whom the products were imported.

Credit
Okay for example a buyer buys the product of Rs.3600 on may 1 and he pays only Rs.3000 so the credit in the particular transaction remains Rs.600 but the vat and billing will only be done for the amount paid i.e. Rs.3000 and on today's earning and transaction only Rs.3000 Will be seen.

Now if the buyer pays the amount of Rs.600 in may 5 , the billing of Rs.600 will be done on may 5 and the Rs.600 will be shown on transaction of may 5.

Bad Debts
If the credits are not paid with in 2 months or for the certain amount of time the credit will move towards bad debts.

But also remember the bad debts can also be paid same as credits.

Partners
A sellers can also add the information of the importers he imports from while adding the items the seller can select the importers he added the product from.

You can also add the total cost price while adding the item so the profit could be calculated and also you can separately calculate the VAT to be paid to government.

how do you add a menu item on the side bar

i keep trying to add menu items on the 'view/main.php' file but i can't seem to be able to add one yet... help please. and the the reports, eventlog and other links are appearing on the sidebar as well... help me out here am I missing something here

Log in failed. Please check your internet connection and try again later.

I had a problem with access, help please. Thanks.

Log in problem

Hi, May I know what is the equivalent password of the hashed password in the database cause I cannot log in and create a new user.

add date

I wanted to manually add the date of the transaction. How?

Need to use discount in price not percentage

I want to add discount in fix price count i.e 100 or 200 i dont want it to be in percentage %
can you please make the changing?

later the totaly amount before discount should also be printed on reciept also

Log in problem

Hi!
I have a problem with Log in. Send me a message "Invalid email/password combination", but the user and pass are correct.
Thanks!

How to change date/Time to my local time (GMT +2:00)

I tried to change the time_zone in my sql but that doesn't help.
Kindly let me fix this.

Thanks in advance

how to add in expenditures/spendings/outgoing transactions

Hi Amir thx for the project again it does only wonders to help me in my projects to
but how can go by adding expenditures/spendings/outgoing transactions functionalities

coz this project's file are super nested

and how to fix transaction reciept being printed and having to much padding on side that causes to not fill on print paper.

thx again

Error

Error, Need help

An Error Was Encountered

Unable to load the requested class: Email

Currency Symbol

where can i change the currency symbol to $ ?

Getting Error While searching for transactions

Admin ACL Manager

Inventory view Role for the staff. How can I do that?

Currency

Hi awesome project you have. Where are the settings for currency?

Change currency

Where could I change the currency?

Item Code input method invalid

URL: https://1410inc.xyz/mini-inventory-and-sales-management-system/transactions
Parameter: Item code
While adding item using the item code it instantly search the item which makes larger item code entry invalid. for example there are items in DB with codes 1 , 12 , 123 , 1234 , 12345
if i want to enter item with code 12345
till the time i enter 12345, it will add item 123 or 1234 instantly.
Solution:
Either set time limit to read input so that larger code can be entered and traced easily OR place a button to initiate the search.
waiting for your quick response/fix.

Log in failed. Please check your internet connection and try again later.

sir error on login page

Prevent multiple items list with no selected value

If user click on 'new item' and no item was selected in the last "new item" list, do not create a new list.

This is what we are trying to prevent:

Print receipt having 50+ items

i recently printed a receipt hacing 50+ items, it didnt printed whole reciept. can you look into it?

Log in failed. Please check your internet connection and try again later.

Hi,

Im having this error when I try to login using the demo account.

Log in failed. Please check your internet connection and try again later.

Can you please help me?

Update*
Issue resolved....

Css Not loading on Localhost/Cpanel and cant even login

i tried using the software in xampp localhost, but it didnt work as the base url dont recognise working in local server and more over i can't login both on localserver and in cpanel

Error while using SQLite

The attached error occurred while using the SQLite database.

when i install this program,an error happened

install this program,we got error :
A Database Error Occurred

SQLSTATE[HY000] [2002] No such file or directory

Filename: controllers/Home.php

Line Number: 13

============
I had modified these files(even default ,its did not works),any tips?,thanks
public/js/main.js
application/config/config.php
application/config/database.php
.htaccess

Need Total Price of All inventory items

in the inventory items i dont see anywhere total price of my inventory stock. i want to know how much is my inventory total worth.
It will be good if you add a DB query and display price of total Stock.
sum UNIT PRICE of all inventory items and display its result in Total stock price.

add the discount on each item individually and not on the whole invoice?

Is it possible to add the discount on each item individually and not on the whole invoice?

where can i edit the currency ?

Add and edit customers info

please kindly direct me how to

-Add and edit customer to the menu
-Select customer in transaction mode auto populate the phone number and email

thanks a billion times

Multiple store locations or warehouse

Hi @amirsanni ,

With my requirement, im lacking the option for multiple warehouse/store location. Have you interested to add that?

Thanks for the script.
Sajin

Error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND'

I try this under my fedora 28 and got the following error. I changed the folder name to "inventory". Thank you!

An uncaught Exception was encountered
Type: Error

Message: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND'

Filename: /var/www/html/inventory/system/database/drivers/pdo/subdrivers/pdo_mysql_driver.php

Line Number: 145

Backtrace:

File: /var/www/html/inventory/application/controllers/Home.php
Line: 13
Function: __construct

File: /var/www/html/inventory/index.php
Line: 315
Function: require_once

Request for adding a new feature !

Is it possible to add Purchase Rate, Selling Rate and Profit for each product items so that we can track our shop progress. ? whether we are going good or need attention?! something like that...

What's the reason of this problem?

include access restriction in showing inventory items. [$this->genlib->superOnly();],

the basic level admin can access inventory through url "/items". or just exclude the inventory items from admin role check in main.php

Where is the file of the Log-In page?

Sorry Mate, I'm just new to this Web Development. Kindly teach me where to direct?

Mobile login issue

its just me or what, i can't login using mobile

Login problem

Unable to login with the email and password provided.
I got "Log in failed. Please check your internet connection and try again later."

My internet connection is very good.

Please check here: http://www.test.motizafarms.com/

Add Settings Module

Add a new module where users can set basic things like the logo (for site and receipt), store name, address, phone number, currency etc.

Add feature to backup and import the mysql database as well

We can currently back-up and import sqlite databases on the app but no such thing for mysql database.

Facing Error on Search.

im facing this error while searching anything.
it does perfectly searches the querry but displays this error. i dont know what is it about. ??fix it?

New Transactions Quantity are Same

Dear Brother,
I just experimenting with your project. There is a bug in the
transaction. When you add a new item to transaction. The item name is changed but the remaining quantity and the price is shown same as the first item.
(Pins available qty =15 & price/Unit = 100) (watch available qty=20 & price/unit=300)
Need your guidance please.
Note: Screenshot attached.

Display Barcode (item code) along with item on Transaction

if we manually search for any item using the dropdown list (incase we are not using a barcode scanner)
The barcode of respective searched item should also be displayed , you can place the item code in item code field or make a new field for it.

login failed

i just update the php but still failed

Floating number with at least 2 digits at quantity field in transactions

I want the unit price to act as per unit and as per kg. (KG or Unit will be specified in description)
So I need the quantity to accept floating numbers that can multiply with the unit price.

SQLSTATE[42000] [1044] Access denied for user 'id3231963_root'@'%' to database '1410inventory' Filename: controllers/Home.php Line Number: 13

Database error host

"Item not found" showing even though item was found

While using barcode scanner, error "Item not found. Item may not be registered." even though item was found and added to the list.