Automating Shipments and Inventory with Notion

The magazine faced challenges in systematically managing its sponsor program, which involved receiving items from sponsors based on contracts, boxing them, and sending them to recipients. There was a need for a centralized system to track:

• Items promised by sponsors.
• Items received from sponsors.
• Items sent to recipients.
• Revenue per contract and per shipment.

The existing process lacked a structured approach, leading to difficulties in tracking inventory and financial data related to the sponsor program.

A two-level system focusing on "shipments" and "boxes" was developed within Notion to address the tracking challenges. Key components of the solution included:

• Hierarchical Structure: Each shipment was designed to contain multiple boxes, with each box holding a specific quantity of items.
• Box Templates: Templates were created for commonly used sets of items to expedite the process of adding new boxes to shipments.
• Inventory Module: An inventory feature was built to manage and monitor the received contract items and how much was left.
• Data Integration: The system was integrated into the magazine's existing Notion account, connecting with two primary databases.
• Automated Calculations: The solution utilized Notion's features such as databases, relations, formulas, and roll-ups to automatically pull and process data for tracking and reporting.

The implementation of the Notion-based system led to several positive outcomes:

• Comprehensive Tracking: The magazine gained the ability to track all necessary information regarding contracts, including items received and sent.
• Revenue Visibility: The system provided clear visibility into campaign revenue and per-box revenue for each shipment.
• Automated Dating: The sent date for boxes was automatically linked to the shipment's date.
• Inventory Management: Users could effectively manage inventory with automatic stock alerts and notifications.
• Efficient Workflow: The system was tailored to the client's specific requirements, resulting in a more efficient, controllable workflow.