e commerce

  This is the template that I used before I changed it around to fit my ideal website. This is my website after I changed the template around. I used wix to get my template. After acquiring the template I removed the parts that I would not use. This included the newsletter , shop by categories  and brands. After this I had to change all of the pictures used to fit my website and since I chose a pc selling company , i replaced the images with pcs and pc parts. I then removed the heading unwanted pages. Then I went into the footer and using Wixs  available icons , there were social media platforms , so they were then added into the footer so they could be used by potential customers. I then added one more vector image  mentioning returns and i also changed one of the previous ones into a truck showing that we deliver all over Europe.

  IYZ E-Commerce Computing Blog Checklist Student name: Sylwia Jabłońska   Blog criteria Completed? Blog has been customised to reflect Computing/Technology.   Has a minimum of 10 posts. completed Number of Posts: 30 Welcome Post: A short introduction to who you are as a student, your interests, your current IT/Computing skills and your chosen Degree destination. Not completed Class and Homework Tasks: Definition of e-commerce with reference. completed Class and Homework Tasks: Definitions of programming languages; Python, Ruby, HTML, JavaScript and CSS with references. completed Class and Homework Tasks: Research on the inventors of the WWW and E-Commerce with references and commentary. completed Class and Homework Tasks: Essential features of an e-commerce website and the advantages/disadvantages of e

  The 1st image is now my contact page the 2nd  was the template I used to improve it upon. First thing I did was remove the opening dates as it served me no purpose since my business is an ecommerce store. I then added on my own links to social media apps through the Wixs app such as  Instagram Facebook twitter and a few more. It allows customers to access those medias where my promotional accounts are. I also removed the newsletter from the site as I do not need it. Lastly I added a button using Wixs app which re directs the page to my about us page,

 

 My business P&C will contain different pc parts below this message you will see the excel sheet containing my products. All of these products are available to order at my website under market value. As you can see we can provide a wide range of graphics card from NVIDIA ranging from the old 1050 series , to the newer 30series.

 

 In this blog there will be a comparison of two different websites product page. Curry's Product page is filtered by costs ranging from six different options, £0-40,£40-60,£60-100,£100-500,£500-999 and lastly over £1000.They also have an option to hide out of stock items. Also they also let you sort the page by brands, which is really nice touch as it allows people to easily navigate what exact item they want. In the middle of the screen you can see deals on items which may entice customers to buy them.There is another option to change the way you view products you can interchange between list and grid.The first thing you see is that they have upto 30% deals in over 100s of products, this catches the eye of a customer which may make them click onto it and buy it. Novatech does not have a list of every item you can purchase unlike Curry's, which this may dissuade customers. They do though have two advertisements one of  for intel processor and then for msi.This is good as it mak

  What is the definition of a database management system? The definition  for database management system is a computer manipulated data system that keeps track of users data , in an organised manner. Benefits of using a database management system? Simple to use Secured Data Less mix up since its simple Faster access to your data since its all in one organised place Easier to recover data due to it being in the same spot Here are some examples of  Data base management systems; SQL server , Microsoft Access , Clipper , dBase , Filemaker. There are many more dbs systems available to use as well. All these database systems are compatible with  each other. Reference list Ibm.com. 2022.  IBM Docs . [online] Available at: <https://www.ibm.com/docs/en/zos-basic-skills?topic=zos-what-is-database-management-system> [Accessed 9 April 2022]. ShineLearning. 2022.  What Are the Advantages of Database Management System?- Talent Economy . [online] Available at: <https://learning.shine.com/tal

  Entity relationship diagram are a type of  flowchart that show how different data impact each other. Entities are definable things in the diagram such as a person  or an item or even an event. typically shown as rectangles Relationship is how the entities interact with each other in the entity relationship diagram typically are shown as diamonds Attributes - are characteristics of a entity typically shown as a circle. Cardinality- is the numerical value used to  show the relationship in-between  two values. What are the benefits of Entity relationship diagrams? Simple to use visually descriptive- easy to process information in diagrams flexible Reference list Lucidchart. 2022.  What is an Entity Relationship Diagram (ERD)? . [online] Available at: <https://www.lucidchart.com/pages/er-diagrams#:~:text=An%20Entity%20Relationship%20(ER)%20Diagram,each%20other%20within%20a%20system.&text=They%20mirror%20grammatical%20structure%2C%20with,nouns%20and%20relationships%20as%20verbs.>

 Entity Relationship diagram design

 Analyse and compare two different FAQ pages For Curry's there are only 3 frequently asked questions, update on their order , how to link a store and online account and lastly how to claim your cashback. There should be more frequently asked questions as it is unlikely that a huge company only gets mostly 3 questions asked. Amazon has a lot more questions compared to Curry's it has a few more further down the FAQ page. They present the details of the answer straight away which in Curry's you need to press once. The first 4 Amazons FAQ are : what amazon is?, what does the sales rank mean , how do i find sales information for my title and lastly How do i promote my titles at Amazon. These questions are mostly technical and provide better experience for customers at Amazon, which Curry's failed to show with their basic questions. My FAQ My order updates,  this will show customers where their package is currently at, this will make them trust my company more as it will have

(4P’s of Marketing, 2022) This blog will be talking about the 4ps of marketing mix and how they will  be integrated into my websites business furthermore we will show one example of each P that a competitor has used. Place - where is your business selling your product at. Price - The price of your product. Promotion - How will you promote your business. Product - What products your business will be selling.  My business place is online as it is a ecommerce business , the price of my business will be under the market price , the way we will promote our business will be ads or even YouTube videos , the product that I am offering is Pcs and its computer components. Price Curry's  will change how much their product cost based on customer feedback, if the customer finds a competitor selling the same item at a lower price  they then copy that price onto their website. This way they will still get sales. Place To access Curry's products all you need to do is go and type this link into

 

In this post two different websites About us pages will be compared and analysed. The two websites that I chose are Curry's and Novatech. It mentions how Curry's is a part of Curry's Business , it also mentions how it is the "leading  specialist and telecommunications retailer and service provider". Furthermore they mention that they can provide you the customer advice on the right technology product that you want to purchase from them. Lastly it mentions that if you have any inquires you can message their support staff. In Novatechs About us page  they contain a video which explains their story. They later mention that  they provide from desktop pcs to gaming pcs , creative workstations , enterprise scale servers and lastly even specialised hardware for the  Royal Navy. Mentions also how they are the most trusted  technology providers.They also mention how they have 16000 five star reviews on Trustpilot. Lastly they mention that they have a sub company called  Re

  Currys has a distinct logo on the top left of the screen , which you cant miss if your viewing the site. It also shows you that you can get free delivery on your purchases which could entice new customers due to paying less . If you cant afford the item straight away , you can pay monthly . Which allows people to buy things that they couldn't before. It also allows you to order some items now and then collect them at store if you want too. It also allows you to see which store is the closest one too you. The body consists of items that you can buy which also contains some sort of deal to pay less for the item trying to entice someone to buy it. The footer contains good information on its services , as it shows  that you can see the delivery of your items , you can order online and then collect your items in the store if that is what you want and it also shows that you can get your damaged goods get repaired as well it also mentions on how you can get returns of your items . Also

 Order form using Excel In this blog I will be demonstrating in steps on how to create an order form by the use of excel. The first step is highlighting your product list and then naming it in the e5 box, you should name it as ProductList. The second step will be making your Product look up , you will highlight and then name  your entire table , this way if you ever need to get information from it , you only need to write its name.You should name it ProductLookUp. In the next step you will need to add  a new sheet on the same excel document and that is where you will be  writing down your product number , product name , price , quantity and total into different cells.  You will then need to highlight however many cells you want underneath your product number, then you will press data validation furthermore you will need to  press on the allow box and change it from any value too list. Furthermore a new box will appear which you will need to type in =ProductList Your next step is to wri