Looks like you are not familiar with WordPress Bulk Edit.
Change the Screen Options to show all the products you have (if there are too many this can be slow, and is better to do it following some 100/200 product per page).
Select all the products, select Edit in the Bulk Edit dropdown and Apply.
Now you can change a batch of product details.
Related Posts:
- Woocommerce: Grab total revenue of a product over all orders
- Column count doesn’t match value count at row 1
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- MySQL string replace
- Access denied for user ‘root@localhost’ (using password:NO)
- MySQL ERROR 1290 (HY000) –secure-file-priv option
- Which MySQL data type to use for storing boolean values
- ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
- Cannot delete or update a parent row: a foreign key constraint fails
- PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
- Your password does not satisfy the current policy requirements
- MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
- What is the definition of cardinality in SQL
- How to restart remote MySQL server running on Ubuntu linux?
- Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
- PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
- Selecting data from two different tables without using joins
- Difference between VARCHAR and TEXT in MySQL
- MySQL: Invalid use of group function
- How can I loop through all rows of a table? (MySQL)
- Simple Random Samples from a Sql database
- What does SQL clause “GROUP BY 1” mean?
- LAST_INSERT_ID() MySQL
- SQL select only rows with max value on a column
- Trying to perform MINUS operation in MySQL
- How do I find which transaction is causing a “Waiting for table metadata lock” state?
- mysql count duplicates
- phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
- MySQL config file location – redhat linux server
- Create boolean column in MySQL with false as default value?
- Is there a naming convention for MySQL?
- Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
- MySql – HAVING vs WHERE
- How to stop mysqld
- Is merge statement available in MySQL
- GROUP_CONCAT comma separator – MySQL
- Complex meta query with 3 keys
- Set page template for all pages?
- Optimize Multiple Taxonomy Term MySQL Query?
- WordPress MySQL & PHP Performance
- What specific database privileges does WordPress need?
- Using source control with WordPress
- My WordPress site always displays a cached version of its homepage
- Updating User Meta with SQL Query
- wpdb prepare syntax
- How to run this SQL query of wp_terms database
- Proper way to work with wpdb to get user’s firstname
- How to change post format from Aside to Image for all posts?
- Inserting Hundreds of Thousands of Posts at Once
- wp_admin edit.php slow with lots of queries
- How to add and SQL query of posts only published
- Slow Mysql Queries
- can database and media folder be moved to a different drive?
- Find duplicate posts with same slug and author
- writing inner join in wpdb
- How to get data from WordPress site sql file
- Unknown collation when I import a dump from an existing site into a development database?
- PHP script can’t connect to Database on port 3307
- WordPress with php5-fpm and nginx
- When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
- WpDataTables – View Image Directory
- Automatic switch to backup database on fail
- How to translate this mySQL query to $wpdb query
- $wpdb to insert html form information
- Proper usage of $wpdb->update()?
- MySQL 5.5 upgrade ‘broke’ WordPress [closed]
- Separate DB by yearly archive of WordPress
- WordPress plugin overloading with tmp tables
- Site not responding error – taking long to load [closed]
- WP-DownloadManager – Query most download per week/month etc
- Update MySQL query so that it functions again
- Query posts by custom taxonomy and sort by post_modified
- WordPress $wpdb get posts from category and sort by custom meta
- Getting error “Warning: mysql_query(): Can’t connect to local MySQL server through socket ‘FILEPATH/cccatalog-plugin.php on line 1656”
- External wpdb connections in different plugins on single page
- Array Formation Issue
- Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
- WordPress $wpdb no result
- Integrating Custom Database with WordPress
- how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
- How to get the custom field value using SQL query
- Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
- when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
- edit_user_created_user hook – using to update Groups
- WordPress database problem wp_posts, primary key
- Mysql Error in querying form entries in Gravity Form plugin
- Improving performance of SQL sub-queries in WordPress
- Saving custom term value to the database in new table
- Help with sorting and storing data on WordPress
- MySQL errors after a WordPress clone
- MYSQL Join on meta key value?
- Complicated MySQL Query
- problem with quotes on new post
- How can I delete the options from DB when the plugin is deleted?
- Initialization of table in database using ‘CREATE … IF NOT EXISTS’
- mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
- How do I load a sql.gz file to my database? (importing)
- Split Million WordPress Post’s Into Multiple Database Server
- Batch Replace URLs in WordPress Database
- $wpdb->get_results() query empty, but same query in phpmyadmin has results

