Skip to content

Latest commit

 

History

History
33 lines (27 loc) · 2.57 KB

tables.md

File metadata and controls

33 lines (27 loc) · 2.57 KB

logo Shopify Orders DB Documentation

Name Description
customers Customer details
Name Description
products Product & Listing Data
variants Product Variant details & Inventory
product_options Product & variant options configurations
inventory_levels Inventory Levels for items at each inventory location
inventory_locations Inventory locations
Name Description
orders Order Details
order_attr Order source, campaign & attribution details
order_prices Amounts charged for order
adjustments Adjustments on order for refunding shipping and refund discrepancies
date_dimension Date Dimension Table for Analysis
discount_apps Discount Applications for Each Order
discount_codes Discount Codes In Use for Each Order
line_items Line Items with Units Sold for Orders
refund_line_item Refunded Units
refunds Order Refunds
ship_lines Order shipping lines pricings method & discount