Stock Management System with PHP, Open Source

Stock Management System

Stock Management System open source project with procedural php, MySQL, bootstrap, and jquery. This application is based on web application and develop with procedural php, MySQL database, jquery, datatables plugins, and bootstrap. This application provides the users to manage brands, category, product, orders, and report.

In brands page, the admin can add, update, and remove the brand’s information. In product section, the admin can add the product information and manage the stock. In order section, the application will manage the stock of the product and generates the total amount of payment to be pay by the client. The application can also generate the orders report on based on the month you select.

Requirements

  • PHP Version +5.4.4
  • Web Server ( Recommended : Apache with PHP and Mysqli )

Features

  • View of a total number of brands, categories, product, and orders.
  • Add, update, and remove brands information.
  • Add, update, and remove categories information.
  • Add, update, and remove product details.
  • Add, update, and remove orders details.
  • Print orders invoice.
  • Update orders payment.
  • Generate the orders report by selecting specific start and end date.
  • Change Password
  • Change Username

Users

  • Admin
    • Username: admin
    • password: password

Change the VAT

To change the vat number, all you have to do is go to the order.js file which is located at [custom/js/order.js] and search for subAmount function. In the line of 555, you will see the VATvariable, change the VAT number that you desired. To change the vat number in the front end of the application, go to orders.php and at the line of 369, you will see the VAT label, change it the number you desire.

Download Online Stock Management System

Please Read:

While creating the database for this system, either you can create the name of the database as a stock or change the name at the php_action/db_connect.php file. As shown below:

<php 
$localhost = "127.0.0.1"; 
$username = "root"; 
$password = ""; 
$dbname = "stock"; 

// db connection 
$connect = new mysqli($localhost, $username, $password, $dbname);

// check connection 
if($connect->connect_error) {
  die("Connection Failed : " . $connect->connect_error);
} else {
  // echo "Successfully connected";
}

?>

For Database :

For Source Code:




73 thoughts on “Stock Management System with PHP, Open Source

      1. Hey can you help me please instead of “Selecting” all the products in Add Orders and Add Product could you please turn it into a search ? please it’s my only chance to pass in my project 🙁

  1. Hello
    Nice work.
    I would like to change my vat percentage and show my current stock in report.

    Please let me know how I update those things.
    It will be great help for me.

    Thanks

  2. On order page there is no changes after changing the quantity. This is still that amount in total field which is product rate.Please help me how i can solve this issue.

  3. Hello,
    Thanks for the great software, i want to upload my server, but could not do that, already imported the database. showing this error..
    Connection Failed : Access denied for user ‘root’@’localhost’ (using password: NO)

    also i have updated the

    header(‘location: http://localhost:9080/stock/index.php‘);
    to
    header(‘location: mydomain.com/index.php’);

    ex. “mydomain.com” used for example

    Anyone can help me to solve it
    Thanks in advanced…

    1. is it shared hosting you are using?
      have you checked the same thing on localhost if it is working or not?

      Please contact me on my email may be i can help because i have gone through the same issue with other project.

  4. Hi, I encounter some problem in your project.
    I have set up the database and data using your SQL code. And I have change the connection config.
    And I am able to login using admin password.
    But I can’t get access to the data, there is no data list shown although the data is set up in the database. How to solve it?

  5. I have using my database data to replace yours in the web.
    But i can’t display the data list after set up the all the necessary steps.

    Is the js file will affect the display of data

  6. Hello, May I know why i cannot add new user?
    I tried to insert in phpmyadmin and in the sign in there…
    Please contact me as soon as possible,Thanks

  7. thanks for this wonderful videos and very nice explain and professional tutorial . i wish for you good and great future in php

  8. Hello codersfoder, please make a single video tutorial on using input text field for products instead of select option… We will use the item id to querry the db and echo d product name in another input field…thanks in advance

  9. Thanks brother You have done a great job. Keep it up. V
    Brother how do I add items and quantity of products to report print please. Thanks again

  10. Application Working Fine, But as we need to change Quantity in “Manage Orders” . The Problem is Quantity is not updated correctly in Product Table. Please Give Me Reply.

  11. Hello, I downloaded your application but on the invoice I notice that the quantity does not multiply with the unit price of the product select

  12. hi.. is it possible to add more users ?
    how can i do this? i tried to add one user manually in phpmyadmin but when i try to log in it says incorrect username and password combination

  13. Hello , i like your work and i cover him a little bit,but i have a problem.When i create a new product, it dont appear in the datatable only right loading… on the save button.
    Someone can me explane what is the problem there?
    Thanks!!!

  14. Great work..!!!
    I have added one tab named as channel, everything works fine for channel like adding, removing and viewing data but on click of edit button popup opens with blank data. Can you please help me where is the exact issue?

  15. Hi i need help
    This site can’t be reached

    localhost refused to connect.
    Search Google for localhost 9080 stock dashboard
    ERR_CONNECTION_REFUSED
    this is my error plz help

  16. The add row button in add orders is not working when this is uploaded on any hosting. It would be great if you could suggest me a fix

  17. I go to line 555 order.js and change the vat value but after it saved nothing changed and the value still counted as 13%..help me plz

  18. how i can add my company name and contact number in order print page??? btw thanks a lot for this… project..

  19. Thanks for sharing the codes!

    Sorry, I’m novice and still learning. Does anyone know how to resolve the following error?

    Notice: Undefined variable: connect in C:\xampp\htdocs\stock\index.php on line 27

    Fatal error: Call to a member function query() on null in C:\xampp\htdocs\stock\index.php on line 27

  20. Hi,

    Thanks for your work !
    I have an issue when I add one column in the product table:
    “DataTables warning: table id=manageProductTable – Requested unknown parameter ‘8’ for row 0. For more information about this error, please see http://datatables.net/tn/4
    How can I solve that please ?

  21. i already change the vat on line 555 in order.js but it seems that its not working i calculate it manually but the answer is not correct.

  22. // vat
    var vat = (Number($(“#subTotal”).val())/100) * 7;
    vat = vat.toFixed(2);
    $(“#vat”).val(vat);
    $(“#vatValue”).val(vat);

    // total amount
    var totalAmount = (Number($(“#subTotal”).val()) + Number($(“#vat”).val()));
    totalAmount = totalAmount.toFixed(2);
    $(“#totalAmount”).val(totalAmount);
    $(“#totalAmountValue”).val(totalAmount);

    it show 13%

  23. dear sir, how can i remove a complete VAT because the products and orders are not same tax value, so i want to remove how i can i do please help me.
    thank u

Leave a Reply

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