Back to Home
ERD Studio
Browse Templates/E-Commerce Platform

E-Commerce Platform

A comprehensive e-commerce database schema designed for online stores and marketplaces. Includes product catalog with categories, customer management, order processing with line items, payment tracking, shipping addresses, and inventory management. Suitable for Shopify-like platforms, WooCommerce alternatives, or custom e-commerce solutions.

PostgreSQL12 tablesE-Commerce
e-commerceshoppingpaymentsordersproducts
Created with ERD Studio

Tables in this template

usersUsers
8 cols
addressesAddresses
10 cols
categoriesCategories
6 cols
productsProducts
10 cols
product_imagesProduct Images
7 cols
cartsCarts
6 cols
cart_itemsCart Items
5 cols
ordersOrders
12 cols
order_itemsOrder Items
7 cols
paymentsPayments
8 cols
reviewsReviews
8 cols
couponsCoupons
10 cols

Related Templates

View all templates →

Shopify

Clone

E-commerce platform with multi-store support, product variants, fulfillment, and discounts

PostgreSQL15 tables
e-commercemulti-tenantinventory+2
E-Commerce

Multi-Vendor Marketplace

Database schema for a multi-vendor marketplace with stores, products, orders, reviews, and seller payouts.

PostgreSQL11 tables
marketplacemulti-vendore-commerce+3
E-Commerce

Subscription Box Service

Database schema for a subscription box service with recurring plans, curated boxes, and shipment tracking.

PostgreSQL10 tables
subscriptionrecurringbox+3
E-Commerce

Digital Product Store

Database schema for a digital product marketplace with creators, licenses, downloads, and customer reviews.

PostgreSQL10 tables
digitaldownloadslicenses+3
E-Commerce
E-Commerce Database Schema Template | ERD Studio