I am writing a Wordpress plugin to store product data that is pulled from the Amazon Affiliates API. My goal is to have an admin page where I can add new products and view/edit/remove existing products.
Essentially I will assign each product a custom slug such as "amazon-miter-saw-blade", then I can use a shortcode such as
[wp_product id="amazon-miter-saw-blade"]. This will output something along the lines of
For each custom shortcode slug I want to store a product name, price and ID. The name and ID will remain static and the price will be updated every hour on a scheduled cron. As there will potentially be hundreds of products, what are the common options for storing such data? So far I have found that I can create a custom database table, use
add_option or transients. Transients would be fine for the price but since the rest is static, would a custom database table or options be better suited?