Product Database

-

 In this post I would like to show my product database.

 
Product database (Author's work)

This database contains product number, product name, quantity in stock, unit price (how much it cost for my company), sale price (how much customer has to pay), sold units etc. as showed above.

To calculate total sales, total costs and profit I used an Excel formulas.

Excel formulas (Author's work)

I also created 3 charts, which are showing total amount of sold units, total income and profit.

Total amount of sold units (Author's work)

Total income chart (Author's work)

Profit chart (Author's work)



Comments

Post a Comment

Popular posts from this blog

Wireframe

-
Image
In this post I want to show initial design of my e-commerce webside homepage, which includes the header, body and footer. To create this initial project I have used Mockflow software. Author's work As we can see in the image, the webpage is divided into header, body and footer. The header contains logo, categories of products, search bar, login button, sign up button, cart and wishlist. Below the header, I want to set the banner with information about my e-commerce business, piece of history and slogan. In the body, I want to include only the pictures of products. I believe that the clear structure of the body will be helpful for my customers. Footer contains hyperlinks to all necessary information such as terms and conditions, FAQ and contact page. Moreover, I want to include hyperlinks to social media profiles of my company.
Read more

SEO

-
SEO (Search Engine Optimization) is a range of techniques, which are helping to improve the quality and quantity of traffic on the website.  SEO is mostly used for commercial purposes, to position the website on the first page of the search engine without using paid advertisements, to increase earnings on this website.
Read more

Website security

-
Image
Why encryption is using in case of online transaction? Encryption is translating the data to different form than it is in reality, and make it possible to read only for people, which have a secret key (Lord, 2020). According to Elefant (2011) it is important to encrypt the data in case of online payments, because it makes this data almost imposible to read in terms of any attacks for example "man-in-the-middle" attack. Security of my website. My website is secure by SSL (Secure Socket Layers) technology provided by Wix. It means, all of the data exchanged between the server and customer will be encrypted, which makes even in case of attack, hackers will be not able to decrypt the data. Part of SSL certificate of my website (Author's work)   My payments will be secured as well. Module provided by Wix, which contains the payments, contains addictional SSL Certificate as well. Moreover, using the HTTPS domain makes, the security of the payments is improved as well. Checkout ...
Read more