Skip to main content

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

Popular posts from this blog

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

 

6. Analysis and comparison of 2 e-commerce websites

Analysis and comparison between;  SuperDry vs Mountain Warehouse  E-commerce Website Evaluation The above diagram points out the major similarities between two websites  https://www.mountainwarehouse.com/  and  https://www.superdry.com/ . Both of the websites sell clothing related products, however MountainWarehouse aims towards an outdoor audience and SuperDry focuses on premium/designer style.  They have multiple pages like product, order, FAQ, home, etc. Both have social media links (Twitter, Facebook, Youtube and Instagram) but only Superdry has contact link. Add to bag/cart button is available on both and they sell internationally. Their pages are interlinked to the navigation bar and Superdry has 3 navigation tabs, MountainWarehouse has 11 tabs.   UX (User Experience) Evaluation Superdry and MountainWarehouse both have easy to navigate design but Superdry may be more user-friendly due to large product images. Both are written in clear English and...