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.

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 manual

Address

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.
Image without caption