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.

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

    To delete all products
    ```sql
    TRUNCATE TABLE tec_products;
    ```

    Thank you
  • Login to Reply