## Problem Implement an inventory management system for a warehouse. It must track stock levels, process orders (reducing stock), accept restocks, and trigger automatic reorder alerts when stock falls below a threshold. ```python class InventorySystem: def add_product(self, sku: str, quantity: int, reorder_point: int, reorder_qty: int) -> None: def fulfill_order(self, sku: str, quantity: int) -> bool: # False if insufficient stock def restock(self, sku: str, quantity: int) -> None: def get_alerts(self) -> list[str]: # SKUs below reorder_point def inventory_snapshot(self) -> dict[str, int]: # sku -> current quantity ``` ## Example ``` inv.add_product("SKU-A", quantity=100, reorder_point=20, reorder_qty=50) inv.fulfill_order("SKU-A", 85) -> True (stock: 15) inv.get_alerts() -> ["SKU-A"] # 15 [] # 65 >= 20 ``` ## Follow-ups 1. How would you handle concurrent fulfill_order calls for the same SKU? 2. Add support for batch orders across multiple SKUs — atomically succeed or fail all. 3. How would you design the database schema for this, with full order history?

InterviewDB Question

Inventory System: Design a Warehouse Inventory Manager with Restocking Logic

Question Details

Problem Implement an inventory management system for a warehouse. It must track stock levels, process orders (reducing stock), accept restocks, and trigger automatic reorder alerts when stock falls below a threshold. Example Follow-ups How would you handle concurrent fulfill_order calls for the same SKU? Add support for batch orders across multiple SKUs — atomically succeed or fail all. How would you design the database schema for this, with full order history?

Full Details

🔒

Unlock all Shopify questions

Full insider details, leaked discussions, and candidate experiences.

Get full access — $100 a year, unlimited access

About This Question

This is a reported interview question from a shopify interview.

It covers the following topics: Coding, Pair Programming, Sql .

Topics

Coding Pair Programming Sql

Inventory System: Design a Warehouse Inventory Manager with Restocking Logic

Question Details

Full Details

About This Question

Topics

More Shopify Interview Questions