My E-Commerce Blog

Database Database is a collection of structured information or data stored in electronical devices usually managed by Database Management System (DBMS). It is commonly used by displaying rows and columns of tables. The data structured inside would then be easily accessed, controlled, managed and modified. For example: emails, phonebooks and newspapers (Oracle, 2023).  Advantages of Using Database More organized and structured data Data errors can be checked so it is more accurate and reliable Prevents incorrect information being stored Easier to backup and recover data Increased security that reduces chances of mistakes in the data Protected by passwords and encrypted that denies unauthorized access Information can be retrieved faster East to use and learn Can be shared easily to everyone reduces amount of disk space and avoids multiple copies of the same data Easy to recover loss data (Williams, 2022) References Oracle (2023)  What Is a Database? Available at: https://ww...

 Product Page The displayed product in my product page above is a pencil case. The product ID is displayed below it as well as the price, quantity and "Add to Cart". Beside the photo of the product, on the right, the product information is displayed as well as a brief description explaining what the product is about.

4Ps of Marketing Strategies Marketing is a process of buying, selling, delivering and exchanging of products between businesses, and customers (American Marketing Association, 2022). Product It is basically the products of what your company sells to the customers which could be online or offline. It is promoted through the other 3Ps of marketing strategies. For example: Apple selling smartphones (American Marketing Association, 2022). Price It is the amount of value you charge the customers for buying your products. Depending on the fairness of the prices, you could either get a profit or none at all (American Marketing Association, 2022). Place This is the location of where you should sell your products and how it is delivered to the market. It could either be a place is real life or online (American Marketing Association, 2022). Promotion This includes advertising and promoting your products to the customers, showing them why they should spend their money on it and how it is useful t...

SEO SEO stands for Search Engine Optimization. Its purpose is to increase the rankings of ones own website in search engines such as Google. It also increases online traffic in organic search engines. It uses crawlers  which are bots used to gather information on the internet linking one web page to another (Ellis, 2023). References Ellis, M. (2023)  What Is SEO? Available at: https://moz.com/learn/seo/what-is-seo (Accessed: 1 September 2023). 

Temu (https://www.temu.com/uk/support-center.html?_x_sessn_id=2cgvf0gcpj&refer_page_name=home&refer_page_id=10005_1693895812569_dpywtz85xg&refer_page_sn=10005) Above is a section of FAQ page in Temu. It is separated into recommended topics that customers have frequently chosen to inquire about. Alibaba (https://service.alibaba.com/page/knowledge?pageId=128&language=en) Above is another section of FAQ but it is in Alibaba. It is separated into categories displayed on the left where you could choose from. There is also a search bar for you to type in your related questions.

(https://www.tts-group.co.uk/aboutus/about-us.html) Above is the about page of one of a website selling stationeries and school products similar to my own website project. Their main target are towards children and giving them a "reason to love learning". (https://www.justforschools.co.uk/about) This is another about page of a website online selling school products. Their target is not only children, but middle schoolers too. They also sell furniture for studying purposes that could be places at school or in your room.

 https://princessfarahahhud.wixsite.com/mysite-1  Above is the link to my website and below are screenshots of my website, although it cannot be seen fully since I have edited most of the content on a desktop despite currently using a laptop. However, the content is still there. The top of the homepage contains a menu and a search bar to navigate through. There is also a logo and the users account displayed. Below it is a welcome banner with a slogan or phrase for our website. On the bottom right, a chat button is displayed at all times for the users to chat with us. This is another banner displayed in the homepage that automatically switches  repeatedly. Here we display our best selling products and recommendations for the customers to browse through. I have included around 10 or 11 products on my home page. Discounts and sales are also advertised on the homepage.

 For my initial idea, I will create a website for selling stationeries and school products such as bags, pencils, pens, pencil case, sticky notes, notebooks and etc. I will add a customer service, a page about the website, the product page, banner, search bar and the best selling products including a phrase displayed at the top of the home page. It is targeted to students of all ages and is very family friendly. I will also include a logo of my own together with the name of the website "2 Cool 4 Skool". This will all be done on WIX.

 Meta Tags Advantages helps search engines understand what the web page is all about improves the users' overall experience by giving out more information of the content increases the ranking of websites and click-through rates, creating traffic (Uses of meta tags and Advantages and disadvantages,  2023) Disadvantages Meta tags are just one of the many options or factors which could improve the rankings of websites so it doesn't have that much impact some creators of websites may just stuff a bunch of keywords in the meta tags which could potentially harm the search engine and decreases the users' experience consumes a lot of time when creating the meta tags, especially for large websites with dozens of pages (Uses of meta tags and Advantages and disadvantages,  2023) Overcoming the disadvantages A website should not contain too many meta tags and must only include keywords. In the case of using a description meta tag, the user must input words and sentences using their o...

 Product Database I have ten products listed in the product table with its unique ID, name, price, quantity and profit using the respective formula shown above in the second picture. I have used a pie chart to show the products and sale prices. I have also used a bar chart to show the profit gained or lost in the product table.

Customer Database Below is my work of creating a customer database using Microsoft Excel: The table above organizes the data of all the customers that the suppliers needed to send or ship their products to them accurately. This also includes personal information such as phone numbers and email as a way to contact them in case any problem arises during the shipment of their products. The table also includes the customers' own unique ID to identify each of them separately. Their names and addresses must always be included so that the supplier could know each of their locations and identity. 

 Types of E-Commerce Business to Consumer (B2C) Amazon ( https://www.amazon.co.uk/ ) Amazon is the "world's largest online retailer" which originally began as an online bookselling company. It has a wide range of products and inventory that the customers would use to buy all kinds of products such as clothes, makeup, jewelry, toiletries, kitchen wares, electronics, books and etc. (Yasar, 2022). It is the "iconic " example of an e-commerce (Hall, 2023). Business to Business (B2B) Alibaba (https://www.alibaba.com/ ) Alibaba is a globally used e-commerce B2B website with B2B followers between 50 to 100 employees that were equally divided between manufacturers and trading companies (Wulf, 2010).  Consumer to Consumer (C2C) eBay (https://www.ebay.co.uk/) According to Dimancea (2016), since eBay's release in 1995,  about 147 million people have have been actively using it until today. It is estimated that about 430 000 million people in the United States have been...

research definition in HTML and how they improve SEO for your ecommerce website Alt Tags Alt tags are used in html to display alternate texts for images when the user could not view the images because of some error such as poor internet connection. The alternate text usually describes the appearance or function of the image ( Alt Text, 2021).  Alt tags provides information of the displayed image to the search engine that informs the user of it. This also helps in increasing the web page's ranking in search engines. Without the alt tags, screen readers and browsers won't be able to read the page and the image will not load correctly. Alt tags provides alt text that describes the image which is very helpful for visually impaired users. This is the reason why alt tags are important for Search Engine Optimization (SEO) ( Why Image Alt Text is Important for SEO, 2011). Title Tags Title tags are used in html to display the web page's title. The title of the page is an accurate s...

Below is the digital wireframe for the website homepage:  For my wireframe, I will put a logo on top with either a phrase or website name beside it. There will be a search bar below it and a shopping cart. On the right, the

  IYZ E-Commerce Computing   E-Commerce Website Ideas     My E-Commerce website will be selling the following (product/service): Books and School Supplies   The business model for my E-Commerce website is: B2B, B2C, C2C, C2B, G2C Business to Consumer (B2C) My Target Market is: Worldwide The business name for my E-Commerce website is: 2 Cool 4 Skool   My tagline / slogan is: Knowledge can be easily gained by using plenty of the correct tools I researched the following competitor E-Commerce websites: School Supplies & Discount Teacher Supply Store | Discount School Supply School Supplies and Teacher Supplies | School Specialty Ditzy Doll - Stationery & Office Supplies (ditzystationery.co.uk) The Education Supply People | Consortium Education Educational and Office Supplies for School, Consortium, Academy an...

Meta Tags Meta tags, officially known as "Metadata Elements", are information added at the top of the html web page which is the "head" area ( Kaurin and Dragić, 2012).  They are codes that provides information to the search engines on how it is to be displayed in the search results and to the users. Additionally, it is also only visible in the html code (Hardwick, 2020).  It is mainly used in SEO (Search Engine Optimization) and contains six most significant tags which are meta title, meta description, meta robots, meta refresh redirect, meta charset and meta viewport (Hardwick, 2020).  Below is a website and its page source: (https://www.heathrow.com/) (view-source:https://www.heathrow.com/) Meta Title It is a tag that contains the main title of the webpage with keywords that search engines will use to provide information to the visitors (Hardwick, 2020). Meta Description It is a tag that contains the brief summarization content of what the whole webpage is all ab...

 Amazon vs Temu Amazon ( https://www.amazon.co.uk/ ) This website sells electronic devices such as televisions, computers and etc. It also sells other products for the kitchen, house and the necessities needed for babies, toddlers and kids. In addition, it also sells clothes which could be found in all e-commerce websites. Amazon contains millions of pages. Although it has its own social media, there are no social media links on the homepage of the website. Its social media is called "Spark". There are also no links to their emails, live chat and phone. It does not have a "buy it now" option but has a "shop now" option. It contains many links that interlinks web pages with each other. There are around 9 tabs in the top navigation menu which are easy to navigate since few of them contains a drop-down list and has good proficiency in English. It is a user friendly website compatible with all browsers. It also has good content with high quality images of pro...

 Programming Languages HTML HTML which also stands for "Hypertext Markup Language" is a markup language used for creating the structures of web pages. It contains "tags" to create headings, paragraphs, adding bolded words, adding images, adjusting the sizes of fonts and images, adding bullet points and etc. (Chris, 2021). CSS CSS which also stands for “Cascading Style Sheets” is a computer language composed of coding elements used for structuring and creating webpages ( Css, 2023). Javascript Javascript (JS) is an object-oriented programming language used by developers to create webpages that users could interact with by adding interactive elements such as clickable buttons, pop menus, animations and etc. ( 10 Practical Applications of JavaScript & Tips for a Successful Career, 2023). Python Python is an "interpreted, object-oriented, high-level programming language" developed by Guido van Rossum which was first released in 1991. It is used for softw...

  Advantages Reduces cost: Making an e-commerce website reduces most of the cost of setting up its own shop in reality such as displaying signs, arranging furniture, putting up the equipment and designs. Worldwide: Could sell much more products to customers globally from different countries and areas. Convenient: The customers could buy the products anywhere just by accessing their website. It also contains various functions and options for the customers to use to find products that suits their own taste. Cookies: E-commerce websites contain cookies that could help the seller check what the buyer has previously purchased which is a necessary information to provide complimentary items, Fast: Customers could buy the products more faster and saves time with just a few clicks. In addition, e-commerce websites could digest large amounts of client information in a short amount of time.  Privacy: The privacy of the clients when buying the products is much higher than buying them in r...

 Essential Features There are many features in an e-commerce website. According to a few of the most successful e-commerce websites, there are many essential features that are most commonly found and took part in its success (Purwati, 2011). Logo A logo represents the website or seller and instills trust in the customers. Each product has a logo that represents the seller or the website. It helps differentiate the brands and helps the customers in choosing the right product to buy. It communicates with the customers through images of different shapes, sizes and colors ( 'What makes a good ecommerce logo?', 2008). Navigation System Firstly, there is the navigation system. Its function is to help customers find their way through the website while shopping for products  to buy. In addition, it must be user friendly to better appeal to the customers. There are 3 types of navigation menus such as top navigation, side navigation and mega navigation. Top navigation is used when there...