Sales & Orders
Orders, invoices, shipments, credit memos — the post-checkout sales flow.
52 tables
sales_bestsellers_aggregated_daily
Sales Bestsellers Aggregated Daily
from Magento_Sales
sales_bestsellers_aggregated_monthly
Sales Bestsellers Aggregated Monthly
from Magento_Sales
sales_bestsellers_aggregated_yearly
Sales Bestsellers Aggregated Yearly
from Magento_Sales
sales_creditmemo
Sales Flat Creditmemo
from Magento_Sales
sales_creditmemo_comment
Sales Flat Creditmemo Comment
from Magento_Sales
sales_creditmemo_grid
Sales Flat Creditmemo Grid
from Magento_Sales
sales_creditmemo_item
Sales Flat Creditmemo Item
from Magento_Sales
sales_invoice
Sales Flat Invoice
from Magento_Sales
sales_invoice_comment
Sales Flat Invoice Comment
from Magento_Sales
sales_invoice_grid
Sales Flat Invoice Grid
from Magento_Sales
sales_invoice_item
Sales Flat Invoice Item
from Magento_Sales
sales_invoiced_aggregated
Sales Invoiced Aggregated
from Magento_Sales
sales_invoiced_aggregated_order
Sales Invoiced Aggregated Order
from Magento_Sales
sales_order
Sales Flat Order
from Magento_Sales
sales_order_address
Sales Flat Order Address
from Magento_Sales
sales_order_aggregated_created
Sales Order Aggregated Created
from Magento_Sales
sales_order_aggregated_updated
Sales Order Aggregated Updated
from Magento_Sales
sales_order_confirm_cancel
Save the confirmation key to cancel guest order
from Magento_OrderCancellation
sales_order_grid
Sales Flat Order Grid
from Magento_Sales
sales_order_item
Sales Flat Order Item
from Magento_Sales
sales_order_payment
Sales Flat Order Payment
from Magento_Sales
sales_order_status
Sales Order Status Table
from Magento_Sales
sales_order_status_change_history
Save the updated order status with timestamp
from Magento_Sales
sales_order_status_history
Sales Flat Order Status History
from Magento_Sales
sales_order_status_label
Sales Order Status Label Table
from Magento_Sales
sales_order_status_state
Sales Order Status Table
from Magento_Sales
sales_order_tax
Sales Order Tax Table
from Magento_Sales
sales_order_tax_item
Sales Order Tax Item
from Magento_Sales
sales_payment_transaction
Sales Payment Transaction
from Magento_Sales
sales_refunded_aggregated
Sales Refunded Aggregated
from Magento_Sales
sales_refunded_aggregated_order
Sales Refunded Aggregated Order
from Magento_Sales
sales_sequence_meta
sales_sequence_meta
from Magento_SalesSequence
sales_sequence_profile
sales_sequence_profile
from Magento_SalesSequence
sales_shipment
Sales Flat Shipment
from Magento_Sales
sales_shipment_comment
Sales Flat Shipment Comment
from Magento_Sales
sales_shipment_grid
Sales Flat Shipment Grid
from Magento_Sales
sales_shipment_item
Sales Flat Shipment Item
from Magento_Sales
sales_shipment_track
Sales Flat Shipment Track
from Magento_Sales
sales_shipping_aggregated
Sales Shipping Aggregated
from Magento_Sales
sales_shipping_aggregated_order
Sales Shipping Aggregated Order
from Magento_Sales
salesrule
Salesrule
from Magento_SalesRule
salesrule_coupon
Salesrule Coupon
from Magento_SalesRule
salesrule_coupon_aggregated
Coupon Aggregated
from Magento_SalesRule
salesrule_coupon_aggregated_order
Coupon Aggregated Order
from Magento_SalesRule
salesrule_coupon_aggregated_updated
Salesrule Coupon Aggregated Updated
from Magento_SalesRule
salesrule_coupon_usage
Salesrule Coupon Usage
from Magento_SalesRule
salesrule_customer
Salesrule Customer
from Magento_SalesRule
salesrule_customer_group
Sales Rules To Customer Groups Relations
from Magento_SalesRule
salesrule_label
Salesrule Label
from Magento_SalesRule
salesrule_product_attribute
Salesrule Product Attribute
from Magento_SalesRule
salesrule_website
Sales Rules To Websites Relations
from Magento_SalesRule
shipping_tablerate
Shipping Tablerate
from Magento_OfflineShipping