Data Models

This page provides a reference for all Eloquent models in the Middleware Platform.

---

NFusionTenant

File: app/Models/NFusionTenant.php
Table: n_fusion_tenants

Represents one nFusion API account. See Tenants → for full details.

---

NFusionSyncTarget

File: app/Models/NFusionSyncTarget.php
Table: n_fusion_sync_targets

Defines a sync destination for a tenant. See Sync Targets →.

---

NFusionSyncLog

File: app/Models/NFusionSyncLog.php
Table: n_fusion_sync_logs

One record per sync run per target. See Logs & Monitoring →.

---

NFusionSyncLogItem

File: app/Models/NFusionSyncLogItem.php
Table: n_fusion_sync_log_items

Per-SKU detail for a sync run (created when debug_enabled is on).

---

Product

File: app/Models/Product.php
Table: products

Tracks WooCommerce product data received via the product-update webhook. Used primarily for sale-price overlays.

Key columns:

Column	Description
sku	Product SKU (unique)
markup_sale_price	Per-ounce sale markup override
sale_starts_at	When the sale activates
sale_ends_at	When the sale deactivates
created_at	First time this product was seen via webhook
updated_at	Last update timestamp

Static method Product::getOnSaleProducts() returns all products with an active markup_sale_price.

---

ShipStationOrder

File: app/Models/ShipStationOrder.php
Table: shipstation_orders

Order records from ShipStation webhooks. See ShipStation Integration → for full column reference.

---

ShipStationOrderItem

File: app/Models/ShipStationOrderItem.php
Table: shipstation_order_items

Line items belonging to a ShipStationOrder.

---

ShipStationShipment

File: app/Models/ShipStationShipment.php
Table: shipstation_shipments

Shipment records (tracking numbers, carrier, ship date) from ShipStation SHIP_NOTIFY webhooks.

---

User

File: app/Models/User.php
Table: users

Standard Laravel user model for Filament admin panel authentication.

---

Enums

Enum	Values	Description
NFusionTenantStatus	active, inactive	Tenant active state
PreciousMetal	gold, silver, platinum, palladium	Metal type
SyncTargetType	WooCommerce, Algolia, HTTP	Sync target provider type
SyncLogStatus	running, success, partial, error	Sync run outcome