How to improve my non-unique metadata MySQL entries?

How would you save such a repetitive data pair inside MySQL?

As separate key/value pairs, which is what you have already done.

The only situation I would reconsider this, is if you need to filter or search for restock posts via these IDs. If that is the case then I would use a private/hidden taxonomy where each term has the post ID as the slug. Post meta is not good for searches/filtering.

Related Posts:

  1. What is the index [0] for on post meta fields?
  2. Custom field metabox not showing in back-end
  3. How to hide meta box values from custom fields list?
  4. importing data from non-wordpress mysql db
  5. Create meta boxes that don’t show in custom fields
  6. Ordering posts by anniversary using only day and month
  7. Move value of one custom field to another
  8. Displaying posts with only upcoming dates according their custom field date value
  9. Custom fields to save multiple values
  10. Difference between ‘LIKE’ and ‘IN’ in meta queries
  11. wp_handle_upload error “Specified file failed upload test” but still creates attachment?
  12. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  13. MySQL query to set wp_postmeta using term_taxonomy_id value
  14. MySQL Query that looks for post with Custom Field, then changes Category
  15. Unique Post Meta Values
  16. Create Multiple File Upload Metabox in WordPress
  17. How to add a new meta key and assign timestamp to posts
  18. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  19. Add custom field to all posts in specific post_type
  20. Button inside Custom Meta Box triggering the Update Button
  21. Why is my Custom Meta Box Field Inputs NOT saving?
  22. get_posts in meta box dropdown not showing latest posts
  23. How can you include custom post meta in search without calling each key?
  24. Display Custom Meta Box Field Only If Value is Present
  25. Ordering posts by custom field named “date” in backend
  26. Unique meta_key with array value vs repeated meta_key with single values
  27. shortcode in a custom metabox
  28. Avoiding ACF get_field and returning to core WordPress function
  29. Problem with saving large amount of data in postmeta/usermeta
  30. Move Title and the Content WYSIWYG editor position
  31. How to validate select field in post meta?
  32. How to use media upload on metabox post page without breaking TinyMCE?
  33. Let’s Create Custom Field Template Documentation
  34. How add multiple wp_editor_box to new post
  35. change order of images attached to post
  36. Can I save post meta programatically without setting metaboxes?
  37. Meta box values are displayed on Custom Fields list. Is it possible to hide them?
  38. If metabox has content display content
  39. put saved metabox values back into fields and then display on the front end
  40. Set class if a meta value is set within post archive
  41. WordPress Blocks, setAttributes not saving
  42. Allow HTML in Custom Metabox area
  43. Custom field metabox not showing in back-end
  44. Save, update, get and sanitize post meta as HTML not plain
  45. Create Meta boxes dynamically
  46. Get meta value when the page is a blog archive
  47. Can’t save meta field value if the title not set
  48. Display Data From This Custom Media Upload Meta Box?
  49. When post is updated, custom metadata in text area field is overwritten
  50. wp_postmeta are updated for only one page
  51. When editing a post with a custom meta box the values aren’t displaying correctly
  52. Dynamic background image used in css after selector
  53. How to add new Metadata options (Date, Author, etc.) for Posts?
  54. WP Query Args – search by meta_key or title
  55. Saving multiple custom meta box fields
  56. How can I avoid re-inventing the Custom Fields wheel in my Plugin’s Metabox?
  57. Transients vs CRON +Custom Fields: Caching Data Per Post
  58. Unable to save datetime custom meta field using update_post_meta() function
  59. Create custom field on post draft or publish?
  60. get_post_meta fields don’t show up on posts page
  61. copy attachments to another post type and change attachment url
  62. Cannot edit post meta fields with rest API
  63. Add a post meta key and value only if it does not exist on the post
  64. Function to change meta value in database for each post
  65. Get aggregate list of all custom fields for entire blog
  66. Sorting posts by multiple values, combined
  67. WP_Meta_Query causing long-running MySQL queries
  68. Woocommerce with metabox plugin
  69. ACF: How to get the full field name (meta_key) by a field key?
  70. Tweak Meta for Post to work it for Pages also
  71. Custom Meta Box (SELECT) Not Saving
  72. UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
  73. Alter main archive, to show posts with meta as last
  74. Displaying multiple URLs as custom field values
  75. Stop sending email everytime I updates my post
  76. Best way to store everyday post views?
  77. Unable to get specific value from post meta
  78. Custom meta is not being saved
  79. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  80. IF Custom field value equals ZERO
  81. Branch made by several custom values
  82. User customising position of WordPress Featured Image
  83. Insert image into sub-field with update_post_meta
  84. How to use conditional statement with custom field
  85. Help setting up a sql query
  86. How can I add/update post meta in a admin menu page?
  87. Get author total post votes from post meta
  88. Making WP_Query limit results by date before today where date is a meta_query
  89. How to display custom fields in hestia theme
  90. Show posts from WP Custom Post Type selected from a field in a metabox
  91. Metabox/Custom fields are not saving input data
  92. meta_query to check all custom fields
  93. Update custom table on metabox POST
  94. how to modify a field’s size in a metabox : ROWS height, and scroll control?
  95. Saved Post Meta Array Returns as String
  96. change attachment custom field onChange event
  97. Custom Meta Boxes and Fields for WordPress: Change directory upload based on user-edit page
  98. added a meta box to post however when saving menu while debug on throws a warning
  99. loop through custom post-type with two meta_keys
  100. Make Custom Fields Public in JSON – API
techhipbettruvabetnorabahisbahis forumuedusedusedusedusedueduedueduseduedus