Design autocomplete and merchant bulk edits
Company: Pinterest
Role: Software Engineer
Category: System Design
Difficulty: medium
Interview Round: Onsite
### System Design Prompts
#### 1) Design search engine input suggestions (autocomplete)
Design a system that provides real-time query suggestions as a user types in a search box.
Cover:
- APIs and end-to-end request flow
- Ranking logic (e.g., popularity, personalization)
- Data sources and offline/online components
- Latency and scale expectations
- Handling updates (trending queries, new queries)
---
#### 2) Design a merchant product update system (bulk + single-item edits)
Design a system that allows merchants to update product data:
- Single-item edits (CRUD for one product)
- Bulk edits (e.g., upload a file / run a job that updates thousands of SKUs)
Cover:
- APIs, data model, validation
- Concurrency/conflict handling (simultaneous updates)
- Observability and audit trail
- Partial failures, retries, idempotency
- Rollback / revert capability
Quick Answer: This question evaluates a candidate's system design competency across real-time search/autocomplete and large-scale product update pipelines, covering API design, ranking logic and personalization, data modeling, offline/online components, concurrency and conflict handling, consistency, fault tolerance, observability, and auditability.