Stearns Digital

Selected work

Operational systems. Built where the work gets difficult.

Inventory decisions, warehouse execution, supplier data, and commerce integrations—designed around the exceptions that generic software leaves behind.

Zoho Inventory Finale Inventory Shopify Packiyo PromoStandards Python Node.js MySQL

Experience, made concrete.

Client identities and sensitive operating details are omitted. The work, systems, APIs, and technical decisions are not.

Warehouse execution · Distribution

A barcode-guided picking system connected to inventory

A tablet workflow validated every carton against the active order and returned shipment status to the inventory platform.

Systems & technologiesZoho Inventory API · barcode scanners · tablet web application

Supplier automation · Promotional products

One integration layer for multiple supplier protocols

Supplier orders, invoices, products, and shipments were normalized before being written into the inventory system.

Systems & technologiesFinale Inventory API · PromoStandards SOAP/XML · REST/JSON · FTP · Python · MySQL

Ecommerce fulfillment · Historical system

Enriching ecommerce orders for a 3PL workflow

A recovered system moved Shopify orders into a fulfillment platform, then generated QR codes and PDFs for warehouse use.

Systems & technologiesShopify Admin API · Packiyo API · Node.js · MongoDB · PDFKit · QR codes

Traceability · Manufacturing & distribution

Following a serial number from factory box to sales order

A practical model for connecting manufacturing, cartons, warehouse activity, and customer-facing validation.

Systems & technologiesSerial identifiers · relational data model · validation portal

Data pipelines · Manufacturing

Building factory file intake that survives duplicates and delays

Turning recurring box files into a visible, retryable process instead of a fragile upload folder.

Systems & technologiesCSV intake · checksums · staging tables · retry queues

Inventory planning · Decision systems

Turning a forecast into a repeatable decision system

The real product is a trustworthy process for deciding what to buy and when.

Systems & technologiesForecasting models · planning controls · exception workflows

Commerce integration · Order operations

Why order synchronization must be designed for replay

Overlapping exports, late updates, and partial retries are normal. A durable integration assumes they will happen.

Systems & technologiesCommerce APIs · idempotency keys · reconciliation logs

Product operations · Multi-SKU commerce

Making the product catalog an operational source of truth

How a style, colorway, and SKU hierarchy can support sales, inventory, planning, and controlled maintenance.

Systems & technologiesRelational catalog · CSV imports · validation rules

Have an operational gap between systems?

Tell us where the data, handoffs, or exceptions stop flowing.

Start a conversation →