Need wordpress filter help

chareen3 said:

Yes, it is possible to update the products in your WooCommerce store using a custom code. Here is a general outline of the steps you can follow to achieve this:

1. Connect to your WooCommerce store's database using a MySQL client such as PHPMyAdmin or the MySQL command line.
2. Use the following SQL query to update the products that have a blank value for the "Product Brand" field:

SQL:

UPDATE wp_posts SET post_excerpt = 'Brand Name' WHERE post_type = 'product' AND post_excerpt = ''

Replace "Brand Name" with the actual brand name you want to assign to the products.

1. Run the query to update the products.

Keep in mind that this is just a general outline and you will need to adjust the details to match your specific setup. It is also a good idea to make a backup of your database before making any changes.

You can use a WordPress plugin such as WP All Import to import the product data from a CSV file and update the products in bulk. This may be easier and less error-prone than writing a custom code.

Click to expand...

guguk said:

I think that most logical way to doing via "Bulk Edit" plugins with slow-mode (because it will be increase server CPU otherwise)
Or you can use wp-all import plugin to update that only this field may it faster than "bulk edit" plugin (I've no idea about comparing)

Last time you can do it with running SQL but it's not safest method rather than others. Because we dont know that "product-brand" is what? a variation like color, size? custom field? So, preparing SQL code a little bit hard, i guess.

Click to expand...