Skip to main content

Database in my E-Commerce website

Why Do I need a Database in my E-Commerce website

 Database in my store is essential as I am providing digital wallet and cryptocurrency <---> pound exchange, so I need to know how much every user is spending on which cryptocurrency to improve my services.




Tabular Database in excel allows me to filter different things, for example I am able to filter customers by cryptocurrencies they are buying or amount they spent on cryptocurrencies and this is very useful feature of databases. Filtering is also very useful when you need to find contact to one of the users.




Filtering and other features of database are useful when you need to make some sort of statistics to improve services that you are providing to customers.


How would I collect data from customers

 Most of the data from customers will be collected as soon as new customer register. There will be also feature of updating the data user provided at register to different one.

Another part of data that I will be collecting will be based on cryptocurrency that user buy and amount user spend for this cryptocurrency, so it will be collected through store.


 How do I connect Database to my website

Database will be connected through the backend of my website. There will be a registration / login form, which receives user input and send it to backend and from the backend to my database.

Comments

  1. Unknown6 March 2018 at 06:48

    Good start, please also include the Customer order form on your Digital Notebook and explain how the SUM formula functions on the template. (with screenshots & written notes).

    ReplyDelete

Post a Comment

Popular posts from this blog

Survey results and analysis + SWOT Analysis

In the last weeks I have created a survey to gather informations, which can potentially give me some ideas about my software and how I can improve it in order to fulfil expectations of potential clients. To analyse all of data gathered I used charts that were generated automatically in the Google Forms and SWOT Analysis of data in charts. In the first part of my survey I am asking respondents about themselves do predict if there are any chances that they are on some higher positions in companies that they are working for. The variation of both higher age and higher education - age 30+ and bachelors level of education and above makes possibilities that the respondent is currently on some higher position. I decided to use this variation instead of asking respondent directly, because I am aware of that maybe not everyone want to share such information with survey even if they are anonymous. As we are able to see on the chart there is an impressive number of people who have educati...
3 comments
Read more

SEO

SEO (Search Engines Optimisation) - It is about optimising web pages for the search engine to be as high in search engine as possible. To optimise web page we have to use correct tags, words, web page structure, link to partners and social media. In order to do SEO on the page correctly we have to know how exactly the SEO works. SEO is used to make websites visible in the search engine on the highest position. Optimisation is also used to have high Click Through Rate (CTR) to monetise websites.
2 comments
Read more

Terminology 11/01/18

Internet website cookies - Files in browser used for saving your preferences, visual styles, to remember login and password, adverts are handled by cookies saved in browser. UI - User Interface - human friendly interface which is helping to communicate between human and computer or webpage. Page source - Code in which page was written. In page source you can find HTML, CSS or JavaScript. Meta tags - keywords for describing a page. For example you can use it to describe default language, description (for search engines), etc.. JavaScript / JQuery - These programming languages are mostly used in web development for such purposes like adding dynamic and interactive elements to websites. Hyperlinks -  hyperlinks are texts, pictures, animations, etc. and you can add URL to them. For eg. you can be redirected to another website just with clicking on some text or picture.
2 comments
Read more