= UseCase009 - Modification of a Product

**Initiating actor:** Logged-In Admin

{{{#!div style="text-align: justify; width: 100%;"
The goal of this use case is to allow an administrator to update the details of an existing physical product in the inventory. This ensures that information such as current pricing, stock availability, and format descriptions remain accurate, reflecting real-time changes in the store's supply and business requirements.
}}}

== Scenario

{{{#!div style="text-align: justify; width: 100%;"

1. Admin selects an existing Product from the inventory management interface that requires an update.

2. System retrieves the current data for the Product, including price, stock, description, and format.

{{{#!div style="margin-left: 20px;"
{{{
SELECT product_id, format, price, stock, description, release_id
FROM Product
WHERE product_id = @selected_product_id;
}}}
}}}

3. Admin enters the new values for the attributes that need to be modified.

4. System validates the updated information to ensure it adheres to the required data formats (e.g., non-negative values for price and stock).

5. System updates the corresponding record in the Product table with the new data.

{{{#!div style="margin-left: 20px;"
{{{
UPDATE Product
SET 
    price = @new_price,
    stock = @new_stock,
    description = @new_description,
    format = @new_format
WHERE product_id = @selected_product_id;
}}}
}}}

6. System confirms the successful modification to the admin and updates the product information across the public catalog immediately.

{{{#!div style="margin-left: 20px;"
{{{
SELECT * 
FROM Product 
WHERE product_id = @selected_product_id;
}}}
}}}

}}}