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.
^ click to enlarge ^
Related Posts:
- Woocommerce: Grab total revenue of a product over all orders
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- How to use mysqli_query() in PHP?
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- 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
- Cannot add or update a child row: a foreign key constraint fails
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- String concatenation in MySQL
- wp_postmeta – lot of meta fields
- Linking Plugin Files to WP
- optimise SQL wordpress call
- XML RPC post produces immediate revision with odd post_date_gmt
- MYSQL Join on meta key value?
- Get data from 3rd table
- why is $wpdb->update() causing a DB error from within wp_set_password()
- MySql Query for WordPress
- Internal error (500) on local & Fatal error on live when trying to access post type edit screen
- Query sql for truncate post_content in wp_posts table
- How should I troubleshoot a database serialization issue with a WordPress migration
- Running WordPress from MySQL Cluster with HAPRoxy
- How WP decide to show or not to show in admin panel the pop-up window with hint? Need a fix
- Global MySQL replacing of text patterns/matches
- Delete posts with word count less than x number of words
- Using wp config to connect to a DB from a plugin
- Foreach only outputs if id is 0
- MySQL: get post_tag items that are tags (not SEO keywords)
- Complicated MySQL Query
- SQL – Pull products of particular category from a remote WordPress woocommerce db
- Efficiently loop over huge number of posts
- Using queries in and i see 7000+queries?
- how to search through plugin in wordpress cimy-user-extra-fields?
- problem with quotes on new post
- $wpdb->get_var returns 0
- Get all the related data from WordPress DB
- How to display blog posts only authored by the administrator
- cannot log in to the mysql server (wamp and wordpress)
- “Error 1064” when importing msql database after updating wordpress version to 4.2.1
- Trying to insert a row from a Plugin
- SQL command to export post_content from wp_posts using phpMyAdmin
- SQL Database Lost
- 504/502 errors plauging our site
- WP_Query with LIKE returns strange query
- how to show the data from a myqsl database in a post [closed]
- Post sorting and ordering function in WordPress Admin is broken and always shows post from oldest to newest
- How can I delete the options from DB when the plugin is deleted?
- PHP Creating a formula from mysql db values and db stored math operator
- Why can’t I connect to imported WP DB on local MAMP?
- Need SQL query to find&replace image URL
- Share or sync user table data with another user table
- Where other than wp-config can database access details be defined?
- remove wordpress post links
- Initialization of table in database using ‘CREATE … IF NOT EXISTS’
- SQL get last entry of a specific gravity form
- mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
- How do I load a sql.gz file to my database? (importing)
- Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
- Why does the MySQL command line tool ignore the –port parameter?
- How can I show user’s privileges in MySQL?
- InnoDB: Error: log file ./ib_logfile0 is of different size
- Postgres equivalent to MySQL’s \G?
- mysqldump to a tar.gz
- Postgres equivalent to MySQL’s \G?
- Postgres equivalent to MySQL’s \G?
- How can I show mysql locks?
- How to check what port mysql is running on
- Where is my mysql log on OS X?
- Changing host permissions for MySQL users
- How to find source of these strange SQL queries?
- Split Million WordPress Post’s Into Multiple Database Server
- Batch Replace URLs in WordPress Database
- Getting 504 Gateway Timeout Error on AWS Server! [closed]
- WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
- Possible SQL injection. How to locate and fix?
- How to reduce uncached page generation time?
- Do Seeded Orderby Rand Queries Benefit from DB Caching?
- After Import: Insert “Use” Statement in Database
- Remove posts that start with similar words (like a delete duplicate posts plugin)
- $wpdb->get_results() query empty, but same query in phpmyadmin has results
- mysql running over 200% CPU according to atop – pt-query-digest suggests slow running query is a lookup in wp_options for ‘autoload’ = yes
- WordPress cannot detect (present, loaded) mysqli
- Admin backend is very slow to create or edit posts by core meta query
- WP_Query does not return the result even if the data is present in the database
- SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’ always is running
- MySQL has died. How do I recover? SOLVED
- Updating wp_postmeta from meta_keys and meta_values from another table having price and sku only
- Does WordPress work with MySQL active-active GTID-Based Replication without any issues?
- Import posts from a different database with the same old id
- WP Plugin: How to avoid db access for each comment?
- Slow search queries with a large database
- How connection pooling can be implemented in WordPress?
- MariaDB version not recognised
- Saving Tutor LMS plugin courses as WordPress Blog Posts in Database [closed]
- How to sync non-wp database with wp-database?
- Recursion using year loop in sql
- Lets simple destroys website