Batch disable Sale price? - Marketpress

Hi i wish to batch disable the sale price check box for my products.
I imported the products (140) of them and included the sale price in the CSV file, however after importation, it has activated the sale price, is there a way to easily or as a batch applied to all or by category to enable / disable the sale price?

Thanks

Tom

  • Timothy Bowers

    Hey there,

    There isn't an automated way of achieving this for all products in a database. But there is a way :slight_smile:

    First of all, backup, backup, backup please. And test on your staging site first. :slight_smile:

    You can then run this MySQL statement from your PHPMyAdmin

    UPDATE TABLENAME_ID_postmeta
    SET meta_value='0'
    WHERE meta_key = 'mp_is_sale';

    You'll need to change the table name TABLENAME to your own, and if you're in a multisite you need to change the ID to the site ID. If you're not in a multisite it would be like TABLENAME_postmeta

    If you have any further questions, let me know.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.