Question: Bulk Edit And Delete

Bulk Edit And Delete

How to bulk select and edit/delete products? Need to add 0 to beginning of each UPC code because it was dropping during import. Even to delete all products it must be done one by one.

RP

Rupesh Patel

Asked

How to bulk select and edit/delete products?

Need to add 0 to beginning of each UPC code because it was dropping during import.

Even to delete all products it must be done one by one.

  • MS

    Mian Saleem

    Answered

    Hello,

    There is no such option to bulk edit/delete products. You an do so on your database.

    UPDATE tec_products SET code = CONCAT('0', code);
    

    To delete all products

    TRUNCATE TABLE tec_products;
    

    Thank you

  • Login to Reply