Question

Add Attributes To Products In Magento

Asked by: rafique12

Hi all, I am trying to add attributes in Magento to show product sizes i.e small, medium, large. However, I cannot get the drop down box to display these attributes which need to visible to the customer before they checkout.

Anyone know how to do this? I would appreciate it because my client is getting very frustrated.  

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2009-08-31 at 23:20:06ID24697088
Tags

magento

,

oscommerce

Topics

Stores & Carts

,

PHP Frameworks

Participating Experts
2
Points
500
Comments
51

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. Attributes supported
    Why doesn't IE 4.0 support TITLE attribute in the <A> tag ?
  2. Select all products with precific attributes
    I have a table products with product_id as primary key and catalog_id as a column. The other table is product_attributes with product_id and attribute_name as primary key, and an other field product_attribute_value . I need to retrieve ALL the products which MATCH the follow...
  3. Attribute "O"
    What is the file attribute "O"? How does it get set?

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: fiboPosted on 2009-09-01 at 00:27:57ID: 25229205

As usual with Magento, it is very easy to do... once you know how.

1 - Add the attribute as usual, selecting the type "list".

2 - Save the attribute. Before saving can proceed, you are required to give these labels from the tab "manage labels/options".
There, you will have to define these labels for each of the "stores":
- the admin "store", so this is the label set used when entering products in the back-office
- the front-office stores, so this will be the text displayed to visitors/ customers

NOTES:
- If no text is defined for the front-office stores, then the (required) values from admin will be used
- If you have different stores for different languages, this allows you to have labels in each language.
- When you define the attribute, there are as usual several important "decisions":
-- will the attribute be displayed by default when displaying product properties
-- which "attribute sets" will this attribute be part of?
-- will this attribute be used for "layered navigation", as is possible with any list attribute.

Be sure that you have at least one store enabled when creating the attribute.
Let me know of any other problem with this.

 

by: rafique12Posted on 2009-09-01 at 02:03:14ID: 25229617

I am terribly sorry but I just cant understand how to do this. I have set up everything as you have said but I still cannot see the drop down list which will allow users to choose size and colour before checking out.

this is really frustrating as my client is relying on me to fix this!

 

by: fiboPosted on 2009-09-01 at 02:14:47ID: 25229669

OK. Let's proceed step by step

0 - Can you confirm that you have defined 1 web, 1 store and 1 view (at least one of each).
If not... this is the problem... first define them!

DO NOT reuse any attribute you have previously defined.

Let's define a new attribute "the_Size" with three values "low" "medium" "high".

1 - Define the new attribute from the admin panel "catalog" / "attribute"
Type the_size almost everywhere you are asked for the attribute name
Define type as option list.
NOW: make a screen capture that you will paste here if needed.

2 - SAVE the attribute. This should fail with an error message asking you for labels.
IF it does not: make a second screen capture.
if it "fails", you should be presented with a screen for defining labels. if not, select in the leftmost column the tab "labels".
Once you have the screen, you should be done.

If you are not, please paste here the images you captured

 

by: DaymoHPosted on 2009-09-01 at 02:42:29ID: 25229788

That's true @fibo, don't forget to add the attribute to an attribute set though for it to show in products.

If you need to keep a track of stock levels of each size, the solution above is not, unfortunately, the way forward.
For stock level control,

Create an attribute called 'sizes' or something similar and fill in the relevant details, make it a 'dropdown' and 'Use To Create Configurable Product' is set to 'YES' fill the other details in as required and set the labels as per fibo's instructions. Save the attribute and add it to an attribute set.

Create a seperate simple product each with the attribute set containing your 'size' attribute for each size and set them to 'Visibility - Nowhere'

When you've created all of the simple products create another product with the same attribute set but make it configurable and fill in the details as appropriate, calling your product something like

' A biggish hat available in 3 sizes'

make sure you set the visibility to 'Catalog, Search' fill in all the details as per the simple product but then 'Associate' the simple products with the configurable using the button on the left called 'Associated Products'

Make sure all the simple products are set with a value in the 'qty' section of 'inventory' and set 'In Stock' - all simple products and the configurable one must be 'enabled' in each store you want it to show in.

You should now have the product showing in the front end, and you are able to manage the stock of each size.

 

by: fiboPosted on 2009-09-01 at 02:52:33ID: 25229845

Just a word of caution: until you have got your attribute creation fine, avoid any potential source of trouble.
Naming the field 'size' or 'sizes' might create problems with existing attributes/ fields. Hence my suggestion to call it 'the_size'...

Also, please proceed one step at a time:
- first get the option list with the simple example I gave,
- then, when it works, proceed to the more complete (and in most cases more useful) example from DaymoH.


This is the safest way to reach your destination

 

by: rafique12Posted on 2009-09-01 at 02:56:23ID: 25229861

Here's the screen shot before saving

 

by: DaymoHPosted on 2009-09-01 at 03:03:53ID: 25229885

@rafique12

If you are going down the configurable route you need to set the scope to 'Global' and I would set unique to 'no' When you have global set you should see 'Use To Create Configurable Product' appear. (sorry forgot that)

:-)

 

by: rafique12Posted on 2009-09-01 at 03:06:52ID: 25229897

Error Message after saving

 

by: rafique12Posted on 2009-09-01 at 03:09:49ID: 25229911

This is too confusing! Could I ask one of you to do the configuration for me in my magento backend?
PLEASE!!!!!!!!!!!!!!!!

 

by: DaymoHPosted on 2009-09-01 at 03:16:59ID: 25229958

I would hapily, but It is better for you to do it. I will post step by step instructions so bear with me.

 

by: fiboPosted on 2009-09-01 at 03:22:11ID: 25230001

Daymoh: please hold on until the simple option is reached. Then we will all be happy to let you lead the next steps. OK?

 

by: DaymoHPosted on 2009-09-01 at 03:23:42ID: 25230013

In the Admin panel go to

Catalog>Attributes>Manage Attributes

Click <Add New Attribute>

and make the settings like the attachment

 

by: DaymoHPosted on 2009-09-01 at 03:24:14ID: 25230018

Sorry fibo, will do.

 

by: fiboPosted on 2009-09-01 at 03:37:59ID: 25230127

Rafique:

- starting from your last screen capture: YOU ARE DONE!

It is just begging you for the labels!

So:
- in "manage titles": give the name of the attribute, or more precisely the label of the field. In your case, looking at your first screen I would probably select
Dress Size
in the Admin box (and this will also be used as a default in the "default store view"

- in "manage options": click on the button "add option" 3 times, since we want (for example sake) 3 values
This will add 3 lines of boxes.
-- The first one would be "admin": small / "default store view": leave empty, will reuse "small" / "Position": leave empty / "Is Default" : leave empty
-- Second line: "admin": medium / "default store view": leave empty, will reuse "medium" / "Position": leave empty / "Is Default" : Yes
-- Third line: "admin": large / "default store view": leave empty, will reuse "large" / "Position": leave empty / "Is Default" : leave empty

And now "Save attribute" ... it's OK.

Additional info:

- we have typed here the options in the correct order. If we had to change the display order, we would use the column "position" for this
- "is default": select the option you want as a default.

Additional remarks:
1 - as per your screenshots, you have defined the attribute to be "per store view". THIS IS NOT WHAT YOU WOULD DO NORMALLY, it should more probably be "Global" (ie: all web sites, stores and store views) or "Per Site" or "Per Store". In these cases, instead of having the 2 "store views" columns you have (ie "admin" and "default store view") you would get extra columns.
2 - As I asked previously: have you defined at least one web site, one store and one store view? your screens seem to hint that no.. Not a big problem, but LOTS of Magento features do in fact rely on this...

Rafique: please confirm when you are done with this simple example, so that, if you want to, Daymoh can lead
you to the next step.

 

by: rafique12Posted on 2009-09-01 at 04:18:50ID: 25230308

I have followed the steps with a fine tooth comb: I have no idea why this won't work! I'm thinking that maybe this version contains bugs and errors as it is the latest release. I don't know what to do!?!?!?!?!?

http://zetarose.com

                                              
1:

Select allOpen in new window

 

by: fiboPosted on 2009-09-01 at 04:35:57ID: 25230398

My notes were aimed to be resumed from your last "error" screen which, as I said, is not really an error, but just tasking you do add the missing labels.

If you resume from where you stopped last time (or starting with a fress new attribute), what do you get?
paste the screen capture of your next ferror step

 

by: rafique12Posted on 2009-09-01 at 04:55:27ID: 25230533

there is no errors! It just doesn't show the attribute i.e sizes for the products on the front page...

 

by: fiboPosted on 2009-09-01 at 05:18:23ID: 25230728

OK. So you are not complete on the front office, but the back office works.

Just before proceeding further: go to admin/ system / cache and update / refresh all of them! Then check again your front page.


Making attribute visible on the front office now require to things:
1 - Check your declarations of the attribute: are they configured to be displayed or not (cf infra)
2 - Edit some products so that the values are present and have some chance to display on the front-end (so you have to edit these products in the back-office, check that the options are available and select one of them).

1 - Using as a reference your first screen shot: some values need to be changed.
- scope: change it to store
- unique value: select NO
- value required: it says yes, change it to no. yes means that most of your existing products are "wrong" since they do not have a value for this attribute!
- used in search results validation: say yes (might help making things more visible) for now, although in this precise case this is probably meaningless
- save attribute.
- switch to "attribute sets", select the one used for a product like dy1509. if this is not the case, copy the attribute currently in the rightmost column to the center column, preferably at the top of this column: now your attribute is part of this "attribute set".
- save.
- open the product dy1509 from catalog/ product (still in back-office)
- you should see this attribute in one of the tabs, eg the one where you dragged the attribute. IS IT THERE? somewhere else? if you don't din it in any of the tabs... look again!
- once you have it displayed, select one of the values, save the product
- back to system / cache. again, refresh all the options here
- just in case: still in the back office, display again product dy1509: is your value still there? if NO, paste here a screen capture
- if yes: now go to the front office, CLEAR THE CACHE IN YOUR BROWSER, and display product dy1509. If it not there... just tell here, we'll be able to check the page

 

by: fiboPosted on 2009-09-01 at 05:21:54ID: 25230759

Oops, some paset failed. Here is the correct text

1 - Using as a reference your first screen shot: some values need to be changed.
- scope: change it to store
- unique value: select NO
- value required: it says yes, change it to no. yes means that most of your existing products are "wrong" since they do not have a value for this attribute!
- used in search results validation: say yes (might help making things more visible) for now, although in this precise case this is probably meaningless

- Visible on product view page on front end: change from no to yes... for now (normally no would be fine)
- used in produt listing: say yes

- save attribute.

 

by: rafique12Posted on 2009-09-01 at 06:24:47ID: 25231277

Sorry fibo but this just isn't working for me! I don't understand why Magento has made this so complicated.
I have followed your instructions to the letter, every seem okay in the back office but nothing shows on the front for the size attributes

 

by: fiboPosted on 2009-09-01 at 06:36:25ID: 25231391

please, show me a screen capture of the product DY1509 page where the attribute is defined.

Magento is complicated at time. However, I feel that you should succeed. So something is going bad. Since I'm not looking at your screen, I need the captures

Please send me also a capture of your system/ cache page

 

by: fiboPosted on 2009-09-01 at 06:39:25ID: 25231430

Please send me also a capture of the page where you have defined the labels and options for the attribute

 

by: rafique12Posted on 2009-09-01 at 07:01:59ID: 25231635

This image shows the current configurations...

 

by: fiboPosted on 2009-09-01 at 07:08:20ID: 25231703

This first screen seems fine. A look to the next one should clarify the situation for the options

 

by: fiboPosted on 2009-09-01 at 07:11:48ID: 25231738

Hmmm... I see trhat you are using Chrome as a browser.

Not sure if this has any effect here, but I have had problems with Chrome displays of some Magento pages.

When we will have checked everything for any option we might have left wrong, displaying thru IE (7 or 8) or Firefox will have to be tested.

 

by: fiboPosted on 2009-09-01 at 07:22:10ID: 25231849

We are within 10 minutes to get the display you want... tell me when you can block 15-20 muinutes so that we reach success asap.

 

by: rafique12Posted on 2009-09-01 at 08:50:14ID: 25232819

Sorry I had a break. What needs to be done? you say i need to test in firefox which i have done but there is no change there!

I may just change the software to something more simple like open cart or presstashop!!!

this is very time consuming for all of us

 

by: rafique12Posted on 2009-09-01 at 09:27:49ID: 25233218

Okay I have tested in all browsers and there is no change. Could it be that version 1.3 has bugs?
Let me know and will downgrade to the previous version

 

by: fiboPosted on 2009-09-01 at 09:40:29ID: 25233361

No. Bugs should notbe our main suspects for now.
Please provide me with screen captures for:
- labels description of your attribute (this is the current version of the 2nd image you sent me)
- the page/tab of the product dy1509 in your back-office that shows which option you have selected
- the page system/ cache
Thx.

 

by: rafique12Posted on 2009-09-01 at 09:48:32ID: 25233436

We have been here for hours! I cant deal with this it just doesn't work the way it should. Magento cant be serious if they want to release software that is so complex to use for something so simple. I dnt want to waste anymore of your time or mine!!

 

by: fiboPosted on 2009-09-01 at 09:53:46ID: 25233499

OK. Decisioon is yours.
However, on this precise function, things are really close. If your client has been waiting that for some time... why not give it a try?

We have not been here for hoiurs, because we have been leadinf=g some other tasks as well. Again, if we block our time it will be done within 20 minutes

 

by: fiboPosted on 2009-09-01 at 10:17:37ID: 25233716

Are you here?

 

by: rafique12Posted on 2009-09-01 at 10:18:25ID: 25233727

Okay could you log in to the admin and make sure everything is okay?
I just dont want to be here till tommorrow.

 

by: fiboPosted on 2009-09-01 at 10:21:22ID: 25233759

yes, but I can't login to admin without a password. create a TEMP admin profile, send me the details by PM to bernard.savonet@gmail.com
You will later disable this user from any privilege, OK?

 

by: fiboPosted on 2009-09-01 at 10:33:26ID: 25233858

sorry I just launched a compare in your front-end, and it crashed. should not have broken anything

 

by: rafique12Posted on 2009-09-01 at 10:35:35ID: 25233877

thanks

 

by: fiboPosted on 2009-09-01 at 10:37:35ID: 25233893

if you want me to connect as an admin, you must create a user for me, that you disable later and delete afterwards. Any problem there?

 

by: fiboPosted on 2009-09-01 at 10:39:26ID: 25233909

.. but I don't need that access if you paste me the the screen captures I requested...

 

by: rafique12Posted on 2009-09-01 at 10:41:16ID: 25233933

Okay thanks alot!

 

by: fiboPosted on 2009-09-01 at 10:45:48ID: 25233973

just to be sure: I'm waiting for some material from you, either the screen  captures or anything that helps to progress and close the case!

 

by: rafique12Posted on 2009-09-01 at 11:00:14ID: 25234115

I sent a temporary password and username to the email you provided...

 

by: fiboPosted on 2009-09-01 at 11:07:50ID: 25234198

not arrived yet, whether is the regular mailbox or in the spam box

 

by: fiboPosted on 2009-09-01 at 11:15:39ID: 25234294

just create a new client on your store front-end. confirmation mail did arrive fine. you can find all the info in the admin panel

 

by: fiboPosted on 2009-09-01 at 11:18:20ID: 25234325

sorry: "just createD a new client..."

 

by: fiboPosted on 2009-09-01 at 11:26:24ID: 25234426

Sorry, have to go, and it seems you are busy with some other tasks.

If you want to progress, please past me these screen captures. And dedicate some time to solve the problem.

 

by: rafique12Posted on 2009-09-01 at 11:51:05ID: 25234697

I am here my friend!

 

by: rafique12Posted on 2009-09-02 at 00:55:01ID: 25238782

Can anyone help me to resolve this issue please!?!?

 

by: DaymoHPosted on 2009-09-02 at 01:12:12ID: 25238866

HI rafique12,

If I send a message to you via the contact me at Zetarose will you get it?

 

by: rafique12Posted on 2009-09-02 at 01:14:10ID: 25238875

No that's the client email: you can message me here:
catchmel8r@googlemail.com

 

by: fiboPosted on 2009-09-02 at 04:19:27ID: 25239740

Thx for the grade and points. Glad we could help.
We had direct access to the site and worked in chat with Gmail. However some of the items that were exchanged will be useful for others, so I will post a summary here.

 

by: fiboPosted on 2009-09-02 at 04:34:21ID: 25239826

Since we had direct access to the site and worked in chat with Gmail, the corresponding items were not visible here on EE.
However some of the items that were exchanged will be useful for others, here is a small summary of the main points:
- Being logged as an admin, I created an attribute and its label and options labels. The option labels were not created in the proper order, thus had to use the fields "order" to adapt.
- Selected a "default" option... but in fact this is not useful if the attribute is not defined as "must have a value"
- Then switched to Catalog / Attributes / Manage attributes set. Select the attribute set(s, one at a time) for which you want to add the newly-created attribute.
- In the chosen selected attribute set, select which main area (tab) you want to add the attribute, then drag it there from the rightmost column.
- Now go to catalog / products and select a product for which you want to add data for the newly created field / attribute. Select data, save product.
DONE!

We have also created 2 subcategories to the default root category.
- Catalog / Manage categories. Then select the default root category, and click on the button "add subcategory"... fill in the fields.
- There are 3 "names" for the (sub)category:
-- field name (letters, - and _ but no space; I personally use all lower case),
-- url name (letters, - and _ but no space; I personally use all lower case, words separated by dashes - if they are meaningful)
-- and page title (properly capitalized nouns and names, separated by spaces).
- Place also, at least for now, some relevant keywords in the metatags keywords box, and a small relevant sentence in the box "meta description".
The subcategories to the root categories will display automatically on the menu of the page, needing no special action!

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...