I want to create grouped and bundle products, where a bundle and group have a special price that is not sum of prices of all individual products.
How to achieve that?
Magento – add special price to grouped product
bundled-productgrouped-productsprice
Related Solutions
To hide Special Price make sure in that if special price is zero then don't write special price is 0.00 .
if you write special price is 0.00 he is display fronted special price is 0.00.
in short keep it empty if there is no special price.
The best way I can think of doing this is via an SQL statement
SELECT cpeid1.entity_id, cpeid1.value as price, cpeid2.value as special_price
FROM catalog_product_entity_decimal cpeid1
LEFT JOIN catalog_product_entity_decimal cpeid2 ON (cpeid1.entity_id = cpeid2.entity_id AND cpeid2.attribute_id = 76)
WHERE cpeid1.attribute_id = 75
AND cpeid2.value IS NOT NULL
;
Where 75 = price attribute id and 76 = special_price attribute id (from the eav_attribute table)
Best Answer
Bundled products can be created with a fixed price, after that the special price can be a percentage of that. Using the fixed price will ignore any price changes in the simple products under it.
Grouped products do not offer an option like that. But you can use
Promotions > Catalog Price Rules. In the conditions tab you can specify the SKU of the product you wish to apply the rule to. After that you can set the promotional price and you're done.Small side note: having a lot of promotional rules will slow the frontend of your shop down so use them wisely