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
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- MySQL Error “Operand should contain 1 column”
- How to use MySQL DECIMAL?
- MySQL ERROR 1290 (HY000) –secure-file-priv option
- MySQL server startup error ‘The server quit without updating PID file’
- MySQL DROP all tables, ignoring foreign keys
- Duplicating a MySQL table, indices, and data
- mysql Foreign key constraint is incorrectly formed error
- mysql is not recognised as an internal or external command,operable program or batch
- SELECT * FROM multiple tables. MySQL
- mysql: SOURCE error 2?
- How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
- Data truncated for column?
- MySQL foreach loop
- MySQL IF NOT NULL, then display 1, else display 0
- MySQL date format DD/MM/YYYY select query?
- MySQL Calculate Percentage
- Repair all tables in one go
- Get the new record primary key ID from MySQL insert query?
- How to change collation of database, table, column?
- Failed building wheel for mysql-python
- ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
- Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
- Remove Primary Key in MySQL
- How to get the max of two values in MySQL?
- mysql: connection refused when trying to connect to localhost using remote IP
- Error: Duplicate entry ‘0’ for key ‘PRIMARY’
- Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
- Complex meta query with 3 keys
- Creating 20,000 Posts or Pages using a .csv file?
- How to log mysql errors from wordpress core?
- Search and replace text across all posts
- Bad Request (Invalid Hostname) on working server, database problem
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- wpdb Custom Meta Data with 2 conditions
- query to create woocommerce products from images
- Configure WordPress to connect to Mysql DB using SSH tunneling
- How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
- Rewrite database urls
- SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
- Migrating from Existing MySQL Setup to WordPress
- How to split the a table in database?
- Can I restart MySQL engine when WordPress website is live?
- How do I run SQL queries on a WordPress web page? [closed]
- SQL to order by CPT results by user->display_name w/only user->ID known
- How do I join a $wpdb query with user meta using default value if not exist?
- mySQL statment count of post in each category and sub category
- WordPress page and plugin list using sql query
- Paypal Post IPN handeling nightmare
- pagination on data fetched using SQL query
- Speeding SQL queries for a large database?
- Database Structure on Different Servers
- Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
- Changing MySQL password via WHM – does this affect WordPress?
- How to get INSERT errors from $wpdb?
- How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
- Export Yoast Keywords from MySQL/phpMyAdmin
- Same database; different WordPress
- Comment Approve – Add custom function when comment is approved
- How to insert dash (-) into database using wpdb and new_to_publish hook?
- MySQL: How to change url in posts from xxx.com to yyy.org?
- How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
- WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
- Upgrade DB Loop – WordPress DB Version Conflict
- WordPress & MySQL , problem with use many array in meta_query
- JOIN and SUM different statement results (Mailster Database)
- Button writing to MYSQL database
- In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
- MySQL ‘duplicate entry’ error
- WP Function does not trigger on Webhook API Call
- Performing CRUD operations on front end in wordpress
- Display a number value from mysql query in WP
- WordPress Dutch characters encoding problem
- How to show result of sql query in a page?
- Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
- 403 Forbidden home on localhost with nginx server
- get/show Last ID
- How do I insert content of various MySQL fields in post?
- HyperDB failover Delay
- Select latest 2 articles, but only from given category
- CONCAT_WS in custom sql query
- Query does not filter duplicate _sku numbers
- Ordering topics by most replies in X days using MYSQL statement
- MySQL Select within WP Page template
- Create Database Tables on Plugin Activation hook
- Slow WordPress admin panel with a total query time of 1664ms
- wp_postmeta – lot of meta fields
- Running WordPress from MySQL Cluster with HAPRoxy
- Delete posts with word count less than x number of words
- MySQL: get post_tag items that are tags (not SEO keywords)
- $wpdb->get_var returns 0
- cannot log in to the mysql server (wamp and wordpress)
- SQL command to export post_content from wp_posts using phpMyAdmin
- 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