SYSTEMAPI CHECKINGWRITE PROXY CHECKINGDATA CHECKING
KRPUS ⚓ USLAXICN ✈ LAX5609 RIVERWAY · BUENA PARK CA

LOGISTICS MASTER 2026 · LIVE WORKBOOK SYNC

StyleKorean
Logistics Hub

Every import, inbound delivery, trucking move, and small-parcel shipment across the next fourteen days—one operational board.

MASTERNATIONALSALES
Syncing live records…AUTO SYNC 30 MIN · LAST SYNC — · NEXT CHECK —
Logistics Control Tower
stylekorean.dpdns.org
Syncing
Warehouse Control Tower
skwarehouse.dpdns.org
External system · no live data here
INBOUND0arrivals in view
OUTBOUND0shipments in view
DUE TODAY0tracked moves
EXCEPTIONS0pending / hold / delayed

2026 ACTUALS · INVOICE FIRST / RATE FALLBACK

KPI Control Tower

SHIPPING COSTS
MTD$0
TRANSFER SHIPPING
MTD$0
TRUCKING TRANSFERS TO NJ
MTD$0
SALES · NATIONALS
MTD$0.00
SALES · WMS WHOLESALE
MTD$0.00
NET MARGIN
—No cost/margin data source yet
TOP 3 CARRIERS · YTD (always YTD)
  1. Carrier data unavailable
TRUCKLOAD MIX · YTD (always YTD)
LTL0%
FTL0%
AVG TRUCKING COST · MTD / YTD
LOCAL / REGIONAL HEURISTIC$0$0
CALIFORNIA$0$0
OUT OF STATE$0$0
Methodology notes

All rows, including hidden/completed entries. Shipping costs use freight Invoice first, then Rate when Invoice is blank—never shipment Invoice Amount. Nationals sales use Order Date (column G) and Amount (column E), expand K values, and exclude cancelled orders. WMS wholesale sales use Date (column A) and numeric INVOICE AMOUNT (column G); text entries such as “FREE SAMPLE,” “FOC,” “Sample,” and operational notes are excluded. MTD is the current month through today; YTD begins January 1, 2026. Trucking averages exclude transfers and unclassified destinations; local / regional uses a destination city/ZIP heuristic for the Southern California operating area and is not a measured mileage radius. The NJ transfer card includes only TRANSFERS rows whose TO field is NJ or New Jersey. Carrier freight spend uses the same freight Invoice-first, Rate-fallback cost, and shipment share is each carrier’s moves divided by all YTD moves with a named carrier. Open Nationals source · Open WMS source.

By shipment count · MTD / YTD

Top Carriers

Air0 MTD · 0 YTD
  1. No named carriers
Ocean0 MTD · 0 YTD
  1. No named carriers
Domestic Transportation0 MTD · 0 YTD
  1. No named carriers
Small Parcels0 MTD · 0 YTD
  1. No named carriers
Active shipments by mode

Freight Mix

No classified freight in the active schedule.

INBOUND MILESTONES · OUTBOUND LAST-KNOWN SCAN

Live Shipment Map

0pinned
Ocean import (port milestone) Air import (port milestone) Parcel — last carrier scan
Mode & carrier colors
WholesaleOceanAirUPS (Parcel)FedEx (Parcel)USPSAmazonDHL (Small Parcel)UPS (Freight)FedEx (Freight)DHL (Freight)
Outbound departments
WholesaleB2B/E-ComNationalsMBXNJ

CURRENT + UPCOMING · OCEAN / AIR

Import Schedules

0 Ocean0 Air0
ModeShipmentInvoiceMBLHBLContainer #VSLPODETAStatus
Syncing import schedules…

PRODUCTS ON INBOUND SHIPMENTS

Inbound Inventory

0products · 0 units
Showing 0 of 0
Product nameSKU #UPC #ExpirationPallet #Qty
Syncing inventory…

MATCHING PRODUCTS · CURRENT WAREHOUSE ON HAND

Products in Stock

0products · 0 units
Showing 0 of 0
Product nameSKU #UPC #ExpirationQtyLocation
Syncing inventory…

QTY UNDER 200 · CURRENT WAREHOUSE ON HAND

Low Stock

0products
Product nameSKU #UPC #ExpirationQtyLocationIncoming shipment #
Syncing inventory…

ARRIVALS

Inbound schedule

INBOUND0next 14 days
MON24AUG0
TUE25AUG0
WED26AUG0
THU27AUG0
FRI28AUG0
SAT29AUG0
SUN30AUG0
MON31AUG0
TUE1SEP0
WED2SEP0
THU3SEP0
FRI4SEP0
SAT5SEP0
SUN6SEP0

UPS · FEDEX · USPS · DHL · AMAZON

Inbound Schedule (Small Parcels)

0active
MON24AUG0
TUE25AUG0
WED26AUG0
THU27AUG0
FRI28AUG0
SAT29AUG0
SUN30AUG0
MON31AUG0
TUE1SEP0
WED2SEP0
THU3SEP0
FRI4SEP0
SAT5SEP0
SUN6SEP0

DEPARTURES · TRUCKING ONLY

Outbound schedule

OUTBOUND0next 14 days
MON24AUG0
TUE25AUG0
WED26AUG0
THU27AUG0
FRI28AUG0
SAT29AUG0
SUN30AUG0
MON31AUG0
TUE1SEP0
WED2SEP0
THU3SEP0
FRI4SEP0
SAT5SEP0
SUN6SEP0
🛒

Fulfillment Orders

Live WMS fulfillment status · all shipping methods

0 of 0 Orders—View Source ↗
Connecting…
Picking
0 / 0
0%
›
Inspected
0 / 0
0%
›
Moved to Packing
0 / 0
0%
›
Dimensions
0 / 0
0%
Rows
Invoice #CustomerShip OutPickingMethodAmountFulfillment StatusMoved to PackingDimensionsDetails
Loading fulfillment data…
0 of 0
Page 1 / 1
View Source Orders →

UPS · FEDEX · USPS · DHL · AMAZON

Outbound Schedule (Small Parcels)

0active
MON24AUG0
TUE25AUG0
WED26AUG0
THU27AUG0
FRI28AUG0
SAT29AUG0
SUN30AUG0
MON31AUG0
TUE1SEP0
WED2SEP0
THU3SEP0
FRI4SEP0
SAT5SEP0
SUN6SEP0

LOGISTICS MASTER · NATIONALS · WMS

Data Grids

Loading…

Shipment Notices

New shipment notices and changes extracted from incoming email, plus anything routed for review.

Loading…

    Document Folders

    Warehouse Documents drive — source documents and Gmail-archived attachments.

    Roadmap · Design Placeholder

    Gmail Shipping-Doc Ingestion

    Not built yet
    shipping-docs@stylekoreanus.com
    A dedicated inbox would receive BOLs, invoices, PODs, and entry summaries from carriers & brokers.
    Not connected
    1 · Receive
    Incoming Email

    Gmail push notification (or polling) fires when a carrier/broker email with an attachment lands.

    2 · Parse
    Classify & Extract

    Detect document type (BOL, Invoice, POD, Entry Summary), extract PO# / container# / tracking#, match it to a shipment.

    3 · File & Update
    Drive + Schedule

    File the document into its Warehouse Documents folder, and push the extracted identifiers and status into the matching Import or Outbound schedule row.

    Design placeholder only — there is no Gmail connection, parser, or classifier behind this yet. Building it would need a Gmail API integration, a document classifier, and a write path into both Drive and the source Google Sheet. This is separate from the real, already-built "Shipment Notices" feed above, which extracts status/date changes from email bodies rather than parsing document attachments.

    Shared Vocabulary

    Status Workflow

    ScheduledWork in ProgressPendingShippingShippedDeliveredReceivedCancelledCompletedN/ACustoms ClearanceFDA Review / HoldFWS Review / HoldFDA DetainedAQI ExaminationDelayed

    Normalized from raw sheet text (lib/domain/status.ts). The five colors group statuses by what they mean operationally — complete, needs attention now, delayed/pending, held for review, or in progress — not by which department's sheet a row came from.

    Email ↔ canonical sheet reconciliation

    Tracked Shipment Updates

    Latest unmatched or stale events reviewed through 08/22/26. Resolve the urgent items first.

    3 urgent9 missing19 tracked

    This list was hand-reviewed through 08/22/26 and hasn’t reconciled against the live workbook since — some of these may already be resolved. Re-check each row against the source sheet before acting on it.