Asfand Yar E-Commerce Blog

 I have added FAQ section on my website so it can help the customers with most important questions.  I did my research on different competitors websites such as The Handmade Soap Company, All Natural Soap etc and came up with below questions and adjusted the answers to suit my business. Below are a few examples of my research ideas: Below are the Frequently Asked Questions on the website I have:

 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.