Bulk set specific brand for priducts with blank brand

  • I installed this and added brands for branded products but i have a brand called OEM and i need for products with blank brand to massively add the OEM brand value. I tried to sort products by brand but this column is not sortable. If it was, then i would bulk edit from woocommerce backend. Is there a query i could run from phpmyadmin to massively add a specific brand to products with blank brand? (i could get the id of OEM brand and use it in the query).

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Dmytro Holovnia

    (@dholovnia)

    You can export your products with WooCommerce export functionality, edit data with Excel and import it back.

    Other option is just to use WooCommerce bulk edit. Click Screen Options at the top right corner, set ‘Number of items per page’ to 500 and Apply. Choose needed products and select bulk option to edit. Set OEM brand and save. Editing by 500 products will make it much faster.

    Regards,
    Dima

    Thread Starter pm4698

    (@pm4698)

    Thank you for your answer. I have set brands for several items so if i do bulk edit the OEM beand will apply only to products with no brand or to all?If its for all then i will lose already applied brands.

    Is there a solution through phpmyadmin query?

    Plugin Author Dmytro Holovnia

    (@dholovnia)

    You can choose what products to edit. Please check products page.

    We are not providing custom code or support for it. You can hire a freelancer for an hour or so and he will do it for you.

    Regards,
    Dima

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Bulk set specific brand for priducts with blank brand’ is closed to new replies.

Tags