Retrieve basic product details