Supermarket Management System Project in Django with Source Code

July 1, 2021June 29, 2021 by adones evangelista

Supermarket Management System Project in Django with Source Code

This Supermarket Management System Project in Django created based on python, Django, and SQLITE3 Database. Supermarket management system refers to the system in which all parts of supermarket management are handled. These considerations include information about diverse items, staff, management, customers, billing, and so on.

A System allows for the efficient management of retail data. The customer can also buy and pay for the products they’ve chosen. This project is built on a supermarket’s sales transaction and billing of items.

The first action entails entering the items into the system, as well as the rates that are now in effect in the supermarket and the names of the items that the store has agreed to sell.

Watch the video here to see the full running source code of the Supermarket Management System Project in Django

To start creating a Supermarket Management System Project in Python Django, makes sure that you have PyCharm Professional IDE Installed in your computer.

This Supermarket Management System in Django Framework, Also includes a Download Source Code for free, just find the downloadable source code below and click download now.

Admin Features of Supermarket Management System in Django

Organize and manage a store’s personnel.
Monitoring of net income and expenditures.
Keep track of all the items sold in the business.
Keep track of varied product inventories.
Products can be added or removed, and expired products can be removed
Users can look up specific product information.
Generation of bills.
The admin can Supervise employees who work in a store.
The admin can Monitor net income and expenses.
Admin can keep track of all the items sold in the business.
Keep track of varied product inventories.
Admin can manage the Products can be added or removed, and expired products can be removed.
He should be able to Look for specific product information.

Supermarket Management System in Django Steps on How to Create a Project

Time needed: 5 minutes.

Here’s the step’s on how to create a Supermarket Management System Project in Django with Source Code.

Step 1: Open file.
First , open “pycharm professional” after that click “file” and click “new project“.
Step 3: Select file location.
Then, select a file location wherever you want.
Step 2: Choose Django.
Next, after click “new project“, choose “Django” and click.
Step 4: Create application name.
After that, name your application.
Step 5: Click create.
Lastly, finish creating project by clicking “create” button.
Step 6: Start Coding.
Finally, we will now start adding functionality to our Django Framework by adding some functional codes.

Functionality and Codes of the Supermarket Management System Project in Django with Source Code

Create template for the company form in Supermarket Management System in Django.

In this section, we will learn on how create a templates for the company form. To start with, add the following code in your company.html under the folder of /templates/.

{% load widget_tweaks %}
{% load static %}
{% block content%}
    <script>
        $(document).ready(function() {
           var logo = document.getElementById('nav_logo')
           var img = document.getElementById("comp_logo").getAttribute("src")
           logo.src = img;
        });
    </script>
    <div class="modal fade" tabindex="-1" role="dialog" id="modal" style="z-index: 50px">
        <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content"></div>
        </div>
    </div>
    <div class="container">
        <form method="post" enctype="multipart/form-data" action="{% url 'edit_company' 1 %}">
        {% csrf_token %}
            <div class="modal-header my-0">
                <h5 class="modal-title">UPDATE COMPANY DETAILS</h5>
            </div>
            <div class="modal-body my-0">
                <div class="{% if form.non_field_errors %}invalid{% endif %} mb-2">
                    {% for error in form.non_field_errors %}
                        {{ error }}
                    {% endfor %}
                </div>
                <img id="comp_logo" src="{{ company.logo.url }}" width="30" height="30" class="d-inline-block align-top" alt=""> <br /><br />
                <div class="form-row">
                    {% for field in form %}
                        {% if field.name in ',logo' %}
                            <div class="form-group col-md-12 {% if field.errors %} invalid{% endif %}">
                                <label for="{{ field.id_for_label }}">{{ field.label }}</label>
                                {% render_field field class="form-control" rows="5" placeholder=field.label %}
                                {% for error in field.errors %}
                                    <p class="help-block">{{ error }}</p>
                                {% endfor %}
                            </div>
                        {% endif %}
                    {% endfor %}
                    {% for field in form %}
                        {% if field.name not in 'logo,address,created_by' %}
                            <div class="form-group col-md-6 {% if field.errors %} invalid{% endif %}">
                                <label for="{{ field.id_for_label }}">{{ field.label }}</label>
                                {% render_field field class="form-control" placeholder=field.label %}
                                {% for error in field.errors %}
                                    <p class="help-block">{{ error }}</p>
                                {% endfor %}
                            </div>
                        {% endif %}
                    {% endfor %}
                    {% for field in form %}
                        {% if field.name in ',address' %}
                            <div class="form-group col-md-12 {% if field.errors %} invalid{% endif %}">
                                <label for="{{ field.id_for_label }}">{{ field.label }}</label>
                                {% render_field field class="form-control" rows="5" placeholder=field.label %}
                                {% for error in field.errors %}
                                    <p class="help-block">{{ error }}</p>
                                {% endfor %}
                            </div>
                        {% endif %}
                    {% endfor %}
                </div>
                <div class="form-group justify-content-start">
                    <button type="submit" class="btn-primary py-1">UPDATE DETAILS</button>
                    <button type="reset" class="border-primary text-primary px-3 py-1" rel="modal:close">CANCEL</button>
                </div>
            </div>
        </form>
    </div>
{%endblock%}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

{% load widget_tweaks %}

{% load static %}

{% block content%}

<script>

$(document).ready(function() {

var logo = document.getElementById('nav_logo')

var img = document.getElementById("comp_logo").getAttribute("src")

logo.src = img;

});

</script>

<div class="modal fade" tabindex="-1" role="dialog" id="modal" style="z-index: 50px">

<div class="modal-dialog modal-dialog-centered" role="document">

<div class="modal-content"></div>

</div>

</div>

<div class="container">

<form method="post" enctype="multipart/form-data" action="{% url 'edit_company' 1 %}">

{% csrf_token %}

<div class="modal-header my-0">

<h5 class="modal-title">UPDATE COMPANY DETAILS</h5>

</div>

<div class="modal-body my-0">

<div class="{% if form.non_field_errors %}invalid{% endif %} mb-2">

{% for error in form.non_field_errors %}

{{ error }}

{% endfor %}

</div>

<img id="comp_logo" src="{{ company.logo.url }}" width="30" height="30" class="d-inline-block align-top" alt=""> <br /><br />

<div class="form-row">

{% for field in form %}

{% if field.name in ',logo' %}

<div class="form-group col-md-12 {% if field.errors %} invalid{% endif %}">

<label for="{{ field.id_for_label }}">{{ field.label }}</label>

{% render_field field class="form-control" rows="5" placeholder=field.label %}

{% for error in field.errors %}

<p class="help-block">{{ error }}</p>

{% endfor %}

</div>

{% endif %}

{% endfor %}

{% for field in form %}

{% if field.name not in 'logo,address,created_by' %}

<div class="form-group col-md-6 {% if field.errors %} invalid{% endif %}">

<label for="{{ field.id_for_label }}">{{ field.label }}</label>

{% render_field field class="form-control" placeholder=field.label %}

{% for error in field.errors %}

<p class="help-block">{{ error }}</p>

{% endfor %}

</div>

{% endif %}

{% endfor %}

{% for field in form %}

{% if field.name in ',address' %}

<div class="form-group col-md-12 {% if field.errors %} invalid{% endif %}">

<label for="{{ field.id_for_label }}">{{ field.label }}</label>

{% render_field field class="form-control" rows="5" placeholder=field.label %}

{% for error in field.errors %}

<p class="help-block">{{ error }}</p>

{% endfor %}

</div>

{% endif %}

{% endfor %}

</div>

<div class="form-group justify-content-start">

<button type="submit" class="btn-primary py-1">UPDATE DETAILS</button>

<button type="reset" class="border-primary text-primary px-3 py-1" rel="modal:close">CANCEL</button>

</div>

</div>

</form>

</div>

{%endblock%}

Create template for the add expenses form in Supermarket Management System in Django.

In this section, we will learn on how create a templates for the add expenses form. To start with, add the following code in your add_expense.html under the folder of /templates/.

{% load widget_tweaks %}

{% block content%}
    <script type="text/javascript">
        $(document).ready(function () {
            selected = $("select option:selected").val();
            if (selected == ""){
                $("select option:selected").remove();
            }
            $("select").editableSelect();
        });
    </script>
    <div class="modal fade" tabindex="-1" role="dialog" id="modal" style="z-index: 50px">
        <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content"></div>
        </div>
    </div>
    <div class="container">
        <form method="post" action="{% url 'expense' %}">
        {% csrf_token %}
            <div class="modal-header my-0">
                <h5 class="modal-title">ADD INCURRED EXPENSES</h5>
            </div>
            <div class="modal-body my-0">
                <div class="{% if form.non_field_errors %}invalid{% endif %} mb-2">
                    {% for error in form.non_field_errors %}
                        {{ error }}
                    {% endfor %}
                </div>
                <div class="form-row">
                    {% for field in form %}
                        {% if field.name not in 'description,created_by' %}
                            <div class="form-group col-md-6 {% if field.errors %} invalid{% endif %}">
                                <label for="{{ field.id_for_label }}">{{ field.label }}</label>
                                {% render_field field class="form-control" placeholder=field.label %}
                                {% for error in field.errors %}
                                    <p class="help-block">{{ error }}</p>
                                {% endfor %}
                            </div>
                        {% endif %}
                    {% endfor %}
                    {% for field in form %}
                        {% if field.name in ',description' %}
                            <div class="form-group col-md-12 {% if field.errors %} invalid{% endif %}">
                                <label for="{{ field.id_for_label }}">{{ field.label }}</label>
                                {% render_field field class="form-control" rows="5" placeholder=field.label %}
                                {% for error in field.errors %}
                                    <p class="help-block">{{ error }}</p>
                                {% endfor %}
                            </div>
                        {% endif %}
                    {% endfor %}
                </div>
                <div class="form-group justify-content-start">
                    <button type="submit" class="btn-primary py-1"><i class="fa fa-money mr-1"></i>ADD EXPENSE</button>
                    <button type="reset" class="border-primary text-primary px-3 py-1" rel="modal:close">CANCEL</button>
                </div>
            </div>
        </form>
    </div>
    <div class="container" >
        <div class="row text-muted border-bottom border-top py-2 mb-2 font-weight-bold">
            <div class="col-3 pl-3">Category</div>
            <div class="col-4 pl-0">Description</div>
            <div class="col-2 pl-3">Amount</div>
            <div class="col-3 pl-3">Action</div>
        </div>
    </div>
    {% for expense in expenses %}
        <div class="container" >
            <div class="row highlight bg-light mb-2 py-2">
                <div class="col-3 pl-3">{{ expense.category }}</div>
                <div class="col-4 pl-0">{{ expense.description }}</div>
                <div class="col-2 pl-3">{{ expense.amount }}</div>
                <div class="col-3 pl-3">
                    <a class="btn btn-sm"
                        title="Edit Expense"
                        href="{% url 'edit_expense' expense.id %}"
                        rel="modal:open"><i class="fa fa-edit mr-1"></i>Edit</a>
                    <a class="btn btn-sm text-danger"
                        title="Delete Expense"
                        href="{% url 'delete_expense' expense.id %}"
                        rel="modal:open"><i class="fa fa-trash mr-1"></i>Delete</a></div>
            </div>
        </div>
    {% endfor %}
    {% if not total_expenses.amount__sum is None  %}
        <div class="container mb-5">
            <div class="row text-muted border-bottom border-top pt-2 mb-2 font-weight-bold">
                <div class="col-7 pl-3">Grand Total</div>
                <div class="col-5 pl-3">{{ total_expenses.amount__sum }}</div>
            </div>
        </div>
    {% endif %}
{%endblock%}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

{% load widget_tweaks %}

{% block content%}

<script type="text/javascript">

$(document).ready(function () {

selected = $("select option:selected").val();

if (selected == ""){

$("select option:selected").remove();

}

$("select").editableSelect();

});

</script>

<div class="modal fade" tabindex="-1" role="dialog" id="modal" style="z-index: 50px">

<div class="modal-dialog modal-dialog-centered" role="document">

<div class="modal-content"></div>

</div>

</div>

<div class="container">

<form method="post" action="{% url 'expense' %}">

{% csrf_token %}

<div class="modal-header my-0">

<h5 class="modal-title">ADD INCURRED EXPENSES</h5>

</div>

<div class="modal-body my-0">

<div class="{% if form.non_field_errors %}invalid{% endif %} mb-2">

{% for error in form.non_field_errors %}

{{ error }}

{% endfor %}

</div>

<div class="form-row">

{% for field in form %}

{% if field.name not in 'description,created_by' %}

<div class="form-group col-md-6 {% if field.errors %} invalid{% endif %}">

<label for="{{ field.id_for_label }}">{{ field.label }}</label>

{% render_field field class="form-control" placeholder=field.label %}

{% for error in field.errors %}

<p class="help-block">{{ error }}</p>

{% endfor %}

</div>

{% endif %}

{% endfor %}

{% for field in form %}

{% if field.name in ',description' %}

<div class="form-group col-md-12 {% if field.errors %} invalid{% endif %}">

<label for="{{ field.id_for_label }}">{{ field.label }}</label>

{% render_field field class="form-control" rows="5" placeholder=field.label %}

{% for error in field.errors %}

<p class="help-block">{{ error }}</p>

{% endfor %}

</div>

{% endif %}

{% endfor %}

</div>

<div class="form-group justify-content-start">

<button type="submit" class="btn-primary py-1"><i class="fa fa-money mr-1"></i>ADD EXPENSE</button>

<button type="reset" class="border-primary text-primary px-3 py-1" rel="modal:close">CANCEL</button>

</div>

</div>

</form>

</div>

<div class="container" >

<div class="row text-muted border-bottom border-top py-2 mb-2 font-weight-bold">

<div class="col-3 pl-3">Category</div>

<div class="col-4 pl-0">Description</div>

<div class="col-2 pl-3">Amount</div>

<div class="col-3 pl-3">Action</div>

</div>

</div>

{% for expense in expenses %}

<div class="container" >

<div class="row highlight bg-light mb-2 py-2">

<div class="col-3 pl-3">{{ expense.category }}</div>

<div class="col-4 pl-0">{{ expense.description }}</div>

<div class="col-2 pl-3">{{ expense.amount }}</div>

<div class="col-3 pl-3">

<a class="btn btn-sm"

title="Edit Expense"

href="{% url 'edit_expense' expense.id %}"

rel="modal:open"><i class="fa fa-edit mr-1"></i>Edit</a>

<a class="btn btn-sm text-danger"

title="Delete Expense"

href="{% url 'delete_expense' expense.id %}"

rel="modal:open"><i class="fa fa-trash mr-1"></i>Delete</a></div>

</div>

</div>

{% endfor %}

{% if not total_expenses.amount__sum is None %}

<div class="container mb-5">

<div class="row text-muted border-bottom border-top pt-2 mb-2 font-weight-bold">

<div class="col-7 pl-3">Grand Total</div>

<div class="col-5 pl-3">{{ total_expenses.amount__sum }}</div>

</div>

</div>

{% endif %}

{%endblock%}

Create template for the add purchase form in Supermarket Management System in Django.

In this section, we will learn on how create a templates for the add purchase form. To start with, add the following code in your add_purchase.html under the folder of /templates/.

{% load widget_tweaks %}

{% block content%}
    <form method="post" action="{% url 'purchase' %}">
    {% csrf_token %}
        <div class="modal-header my-0">
            <h5 class="modal-title text-primary">ADD NEW PURCHASE</h5>
        </div>

        <div class="modal-body my-0">
            <div class="{% if form.non_field_errors %}invalid{% endif %} mb-2">
                {% for error in form.non_field_errors %}
                    {{ error }}
                {% endfor %}
            </div>

            {% for field in form %}
                <div class="form-group">
                    {% if field.name not in 'total_stock_level,created_by' %}
                        {% if field.name in ',description' %}
                            <label for="{{ field.id_for_label }}">{{ field.label }}</label>
                            {% render_field field class="form-control" rows="5" placeholder=field.label %}
                            <div class="{% if field.errors %} invalid{% endif %}">
                                {% for error in field.errors %}
                                    <p class="help-block">{{ error }}</p>
                                {% endfor %}
                            </div>
                        {% else %}
                            <label for="{{ field.id_for_label }}">{{ field.label }}</label>
                            {% render_field field class="form-control" placeholder=field.label %}
                            <div class="{% if field.errors %} invalid{% endif %}">
                                {% for error in field.errors %}
                                    <p class="help-block">{{ error }}</p>
                                {% endfor %}
                            </div>
                        {% endif %}
                    {% endif %}
                </div>
            {% endfor %}
        </div>

        <div class="modal-footer form-group justify-content-start">
            <button type="submit" class="btn-primary py-1">ADD NEW PURCHASE</button>
            <a href="#close" type="reset" class="btn border border-primary text-primary px-3 py-1" rel="modal:close">CANCEL</a>
        </div>
    </form>
{%endblock%}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

{% load widget_tweaks %}

{% block content%}

<form method="post" action="{% url 'purchase' %}">

{% csrf_token %}

<div class="modal-header my-0">

<h5 class="modal-title text-primary">ADD NEW PURCHASE</h5>

</div>

<div class="modal-body my-0">

<div class="{% if form.non_field_errors %}invalid{% endif %} mb-2">

{% for error in form.non_field_errors %}

{{ error }}

{% endfor %}

</div>

{% for field in form %}

<div class="form-group">

{% if field.name not in 'total_stock_level,created_by' %}

{% if field.name in ',description' %}

<label for="{{ field.id_for_label }}">{{ field.label }}</label>

{% render_field field class="form-control" rows="5" placeholder=field.label %}

<div class="{% if field.errors %} invalid{% endif %}">

{% for error in field.errors %}

<p class="help-block">{{ error }}</p>

{% endfor %}

</div>

{% else %}

<label for="{{ field.id_for_label }}">{{ field.label }}</label>

{% render_field field class="form-control" placeholder=field.label %}

<div class="{% if field.errors %} invalid{% endif %}">

{% for error in field.errors %}

<p class="help-block">{{ error }}</p>

{% endfor %}

</div>

{% endif %}

{% endif %}

</div>

{% endfor %}

</div>

<div class="modal-footer form-group justify-content-start">

<button type="submit" class="btn-primary py-1">ADD NEW PURCHASE</button>

<a href="#close" type="reset" class="btn border border-primary text-primary px-3 py-1" rel="modal:close">CANCEL</a>

</div>

</form>

{%endblock%}

Run Quick Virus Scan for secure Download

Run Quick Scan for safe Download

Downloadable Source Code Below.

Anyway, if you want to level up your programming knowledge, especially python, try this new article I’ve made for you Best Python Projects with source code for Beginners. But If you’re going to focus on web development using Django, you can download here from our list of Best Django Projects with source code based on real-world projects.

How To Run The Supermarket Management System in Django?

Step 1: Extract/unzip the file
Step 2: Go inside the project folder, open cmd and type the following commands to install Django Framework and run the webserver:
pip install -r requirements.txt
python manage.py migrate
python manage.py runserver
Step 3: Finally, open the browser and go to http://127.0.0.1:8000/

Summary

In summary, this 2021 Supermarket Management System in Django with Source Code can be useful to students or professional who wants to learn python programming language. This project can also be modified to fit your personal requirements. Hope this project will help you to improve your skills. Happy Coding!

Inquiries

If you have any questions or suggestions about Supermarket Management System in Django with Source Code, please feel free to leave a comment below.

1 thought on “Supermarket Management System Project in Django with Source Code”

shahid

July 3, 2021 at 5:29 pm

django.db.utils.OperationalError: (1045, “Access denied for user ‘root’@’localhost’ (using password: NO)”)

i am having this error after runserver pls help
Reply

Leave a Comment Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.