Merchant Data Catalog

Welcome to the ShipMonk Merchant Data Catalog — a schema reference for the read-only tables available to merchants through ShipMonk Insights and MDC export.

Available tables

Table	Description
Bundle Mapping	Mapping of bundle SKUs to their component physical products in ShipMonk. Each row represents one physical product within a bundle. Join this mart to marts_mdc__order_item on bundle_id to resolve which physical products are contained in a bundle order item.
Claim	View a detailed breakdown of all your claims over a given period. One row equals one claim.
Inventory History	Tracks historical inventory data, including stock levels, allocations, expectations, and quarantined inventory across warehouses, accounts, and products.
Inventory Ledger
Inventory Ledger 7D	Inventory Ledger (marts_mdc__inventory_ledger) data limited to the latest 7 calendar days
Invoice Item	Invoice item represents charges (invoice line items) that are taken as a source of data for the new invoice detail page and invoice docs (PDF and CSV exports).
Order	The report provides order data including shipping cost estimates and adjustments
Order Action Required	This table tracks actions required for orders, including their type, creation, and resolution timestamps, along with unresolved status.
Order Attribute	Custom attributes attached to orders, provided by the merchant or by the integration. Contains one row per attribute, one order can have multiple attributes. Join with the Order model on order_id.
Order Item	This mart contains information about order items imported or manually created. It should serve as a source of truth for the synchronization from your system. To resolve bundle component products, join with "bundle mapping" mart on bundle_id. In case you want to see how each order is fulfilled use "order line" mart.
Order Line	This mart contains information how orders are fulfilled by ShipMonk (which products were shipped in given order). It also contains tracking fulfillment, status, shipping details, and trading partner information. In case you want to see order items you submit to ShipMonk, you can use "order item" mart.
Order Part	Mart shows original order and parts into which was the order split
Order Reference	View all order references associated with your orders. This table provides a complete list of all reference values linked to orders, including PO numbers, external order IDs, and other reference types used for tracking and identification. Orders may have multiple references, and all are included in this view.
Order With Removed Items	The marts_mdc__order_with_removed_items view shows items that were removed manually from orders and are not in split orders (meaning items removed manually by user)
Package Level Detail	The Package Level Detail report provides a comprehensive breakdown of individual shipment details at the package level, for orders with multiple packages there will be multiple lines within the report. This report helps ensure transparent reconciliation of shipping charges and supports logistics efficiency.
Package Line	Table providing detailed information on package line.
Product	Product master data mart with one row per product, consolidating core product info, handling units, HS codes by region, barcodes, attributes, and integration custom data.
Product With Actual Stock	The marts_mdc__product_with_actual_stock view shows products with actual inventory
Receiving Line	Contains details about the receiving process, including expected and actual quantities, timestamps, supplier, warehouse, and product information. Helps track and manage inventory reception efficiently.
Return Line	Provides detailed return line information, including linked orders, accounts, warehouses, products, and return costs. Tracks individual item-level data for returns.
Shipping Adjustments	Table providing detailed information on shipping adjustments, including order, account, invoice, and fulfillment data, along with calculated charges, ranks, and audit categories.
Stock Unit By Storage Category	Current SKU-lot inventory quantities in the warehouse grouped by address location storage category regardless of their state (i.e. including unavailable, quarantined, ...).