Requirement
Power Pony required an automated solution to route sales orders to the correct warehouse (West Coast or East Coast) based on:
- SKU type (specific Power Pony items such as PP-PPU-4, PP-PWU-4, PP-PRW-4)
- Ship-To State (e.g., California → West Coast, New York → East Coast)
The goal was to eliminate manual intervention, ensure accurate warehouse assignment, and improve operational visibility in real time.
Solution Design
The solution was implemented using SuiteScript within NetSuite, with custom records, fields, and lists created to support dynamic routing logic.
Key Features
- Order Routing Automation
- Orders containing specific Power Pony SKUs are routed based on shipping state.
- West Coast states → PP West Coast Warehouse
- East Coast states → Mason: Main Warehouse
- All other items default to Mason: Main Warehouse (East Coast)
- Automatic Region Assignment
- A custom field Order Region is dynamically populated as “West Coast” or “East Coast.”
- Region assignment is based on SKU and Ship-To State.
- Dynamic Update of Sales Orders
- On order creation, SuiteScript evaluates SKU and shipping address.
- Location and Order Region fields are updated instantly.
- Real-Time Processing
- Routing occurs immediately when the sales order is created.
- No manual updates required.
Customization Details
- Order Region (Custom Field – List)
- Flags region (“West Coast” or “East Coast”) dynamically.
- Ship Region List (Custom List)
- Editable list storing regions for routing logic.
- PowerPony State Group (Custom Record)
- Stores state-to-region mapping for warehouse routing.
- Editable by administrators.
- Administrator Flexibility
- Admins can add/remove SKUs from the script parameters.
- Ensures adaptability for future product changes.