BUS205 Collecting Data and Building DB Tables – Wix.com

hello everyone welcome in this tutorial we will see how to start building our first database for an online store on the platform wix.com so this is our objective that’s the final result of what we’re going to do I just wanted to show to you with and when I press preview let’s home it’s empty for now that’s okay but when I go products over on products men or women I have products for men and women let’s assume this is a an online shop for
outfitting and clothes and things like that so I go here for women I click on it it gives me some items and for any of these clicked items if I click on it it shows me the details of the item is the full name the description of the item and that’s the price I can put a IDI or whatever currency yoga you are going to have and go back for men and it’s the same thing so how to do that we are going to go back to editor and we are going to start our
new website to build the database but before we do that we need to collect some information so this information is about the imagery information the images or the videos or the group of pictures that you’re going to have about the commodity I chose seluruh website it’s a famous brand and they have a lot of offerings and they have their own line shop as well as you can see which is pretty advanced hopefully at some point we will get to that so we
will use some of their data but it’s not our data of course and that’s just for the training purpose you are not actually selling and you’re not even publish this because you don’t have any of these commodities but just for the sake of training and having some data I’m going to click on any of the offerings collect like 3040 offerings of what they have and put them just the image as you can see and that to be number three and see I have now three
offerings that I chose and I also need the data of these offerings so how to get this as well I will show you how to do that so we go to the Wix and I’m going to exit editor for this website and I’m going to create a new website I click on create new website and it’s going to be brand new one I mean I based on free blank template choose a template and it’s going to choose a blank template blank templates and choose this one and edit that’s going
to open the editor for you I can close these windows you don’t need them I just need the same wrong window and the first thing I need to do is to go on the deep mode and turn on the deep mode and you can close this tutorial video tutorial and here in the databases you are going to create a new collection new collection means new table and here you are going first of all define some properties about this table and you are going to go get started
and you’re going to go from scratch and that’s the name of the table is going to be product and here you set different properties for the table is it a site content well yes of course it can be a form submission can be member generated content and their only content member only form submission is it private or not for the custom if you go for the custom you would see that give the collection name and here use custom and set custom permissions you
are going to press this and here you see who can read contents from the collections is it going to be the admin which is you or a site member offer or site member or anyone ok who can read from the table I think I’m going to keep it admin so I’m showing you this I’m going to choose admin all the way but I just want to show you that in some cases when you develop a table in your database you will want the site members which people who have a login
credentials username and password to log into your website you will want them to participate with opinion with submission or sometimes you need just to collect the information contact information of your visitors whether they are members in the site or not so that’s going to be through a submission form or a contact form all these things sorry so I’m going to set the and create the collection and here it is products you will find it only with the
title you kind of ignore this field it’s a mandatory field to the database on the Wix platform so you can ignore it and you can utilize it I prefer just to create my own so I will start first of all with the item code and that’s going to be text I’m going to add and here the determine of the field depends on what you’re going to do here we’re building a very simple one table or one collection that holds the information about the products of
course you can have a design and that’s a different place when we go for the relational databases and all these things you kind of have a certain design and the relations between tables but for now we’re having a simple one table thing so again I’m going to go for the name and that’s the name of the product and I’m going to go for the description and that’s the description and as you can see so far all my fields are text type the field type is
text here I’m going to go for the image and that’s going to be not text it’s going to be image okay and you will see here that I can have a media gallery which is might be image video collection of medium alright and I’m going to click one more time on the category so what which category this product will I mean maybe men women and I’m going to have one more thing type which is going to be text and type is going to be maybe shoes back whatever
okay so that’s the build of my database and I have the code which is not okay okay and I can reduce the title and increase the code a little bit so I have the moves so that’s the first thing back to Celeron code is going to be a start with one that’s okay make it very simple one then the name I’m going to go maybe I’m going to click on this offering so I go here and I think that’s the name of the product okay so I go back here and double click
and paste that’s the name the description okay that’s the description go back to the editor and you’re going to fill in and for the image you already have the images here it’s up to you to put the image now or later you can assign the images all at once or as you wish so here’s the way to upload this image you click on this plus sign and you go for upload image and upload from computer I think I’m going to go to the desktop to the images and I
think it was image one and wait for it to upload and you can press add image to the database so this image will be assigned to that specific role or record so at the image here it is n type it’s men and category is men and type is a jacket okay so I’m going to go plus and do the same thing for the code which is so which I don’t know why for the code and two and again I will go to the cellar and do this for some time please spend 20 30 minutes
collecting some data like this maybe I’m going to have this hat okay and that’s the name of the Hat so I go back here and put the name and again after the Hat where is the description okay it’s just some data to work with and I’m going to go on the plus sign of course I already saved this hat on my desktop in the images folder which I think this one and press open and wait for it to upload and add a to page okay at the page and men again and hat
okay so you’re going to do that and or I will do that but I will stop now and we will come back later and that’s the first thing we do we build the website and there are other ways to do that whether if you have an excel sheet from the store or from another database or CSV file which is also opens in Excel you can import and export from here which is an easy thing to do so that’s the first thing so let me continue this and I’ll come back to start
working on our dynamic pages