Reema E-Commerce

  As shown below, I created my product database, starting by setting up a unique product number followed by the product's name. Moreover, after evaluating the competitor prices and the unit cost, I set up the product's price.  The initial table One of the fundamental elements to be listed on the database is the Total sales, and it could be calculated easily by inserting the  sign (=)  on the cell following by the cells  (sale price)   times   (Stok sale). Total Sales equation Excel will calculate the total sales. Instead of doing the same for every product, all I had done is to click  Enter , and the total sales equation was inserted to all of the other products. Total Sales results Knowing the cost will help later to calculate the profit. Therefore, I added a column for cost on the database. Calculating the cost is pretty simple; first, insert the  sign (=)  followed by the cells  stock quantity  times   unit price . The cells could be chosen by clicking on them, as shown belo

 My e-commerce will include the following 10 products: 1- Double chocolate chip cookie this product includes two options The SKU: RC0000 Double chocolate chip cookie ------------------------------------------ 2-Classic chocolate chip cookies this product includes two options The SKU: RC1000 Classic chocolate chip cookies ------------------------------------------ 3-Cinnamon swirls cookies The SKU: RC0001

What is database: Database is a system that helps businesses to organize, analyze and manage the information that is already in the system or has been put such as new order data  (Linton, 2019). Database functions by storing the information digitally in the system. So the store owners could retrieve or analyze the stored data more conveniently   (Rojas, 2019) .  DBMS:   DBMS stands for Database Management System. DBMS is a management software that allows the user to create, manage, protect and edit data  (Mullins, 2021). It works as a gate between the user and the data in the program. Furthermore, the database management system manipulates and manages the data input in a secure way  (  Guru99 , 2021) . DBMS languages: SQL( Structured Query Language): SQL access language is attributed as a query language that could be used in defining the scheme of the database, secure the data, and modify it (T, 2019) . DDL( Data Definition Language ): DDL language, if the separation between the logic

Arrival e-commerce is pretty similar to the website I'm creating. Thus,  In this post, I will analyze Arrival website FAQ page.    Arrivals cookies website(FAQ page) The questions on the FAQ page are neatly displayed, which makes it much more convenient for the consumer to go through and find the answers to their inquiries. Another vital thing is the quality of responses provided. Each question is answered thoroughly with enough details.  An example of a question on Arrival cookies' FAQ page For example, this question is highly important to be included on any website that sells goods. Moreover, the response to the question is adequate, so that the consumer could be satisfied and their question could be met.  There are other useful answered questions regarding delivery, storage, cancellation and refund, and so on. Therefore,  after analyzing Arrival FAQ page, the website I'm creating is going to include the following questions. 1- Can I customize my order? 2- Can I pre-order

 The product page is one of the most important pages. Therefore, it needs to be appealing and straightforward so the users could have a good user experience. Thus, when I started constructing the product page on my e-commerce, I tried to make it simple yet informative. First, I started to add the product: The first product I added was the double chocolate chip cookies.  I started by adding photos of the product.  Adding photos of the product ( editing page) It is essential to add clear photos, as the photos of the product are one significant element that could attract the consumer. The photos (product page ) Second I choose the name, added a brief description, and set the price: Choosing a name that suits the purpose of the product is important so that the consumer could have an idea of the product even before clicking on the product.  Another important element is the price. Therefore, to set a good price that would attract the customer, analysing the competitor's website is a good

 Having a logo for my e-commerce was an essential element. Therefore, I started to search for websites for creating logos. Luckily I found one that allows you to create a logo with no charges. The website is Free logo design . After that, I started to pick the design that would suit my e-commerce. The good feature of free logo design is that it contains many designs and on top of that it gives you the chance to add your own touches, which what I have done.  First I picked a logo I thought it would be a good fit for my e-commerce: The Logo before  Second, I used the toolbar to add my touches and make it suitable for my website. The final result  I loved the cow icon in the initial design the fixed one. Therefore, I took it and changed the other element, such as the colors and the font of the text. In addition, I added a diamond shape that I found sophisticated yet simple, which was what I wanted the logo to represent. Sources:  https://www.freelogodesign.org/

Out of the 4Ps,  promotion will play an essential role in the success of my e-commerce. Therefore, the website will include social media links. The reason behind social media accounts is that many people use social media these days. Thus, reaching consumers would be easier. Another feature that has been included on the website is the live chat feature. So if the consumer has a question regarding one of the products, the customer service adviser could promote the product and show the options we have. finally, the newsletter submission form. The website consumer could subscribe to our newsletter, and we will be sending emails to them promoting our products. The social media links on my website The live chat section on my website 

 Using Wix, I started building the Reemz cookies e-commerce website. I'm still working on the website, but I have made some changes and added some of the features I mentioned in the previous posts.  1-The header: The header on the Reemz Cookies website As shown above, I have included the name of the shop and the shop's slogan. Furthermore, the main features are included as well, such as: The menu which includes the home button, contact, about us, and shop, and all of these buttons include hyperlinks to the pages to facilitate the navigation. Shopping cart, it is an essential feature in any e-commerce, especially if the market was B2C. Searching bar. There are a couple of elements that need to be included, such as the wish list and sign up icon, but I'm still working on it. All of the tools that I used could be found on the Wix website. Wix has many helpful tools, for instance, adding text, photo shaps, and so on. On top of that, all could include hyperlinks that take to the

Having looked into 2 e-commerce websites helped figure out some of the features that I could include in my e-commerce. The homepage:  The homepage is one of the most important pages on the website since it is the first page that appears to the visitors. Thus, I tried to gather some ideas from similar websites to the one I am working on.  The first website is Chocolate dino company: Homepage : The header part ( Chocolate dino company) Many essential elements need to be included in the header part, and the chocolate dino company website has them. First, the menu, which contains text connected to the pages via a hyperlink. Thus, it is much easier for the visitor to navigate inside the website. As shown in the photo above, the menu is included, as I mentioned earlier. It contains 5 different categories, 1- Shop, which includes all their products. 2-Home, which takes the user to the home page. 3- About us, which is a significant page to be included in any e-commerce website (more details an

 I looked into websites similar to the one I'm creating; my main focus was to analyse and gather some ideas from their About pages. First Ben's cookies  website : Ben's cookies (about us page) On Ben's cookies website, the story was mentioned in a simple yet informative way. The story behind the store is mentioned in a few lines, making it easy for the visitor to read.  Interesting information was mentioned, such as how the store was found and who the founder is, and the best fact was how the store was named.  Second chocolate dino company: Chocolate dino company  (about us page) Unlike Ben's cookie on chocolate dino company, although the text was much longer, it was very touching. The story was told in a way that makes you feel involved in creating the cookies and their community. Furthermore, they have connected happiness with their products; thus, the term happiness would be related to their e-commerce.  Finally, Arrival cookies website: Arrival cookies (about u