← All work

Beverage co-packing & manufacturing

Blueprint, a redesign of product master data in NetSuite

A redesign of how product, pricing and scope-of-work data flows through NetSuite, from customer blueprint to SOP. Each value is entered once and inherited by every downstream record.

  1. Blueprint
  2. Pricing Calculator
  3. Item & BOM
  4. Order
  5. Work order
  6. SOP
Client
Sojo Industries ↗
Beverage co-packing & manufacturing
Stack
SuiteScript 2.x (UE, CS, SL, RL, MR), SuiteCloud SDF, Node.js, DocuSign

Results

  • About 48 SuiteScripts and 171 SDF custom objects
  • Closed the 11 process gaps mapped in the current-state review

The problem

Product, pricing and scope-of-work data was re-entered by hand on every record: pricing calculator, item, BOM, order, work order, SOP. A current-state review found 11 gaps where that caused mismatched BOMs, prices and SOPs.

What I built

  • One flow: Blueprint → Variation / Pricing Calculator → Item → BOM → Customer Order → Work Order → SOP. Each step inherits from the one before it.
  • About 48 scripts:
    • User Events for propagation, price inheritance, BOM-revision signature checks and DocuSign signed-contract hooks.
    • Suitelets to create items, BOMs and SOPs.
    • RESTlets for seeding and match-or-create.
    • Map/Reduce backfills.
  • 171 custom objects deployed through SDF in batches, with backups taken before each production change.
  • Data migration across sandbox and production, with reports for every backfill.
  • An interactive reference app for the business: data-flow diagram, ERD, decision tree and field-source map.