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

9. Understanding Meta tags: Definition, Meta tag analysis of a webpage of choice and description of each meta tag

 Meta Tags The <meta> tag defines metadata about an HTML document. This metadata is not displayed on the page, but is machine-readable. It is used by browsers to determine how to display content or reload a page, by search engines to identify keywords, and by other web services  (w3schools, 2019). Taking an example of a website  https://www.boohoo.com/ . We can view the source page and the meta tags of the website. References Boohoo (2023).  boohoo | Womens & Mens Clothes | Shop Online Fashion . [online] Boohoo.com. Available at: https://www.boohoo.com [Accessed 2 Feb. 2023]. w3schools (2019).  HTML meta tag . [online] W3schools.com. Available at: https://www.w3schools.com/tags/tag_meta.asp [Accessed 2 Feb. 2023]. ‌

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...

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