I am in need of some advice/pointers on how best to attack a problem I am faced with in Magento

Here is the scenario: Consider a product catalog of multiple thousands of products in which there are many and various retail markup percentages. There is a need to sell some of those products to other retailers, and I need a way to easily categorise them into percentrage markup groups, so that the other traders can easily purchase items from us without needing to call and confirm pricing.

All products prices are added to the magento database including VAT - so the actual retail value is the starting point.

I think this needs to be done by adding an attribute on the products that determines the maximum discount level that can be applied to any given product.

Obviously, this would entail a massive amount of work to update every product.

Is there a way to achieve what we need that I don't yet know about (within Magento)?

Can single attribute values be mass-populated somehow, without affecting other attributes such as name/description/etc?


1 Answer 1


I worked with Magento but I don't believe that the differences should be meaningful:

An example of how to achieve the wanted behavior will be as follows:

1. main-menu->promotions->catalog->price rules and create a new rule, let's call it: "30% off".

enter image description here

2. Under rule information you can choose customer groups that will be included.
3. go to (still under "Catalog Price Rule"): actions on the left bar and configure the discount type to be "by percentage" and the Discount Amount to 30.0

enter image description here

4. now all you have to do is group the customers into groups (according to discount) - this is something that you'll have to do once (go over all your customers) but then the maintenance will be easy.

Hope it helps!

  • Unfortunately, this won't work in my scenario. That same customer might have 25% off a different set of products, and 15% off yet other products. I guess what I need is some way of assigning a discount value to the product instead of the customer group? Perhaps a product group with a discount level applied to it, that can be applied to all products that can have that discount level?
    – robgt
    Commented Mar 5, 2012 at 11:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.