Storing data for a wordpress plugin

Using a taxonomy is probably the best way. Creating a CPT will be the second option. The problem with CPTs is that you will need to store data in the mesta table which will most likely have some performance impact on other things being done on the site. Taxonomy term meta data is less bloated and you will have the advantage of being able to associate the posts with the terms representing the funds being refereed in it.

The disadvantage of using taxonomy is that the UI for editing term data sucks more than the post meta data UI. (yes, you most likely will need UI if only for testing that your csv “import” works well, and it is useful to be able to make small changes without regenerating the whole CSV).

Related Posts:

  1. Why WordPress choose data serialization over json_encode?
  2. Dealing with Many Meta Values, 30+
  3. What is the most secure way to store post meta data in WP?
  4. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  5. Meta query interfering with orderby relevance
  6. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  7. How to solve slow WordPress site caused by attachment_metadata
  8. Delete all post meta except featured image
  9. Is it possible to store visitors IPs in wp_postmeta table?
  10. Multiple postmeta with same name for one post in wp_postmeta table
  11. Delete all post meta except featured image Using SQL
  12. One post carries 30 postmeta values, is this too much?
  13. delete post meta from db, even if does not exist?
  14. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  15. Where does the actual data stored by add_post_meta
  16. Structure of postmeta meta_value for woocommerce product download
  17. Routine to convert custom post meta from old to new value
  18. Saving zero as meta value
  19. Uknown meta entries in wp_postmeta
  20. Does post_meta data need to be unserialzed?
  21. Link image with data from the wpdb
  22. Custom Post Type not showing anything added by code anymore?
  23. Compare User meta_value with Product meta_value
  24. How to save EXIF metadata in WordPress database?
  25. _wp_attachment_metadata is not being added to database when PDF files uploaded
  26. “BS_” rows in postmeta table
  27. Migrating meta_key and meta_value from old theme to new one
  28. Database structure for thousands of posts
  29. How much post meta data is too much?
  30. How do i get value from wp_postmeta?
  31. Recommended Post Structure for DB Storage
  32. SQL query : Select a thumbnail for a media
  33. What is the difference between an ORM and an ODM?
  34. Rename a table in MySQL
  35. How should I tackle –secure-file-priv in MySQL?
  36. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  37. Keeping WP database synced across multiple developers using git
  38. Post meta vs separate database tables
  39. Is it possible to define two databases for one installation?
  40. Connect forms in WP to external database
  41. Hook into $wpdb
  42. How to get site URL if database is disconnected?
  43. Is it wise to delete post revisions and autosaves from database?
  44. Improve or optimize a very slow query
  45. Using two different DB users on one WP install
  46. Usage of Direct Database Call Without Caching Error
  47. Can I transfer a mysql database to another site?
  48. Weird issue with database migration and SSL links
  49. Merge two databases: OLD SITE -> NEW SITE
  50. Backup another database with BackUpWordPress plugin [closed]
  51. Easiest Way to Authenticate WP Users Using an External DB?
  52. How to use a different database to list and manage comments in the backend
  53. How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
  54. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  55. Exporting table to csv works in the admin but exports HTML data when used on the front end
  56. wp search-replace (not executing)
  57. How to have an external DB read and get data from my wordpress database
  58. Import users from old WP site to new one
  59. is $wpdb->get_results() safe enough
  60. Can’t update WordFence Options, clear data manually
  61. Is it possible to have more than 1 MySQL database in my WordPress blog?
  62. How to fetch records from database WordPress
  63. restore a db after bad backup
  64. Best practice to import user base (subscribers) from one website to another?
  65. AJAX wp-mysql running too slow
  66. Some weird users in database
  67. Delete/Replace words from X to Y in post content
  68. Location of image metadata on my server
  69. How to create more than one new wpdb object?
  70. Multiple WordPress sites installs sharing the same database but with different content and domains
  71. Remote database -> massive response time increase?
  72. Is it good practice to import/export a blog to test a redesign?
  73. Getting value from database table depending on field value
  74. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  75. Secure way to use name_save_pre?
  76. wpdb->insert not inserting first variable
  77. Database tables for sports betting integrated in WordPress
  78. New installation fatal error in 5.9.3 at edit or create entry
  79. Storing transients giving database error
  80. I want to replicate a wordpress website over multiple servers
  81. Is there anyway to split posts to different databases?
  82. wp-cli + valet: “Error establishing a database connection”
  83. local wordpress broke after changing URL
  84. Unable to login to a https website via the app after changing from http
  85. mysqli_query(): MySQL server has gone away for Curl Request
  86. Is it safe to add INDEX to a column in WordPress database?
  87. WP website showing blank page after moving from subdomain to main domain
  88. create a table using user meta custom data
  89. WPCLI search and replace in a particlar site dir effect another site-dir
  90. How do I find out from my database what version of WordPress I need?
  91. How to create a database table?
  92. Hang Up Followed By Can’t select database
  93. Database error after importing WordPress
  94. Pulling values from a sepcific row in table
  95. import (migration) user database to wp-users
  96. Create hundreds of users with just ID in phpMyAdmin
  97. What is best for saving lot of extra detail of user?
  98. Insert Extra fields added in the front end registration form to DB
  99. Cant Connect to Database
  100. Combining two select posts from mysql – to get least viewed posts