22. Using MS Excel, create a customer database with at least 10 entries, with screenshots to document and show your progress

A customer database includes lead contact details and additional data such as demographic characteristics, profession-related characteristics, buying behavior, and firmographics for B2B clients (Zhostka, 2022). It is a must have for any e-commerce website to gain and retain customers including making tracking orders easier.

A screenshot below shows a simple customer database for my website.

Finally, the following picture shows the details of my product database advertised within my website.

References

Zhostka, T. (2022). What is a Customer Database: Definition, examples, and software | Snov.io. [online] snow.io. Available at: https://snov.io/glossary/customer-database/ [Accessed 16 Mar. 2023].

‌

Comments

20. Analyse and compare different examples of product Pages

We are going to review and compare 2 websites selling energy drinks. Firstly, we have https://www.lucozade.com/ . The page features a minimal look with a large product image and clear description. The price and quantity are enlarged to gain attention of the user as it is one of the most important part of a e-commerce website. The product page also has a promotion banner with free delivery and another stating reliable delivery and easy returns. (Lucozade, 2023) Secondly, we have https://www.yourcoca-cola.co.uk/monster-energy-12-x-500ml/ . The page is similar to the previous, however this page contains more information like reviews about the product by customers, subscription and discounts for subscription , recycling banner for packaging and a product overview about the item. (The Hut.com Ltd, 2023) References Lucozade (2023). Lucozade Alert - Original 12 x 500ml» Lucozade . [online] www.lucozade.com. Available at: https://www.lucozade.com/product/l...

25. Create an ERD for your website database. Identify the entities, attributes, relationships and cardinalities

11. Website project initial idea

Searching around on the internet for energy supplements for sports, there was very little focus on natural ingredients and sugar-free. Most energy drinks/supplements contain processed sugar which makes them taste good but may cause medical issues. Additionally, the whole ingredients of the drinks/supplements are tucked away and the user has to actively search for the ingredients. However, some brands advertise specific ingredients like caffeine, protein, vitamins, etc to lure customers. The products of the e-commerce website are aimed towards the health-conscious audience for sports activities. However, it can be used for other activities as well. Additionally, the ingredients are natural and displayed in a simple way that helps the customer choose the effects they want from the product. (Pixabay, 2016) References Pixabay (2016). Brown and White Track Field . [Online Image] Pexels . Available at: https://www.pexels.com/photo/brown-and-white-track-field-163444/ [Accessed 6 Fe...

ecommerce module

Search This Blog