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?
-
i have run this query but its not working. its showing still dynamic price to No, it sets true in database table though. please let me know what to do? – bhargav shastri May 14 '20 at 13:02
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'
)
-
Do you know it's consequences? I recently had to do the same in Magento2 but the product detail page was still showing the dynamic price. – MagePsycho Nov 12 '17 at 10:16