Change bundle product price type via database

Question

Is it possible to change an existing bundle product from dynamic to fixed price via the database rather than having to create a new product?

Answer 1

you can run this query:

UPDATE `catalog_product_entity_int`  
SET
    value = 1 
WHERE
    entity_id = 'PRODUCT ID GOES HERE' AND
    attribute_id = (
                SELECT 
                     attribute_id 
                FROM 
                     eav_attribute 
                WHERE 
                     attribute_code = 'price_type'
                )