Asfand Yar E-Commerce Blog

 I have shown below, the development and payment of the payment system on the website.  The shopping cart appears once the customer adds the products.  Clicking on the view cart button brings the customer to the cart page, where below information is visible to the customer.  After this page, customer can click on the checkout button to go ahead with the purchase. 

I set up my excel database for my products and have chosen Product name/product numbers and took the prices off the website. The other columns are unit prices, units sold and sales.  I formatted my table to give  column headings, and made them bold, and added colours to clearly mark the columns from each other. The units price and items sold are added to give me data to work with for charts and formulas. I have also added the filter function on all the columns. I pulled down the formula from first cell to apply it on the rest of the table. I also added the SUM function to my table to get the total number of sales, units and price. I also added the pie chart by selecting the data in the table and inserting the 2d pie chart. I changed the headings of the pie chart to show the total sales and the list of products underneath the pie chart. I could not get the figures to display the percentage on the chart so i had to modify it by changing the theme.  Below is the final view...

I am making the customer database in excel. I have added columns like First name, Last name, Address, Country, Email etc I have selected the whole table and added the colours to the rows and also added the filter option in the table so it can be easier to search my customers from the database.

 I have made the following changes to the website: I have changed the homepage by replacing the cover photo with a new picture. I have also removed the favorites videos and replaced them with the pictures and removed the gallery section from the website.  I made changes to the footer as well by removing the personal contact information and added more information on the favorite products on the homepage.  Below is the screenshot of the About Us page after adding two new pictures and commentary that explains what the story is for the business and its handmade products. The contact form has been changed and all the personal information was removed. I have also edited the shipping and returns policy page and added the commentary to suit the business and customers.

 I researched some competitors websites such as Kasu and The Handmade Soap company. upon my research i made my own about us story saying  I am a young entrepreneur starting my own business. i am passionate about the essential oils and scents hence bringing it together in the products. All the products are handmade.

 I made following changes to the homepage of my website: Changed the name on the template and theme and all the colours Added the options of buying the product i.e Soaps and Candles Added different photos on the homepage showing different products and make it more aesthetic  Included the contact us button on the bottom of the page to make it easier for the customer to find the contact information.  Following changes were made to the Contact us page: Included the owner name, telephone number and an email address for the website. Linked a contact form on the page so that customers can fill in the details and send the queries to the owner Added links to all the pages in the bottom and sign up to newsletter field.