Exporting database from website

-

Today I would like to show the process of exporting my product database from my website to Excel.

At the beggining I had to choose, which products I want to export. Because I want to export all database, I marked all of the items.

Product database (Author's work)

Then I had to click on "Export". After this action, I had a database file downloaded in .csv format.

To import it to Excel, I had to choose "Import from CSV" option. The software asked about some details such as formatting. Finally I had a database showed below.

Imported database (Author's work)

As you can see, this database contains a large number of unwanted information. To solve this issue I used "Hide" option.

Below you can see the final version of imported database, which allows me to compare it with the previous database and update it.

Imported database (Author's work)


Comments

Post a Comment

Popular posts from this blog

Wireframe

-
Image
In this post I want to show initial design of my e-commerce webside homepage, which includes the header, body and footer. To create this initial project I have used Mockflow software. Author's work As we can see in the image, the webpage is divided into header, body and footer. The header contains logo, categories of products, search bar, login button, sign up button, cart and wishlist. Below the header, I want to set the banner with information about my e-commerce business, piece of history and slogan. In the body, I want to include only the pictures of products. I believe that the clear structure of the body will be helpful for my customers. Footer contains hyperlinks to all necessary information such as terms and conditions, FAQ and contact page. Moreover, I want to include hyperlinks to social media profiles of my company.
Read more

SEO

-
SEO (Search Engine Optimization) is a range of techniques, which are helping to improve the quality and quantity of traffic on the website.  SEO is mostly used for commercial purposes, to position the website on the first page of the search engine without using paid advertisements, to increase earnings on this website.
Read more

Website security

-
Image
Why encryption is using in case of online transaction? Encryption is translating the data to different form than it is in reality, and make it possible to read only for people, which have a secret key (Lord, 2020). According to Elefant (2011) it is important to encrypt the data in case of online payments, because it makes this data almost imposible to read in terms of any attacks for example "man-in-the-middle" attack. Security of my website. My website is secure by SSL (Secure Socket Layers) technology provided by Wix. It means, all of the data exchanged between the server and customer will be encrypted, which makes even in case of attack, hackers will be not able to decrypt the data. Part of SSL certificate of my website (Author's work)   My payments will be secured as well. Module provided by Wix, which contains the payments, contains addictional SSL Certificate as well. Moreover, using the HTTPS domain makes, the security of the payments is improved as well. Checkout ...
Read more