top of page

Order Summary System

Introduction

Introduction

An e-commerce company thought that manual sorting of the order data on its web page was time-consuming and laborious, so it needed me to create a system that could automatically sort, process and form the data

Solution

Solution

I merged the data of different modules into one table through python (python programming implementation of SQL function)

Original Data
image.png
image.png

I calculated the total amount based on the products purchased in each order and their quantity, the corresponding state tax, and the discount rate corresponding to the promote code, and output it in a table.

image.png

I summarized the data of all orders in this month to generate a Monthly Revenue Summary Table for the convenience of subsequent data management.

image.png

Feature Highlight

Feature Highlight
Accurate algorithm

  • Create the “product” and “order” class to define attributes and methods for the products and orders in the e-commerce website.

  • Create a “createorder” function which converts order data into an order object (including its aggregate product objects).

  • Using the “createorder” function to load order from the data

  • Visualize the data

Pratical Significance

Pratical Significance

​The system can automatically calculate the amount of each order and the company's monthly transaction amount, which can save the cost caused by manual input and improve the company's operating efficiency

Learning Outcomes & Reflection

Learning Outcomes & Reflection

This case shows my proficiency in the use of Python’s objects and functions, and demonstrates my problem-solving preciseness by coming up with accurate algorithms.

bottom of page