Images with 300 dpi are ideal. A high dpi is optimal for fine art prints because the more dots of colour that can be printed in a small area, the more detailed your final image will appear.
Other products may require lower image resolution. The specific dpi for each product can be found on the product page.