I’ve checked and WordPress does, by default, retrieve & cache all post meta along with the main query’s posts, so you’re perfectly fine storing a product’s additional fields as standard post meta.
You might want to store Brands (merchants? manufacturers?) as a custom taxonomy so that you can take advantage of built-in templates and queries to show all products of a certain brand.
Related Posts:
- WordPress Unit Testing – Cannot Create Tables
- Insert data in database using form
- When is it appropriate to create a new table in the WordPress database?
- Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
- BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
- How does WordPress create its database during installation?
- stdObject stored in database. How does one convert it to usable format?
- Database with mixed collation (utf8mb4 & utf8_general_ci)
- Moving to another host; which tables to move in a database
- WordPress mysql table double prefixes
- Change WordPress prefix for only one table?
- input data and output table [closed]
- Retrieve data from the database to table such as comments in the admin control panel
- Change options table prefix only
- Query multiple tables at once?
- Why does changing Database Table Prefixes result in loss of content?
- WordPress url transformation script
- Should I use an additional column in the DB?
- Will adding & modifying default WordPress table index break future WordPress update
- What is wrong here? Issue with post_id and meta_value
- How to edit custom table data in frontend
- How do you enable scripts on a WordPress installation in Softaculous?
- How to map data on CSV to web pages?
- Create hundreds of users with just ID in phpMyAdmin
- Have WordPress Use a Different Database for users
- Is it fine to have foreign key as primary key?
- Custom form that store input in database
- Restoring WordPress posts from database only
- Can a post ID be 0?
- Issue with wp_insert_post and post_content field error Could not update post in the database
- wp_posts – guid update
- what is the wp_5_posts table in the database?
- Migrating data between local and development server
- WordPress Database Charset/Collate
- What is the database table for pages?
- Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- storing database in version control
- Is deleting orphaned wp_options entries safe?
- How to build a movie database with wordpress?
- Sub-domain or 2nd, temporary different domain?
- Hook to be used when creating a database table
- Delete all post meta except featured image
- Where is custom template file chosen for a post stored in the DB?
- How do i get user data from a custom table in the wordpress database by user ID?
- Converting WordPress into Android or iPhone app
- Safe way to find last inserted id in a table?
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- WooCommerce sku location in DB
- WordPress DATABASE Update Manually?
- I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
- Multiple postmeta with same name for one post in wp_postmeta table
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- Can I have multiple database users within WordPress?
- Adding a Table to the wordpress database
- A field with dashes in the slug [closed]
- Structure of postmeta meta_value for woocommerce product download
- Handling large N data in WordPress
- How to replicate a user plugin made table value, to this user’s custom meta table value?
- WordPress ‘repairing database’ in a constant error loop?
- Is there a way to recover the table wp_term_relationships?
- Trouble Migrating all data blog from WordPress.com to WordPress.org
- Historic WordPress database connection
- Check if an option exists and get its value in one hit
- $wpdb error (Call to a member function insert() on a non-object)
- Problems with moving my WordPress site to another domain/server
- Is it important to have integers inserted using %d rather than %s?
- How To Run A Temporary Instance Of a WordPress Backup Without a Database?
- Share users across multiple sites on same database, but with different domains
- Global__r connection timed out
- Connect to database in the header of my WordPress website
- Moving WordPress site to new domain – database import [duplicate]
- Location of WP default mySQL tables creation file?
- WordPress where clauses in db select
- How to display data from db in select list [closed]
- echo site_url() returns a different value than what is in the database siteurl field
- Native timestamp on wp_options option
- _wp_attachment_metadata is not being added to database when PDF files uploaded
- SELECT rows between two datetimes when the range is dynamic [closed]
- adding user_id and name to a separate table whenever a user register based on role
- How do I loop/iterate through posts to edit all img tags?
- error establishing a database connection 3
- How to edit posts/pages without making the change live?
- Correct and secure way to access a custom SQL database in a custom PHP template file
- How to optimise this database query?
- How to retrieve user data based on role using SQL?
- Does WordPress Support Using Named Pipes on the Windows Operating System?
- Store id from database query in cookie
- Split database on large site?
- Store the wordpress “featured image” under »wp_posts« Database table
- Custom metabox does not store data
- What WordPress file is saving new users to database
- wordpress database error
- How do i get value from wp_postmeta?
- Local host to server import problem
- Display single post inside accordion based on form submission results
- featured image not showing up with mysql_connect
- Options of accessing wordpress data from mobile app
- wp_usermeta key problem
- Database Queries are crashing the server