Simple POS - Point of Sale Made Easy

Simple POS is PHP and jQuery based web application.

Documentation Version 1.0.1

Public Beta

Due to the large number of changes to v4 we have decided to release it as a beta to collect user feedback. Please note that during this period based on user feedback we may make some changes to improve the item. Update tool is not yet available and will be added soon.

Installation Instruction

Requirements: Apache 2.2+, Mysql 5.4+, PHP 5.4+

  1. Copy/Upload the folder and files to your web server using cPanel or FTP
  2. If you are installing in sub folder, please make sure there is no space in folder names
  3. Create mysql database, database user and grant all permission to user for this database.
  4. Open the http://yourdomain.com/pathtoupload/install/index.php
  5. Step 1: Pre-install system checklist - If there is any issue with checklist, you will need to fix it first to proceed to next step.
  6. Step2: Provide you Envato Username and Purchase Code to validate the purchase.
  7. Step 3: Provide the database host, database user, database password and database name to proceed to next step. Please make sure you don't have $ sign in your password.
  8. Step 4: Site Config: Please Fill in you Simple POS Base URL and select your timezone. You must check the site url as installer might guess it wrong
    • Base URL for public_html or www/htdocs folder will be http://yourdomain.com/ or http://localhost/
    • Base URL for sub-domain will be http://subdomain.yourdomain.com/
    • Base URL for sub-folder will be http://yourdomain.com/subfolder/ or http://localhost/subfolder/
    • Base URL must not have space and it should end with a trailing slash
  9. If everything goes smooth, you will be redirect to final page with login details.
  10. Remove the install folder before start using the Simple POS.
  11. Login using default username and password. You should can add new admin account before deleting/editing default account.

Request Installation

We will provide the service to install the item for $10 To request the installation, please send $10 to saleem@tecdiary.com by Paypal or Skrill and email us your license file and hosting control panel details with reference of your payment to support@tecdiary.com

Updating from V3

We have added the update tool for testing purpose and feedback only. If you are advance user and have good command and experience of backup/restore (files & database) then you can try this update tool.

Please don't try this on your production version. Backup and restore the production version to different location and then try to update that. We are not providing any support for this at least for this version.

Please follow these steps to update from v3.x to beta v4.0

  1. Backup all your files and database. Save/download the backup. (MUST)
  2. Save/download database config file (spos/config/database.php) on your computer
  3. Delete all old files/folders except assets/uploads as your product images and other upload data is in this assets/uploads.
  4. Upload all the new files/folders (from your downloaded file).
  5. Move all the contents of assets/uploads/ to newly uploaded uploads/ folder.
  6. Once all the files are uploaded. We need to update the datase configuratiuon to the newly uploaded database configuration file (app/config/database.php) form the locally saved copy of database config file in step 2. You need to update the hostname, username, password and database.
    LETS ACCESS UPDATE TOOL FROM BROWSER, UPDATE TOOL WON'T ASK FOR DATABASE CONFIG AS WE HAVE ALREADY UPDATED THE DATABASE SETTINGS.
  7. Open the browser and type http://yourdomain.com/pathtoupload/update/index.php
  8. Step 1: Pre-install system checklist - If there is any issue with checklist, you will need to fix it first to proceed to next step.
  9. Step 2: Provide your Envato Username and Purchase Code to validate and update your license.
  10. Step 3: Site Config: Please fill in you Base URL and select your timezone. You must check the base url as update tool can guess it wrong. This is the same base_url that you have in your old spos/config/config.php file
    • Base URL for public_html or www/htdocs folder will be http://yourdomain.com/ or http://localhost/
    • Base URL for sub-domain will be http://subdomain.yourdomain.com/
    • Base URL for sub-folder will be http://yourdomain.com/subfolder/ or http://localhost/subfolder/
    • Base URL must not have space and it should end with a trailing slash
  11. If everything goes smooth, you will be redirect to final page with update complete message.
  12. Remove the install and update folder before start using the Simple POS. If you find any issue with update, please email to support@tecdiary.com

Update Instruction (from 4.0.x to latest)

Requirements: Apache 2.2+, Mysql 5.4+, PHP 5.4+

  1. Extract the downloaded file.
  2. Copy Beta v4.0.x/app/config/migration.php, paste and replace the old file in yourinstallationdirectory/app/config/
  3. Copy Beta v4.0.x/themes, paste and replace the old folder in yourinstallationdirectory/
  4. Copy
    1. Beta v4.0.x/app/controllers
    2. Beta v4.0.x/app/core
    3. Beta v4.0.x/app/helpers
    4. Beta v4.0.x/app/language
    5. Beta v4.0.x/app/libraries
    6. Beta v4.0.x/app/migrations
    7. Beta v4.0.x/app/models
    Paste and replace the old folders in yourinstallationdirectory/app/
  5. There is no db change, so you are done.

Hardware

1. Receipt Printers:

We have tested the update V4 with Bixolon SRP-350II (USB) with Web Browser Printing and Java Applet by adding qz print plugin that will support these printers

  • Samsung Bixolon SRP350plus, Bixolon SRP-350II and Bixolon SRP-270.
  • Telly Dascom 1125 (USB)
  • Epson Thermal Printer (COM)
  • Eltron P310i
  • Zebra GK420, Zebra P310, Zebra LP 2844 and Zebra TLP2844
  • Citizen CT-S2000 (USB)
  • DOS/LPT1 Printing
  • Print directly to file: i.e. \serverprinter
  • Nippon Primex
  • Essae PR-85j
  • Bematech MP200

Bixolon printers will work fine however you might need to change some commands for other printers. Please be informed that we can't provide support regarding any issues with plug-in. You will need to manage it by yourself.

2. Barcode Scanners/Readers:

Any of the barcode scanners/readers will work fine with v3 as long as it can read accurately.

3. Magnetic Card Readers:

Most of the Magnetic Card Readers will work fine. We have tested this with Uniform MSR213 Magnetic Stripe Card Reader (USB - 3 Track Reader).

For tablet/mobile card readers: No such feature and recommendation yet.

4. Cash Drawers:

You should buy the cash drawers that can be connected to pos printer. To use cash drawers, you printer should have the port to connect cash drawer as Bixolon SRP350II.

For Browser Print, you might need to set your printer to open cash drawer before printing.

For Java QZ Print, It will be fine as cash drawer will be opened with printing and can be opened without printing.

5. For barcode and label printing:

Any desktop laser print will work fine for barcode printing. The label print should work with label printer but the design is very simple and we will not offer any support to customize this. You can customize as you like or hire developer.

Live Demo For Simple POS V3.0 & Beta V4.0

Demo Link for B4.0: http://spos.tecdiary.my/

Demo Link for V3.0: http://spos.tecdiary.my/spos3/

Login Details:

Role:               Username                 Password
Admin: admin@tecdiary.com 12345678
Sales staff: salesman@tecdiary.com 12345678

Credits

Thanks to all great people who are developing open source software.

  • CodeIgniter - PHP-Framework under MIT License
  • Ion_auth - A simple, lightweight authentication library by Ben Edmunds under the Apache License v2
  • Bootstrap - Most popular HTML, CSS, and JS framework under MIT License
  • jQuery - A fast, small, and feature-rich JavaScript library under MIT License
  • Font Awesome - The iconic font and CSS toolkit under GPL License.
  • DataTables - A plug-in for the jQuery under two licenses: GPL v2 license or a BSD (3-point) License
  • Zend Framework 1 (barcode library) - under New BSD License
  • Moment.js - Moment.js is freely distributable under the terms of the MIT license.
  • Bootstrap-datetimepicker - Date and Time picker widget based on bootstrap under Apache License V2
  • iCheck - Highly customizable check boxes and radio buttons under MIT License
  • Accounting.js - A tiny JavaScript library for number, money and currency formatting under MIT License
  • jQuery Cookie - A simple, lightweight jQuery plugin to manage cookies under MIT License
  • Commercial Licenses
    • Highcharts
    • FormValidator
    • Redactor Text Editor

Thanks to all the friends for their suggestions, feedback and help.

Frequently Asked Questions

  • Error

  • Why am I getting CloudFlare Security or Blank error on verification while installing the item?

    If you are not getting any error but blank red alert or CloudFlare Security error mean your request is no reaching to verification server. Please check that you server is not blocking the curl request and secondly there are chances that CloudFlare might be challenging your request due to various reasons. Please check with your host and request them to white list CloudFlare ips https://www.cloudflare.com/ips

    Updating your Anti-Virus and Browser might help. You can check with your host too.

    You can try different host and/or install it locally with any web platform easyphp/lamp/mamp/wamp/xampp.

  • Why I am getting "no input specified" error after install/update?

    Please add the ? 'question sign' after index.php in the .htaccess file, you line will be look as RewriteRule ^(.*)$ /index.php?$1 [L]code.

    For more information, please visit this guide page.

  • Why the installer/update tool is locked?

    After successfully installation/update, the installer/update tool will be automatically locked.

    If you having any issue after installation or like to perform the installation again, please upload the files again.

  • Why am I getting 404/500 error page after installation?

    Please

    1. make sure that your apache mod_rewite is enabled
    2. check that .htaccess file is successfully uploaded and exists in the main directory of installation
    3. base_url in app/config/config.php
    4. check your database settings in app/config/database.php
    5. check your folders/files permissions (folders should have 755 and files should have 644 permissions).

    If you are using godaddy, please visit the codeigniter official guide here. You might need to check and modify you .htaccess files too.

    You can always check your error log to get more information about the issue.

  • Why sale time is different from my computer time?

    The time with Javascript and PHP could be different as javascript use your computer time but php will use your server time.

    Please check your timezone in index.php and make sure that you have set the correct time zone. You can find your timezone at http://php.net/manual/en/timezones.php

  • Why I can't send emails?

    We have tested the email function on different hosting servers. Please check with your host about this and if you need to check the code that will be in app/libraries/tec.php and look for send_email()

  • Why I can't login and getting time out error?

    Timeout feature has been enabled. The user will be timed out after 3 unsuccessful login attempts for 10 minutes. You can disabled this in app/config/ion_auth.php by changing the $config['track_login_attempts'] = TRUE; to $config['track_login_attempts'] = FALSE; or you can increase the attempts from 3 to any number you like.

  • Why I can't upload any file?

    This could be due to permission on the /uploads. Please set 777 permission to /uploads and all other folder in the /uploads/

  • Why I getting db error and can't login?

    Please check your db configuration in app/config/database.php

  • Can I use this on Windows server with IIS?

    Yes but we haven't tested this and don't provide any support for setup.

    If URL Rewrite module is not installed, please install it from here http://www.iis.net/downloads/microsoft/url-rewrite. Please check the complete web.config file. Place this in the main installation folder where the index.php is placed.

    <?xml version="1.0" encoding="UTF-8"?>
    <configuration>
        <system.webServer>
            <rewrite>
                <rules>
                    <rule name="Imported Rule 1" stopProcessing="true">
                        <match url="^(.*)$" ignoreCase="false" />
                        <conditions logicalGrouping="MatchAll">
                            <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
                            <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
                        </conditions>
                        <action type="Rewrite" url="index.php?url={R:1}" appendQueryString="true" />
                    </rule>
                </rules>
            </rewrite>
        </system.webServer>
    </configuration>

  • Can I use this with NGINX?

    Yes but we haven't tested this and don't provide any support for setup.

    You can follow the guide http://wiki.nginx.org/Codeigniter. Your nginx.conf file will look like this.

    server {
        server_name domain.tld;
    
        root /var/www/codeignitor;
        index index.html index.php;
    
        # set expiration of assets to MAX for caching
        location ~* \.(ico|css|js|gif|jpe?g|png)(\?[0-9]+)?$ {
            expires max;
            log_not_found off;
        }
    
        location / {
        # Check if a file or directory index file exists, else route it to index.php.
        try_files $uri $uri/ /index.php;
        }
    
        location ~* \.php$ {
        fastcgi_pass 127.0.0.1:9000;
        include fastcgi.conf;
        }
    
        location ~ /files {
        deny all;
        return 404;
        }
    }

  • Why some products are missing from order when I add 100+ products?

    There is no restriction in Simple POS on the number of order items. If you are having such issue, please check your php configuration file (php.ini) for max_input_vars and set it to higher number i.e, 10000.

  • Why Wordpress showing 404 page when I access the Simple POS?

    You can exclude sub-directory from RewriteRule of wordpress by adding the line below to your .htaccess file in main directory of wordpress.

    RewriteCond %{REQUEST_URI} !^/(mydir|mydir/.*)$

User Guide

SimplePOS

SimplePOS

SimplePOS

SimplePOS

SimplePOS

SimplePOS

Adding Language

Guide to add new language.

  • Please create new folder in app/language/ and name it yourlanguagename
  • Folder name should be without space and all lower letters.
  • Copy all the files from app/language/english/ and paste then to app/language/yourlanguagename/
  • Now you can translate these all file to your language
  • Download flag image (format: png, width: 16px, height: 11px) and paste it in themes/default/assets/images/
  • You can add new key to language array. (See Code Section)

Please replace the yourlanguagename with your language For example, spanish, french, chinese etc

To add select option in setting's language

Please open themes/default/views/settings/index.php and search for ( $available_lang = ) You can replace the default with your theme if you are using different theme. You can add new array key for your language as following:

$available_lang = array(
'english' => 'English',
'yourlanguagename' => 'Your Language Name',
);

yourlanguagename must be same folder name that you created in app/language/

If you are getting the error "Unable to load the requested language file: language/yourlanguagename/form_validation_lang.php or calendar_lang.php" Then you will need to add your language in lib/language/ as you did above for app/language/ and translate the system language files to your language.

Add/Remove column to table

Here are the steps to follow

To add a column you will need to

  1. Modify the select statement and select the desired column, in the controller.
  2. Add new element to datatables columns (should be in sequence) in the relative view file.
  3. Lastly add the th tag with column heading to table head (should be in sequence).

To remove a column you will need to

  1. Modify the select statement and remove the desired column, in the controller.
  2. Remove the element form columns of datatables in the relative view file.
  3. Lastly Remove the th tag with column heading to table head.

Sorting Tables

We have used datatables library for all listing tables. If you need to change any table sorting column, you will need to modify the view file.

The first column of the table will start from index 0 and then increase 1 with each columns. Let say you want to sort the table with 4th column then you will need to use index 3 as "aaSorting": [[3, "asc"]],

You can change the sorting for any table by modifying the files as described here.

For example, if you need to change the sorting for customers, you will need to edit the /theme/default/customers/index.php and search

"aaSorting": [[0, "asc"]],

This is being sorted for first table column, If you want to sort it by id (2nd table column) then you will need to change as

"aaSorting": [[1, "asc"]],

You even can sort the table with multiple columns as

"aaSorting": [[0, "asc"], [1, "asc"]],

Barcodes and Labels

Barcode page is designed to be printed with desktop laser printers. Barcode sheet or barcode pages have 2 columns' table (2 product per row and medium barcode image with 60px height). For labels, each label will be printed on different page as most of you will print label with label printers. We don't provide any support for modify the design.

If you need to modify any of the barcode/label page to show/remove any information, you can do so by modify the products controller. The functions are mentioned that handle the pages.

Functions/Methods handling the barcodes and labels pages are

  • single_barcode() - Handles barcode printing for single products
  • single_label() - Handles label printing for single products
  • print_barcodes() - Handles barcode printing for multiple products based on category
  • print_lables() - Handles label printing for multiple products based on category

File: app/controllers/products.php

Request Installation

We will provide the service to install the item for $10 To request the installation, please send $10 to saleem@tecdiary.com by Paypal or Skrill and email us your license file and hosting control panel details with reference of your payment to support@tecdiary.com

Request Update

We will provide the service to update the item from v3 for $20 To request the update, please send $20 to saleem@tecdiary.com by Paypal or Skrill and email us your license file, v3 installation path/link with login details and hosting control panel details with reference of your payment to support@tecdiary.com

Custom Modifications

Yes, we do provide customization services to modify/enhance the item functionality to suit your needs. We charge $30 per hour. Please email to saleem@tecdiary.com to check availability, estimated cost and time.

Feature Request

Yes, we would love to listen your requests/feedback. Please prepare the details with examples before emailing to saleem@tecdiary.com