Find solution
How do I change the value of an attribute?

How can I assign a specific attribute value by default if a product is assigned to a specific category in Magento 1.8?

  • I have a category RED. If any product is assigned to this category, I want attribute value to be set as RED for attribute named 'COLOR'

  • Answer:

    The short answer that there is no easy way to do this. With some custom coding it may be possible, but here are a few workarounds that might save you a lot of time: If you are trying to sort the products by color, the color attribute can be used in the layered navigation eliminating the need for the Color Category. Then you can just add the color attribute using a CSV import file from Microsoft Excel and you are ready to go If red has to be a category, Follow these steps. Import all the products with a blank color attribute. Make sure that one of the options for the color attribute is red and that the color attribute is part of your products' attribute set. Add which products that you want to the red category (take note of the category id). Now "export all products" using Magento's Dataflow - Profiles. When inside the CSV file you exported using Microsoft Excel just add this formula to the color attribute column: =IF( {CATEGORY COLUMN} == "{CATEGORY ID}", "Red", "") Replace {CATEGORY COLUMN} with the column number of the category ids. Replace {CATEGORY ID} with the category id of the red category. Now "import all products" using Magento's Dataflow - Profiles and any product that is in the category "red" will also have "Red" as their color attribute. I hope this helps answer your question and accomplish your goal!

Nick Bordeau at Quora Visit the source

Was this solution helpful to you?

Other answers

Sorry I am not into Magento .

Bhanu Pratap

Rochak Chauhan

You question is not really clear, but I hope I understood correctly. You cannot assign attributes directly to the product. There is direct relation between a product and an attribute entities. A product can have a certain attribute value. That's it. Even if you insert the value for that attribute manually in the correct table it will be useless. That value will be a zombie value. It will be ignored by the application and it will only take up space in your db. The design of the app is like this. An attribute set contains attributes (in a many to many relation). A product has an attribute set as a parent entity (so one to many relation). A product can have values for the attributes in the attribute set it is assigned to. for More detail about the Problem in order and Invoice types against eCommerce transaction in Magento Click here: http://bit.ly/U53xyf

Atul Gupta

Hi.This feature is available in this extension:http://www.proxiblue.com.au/premium-modules/magento-dynamic-category-products.htmlThere are specific rules that allow you assign/change the attribute values of a product, if that product was assigned to a category.an example rule can look like this: (but is really limited only by your imagination) Demo store: http://dyncatprod.proxiblue.com.au/ admin: demo pass: dem0dem0Disclaimer: I am the creator and seller of this extension in magento.

Lucas van Staden

Hey, you see. That’s the all point of Magento. In one hand, Magento tries to add the way to many features as recommended products and that kind of things into the core. That slows down Magento and makes it difficult to upgrade and maintain. And in other hands Magento heavy and complicated, not good for beginer to discover eCommerce, especially in questions of assigning specific attributes. My suggestion is to find professional team who can solve all your issues, including this one. I found such professionals.Shopping_Cart_Elite is an easily scalable and powerful platform. You can customize it to your business’s needs, and they have excellent marketplace integration for selling on eBay or others. Their platform offers Enterprise features at reasonable prices. Also, such attributes are added by data entry department, so I think rather about increasing amount of my products, not about coding.Disclosure: I'm business owner and used this solution.

Agnes Horton

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.