Inbound imports
Uploading the warehouse export, how matching works, and how to rescue rows that did not match.
This is the step that pays people.
Uploading
Inbound → drop the XLSX exported from Blue Ocean. Columns expected:
Track#, Warehouse, Warehouse Type, Inbound Type, UPC, Product Name,
Received Qty, Total Inbound, Supplier, Price, Inbound Time
The file's own Price column is ignored — payouts come from our deal prices,
not the warehouse's.
What happens on upload
Rows are parsed and flagged
UPCs carrying damage markers (DAMAGED…, DAMAGEBOX…, …BD, D…B) are
stripped back to the real UPC and flagged for attention rather than credited.
Tracking is validated
UPS, USPS, FedEx, and Blue Ocean drop-off identifiers like
CA-WKMHJ-CHAD-090226110853. Anything else is filed as unknown_tracking.
The deal price at that moment is looked up
From price history, using the row's Inbound Time — not today's price.
Rows are matched
By tracking number to a submission, then by UPC to a pending line on it. Matched lines credit the balance, mark the item received, write a transaction and email the reseller.
Re-matching
Re-match unmatched sweeps rows that were stranded when they were first imported. Two things strand a row:
- A drop-off receipt uploaded after the export. The reseller only learns their drop-off number at the counter, which is often after the warehouse has already exported the day. Nothing carried that number when the sheet was imported.
- Rows filed under the old rules. Drop-off identifiers used to be rejected as invalid tracking and were never offered to the matcher at all.
It is safe to press repeatedly: each submission line is consumed once, so a second run cannot pay for the same goods twice.
Rows that need attention
Anything flagged is held rather than credited, and appears on the import's detail page where it can be approved with a custom amount, or rejected.
A row with no deal price is never auto-credited
If no deal matches the UPC, the row is left for a human. Silently crediting zero would look like a payment that had happened.