Sean Foster
Email me
Previous projectNext project

10 · Retail tech

Exchange shipments, tracked out and back

In an advanced exchange, the replacement ships before the broken unit comes back. I built the tracking behind it: tracking numbers on the ERP order become shipments in the CRM, subscribe themselves to UPS updates, and every scan lands on the record through a secured webhook. Staff see every return still out, and customers get reminders until it ships back.

Client
Installs and services checkout tech for national retailers and restaurant chains
Built with
  • UPS Tracking API
  • Salesforce
  • NetSuite
  • Apex
  • Platform Events
  • Lightning Web Components

What it changed

  1. 01

    Shipments are rebuilt from the ERP order's tracking fields: missing ones added, duplicates and orphans removed.

  2. 02

    Tracking numbers subscribe to UPS 100 at a time on a schedule and re-subscribe until the package is delivered.

  3. 03

    Returns still out get reminder emails at 2, 10 and 18 days, then a follow-up task for the team.

How it fits together

  • Built by me
  • Platform or outside system
  • People
NetSuiteOrder, tracking numbersShipment syncQueued ApexShipmentsStatus, delivery dateSubscription jobScheduled, 100 at a timeUPS Track APIPackage updatesWebhookChecks a shared secretReturn trackerOpen returns, remindersCustomersReminder emailsTrackingnumbersAdd, removeduplicatesNot yet trackedSubscribeScan eventsPlatformeventReturns still out2, 10, 18daysNetSuiteOrder, trackingnumbersShipment syncQueued ApexShipmentsStatus, deliverydateSubscriptionjobUPS Track APIPackage updatesWebhookChecks a sharedsecretReturn trackerOpen returns,remindersCustomersReminder emailsTracking numbersAdd, removeduplicatesSubscribePlatform event2, 10, 18 days

More of my work

See all
11 · EnergyOne questionnaire engine, any processAdmins define scored questionnaires as records, and one component renders any of them.Salesforce Lightning Web Components Apex
12 · EnergyPay-by-link checkout for parts quotesCustomers open a secure link, review their parts quote and pay by card.Salesforce Sites Visualforce Lightning Web Components
13 · EnergyAsset counts across a whole account treeLive asset counts rolled up through a customer's whole account tree, for 5 business units.Salesforce Apex Batch Apex

Contact

Need something like this built?

I take on full-time roles and focused projects. Email is the fastest way to reach me.

Email meLinkedIn