This section consists of Database Things and fields description for every thing which is part of the template.
Introduction
To get to the Data section, click the database icon on the left side tabs in Bubble Editor.
See Bubble manual information when working with data: - https://manual.bubble.io/help-guides/working-with-data; https://manual.bubble.io/core-resources/data.
Data Types
Note: In case you have accidentally deleted a data type - no worries! Bubble lets you restoreπͺthe deleted data type.
Clicking on 'show deleted types' or 'show deleted fields' from the Data β Data types tab will reveal the deleted items, and a 'restore' button will appear next to each deleted entry. Simply click 'restore', to restore a field or data type.
Tip: Aside from the below-listed data types and fields, Bubble creates these default fields visible in each data type:
Creator
, Modified Date
, Created Date
and Slug
, except for the User data type. The User data type will have the following fields: email
, Modified Date
, Created Date
and Slug
.
These fields' values can be used in workflows, conditional formatting, etc. To learn more, see the Bubble manualAddress
This datatype contains information about user's shipping address.
Field Name | Type | Notes |
address | text | This field stores the Address Line 1 - it is for the user's street address. |
address2 | text | This field stores the Address Line 2 - it is for the user's apartment, suite, or space number. |
city | text | This field stores the user's city. |
country | geographic address | This field stores the user's country. |
phone | text | This field stores the user's mobile phone. |
post_code | text | This field stores the user's post code. |
state | text | This field stores the user's State. |
AdminCommission
This is the type that stores the admin commission information. It simply stores the amount.
It comes with the following fields:
Field Name | Type | Notes |
% | number | Stores the value of the discount in % |
Note: The data type has privacy rule applied. See the π¬ in database under Privacy section for details.
Category
This type stores information about product categories.
It comes with the following fields:
Field Name | Type | Notes |
icon | image | Stores the image attributed to category. |
icon_dark_mode | image | Stores the image attributed to category (used for dark mode). |
number | number | Stores the category's number. |
title | text | This field stores the category title. |
Company
This type stores information about the seller (company).
It comes with the following fields:
Field Name | Type | Notes |
address | text | This field stores the company's address. |
details | text | This field stores the company's details. |
email | text | This field stores the company's email. |
logo | image | This field stores the company's logo |
name | text | This field stores the company's name. |
phone | text | This field stores the company's phone. |
Item
This data type stores all the information about an item on the platform. Besides regular information like item Brand, Category, Description, etc., it also checks whether an item is approved/declined by the admin.
It comes with the following fields:
Field Name | Type | Notes |
actual_price | number | Stores the actual price of the item. |
approved | yes / no | This field specifies whether the product was approved by an admin. |
declined_by_admin | yes / no | This field specifies whether the product was approved by an admin. |
item_category | Category | This field stores the category of an item. |
item_description | text | This field stores the description of the item. |
item_images | List of files | This field stores images of the product. |
item_popularity | number | This field stores a number that determines how popular an item is. Using this field you can later on display products on your page marked as most popular. |
Item_review | List of Reviews | This field stores the reviews an item gets. |
item_sold_number | number | This field stores the number of items sold. |
item_stock | number | This field keeps track of an item's stock availability. |
itemShippingCost | number | This field stores cost of the shipping. |
new | number | Stores the status of the item, specifies if it is new to the marketplace. |
price | number | This field stores an item's price. |
sale_price | number | Stores the sale price for the item. |
title | text | This field stores the name of the item. |
Log
Log data type stores the history of the transactions.
It comes with the following fields:
Field Name | Type | Notes |
amount without shipping | number | Stores the order's price without the shipping fee. |
charge | number | Stores the charge applied to the order. |
discount | text | This field stores data such as discount, stripe account ID, price of the item. |
discount_amount | number | Stored the value of the discount. |
platform_fee | number | Stores the value of the platform fee. |
Seller | User | This field stores the seller that was involved in a transaction. |
shipping | number | Stores the order name of the shipping. |
Message
This data type stores everything related to messages exchanged between buyer/seller/admin when a dispute is open.
It comes with the following fields:
Field Name | Type | Notes |
content | text | This field stores the message content. |
image | image | Stores the images enclosed to messages. |
new | yes / no | This field determines whether the message has been read. |
Recipient | User | This field attributes the message to a user who receives it. |
Tip: The new field determines whether or not a message is read.
Embedded Notes in Bubble Editor
This template comes with explicit Notes for Database fields, Option sets and their fields, and Privacy rules, which will guide you through the modification process. In order to preview a Note of any data type or field, click on the π¬ icon.