Shipment Tracking & Notification System

1. Executive Summary

Global Promo currently relies on manual processes to track shipments, update distributors, and monitor delivery status across U.S. and China-origin orders. This proposal outlines a system that integrates Zoho Books with a tracking aggregation platform and automated notification engine to:

• Eliminate the Excel tracking spreadsheet and automate tracking number capture for both U.S. shipments (via ShippingEasy integration) and China shipments (via barcode scanning)
• Provide a centralized, real-time shipment dashboard
• Automate distributor email notifications at key shipment milestones
• Reduce manual tracking work by 80% across both U.S. and China shipments

The recommended approach leverages Global Promo's existing Zoho One ecosystem, supplemented by AfterShip (a multi-carrier tracking aggregator), to minimize implementation complexity and team retraining. The entire system can be built using no-code configuration tools — no custom software development is required.

Implementation Roles

This proposal defines what should be built and why. The technical configuration — setting up Zoho Flow workflows, AfterShip rules, and dashboard views — should be carried out by the appropriate resource(s):

How the 80% Reduction Is Achieved

The current workflow consists of five core manual tasks performed by CSRs for every shipment. The proposed system automates four of the five for both U.S. and China shipments — using ShippingEasy integration for U.S. orders and barcode scanning for China orders — leaving only exception handling as a manual task.

U.S. Shipments (via ShippingEasy / UPS / FedEx)

U.S. result: 4 of 5 tasks automated (80%). Full automation is achievable immediately by integrating ShippingEasy with Zoho Books. Note: this percentage is based on task count, not measured time. Some tasks (e.g., checking carrier websites multiple times a day) consume more time than others. Actual time savings should be measured during Phase 5 to validate the impact.

China Shipments (via freight forwarder)

China result: 4 of 5 tasks automated (80%). Barcode scanning eliminates manual tracking number typing — the primary source of data entry errors — without requiring the freight forwarder to change their process. The only remaining manual task is exception handling, which still requires human judgment.

Combined Impact

Across both U.S. and China shipments, the 80% manual work reduction target is achievable. U.S. shipments are automated via ShippingEasy integration. China shipments are automated via barcode scanning of the freight forwarder's shipping labels. In both cases, 4 of 5 repetitive tasks are eliminated, leaving only exception handling — which is itself improved by proactive system alerts. Note: these percentages are based on task count. Some tasks (e.g., checking carrier websites multiple times a day) consume more time than others. Actual time savings should be measured during Phase 5 to validate the impact.

2. Current State Analysis

Current Workflow

Pain Points Identified

3. System Architecture Overview

The proposed system consists of four integrated layers:

Layer Descriptions

1. Data Source Layer (Zoho Books): The system of record for orders, invoices, and tracking numbers. For U.S. shipments, tracking numbers flow in automatically from ShippingEasy via Zoho Flow. For China shipments, the China team scans the barcode on the freight forwarder's shipping label using a Zoho Creator mobile form, which writes the tracking number directly to Zoho Books.
2. Automation Layer (Zoho Flow): Monitors Zoho Books for new or updated tracking numbers. When detected, it pushes the tracking number and shipment details to AfterShip via API and orchestrates downstream actions.
3. Tracking Layer (AfterShip): Aggregates tracking data from 1,200+ carriers worldwide (including all major U.S. and China carriers). Provides normalized status updates and sends webhook notifications on status changes.
4. Notification & Dashboard Layer: Delivers automated distributor emails at key milestones and provides an internal dashboard for real-time shipment visibility.

4. Recommended Tools & Tech Stack

Core Stack

Estimated Monthly Costs for New Services

The tools below are the only new costs this proposal introduces. Everything else (Zoho Books, Zoho Flow, Zoho Creator, Zoho Analytics) is already included in Global Promo's Zoho One subscription at no additional charge.

Subscription Status

Since Global Promo already subscribes to Zoho One, Zoho Flow, Zoho Creator, and Zoho Analytics are included at no additional cost. The only new expense is AfterShip, starting at ~$11/month.

Centralized Dashboard: Where to See All Shipments

A key requirement is a centralized dashboard with real-time shipment status — replacing the current process of checking carrier websites individually and referencing Excel. The proposed system provides two layers of visibility:

The AfterShip Dashboard is the single, centralized location where anyone on the team can see the status of every active shipment — no more checking individual carrier websites or referencing a spreadsheet.

AfterShip Tracking Dashboard: all shipments, carriers, and statuses in a single view. Source: aftership.com

5. Data Flow Explanation

End-to-End Data Flow

Detailed Data Movement

Step 1 — Order Creation (Sales): The sales team creates a Sales Order or Invoice in Zoho Books. Distributor contact info (name, email) is captured on the order. Order status is set to Confirmed. Note: at this stage, no tracking number exists yet — the order has not shipped.

Step 2 — Shipment Dispatch (Warehouse): This is a separate step performed by warehouse staff, not sales. The carrier generates the tracking number — Zoho Books does not. How the tracking number reaches Zoho Books depends on the shipment origin:

• U.S. shipments: Labels are created in ShippingEasy (or directly on UPS/FedEx websites). ShippingEasy can be integrated with Zoho Books via Zoho Flow, so tracking numbers flow back automatically. No manual entry required.
• China shipments: The freight forwarder creates labels and provides the physical shipping labels with tracking numbers. Rather than typing these numbers manually, the China team scans the barcode on each label using a Zoho Creator mobile form (included in Zoho One). The tracking number is captured directly into the Zoho Books order record — no manual typing required, and no changes needed from the freight forwarder. Once the number is in Zoho Books, the rest of the automation chain (monitoring, notifications, dashboard) works identically to U.S. shipments.

Getting the tracking number into Zoho Books accurately is the most important step in the entire process. If this step fails — a wrong number, a missed entry — none of the downstream automation works. That is why this proposal recommends eliminating manual entry wherever possible (see Tracking Number Entry Automation below).

Step 3 — Tracking Number Detection: Zoho Flow monitors Zoho Books for updated tracking fields using either:

• Webhook trigger: Zoho Books fires a webhook when a package is marked as shipped (preferred)
• Scheduled polling: Zoho Flow checks every 15 minutes for new tracking numbers (fallback)

Zoho Flow extracts: tracking number, carrier name, distributor email, and order ID.

Step 4 — Tracking Registration: Zoho Flow sends the tracking number, carrier name, distributor email, and order details to AfterShip. AfterShip begins checking the carrier for status updates automatically.

Step 5 — Status Monitoring: AfterShip checks carrier systems at regular intervals (typically every 3–6 hours; more frequently near delivery). When a status change is detected, AfterShip fires a webhook to Zoho Flow. Status events are normalized into standard categories: In Transit, Out for Delivery, Delivered, Exception, Expired.

Step 6 — Distributor Notification: Based on the status event, the appropriate email is triggered (see Automation Logic below). Emails are sent via AfterShip's built-in notification system or via Zoho Flow + Zoho Books email templates.

6. Automation Logic

Trigger Matrix

Edge Cases & Handling

Email Template Requirements

Each automated email should include:

• Distributor name
• Order/invoice number
• Tracking number (linked to carrier tracking page or AfterShip branded tracking page)
• Expected delivery date (if available from carrier)
• Global Promo support contact information
• Company branding (Global Promo logo, colors)

7. Implementation Phases

Each phase below identifies what needs to happen and who is responsible. The Marketing & System Specialist defines requirements, oversees quality, and validates outcomes. Technical configuration is carried out by a Zoho-certified consultant or IT resource, with the India-based team assisting on execution tasks as directed.

8. Estimated Timeline

Note: These durations assume a Zoho consultant or IT resource is engaged and available on a regular basis. Since Global Promo does not currently have a dedicated IT person, the actual pace will depend on consultant availability and scheduling. Phases can overlap, and Phase 1 can begin immediately with no dependencies.

9. Risks, Limitations & Assumptions

Confirmed Details

• Global Promo subscribes to Zoho One (Zoho Books, Zoho CRM, Zoho Learn actively used; Zoho Flow and Zoho Analytics available)
• U.S. shipments are processed either through ShippingEasy or directly via UPS/FedEx websites, depending on the order
• China shipments are handled by a freight forwarder who creates the shipping labels; the China team currently enters the tracking numbers into the system manually
• Primary carriers: UPS, FedEx, DHL
• Shipment volume: approximately 120–150 per month
• China team does not currently use Zoho apps; management is open to onboarding them
• India-based team assists with email campaigns but has limited Zoho experience

Remaining Assumptions

• Distributor email addresses are stored in Zoho Books on the relevant order/invoice
• Global Promo's ShippingEasy plan includes API access (needs to be confirmed; some plans do not)
• The China freight forwarder provides tracking numbers for all shipments (not just some)

Risks

Limitations

• Real-time is relative: Carrier tracking updates are not truly real-time. Carriers update their systems in batches. AfterShip polls at intervals (every 3–6 hours). "Live tracking" means near-real-time, not to-the-minute.
• China-to-U.S. handoff gaps: When a package transfers from a China carrier to a U.S. carrier (e.g., China Post/EMS → USPS), there can be a tracking gap of 1–5 days while the package clears customs. This is a carrier limitation, not a system limitation.
• No retroactive tracking: This system tracks shipments going forward. Historical shipment data in the current Excel sheet would need to be manually migrated or archived separately.

10. Conclusion

11. Glossary of Key Terms