Retrieving and updating product information.
Keep product information aligned with everyday business activity.
Where this work fits
Inventory work needed more than a product name. Price, quantity, category, availability, and publication status described different things, and users needed to create, find, and update those records.
I built inventory retrieval, update, and deletion operations. Partial updates let the caller change supplied fields, and the service included record-ownership checks around those operations.
Give a product a useful record
Desk lamp
One record also holds its name, category, item type, and publication status.
An unpublished product is not an out-of-stock product.
I kept publication and availability as separate fields rather than compressing them into one status. Create and update requests shared validation rules, while partial updates let a user change a field without resubmitting the entire record.
The skills behind the work
- TypeORM
- Work with relational records through typed queries and repository operations.
- State management
- Represent what is happening now and define which changes are valid next.
- PostgreSQL
- Store relational records and protect related updates with database transactions.
The inventory services supported structured product entry, filtered retrieval, and updates. Businesses could manage those details through defined API operations.