Info


Stock Inventory & Billing System

Multi Outlet Supported

Author : Yupok

Create Date : 10-05-2020

Support : yupokteam@gmail.com

Overview


Stock Inventory & Billing System is a complete and responsive feature with Admin Login, Manager/Outlet Login & User/Customer Login for your Offline to Online Business.

For : Gift Shop, Toy Shop, Garment Shop, Printing Shop, Cafe Shop, Restaurants & Many More Shops.

This feature has an attractive front end and back end interface that are really awesome and eyecatching. Almost all kinds of changes are possible to do using the Admin Panel without having any kind of programming language knowledge.

It is built using the procedural php (with PDO feature) and without any framework. For this reason, it can be customized easily by most of the developers and create own Billing System with this awesome feature.

Security : It is protected against SQL injection, XSS and other attack and your website will be safe.

Requirements


Before starting to install, make sure you fulfill the following requirements:
  • For Local Server installation, you need to have XAMPP, WAMP or any apache server with PHP and MySQL
  • You can use this script on any live LINUX server.
  • Required PHP version in server >= 5.4.

Features


Admin Features
  • Create New Admins
    • Search Admins
    • Activate / Deactivate Admins
    • Note : New Admin also full access rights, They can also deactivate your account. So Be careful.
  • Create Unlimited Outlet Manager
    • Search Manager
    • Activate / Deactivate Outlet Manager
    • Deactivated Manager Automatically Logged Out
  • Create Unlimited Customer
    • Edit Any Customer
    • Search Customer
    • Activate / Deactivate Any Customer
    • Deactivated Customer Automatically Logged Out
    • View who Creates Customer
    • View who Last Edit the Customer
  • Customer
    • Automatically Generated Username
      • If Customer Email entered their Email is their Username
      • If Customer Email empty then their Phone is their Username
    • Automatically Generated Temporary Password
      • By Default Customer Temporary Password is 123456 .A pop up shows to change their Password. They cannot do anything Until they change their default password.
  • Create Category
    • Search Category
    • Edit Category
    • Activate / Deactivate Category
  • Create Brand
    • Search Brand
    • Edit Brand
    • Activate / Deactivate Brand
  • Create Tax Slab Rate
    • Search Tax Slab
    • Edit Tax Slab
    • Activate / Deactivate Tax Slab
  • Create Products
    • Add Unique Product SKU code
    • Search Products
    • Edit Products
    • Activate / Deactivate Products
    • Add Quantity
    • View Available Quantity
    • View Base Price
    • View Tax Price
    • View Selling Price
  • Create Orders
    • Manage All Orders
    • Edit All Orders
    • Add Unlimited Product Rows
    • Search Product Row by Name or Product SKU code
    • Automatic Calculations
    • Discount %
    • Paid / Due Function
    • Clear Due Amount
    • Activate / Deactivate Any Order
    • View who Creates Order
    • View who Last Edit the Order
  • Update Currency
    • Currency can View on Admin/Outlet Manager/Customer Dashboard
  • View Today Sales
  • View This Month Sales
  • View Total Sales from Start
  • View Datewise Sales
  • View Productwise Sales with Daterange
  • View Categorywise Sales with Daterange
  • Update Company Details
  • Update Password
  • Download Order PDF from Manage Order
  • Download Datewise Order PDF from Manage Order

Manager/Outlet Features

  • Create Unlimited Customer
    • Search Customer
    • Edit Only Own Customer
    • Activate / Deactivate Only Own Outlet Customer
    • Deactivated Customer Automatically Logged Out
    • View who Creates Customer
    • View who Last Edit the Customer
  • Create Orders
    • Edit Only Own Outlet Orders
    • Add Unlimited Product Rows
    • Search Product Row by Name or Product SKU code
    • Automatic Calculations
    • Paid / Due Function
    • Clear Due Amount
    • Activate / Deactivate Any Order
    • View who Creates Order
    • View who Last Edit the Order
  • Products
    • View Products
    • Search Products
    • Cannot Edit Products
    • Cannot Activate / Deactivate Products
    • Cannot Add Quantity
    • View Available Quantity
    • View Base Price
    • View Tax Price
    • View Selling Price
  • View Own Outlet Today Sales
  • View Own Outlet This Month Sales
  • View Own Outlet Total Sales from Start
  • View Own Outlet Datewise Sales
  • View Own Outlet Productwise Sales with Daterange
  • View Own Outlet Categorywise Sales with Daterange
  • Update Password
  • Download Order PDF from Manage Order
  • Download Own Outlet Datewise Order PDF from Manage Order

Customer/User Features

  • First Time Customer Login
    • A pop shows to change their Default Password 123456 to Strong Password Validation Rule
    • View Today their Orders
    • View This Month their Orders
    • View Total their Orders from start
    • Download PDF invoice of their Orders
    • View their Details

Create Database, Username, Password & Import SQL file.


  • Step 1: Login to your website CPanel with your Username & Password.


  • Step 2: On Homepage, Scroll Down to Databases & Click on MYSQL Databases option.


  • Step 3: Create New Database, Just write billing_system & press Create Database Button.


  • Step 4: A message appears, Added the database "yupok_billing_system" It means Your Database Name : yupok_billing_system , Note : yupok_ prefix is demo, your website automatic added Prefix to your database name.So copy that name that is your Original Database Name.


  • Step 5: Press Go Back and return to Database Page again.

  • Step 6: Scroll Down the Page, MYSQL Users Add New User, Just fill the details like you want to use Username & Password & keep details in the safe place & Press Create User button.


  • Step 7: A message appears, You have successfully created a MySQL user named "yupok_demo_user". It means Your Database USERName : yupok_demo_user , Note : yupok_ prefix is demo, your website automatic added Prefix to your Username.So copy that name that is your Original Database Username.

  • Step 8: Press Go Back and return to Database Page again.

  • Step 9: Scroll Down the Page again to Add User to Database . Select your Last Created Username & Last Created Database for this billing system & Press Add Button.


  • Step 10: You will redirect to Another Page. Click on ALL PRIVILEGES option, Scroll down & Press Make Changes Button.



  • Step 11: A Success message appears on top right corner. After that scroll down to the page and press Go Back


  • Step 12: Example
    YOUR_HOST_NAME : localhost  Mostly its localhost but if not then contact your website service provide.
    YOUR_DATABASE_NAME : yupok_billing_system  This is demo which we explained above. Your real database name is different.
    YOUR_DATABASE_USERNAME : yupok_demo_user  This is demo which we explained above. Your real database username is different.
    YOUR_DATABASE_Password : password  That is explained in Step 6.
  • Step 13: Import sql file to Database. Go to CPanel homepage scroll down to Database , Click on phpMyAdmin, your database will be open.

  • Step 14: On the left sidebar your Newly Database Option will be shown Just click on that.

  • Step 15: After click see on right side there is Import Option click on that and browse & select sql file from your downloaded database folder and press Go Button on the bottom.


  • Step 16: Your database will be imported and your website is ready to Use.

Configuration


Do Carefully Otherwise Script will not work

  • Unzip the Downloaded File, Go to Upload Folder and Unzip again the stock_inventory_billing_system.zip


  • After that Go to admin folder


  • Now Go to db folder


  • Open config.php file in any Text Editor like Notepad++, Dreamweaver , etc.


  • Save Details according to your database. We explained above How to create Database, Username, Password & Import SQL file. Read Again


  • Note 1 : At Line 19 in config.php file : Defining Base URL : It means this is your full website name. i.e. https://www.yourwebsite.com/ or https://yourwebsite.com/ or http://yourwebsite.com/ . Point to remeber - Please add forward slash / at the end of your website name. Note if you want put this script in folder name for demo like sales then base url will be https://www.yourwebsite.com/sales/ , Put forward slash / at the end , Otherwise script won't work.

  • Note 2 : At Line 22 in config.php file : Defining Admin URL : It means this is your admin folder. Please do not change this line otherwise script won't work..

  • Upload All folder and import database file and its Done.

First Time Admin Login


  • When you have configured correctly Database & Import SQL file then upload time.
  • Go to downloaded file -> Go to upload folder -> Unzip stock_inventory_billing_system.zip file & Open that folder -> Copy all files & admin folder (Note : In admin folder, go to db folder and open config.php file and replace details with your server detail which we explained above.)
  • Create Folder on your server where you want to Upload this script. Upload all copied files.
  • Let we help you in Detail with example.
  • Assume you make a folder on your server mybill and upload all copied files with correct database configuration.
  • URL for Admin/Outlet Manager : www.yourwebsite.com/mybill/admin/
  • Assume you make a folder on your server management and upload all copied files with correct database configuration.
  • URL for Admin/Outlet Manager : www.yourwebsite.com/management/admin/
  • Default Email : admin@admin.com & Password : 123456
  • Click on User Icon on Top Right Corner => Click on Company Details => Update Your Login Email.
  • Click on User Icon on Top Right Corner => Click on Password => Old Password = 123456 => Set New Password & Keep in Safe Place

First Time Customer Login


Note: No Customer made by Default Imported SQL File, First Create Customer in Admin Panel then Login to User Panel as User.


  • Assume you make a folder on your server mybill and upload all copied files with correct database configuration.
  • URL for Customer : www.yourwebsite.com/mybill/
  • Assume you make a folder on your server management and upload all copied files with correct database configuration.
  • URL for Customer : www.yourwebsite.com/management/
  • Login with their Username i.e. Either Email or Mobile(If Email Empty when adding a Customer) and
    Temporary Password is 123456
  • A pop up shows to change their Temporary Password. They cannot do anything Until they change their default temporary password.

Dashboard


  • 3 Types of Analysis available.


  • Today Analysis means Today Total Order, Total Sales amount, Estimated earning after removing Tax & Total tax which you have to paid from All Outlet for Admin. If Manager open their Dashboard then Only show analysis of their Outlet respectively.
  • This Month Analysis means which is current month Total Order, Total Sales amount, Estimated earning after removing Tax & Total tax which you have to paid from All Outlet for Admin. If Manager open their Dashboard then Only show analysis of their Outlet respectively.
  • Total Analysis means from very starting first day of use this script Total Order, Total Sales amount, Estimated earning after removing Tax & Total tax which you have to paid from All Outlet for Admin. If Manager open their Dashboard then Only show analysis of their Outlet respectively.

  • Scroll Down 3 Types of Table Analysis available.(Only For Admin)

  • 1st Today Table Analysis => Today Table Analysis.


  • In this section Admin will get All the ID of Outlet/ Admin, Email of Outlet, Role, Today Total Order & Order Total Amount. (Only Today Date).

  • Scroll Down 2nd Table Analysis => This Month Table Analysis.


  • In this section Admin will get All the ID of Outlet/ Admin, Email of Outlet, Role, This Month Total Order & Order Total Amount. (Only Current Month).

  • Scroll Down 3rd Table Analysis => Table Analysis from Starting i.e. Day 1st .


  • In this section Admin will get All the ID of Outlet/ Admin, Email of Outlet, Role, Total Order & Order Total Amount. (From Day 1st).

Services


This is very important to Set Up your Offline Store to Online. Please follow all the steps carefully.

  • Go to the Services Option.


  • Step 1:If you want to Add/View/Search or Deactivate/Activate another Admin. Click Admin Option. Be careful of creating New Admin because New Admin also has all rights to Deactivate you.


  • Step 2:If you want to Add/View/Search or Deactivate/Activate Managers. Click Manager Option. Note: Manager is your Outlet, Multiple Managers means Multiple Outlet System. Deactivated Managers automatically Logout when click on any option in their panel.


  • Step 3:Click Currency Option, Just select from selectbox & Update your Country Currency so you or Manager Outlet or your User/Customer can view on their Dashboard.


  • Step 4:Click Category Option, Add/Edit/Search/Activate/Deactivate Category. First time you have to create first category by clicking on Add Category Button before creating Brand or Product. You can create unlimited Category.


  • Step 5:Click Brand Option, Add/Edit/Search/Activate/Deactivate Brand. First time you have to create first Brand by clicking on Add Brand Button with respective category. You can create unlimited Brands.


  • Step 6:Click Tax Option, Add/Edit/Search/Activate/Deactivate Tax. First time you have to create first Tax Slab by clicking on Add Tax Button. You can create unlimited Tax Slab.


  • Step 7:Click Product Option, Add/Edit/Search/Activate/Deactivate, View available Quantity, Unique SKU Code of each Product, View Created by , Last Edited By. First time you have to create first Product by clicking on Add Product Button. You can create unlimited Products. Note : Deactivated Products automatically hide when creating New Order.


  • Step 7:Your Store has been setup for creating New Order. Now creating new User, Click User option. You can Add/Edit/View/Search/Activate/Deactivate even Create Order of every single user. For Adding new customer, Click Add Cutomer Button. Note: For creating New Customer you have to fill at least 1 field Either Email or Mobile. Its mandatory for creating automatically Username of customer.


  • Step 8:You can also create New Order Directly via Just searching & selecting Username. Click on Add Order option on Left Sidebar. All the details of that User automatically Field.


  • Note: When creating New Order, Discount and Paid Amount fill on very last and click Outside anywhere. Automatically calculations start. After that click Add Order.
  • Step 9: To Search/Edit/View/Activate/Deactivate/Clear Due Amount/Item Details/Edited By/Created By of Order, Click Manage Order Option on Left Sidebar.


Sales


3 Types of Sales View : Datewise Sales, Productwise Sales, Categorywise Sales with Daterange Selector.

  • Click on Sales=>Datewise Sales, Productwise Sales or Categorywise Sales
  • Select Start Date & End Date and Click on Show, Without page reload Data comes below according to your Date.




  • Note : For Admin = All Outlet including Admin data fetch / For Outlet Manager : Fetching data only their own Outlet.

Copyright © yupok


You are not allowed to use this documentation template for your personal or commercial or any other purposes.