Data Types

This section consists of Database Things and fields description for every thing which is part of the template.

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

Cart Item

Field	Type	Notes
Gross Amount	number	Stores the Price *Quantity.
In Order	yes / no	"no" means the product is in the current cart.
Net Amount	number	Stores the Price *Quantity + Shipping fee.
Product	product	Stores all the data attached to the product.
Quantity	number	Stores the number of products the customer wants to buy.
Shipping Fee	number	Stores the shipping fee
Unit Price	number	Stores the the Price of a product.

Category

Field	Type	Notes
Name	text	Stores the name of a category.

Conversation

Field	Type	Notes
Seller	User	Stores the data related to the seller.

Coupon

Field	Type	Notes
Code	text	Stores the text that can create discount for the customer.
Discount	number	Stores how many % will be applied as a discount for the customer on the total cart value.

Message

Field	Type	Notes
Content	text	Stores the text value of a message.
Conversation	Conversation	Link the conversation to the message.

Order

Field	Type	Notes
Coupon	number	Stores the coupon value for an order.
Gross Amount	number	Stores the Price *Quantity of an order.
Items	List of Cart Items	Stores the list of all items from the cart.
Net Amount	number	Stores the Price *Quantity + Shipping fee of an order
Plateform Amount	number	Stores the money collected by the plateform.
Reference	text	Stores the number that allows to identify an order.
Sellers	List of Users	Stores the Sellers' data.
Status	text	Either Pending, Shipped or Received.

Platform Fee

Field	Type	Notes
Fee	number	Stores the fee % that belongs to the platform.

Product

Field	Type	Notes
Category	Category	Stores the data related to the category.
Description	text	Stores the data related to the description of a product.
Images	List of Images	Stores 3 pictures max. for the product.
Name	text	Stores the data related to the title of a product.
Number of Items Sold	number	Stores the data related to the number of item sold.
Rating	number	Stores the data related to the ratings by customers of a product.
Sale price	number	Stores the data related to the sale price (after discount from the seller) of a prouct. This is not the Voucher (controlled by the Platform).
Shipping Fee	number	Stores the data related to the shipping fee of a product.
Standard Price	number	Stores the data related to the category.
Stock	number	Stores the data related to the number of products in stock.

Review

Field	Type	Notes
Comment	text	Stores the data related to the comment made by a customer for a review.
Product	Product	Stores the data related that links the Product to the Review.
Rating	number	Stores the data related to the review (out of 5 stars).

User

Field	Type	Notes
Adress	geographic adress	Stores the data related to the Adress of the customer for shippment.
Compagny Adress	geographic adress	Stores the data related to the sellers adress.
Compagny Description	text	Stores the data related to the seller's description.
Compagny Email	email	Stores the data related to the sellers email.
Compagny Logo	picture	This is the profile picture of the seller.
Compagny Name	text	This is the seller's official brand name.
Compagny Phone	US Phone	Stores the phone number of the seller.
First Name	text	First name of the User
Last Name	text	Last name of the User
Type	text	Either Customer, Seller or Admin.
Wishlist	List of Products	Stores the list of product / wishlist of a customer.