Bulk edit for Condition and Google category

[ChristianAF]

User story

There are merchants that have more than 2000 products and they need to go and edit each product the condition and google category.

Is your feature request related to a problem?

https://wordpress.org/support/topic/way-to-set-default-product-condition/
https://wordpress.org/support/topic/will-pinterest-tag-work-with-a-catelog-that-i-have-activated-from-another-source/#post-15405267

Describe the solution you'd like

Bulk edit for Condition and Google category

Acceptance criteria

Bulk edit should be present and be able to edit "Condition" and "Google category" for several products at the same time

[ChristianAF]

https://ideas.woocommerce.com/forums/133476-woocommerce/suggestions/44848675-add-the-ability-to-bulk-update-fields-such-as-con

[ChristianAF]

@jconroy here is a bad review: https://wordpress.org/support/topic/not-a-happy-experience/
The second point is related to this issue. I think that is not the only Merchant that has lots of products, and they have to edit all of them 1 by 1. Would be great to have a bulk edit or as she mention, or kind of inherit from some other place. (think the bulk edit is the best one.

[jconroy]

Thanks for adding. We're designing an attribute mapping feature for a different product that we may be able to port here.

Bulk attribute editing etc. Is part of a larger refresh across Woo for product editing experience - not sure when we'd look at it.

Please keep collecting feedback here.

[obregon08]

Workaround while this feature is developed and deployed

Before running any queries, remember to backup your db: mysqldump -u yourdbuser -p yourdbpassword yourdbname > backup.sql

Set google_product_category to "Business & Industrial" for all products

INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT id, "_wc_pinterest_google_product_category", "Business & Industrial" FROM wp_posts WHERE post_type="product" AND post_status="publish" AND NOT EXISTS (SELECT 1 FROM wp_postmeta WHERE meta_key="_wc_pinterest_google_product_category" AND wp_posts.ID = wp_postmeta.post_id);

Set condition to "new" for all products

INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT id, "_wc_pinterest_condition", "new" FROM wp_posts WHERE post_type="product" AND post_status="publish" AND NOT EXISTS (SELECT 1 FROM wp_postmeta WHERE meta_key="_wc_pinterest_condition" AND wp_posts.ID = wp_postmeta.post_id);

Set condition to "new" for all product variations

INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT id, "_wc_pinterest_condition", "new" FROM wp_posts WHERE post_type="product_variation" AND post_status="publish" AND NOT EXISTS (SELECT 1 FROM wp_postmeta WHERE meta_key="_wc_pinterest_condition" AND wp_posts.ID = wp_postmeta.post_id);

[Babylon1999]

zd-7090550

https://wordpress.org/support/topic/pinterest-bulk-editing/