Every media kit request, tied to real stock
A consumer crafting technology company manages PR pull requests for shipping media kits to press and influencers in Airtable. Requests route through a form with approval status, auto-link to PR project initiatives, and pull SKUs from a linked inventory table of roughly 300 items. Stock levels update through formulas that track total requested against remaining balance, low-stock alerts fire automatically, and PR, Marketing partners, and Finance share one audit trail instead of email and spreadsheets.
The problem
PR pull requests for media kits required manual copy and paste between a separate PR project tracker and the pull request base, with SKUs entered as free text. Errors were common and nobody had inventory accountability once a kit shipped.
The back-and-forth with a supplier's outdated system added email and spreadsheet churn on top, out-of-stock issues surfaced too late to act on, and Finance had no visibility into where product actually went.
What they built
PR built a form-based intake with approval status that auto-links each request to its PR project initiative, whether a seasonal campaign or a themed activation, by outlet field or name match.
Requesters select SKUs from a linked inventory table using record pickers instead of free text, and stock deduction formulas subtract total requested from starting quantity to calculate a remaining balance, triggering low-stock alerts when a threshold is reached and leaving Finance a clear audit trail.
The outcome
Accountability improved and manual entry errors dropped once SKUs came from linked records instead of free text, and low-stock alerts now catch reorder timing before it becomes a shortage.
PR, Marketing partners, and Finance share the same visibility into fulfillment, email churn is gone, and ambassadors in a pilot region can now self-serve requests instead of relying on staff to place every order.
Inside the solution
PR Media Kit Fulfillment and Inventory Management
Supply Chain & Inventory Management
- Pull request form intake with status tracking
- Auto-linking requests to PR project initiatives
- SKU selection from a linked inventory table
- Stock deduction formulas for remaining balance
- Low-stock alerts at set thresholds
- Audit trail for Finance review
- Manual copy and paste between two bases
- Free-text SKU entry causing errors
- Email and spreadsheet back-and-forth with a supplier's outdated system
- Out-of-stock issues discovered too late
- Lack of visibility for Finance on product destination
- Improved accountability and fewer manual entry errors
- Accurate reorder timing with automated alerts
- Shared visibility across PR, Marketing, and Finance
- Self-serve ordering for ambassadors in a pilot region
- Public Relations
- Influencer Marketing
- Social Media
- Warehouse
- Finance
- Linked inventory table
- Form-based intake
PR media kit fulfillment with inventory tracking and SKU deduction
Take every press, influencer and ambassador media kit request through one intake-to-shipment workflow where SKUs come from a linked inventory catalog instead of free text, so remaining stock, kit value and the Finance audit trail update themselves. Low-stock thresholds raise linked reorder alerts automatically, shipped requests close out their own line items, and native AI fields draft approval briefs, reorder notes and initiative recaps.
From spreadsheet churn to auditable SKU-level fulfillment
Copy the templates
Replace free text with linked SKUs
Wire up alerts and audit views
FAQ
Frequently asked questions
Each pull request links to an inventory record instead of a typed product name. A formula subtracts the requested quantity from the starting count to calculate the remaining balance automatically.
When the remaining balance formula crosses a set threshold, the base flags the item so the team can reorder before it runs out, rather than discovering the shortage on the next request.
The request auto-links to its PR project by matching an outlet field or a name match, so every media kit sent ties back to the campaign or activation it supported.
The pull request base and the inventory table are linked directly, so a request updates stock in real time instead of requiring someone to copy figures between two separate systems.
No. Fulfillment runs on linked records and stock formulas. The structured request and inventory data here is the kind of foundation the account is evaluating for AI-assisted workflows elsewhere in the business.