Inventory-Invoice-Software

INDEX

1. Introduction
2. Developed With
3. Python External Libraries
4. FAQ
5. Sample Snapshots and Sample Bill
6. NOTE

---

                                              ---END OF SECTION---

---

1. Introduction

This is an Inventory Management System tied up with a Invoice Generation System for a store. It can be used for a small convenient store after certain modifications to the GUI. It is a SINGLE USER, HOST ONLY software, not intended for customer use. It has been compiled into a Windows Executable file. The development details are stated below and sample snapshots are on display too.

---

---

2. Developed with:

• Python 3.7
• SQLite 3

---

                                              ---END OF SECTION---

---

3. Python External Libraries Used:

• Python Docs(python-docx): for generation of bills.
• SQLite 3(sqlite3): for handling databases. NOTE: The existing sqlite3 library and .dll file given in python has to be updated for use.
• CX Freeze(cx_Freeze): for compiling the file into a Windows Executable File (.exe).

---

                                              ---END OF SECTION---

---

4. FAQ: What can this software do?

• It has a GUI Interface for Inventory Management and Invoice Generation of a store, named Daw Bedding Stores.
• It's main window gives the user with 3 choices:
  1. Generate Bills
  2. Add to Database
  3. Update the Database
• The user can run any or all the three instances of the choices together, but it is advisable to do it one at a time.
• Once the user clicks on the "GENERATE BILL" button, the printer connected to the pc or LAN automatically prints the bill and it is also displayed in Microsoft Word (or any other default software to run .doc file). It is also saved in directory named as per the date of use and the files are named according to the customer.
• The software is able to keep on generating invoice and updating the inventory as long as the user wants it to and doesn't need to be restarted every time a customer buys something.
• The software can handle errors like "ITEM OUT OF STOCK", "NO ITEMS WITH SUCH PRODUCT ID" etc and display it to the user for better trouble-shooting.

---

                                              ---END OF SECTION---

---

5. Sample Snapshots and Sample Bill

A few snapshots of the Software in action. I've also uploaded a sample bill which was generated from this software.

• This snapshot shows the Main Window which can be used to run any other process according to user's choice.
• This snapshot shows the Generate Bill's Add to Cart function of the software.
• This snapshot shows the Add to Database function of the software.
• This snapshot shows the Update Database function of the software.
• This snapshot shows the generated bill which has automatically opened in Microsoft Word.

---

                                              ---END OF SECTION---

---

6. NOTE

The code for the software has not been uploaded due to privacy and security concerns. Sorry for the inconvenience.
The only code-document uploaded is "root.py", only for giving a glimpse of the design of the software. This "root.py" is the main window which invokes the other choices upon being choosed by the user of the software.

---

                                              ---END OF SECTION---

---