Sergio's E-Commerce Blog

  References: (No date) Amazon.co.uk . Available at: https://www.amazon.co.uk/?&tag=hydraamazonav-21&ref=pd_sl_781ozcfkw8_e&adgrpid=52740778523&hvpone=&hvptwo=&hvadid=606225024905&hvpos=&hvnetw=g&hvrand=16392265490137281637&hvqmt=e&hvdev=c&hvdvcmdl=&hvlocint=&hvlocphy=9046182&hvtargid=kwd-10573980&hydadcr=13724_2323348 (Accessed: 07 September 2023). Canon UK (no date) About Us , Canon UK . Available at: https://www.canon.co.uk/about_us/ (Accessed: 07 September 2023).

 Definition  "A database is an organized collection of structured information, or data, tipycally stored electronically in a computer system. A database is usually controlled by a database managment system also called DBMS. Together the data and the DMBS alonf with the applicacions associated with them are referred to as a data system often shortened to just data base" acording to (Oracle, 2022) A very typical used modeled in rows and columns which make a table this is used to make the process of data and querying much efficient, the data can be managed and organized, most of this databases are structured on query language SQL for writing information. source:  https://www.freepik.com/free-vector/server-room-cloud-storage-icon-datacenter-database-concept-data-exchange-process_3628676. Differences between a spreadsheet and a database How the information is stored who can access the information  and how much of the data can be stored Databases are desing to store a much...

 What is ERD Entity relationship diagram also refer as ERD, ER model or diagram is a type of diagram based on database desing, ERD contains different symbols and connectors that visualize two important information; the major entities within the system scope and the inter-relationship among these entities. But what is an entity? we often refer to this as people for example students which is a tangible object, and tangible business objects eg product, relationship is about how these entities relate each other within the system. source: https://www.freepik.com/free-vector/cloud-services-isometric-composition-with-characters-working-people-cabinet-with-folders-server-capsule-vector-illustration_23128898. An ER diagram have entities, attributes and relationshops and we will explain each of these symbols; Entity Atributtes  has a name that describe the type and king of an attribute such as varchar for a string and int for integer, when a ERD is draw it is important to ensure the use...

 Definition  "SDLC stands for software development life cycle, it is a process that enables the production of high quality low cost software, the main goal of SDLC is to produce superior software that meets and exceeds the costumer needs and demand, the SDLC outline detail sections with different stages or  called phases. SDLC enhance the development speed and minimizes project risks and costs associated with methors of production" According to (synopsys, 2018) source:( https://www.freepik.com/free-vector/new-app-development-desktop_10276612) Why is so important? makes the project much easier to track the speed of the development is quicker  make better relation with the client  decrease the project failures  decreasing of cost production  provides a standar framework that define the activities  improve the visibility of the life cycle source:( https://www.freepik.com/free-vector/engineer-developer-with-laptop-tablet-code-cross-platform-developmen...

  I have create a costumer database to provide a visibility over the costumers that buy the products or any services that the company provides.  First step is to assing an specific ID number that will never change and not two same persons could have it therefore every costumer on the Database will be located.

 

 I created a product chart with the product id, product name, unit price, sale price, stock quantity, stock sold, total cost and total sale. whit this information from my website products i have been able to see the total profit my products will make. For the calculation i used different formulas such as SUM and MIN.

author's work author's work   

On this blog topic i will show and compare the different product pages from different website examples such as eBay, Amazon and Sony which are well know for their products and sells. eBay: What i can notice firstly is that they offer a total of 10% of discount if you purchase two headsets from them, which is nice because the price is already affordable, the description of the product is nice is not too short or too long for the consumers, most of the people will not even read the full title of the product because is unnesessary, what i do not see first is the brief description of the product. It is self explanatory but having a description could define is worth buying the product next we have the images, are on good quality and does not interfer with the purchase, to be honest they provide quite a lot of them that is a point for this website, next is the rating and stars that help us to view how many people have tried and if it is worth to pay for the total price. source:( https://www....

 The four Ps were introduced in 1950's and they become a mix combine of four elements the product, price, place and promotion this are used in marketing for any product serviced, this are essential to have and target an audience, they gather a number of factors that are consider when promoting a new or an old product, including what the costumers want, what they are looking for and if the product will meet the expectations. Therefore there exist another marketing mixes however the four Ps are a foundation to create a sucessful marketing plan, on this topic i will explain more about this process of each of them and which of them are really important for an eCommerce website (investopedia, 2023). source:( https://www.edrawmind.com/templates/4-ps-of-marketing-template.html) Here Are the 4 Ps of Marketing  1. Product Frist we focused on the porpuse of the product it self, whether who need it and why?, this are also called the qualities of the product and it is the mission of the m...

Alt Tags The main porpuse of an Alt Tag is to ensure that all the images have an specific altenative name, this means that if you add an image of an hamburguer you should also mention that is an hamburguer on the alt tag this wil ease the screen readers for people with no sight, Alt tags solve this problem providing a better text for each picture readed also by the search engine. Search engines emphasie on the content of the alt tags for this reason should be represented as high value. Google and different search engines will index the picture along with the content on the page therefore the image will help to raise the relevance of the page, however the alt tag also impact whether and how the picture shows on Google's search vertical (goup, 2020) Source:( https://www.freepik.com/free-vector/hand-drawn-flat-design-metaverse-illustration_22379260.) Title Tags  This tag is the most important one without hesitation, this is because is the central element for search engine optimization...

 As you can see here i add a "Contact Us section" on the bottom of the webpage and will be more accesible to our costumers, an then i add a small text explaining the importance of our costumers and that they will be assisted by a professional team on any technical need, i also add a picture that illustrate a team working which is how i would like it to be on a real scenario, next adding was the Companies email and a telephone number so the costumer will either call or just send an email to us. There is also a substitution in any case the costumer is on a hurry he would have to option to do a "Let's chat" which is a 24 hour chat with one of our members that will be delighted to answer all the doubts. Author's work

Changing the model for the phone users was the las thing i did to ensure people who have smaller devices will be able to use the website without any problem, i had to change the font size and make the logos a bit more smaller which ensure that people will have all the functions without any problem, i also make the picture more smaller but able to full the length of the screen, adding a little arrow on the bottom corner to allow users to be on the homepage again.  Author's work On the other hand i manage to add a profile section where all the users can manage their accounts with different sections such as changing the name of the user, deleting account or privacy settings and changing the profile picture. Author's work I add the option to make two types of payment such as paying with paypal and also with the browser it self, can give people different options when paying for a product or service. I also ensure that if there is more than two products the price will double. Author...

 Netrun will be using the model of Bussiness to Consumer (B2C) which means that is the process of selling products and services direct between the a business and a consumer as their name refer who are the users of the product and services, most of the companies out there sell directly to consumers can be referred as B2C. I would like to show different exampes of B2C companies that shows how we want to Netrun look like. source:( https://www.amazon.co.uk source:( https://www.ebay.co.uk/ source:( https://www.apple.com/uk/store source:( https://www.sony.co.uk/store source:( https://www.canon.co.uk/ Which one was nice and why not? As it is shown i choose five different websites that can work with the model of Bussiness to consumer which means that we as a bussiness will provide directly to the consumer all ther services they will ask for, my favorite ones were Amazon because it goes with the hand that i want to have different prices and more accesible to the public that rule follow amaz...

Technology and It support Netrun The main idea of my website is to sell products like technology such as laptops, headsets, chargers, cameras and lenses, the name of the brand would be "Netrun" a brand which you can trust no matter on which part of the country you are wheter you are next to a town or even accross the ocean, and technology is apread all over the globe the one thing that would make this company special is that we want to offer discounts every week, and not by every season.  This could be a trouble in the future because who does that, well with Netrun everything is important. The key idea is to work with different brands such as Apple, Canon and Sony which each of them are the leaders on the market, for example Apple is really good quality built but expensive which makes sometimes difficult to have one of their products unless you could afford it. Then you have Canon which as we know is a leader on cameras and lenses great change to attract future photographers ...

Basically meta tags are snippets that describe a page content, the meta tags usually do not appear on the page itself  but only on the source of this web page. "Meta tags are essentially little content descriptions that it can help tell SEO (Search Engine Optimization) what a web page is about" (Localiq, 2018). The benefitial part of meta tags are that these are designed to help the SEO, the downside is that it can not work all the time, the search engine ranks the different meta tags which are four types of meta tags that is worth knowing and it can increase the traffic by letting Google know what can they provide. I will explain the different types. The next four types are: Meta Keyword Attribute Title Tag Meta Description  Meta Robots Attribute  Meta Keyword Attribute  Does not make so much sense to use it these days, years ago using meta data keywords may have been beneficial but not anymore, Keyword stuffing is a term used to refer the action of adding unrelated...