Tables
ERD
21 tables
Expand all
Collapse all
order
80 columns
order_line_items
55 columns
order_line_item_discounts
7 columns
order_shipping_addresses
30 columns
order_coupons
7 columns
order_taxes
12 columns
customer
16 columns
customer_addresses
14 columns
customer_form_fields
3 columns
refund
8 columns
refund_line_items
6 columns
refund_payments
7 columns
product
66 columns
product_category
2 columns
product_variant
27 columns
product_custom_fields
3 columns
product_related_products
2 columns
product_bulk_pricing_rules
6 columns
currency
17 columns
category
16 columns
brand
9 columns
Loading diagram…
order
order
id
long
customer_id
long
currency_id
long
date_created
date
date_modified
date
date_shipped
date
status_id
long
status
string
subtotal_ex_tax
double
subtotal_inc_tax
double
subtotal_tax
double
base_shipping_cost
double
shipping_cost_ex_tax
double
shipping_cost_inc_tax
double
shipping_cost_tax
double
shipping_cost_tax_class_id
long
base_handling_cost
double
handling_cost_ex_tax
double
handling_cost_inc_tax
double
handling_cost_tax
double
handling_cost_tax_class_id
long
base_wrapping_cost
double
wrapping_cost_ex_tax
double
wrapping_cost_inc_tax
double
wrapping_cost_tax
double
wrapping_cost_tax_class_id
long
total_ex_tax
double
total_inc_tax
double
total_tax
double
items_total
int
items_shipped
int
payment_method
string
payment_provider_id
string
payment_status
string
refunded_amount
double
order_is_digital
boolean
store_credit_amount
double
gift_certificate_amount
double
ip_address
string
ip_address_v6
string
geoip_country
string
geoip_country_iso2
string
currency_code
string
currency_exchange_rate
double
default_currency_id
long
default_currency_code
string
staff_notes
string
customer_message
string
discount_amount
double
coupon_discount
double
shipping_address_count
int
is_deleted
boolean
ebay_order_id
string
cart_id
string
billing_address_first_name
string
billing_address_last_name
string
billing_address_company
string
billing_address_street_1
string
billing_address_street_2
string
billing_address_city
string
billing_address_state
string
billing_address_zip
string
billing_address_country
string
billing_address_country_iso2
string
billing_address_phone
string
billing_address_email
string
billing_address_form_fields
string
is_email_opt_in
boolean
credit_card_type
string
order_source
string
channel_id
long
external_source
string
external_id
string
external_merchant_id
string
tax_provider_id
string
customer_locale
string
external_order_id
string
store_default_currency_code
string
store_default_to_transactional_exchange_rate
double
custom_status
string
order_line_items
id
long
order_id
long
product_id
long
variant_id
long
order_address_id
long
name
string
name_customer
string
name_merchant
string
sku
string
upc
string
type
string
base_price
double
price_ex_tax
double
price_inc_tax
double
price_tax
double
base_total
double
total_ex_tax
double
total_inc_tax
double
total_tax
double
weight
double
width
double
height
double
depth
double
quantity
int
base_cost_price
double
cost_price_inc_tax
double
cost_price_ex_tax
double
cost_price_tax
double
is_refunded
boolean
quantity_refunded
double
refund_amount
double
return_id
long
wrapping_id
long
wrapping_name
string
base_wrapping_cost
double
wrapping_cost_ex_tax
double
wrapping_cost_inc_tax
double
wrapping_cost_tax
double
wrapping_message
string
quantity_shipped
int
event_name
string
event_date
date
fixed_shipping_cost
double
ebay_item_id
string
ebay_transaction_id
string
option_set_id
long
parent_order_product_id
long
is_bundled_product
boolean
bin_picking_number
string
external_id
string
fulfillment_source
string
brand
string
gift_certificate_id
long
product_options
string
configurable_fields
string
order_line_item_discounts
id
string
order_id
long
order_line_item_id
long
name
string
code
string
target
string
amount
double
order_shipping_addresses
id
long
order_id
long
first_name
string
last_name
string
company
string
street_1
string
street_2
string
city
string
zip
string
country
string
country_iso2
string
state
string
email
string
phone
string
items_total
int
items_shipped
int
shipping_method
string
base_cost
double
cost_ex_tax
double
cost_inc_tax
double
cost_tax
double
cost_tax_class_id
long
base_handling_cost
double
handling_cost_ex_tax
double
handling_cost_inc_tax
double
handling_cost_tax
double
handling_cost_tax_class_id
long
shipping_zone_id
long
shipping_zone_name
string
form_fields
string
order_coupons
id
long
order_id
long
coupon_id
long
code
string
amount
double
type
string
discount
double
order_taxes
id
long
order_id
long
order_address_id
long
tax_rate_id
long
sales_tax_id
string
tax_class_id
long
name
string
class
string
rate
double
priority
int
priority_amount
double
line_amount
double
customer
customer
id
long
authentication_force_password_reset
boolean
company
string
customer_group_id
long
email
string
first_name
string
last_name
string
notes
string
phone
string
registration_ip_address
string
tax_exempt_category
string
date_created
date
date_modified
date
accepts_product_review_abandoned_cart_emails
boolean
origin_channel_id
long
channel_ids
string
customer_addresses
id
long
customer_id
long
address1
string
address2
string
address_type
string
city
string
company
string
country
string
country_code
string
first_name
string
last_name
string
phone
string
postal_code
string
state_or_province
string
customer_form_fields
customer_id
long
name
string
value
string
refund
refund
id
long
order_id
long
user_id
long
created
date
reason
string
total_amount
double
total_tax
double
uses_merchant_override_values
boolean
refund_line_items
refund_id
long
product_id
long
item_type
string
quantity
int
requested_amount
double
reason
string
refund_payments
id
long
refund_id
long
provider_id
string
amount
double
offline
boolean
is_declined
boolean
declined_message
string
product
product
id
long
brand_id
long
name
string
type
string
sku
string
description
string
weight
double
width
double
depth
double
height
double
price
double
cost_price
double
retail_price
double
sale_price
double
map_price
double
tax_class_id
long
product_tax_code
string
calculated_price
double
option_set_id
long
option_set_display
string
inventory_level
int
inventory_warning_level
int
inventory_tracking
string
reviews_rating_sum
int
reviews_count
int
total_sold
int
fixed_cost_shipping_price
double
is_free_shipping
boolean
is_visible
boolean
is_featured
boolean
warranty
string
bin_picking_number
string
layout_file
string
upc
string
mpn
string
gtin
string
search_keywords
string
availability
string
availability_description
string
gift_wrapping_options_type
string
gift_wrapping_options_list
string
sort_order
int
condition
string
is_condition_shown
boolean
order_quantity_minimum
int
order_quantity_maximum
int
page_title
string
meta_keywords
string
meta_description
string
date_created
date
date_modified
date
view_count
int
preorder_release_date
date
preorder_message
string
is_preorder_only
boolean
is_price_hidden
boolean
price_hidden_label
string
custom_url_url
string
custom_url_is_customized
boolean
base_variant_id
long
open_graph_type
string
open_graph_title
string
open_graph_description
string
open_graph_use_meta_description
boolean
open_graph_use_product_name
boolean
open_graph_use_image
boolean
product_category
product_id
long
category_id
long
product_variant
product_id
long
variant_id
long
sku
string
sku_id
long
price
double
calculated_price
double
sale_price
double
retail_price
double
map_price
double
weight
double
width
double
height
double
depth
double
is_free_shipping
boolean
fixed_cost_shipping_price
double
calculated_weight
double
purchasing_disabled
boolean
purchasing_disabled_message
string
image_url
string
cost_price
double
upc
string
mpn
string
gtin
string
inventory_level
int
inventory_warning_level
int
bin_picking_number
double
option_values
string
product_custom_fields
product_id
long
name
string
value
string
product_related_products
product_id
long
related_product_id
long
product_bulk_pricing_rules
product_id
long
rule_id
long
amount
double
quantity_max
int
quantity_min
int
type
string
currency
id
long
is_default
boolean
last_updated
date
country_iso2
string
default_for_country_codes
string
currency_code
string
currency_exchange_rate
double
name
string
token
string
auto_update
boolean
token_location
string
decimal_token
string
thousands_token
string
decimal_places
int
enabled
boolean
is_transactional
boolean
use_default_name
boolean
category
id
long
parent_id
long
name
string
description
string
views
int
sort_order
int
page_title
string
meta_keywords
string
meta_description
string
layout_file
string
image_url
string
is_visible
boolean
search_keywords
string
default_product_sort
string
custom_url_url
string
custom_url_is_customized
boolean
brand
id
long
name
string
page_title
string
meta_keywords
string
meta_description
string
image_url
string
search_keywords
string
custom_url_url
string
custom_url_is_customized
boolean
Table
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.